PureBytes Links
Trading Reference Links
|
Hi Jeff
Try this.
D1:=Input("Day",1,31,4);
M1:=Input("Month",1,12,1);
Y1:= Input("Year",1900,2400,1999);
D:=DayOfMonth(); M:=Month(); Y:=Year();
Date:=D>=D1 AND M=M1 AND Y=Y1 OR Y>Y1 OR Y=Y1 AND M>M1;
Start:=Date AND Alert(Date=0,2);
StartVal:=ValueWhen(1,Start,C);
100*(C-StartVal)/StartVal;
Regards
Roy
www.metastocktops.co.nz
----- Original Message -----
From: jwlcfp
To: equismetastock@xxxxxxxxxxxxxxx
Sent: Friday, September 14, 2007 10:42 AM
Subject: [EquisMetaStock Group] ROC Since Date
I am currently using the following formula to calculate the rate of
change since a selected date:
Day1 := Input("Day",1,31,4);
Month1 := Input("Month",1,12,1);
Year1 := Input("Year",1900,2400,1999);
100 * (CLOSE - ValueWhen(1,DayOfMonth() = Day1 AND Month() = Month1
AND Year() = Year1, CLOSE))/ ValueWhen(1,DayOfMonth() = Day1 AND Month
() = Month1 AND Year() = Year1,CLOSE)
The formula works on the daily chart but not on the weekly or monthly
charts, unless the specified date is the last trading day of the week
or month. If the date is not at the end of the week or month, I lose
the chart. Does anyone know how to change the formula so the date
will go to the last trading day of the week (if in the
weekly mode) and the last trading day of the month (if in the monthly
mode).
Thanks for your help,
Jeff
__________ NOD32 2529 (20070913) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
[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/
|