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

[EquisMetaStock Group] ROC Since Date



PureBytes Links

Trading Reference Links

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



 
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/