|
PureBytes Links
Trading Reference Links
|
I need some help translating a series of Excel formulas into Metastock. The formula is quite useful as a turning point of closes as anyone will see on a weekly chart.
The data and formulas in the Excel Columns are as follows --
Column A
Index of 0 through n where n = number of weeks that you want to use (at least 20, but you can use more)
Column B
Blank
Column C
Weekly Date
Column D
Weekly Open
Column E
Weekly High
Column F
Weekly Close
Column G
Weekly Close
Column H
Weekly Volume
Column I
Adjusted Close
Column K
=IF(G1<>"",I1-I1,"")
Column L
=IF(G1<>"",H1/1000,"")
Column M
=IF(G1<>"",IF($A1<=$G$1,AVERAGE($I$8:$I1),AVERAGE(INDEX($I$8:$I1,$A1-
$G$1):$I1)),"")
Column N
=IF(G1<>"",IF($A1<=$G$1,STDEVP($I$8:$I1),STDEVP(INDEX($I$8:$I1,$A1-
$G$1):$I1)),"")
Column O
=IF(G1<>"",M1+$G$2*N1,"")
Column P
=IF(G1<>"",M1-$G$2*N1,"")
Column Q
=IF(G1<>"",SQRT((1-0.5*Q$5)*(O1^2+P1^2)-(M1+Q$5*(I1-M1)-Q$5*INDEX($I$8:$I1,$A1-
MIN($A1,$G$1)))^2/G$3),"")
Column R
=IF(G1<>"",IF($A1<=$G$1,Q1/$Q$8-1,Q1/INDEX($Q$8:$Q1,$A1-$G$1)-1),"")
Once in Metastock it still needs additional confirmation for a real trading system, but I believe that it is a very good start for a Swing Trading System.
The data is downloaded from Yahoo.
The Adjusted Close is likely to be the same as Close if you buy data from a good service where everything is adjusted for splits, etc
Thanks in advance for any help, Brett
PS Some of the formulas are too long for a single line and spill to the next line where I have indented them
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|