MetaStock™ Zone Forum & FAQ Artykuły Linki Elliott Waves EasyLanguage™ Zone

 A B C D E F G H I J K L M N O P R S T U V W Y Z #

ROC Since Date by Roy Larsen

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).

Jeff

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Hi Jeff

Try this.

ROC Since Date

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;
StartVal:=ValueWhen(1,Start,C);
100*(C-StartVal)/StartVal;

Regards

Source / From: TOP
equismetastock[at]yahoogroups[dot]com

Equis and MetaStock® and MetaStock Professional® are registered trademarks of Equis International. Achelis Binary Wave®, The DownLoader®,
Expert Advisor®, OptionScope®, Quotecenter® and Smart Charts® are trademarks of Equis International.