I'm trying to write some code that produces a data array value from the same date 1 year ago. Here's what I've written and it's not working. According to tech support what I want is possible, I'm just going about it wrong. Any help would be appreciated. Kirk x:= Fml("Max DLRL Delta 20"); d:= DayOfMonth(); m:= Month(); y:= Year(); x2:=ValueWhen(2,d = DayOfMonth() AND m = Month() AND y = 2005 ,x); x

Kirk, one of the problems with your code is that today's date a year back, may actually fall on a weekend or holiday. The code below fetches data from a year ago (or next available date), as from today (i.e., measured from the last data bar on the chart): [code:1:72e2ac637e] x:=Fml("Max DLRL Delta 20"); lastDay:=LastValue(DayOfMonth()); lastMonth:=LastValue(Month()); lastYear:=LastValue(Year()); start:=Year()>lastYear-1 OR (Year()=lastYear-1 AND (Month()>lastMonth OR Month()=lastMonth AND DayOfMonth()>=lastDay)); signal:=start AND Alert(start=0,2); ValueWhen(1,signal,x) [/code:1:72e2ac637e] And the Ref() function can approximate a year ago, but runs into problems when data is missing: [code:1:72e2ac637e] x:=Fml("Max DLRL Delta 20"); YearlyPeriods:=252; Ref(x,-YearlyPeriods) [/code:1:72e2ac637e] In order to fetch data correctly based on true calendar days rather than periods, you will need a third-party custom dll, such as the accurate LookBack.dll which I offer to my clients. jose '-)

George, you are too kind with your comments, and you definitely over-estimate my talent. ;) jose '-)

Dear Hayseed, I received your Message. First i want to note, that with my opinion, this Topic in one from most valuable in Formulas! I say that because here are written DATE FORMULAS extremaly rare! Hayseed after that Words and Formulas that you written in this Topic, i am in a little Shock! I appreciate your Help in this Topic and also the Help of my Favourite Jose! Kind Regards, George Kanellopoulos.

hey george.... as an example of substituting for the 'c', changing from close to open and also adding ref(c,-1) will enable you to track gaps.... in the case of 5 chart layouts at times the gap will be off the screen, as space is at a premium.... a 'gap tracker' indicator will keep that gap in the field of view.... there are many other such variations......h gap tracker

---

m:=Input("month",1,12,1); d:=Input("day",1,31,1); y:=Input("year",1990,2010,2006); a:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,Ref(C,-1)); aa:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,O); a;aa

---

multiple choice

---

pnt:=Input("close=1, open=2, high=3, low=4",1,4,1); m:=Input("month",1,12,1); d:=Input("day",1,31,1); y:=Input("year",1990,2010,2006); a:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,C); aa:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,O); aaa:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,H); aaaa:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,L); If(pnt=1,a,If(pnt=2,aa,If(pnt=3,aaa,If(pnt=4,aaaa,a)))); --------------------------------

Dear Hayseed, I received your Message and Thank You. I want to note that i do not not to track gaps...! I want to track Conditions(If Exist) that occur in a Specific Date Period and also not Metastock Formula Language Periods meaning 250 Periods, 240 Periods. For that reason i create that Question. Please check it again and if it is possible to you make your Comments, again! Kind Regards, George Kanellopoulos.