[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel Formula for Tradestation RSI Function



PureBytes Links

Trading Reference Links

Tom Vetter asked:
>Has anyone written an Excel formula for the RSI function used by TS?

It's a lot easier to implement it as a macro function rather than a
formula in a cell.

To do it without macros, you need six columns:

1.  First column (say column A) has closing prices
2.  Second column (say B) contains the up price movements
    =IF(A2>A1,A2-A1,0)
3.  Third column (C) contains down price movements
    =IF(A2<A1,A1-A2,0)
4.  Fourth column (D) contains sum of up movements
    The first cell being N rows down: =SUM(B2:B11) for N=10
5.  Fifth column (E) contains sum of down movements
    =SUM(C2:C11)
6.  Last column is the RSI
    =D11/(D11+E11)

Multiply by 100 to scale it to the range output by TS.

-- 
  ,|___    Alex Matulich -- alex@xxxxxxxxxxxxxx
 // +__>   Director of Research and Development
 //  \ 
 // __)    Unicorn Research Corporation -- http://unicorn.us.com