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

RE: [EquisMetaStock Group] Excel to Metastock Help



PureBytes Links

Trading Reference Links

I apoligize. Column F is Weekly Low. Thank you for pointing it out.
   
  Brett

Ron Berlin <rsb_44@xxxxxxxxxxx> wrote:
          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]
>



         


[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/