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
|