|
PureBytes Links
Trading Reference Links
|
As Alex said, it would be neater to implement it as a VBA function call, but
the following is a ready made one.
http://www.futuresmag.com/industry/downloads/rsi.zip
On extraction you need to add the file-extension ".xls" which is somehow
missing.
Also there is a few other oscillators at the following URL:
http://www.futuresmag.com/industry/downloads/downloads.html
KL
> 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
>
>
|