İndikatör 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).

Thanks for your help,
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;
Start:=Date AND Alert(Date=0,2);
StartVal:=ValueWhen(1,Start,C);
100*(C-StartVal)/StartVal;