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

Re: [EquisMetaStock Group] ROC Since Date



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/