|
PureBytes Links
Trading Reference Links
|
It apears that column F and G are both Weekly Close. Was Column J left
unused on purpose?
>From: Brett Sinclair <brett_j_sinclair@xxxxxxxxx>
>Reply-To: equismetastock@xxxxxxxxxxxxxxx
>To: equismetastock@xxxxxxxxxxxxxxx
>Subject: [EquisMetaStock Group] Excel to Metastock Help
>Date: Tue, 9 Jan 2007 09:52:15 -0800 (PST)
>
>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/
|