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

[RT] VIDYA Excel setup



PureBytes Links

Trading Reference Links

Though I have Tradestation, Metastock RealTime 7.0, plus others, I use Excel
for data processing which I convert back for use with charting programs.  So
I do have many indicators already programed into Excel.

Here's the formula for VIDYA plus Chande's Momentum Oscillator thrown in for
a bonus.



J1 = "Length"
K1= you pick the number for VIDYA's length

J2= "Smooth"
K2= you pick the number of VIDYA's smoothing periods


A1 = "Number"
A2= 1
A3= 2
A4= 3 and so forth

B1= "Date"
B2= Day 1's date
B3= Day 2's date and so forth

C1= "Close"
C2= Day 1 closing price
C3= Day 2 closing price and so forth

D1= "Up Amount"
D2 is blank
D3= =IF(C3>C2,C3-C2,0)
D4:Dx    Copy D3's formula

E1= "Down  Amount"
E2 is blank
E3= =IF(C2>C3,C2-C3,0)
E4:Ex    Copy E3's formula

F1= "Up Sums"
F2 is blank
F3= =SUM(OFFSET(F3,-$K$1,-2,$K$1,1))
F4:Fx    Copy F3's formula - NOTE: the # of cells =K1-1 will have "#REF!" in
them

G1= "Down Sums"
G2 is blank
G3= =SUM(OFFSET(G3,-$K$1,-2,$K$1,1))
G4:Gx    Copy G3's formula - NOTE: the # of cells =K1-1 will have "#REF!" in
them

H1= "CMO" - NOTE: this Chande's Momentum Oscillator
H2 is blank
H3= =(F3-G3)/(F3+G3)
H4:Hx    Copy H3's formula - NOTE: the # of cells =K1-1 will have "#REF!" in
them

I1= "VIDYA"
I2 is blank
I3= =IF(A3<=$K$1+1,C3,((2/($K$2+1))*ABS(H3)*ABS(H3)))*I2)