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)
|