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

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;



ROC Since Date
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.

TradeStation® Pro, TradeStation® 2000i, OptionStation®, SuperCharts®, PowerEditor® and EasyLanguage®
are registered trademarks of TradeStation Technologies, Inc. Other names and marks referred to are the property of their respective owners.

All information provided on this website is for educational purposes only. Trading involves risk, including possible loss of principal and other losses.

Ten i inne materiały na tej stronie zostały zamieszczone zostały jedynie w celach edukacyjnych, nie ponoszę żadnej odpowiedzialno¶ci za ich stosowanie.

Gra na giełdzie i rynkach walutowych (FOREX) niesie ze sob± ryzyko poważnych strat finansowych!