hey karl.... seems i've noticed that type question before, but didn't have a good answer.... some of the better coders be able to answer exactly..... you can do a kinda work around using some of the options in the exploration.... by setting your test date and only loading the proper amount of records it might achieve your result.... in your November 1st 2005 and November 20th 2005 test from 11/20/05 and load 14 records or how many lie between those dates..... thats not the answer you were lookin for but might do until.....h

Karl A "date filter" is a very useful tool to have. You can easily drop it down into a chart window, adjust the default start and end dates, then run an exploration or do whatever you want to examine signals between your given date range. Once the date filter has appropriate default dates set you could write your formula as Cum(Fml("Date Filter") and RisingWindow())>=3; Using Cum() with a filter inside it is probably a better option than Sum() as you don't need to concern yourself with the number of lookback periods. Cum() sums everything across all loaded data, and that's where a data filter like mine or a simpler formula like Doc's restricts the enabled range of Cum() to just the date range you want. Here's the date filter in case it's of any use. {Date Filter} {© 2003 Roy Larsen, www.metastocktips.co.nz} Sd:=Input("Start day" ,1,31,1); Sm:=Input("Start month",1,12,1); Sy:=Input("Start year" ,1980,2010,2002); Ed:=Input("End day" ,1,31,31); Em:=Input("End month" ,1,12,12); Ey:=Input("End year" ,1980,2010,2005); Start:=(DayOfMonth()>=Sd AND Month()=Sm AND Year()=Sy) OR Year()>Sy OR (Year()=Sy AND Month()>Sm); End:=(DayOfMonth()<=Ed AND Month()=Em AND Year()=Ey) OR Year()<Ey OR (Year()=Ey AND Month()<Em); Filter:=Start AND (End OR (Start AND Alert(Start=0,2))); Filter; Roy MetaStock Tips & Tools

Sorry Patrick. I guess I just get so used to making do with my own solutions from way back. I must say that I'm finding new uses for the FormDll on a regular basis so I hope the issues surrounding it's installation in various MS versions are resolved soon. Keep up the good work. Roy MetaStock Tips & Tools

I hate to keep harping abut powerPivots Plus but the external functions for creating a multi time frame indicator are included Compare this indicator with the QStick indicator included in Metastock Periods:=Input("Length",1,100,8); factor:=Input("TFactor", 0, 1000, 1); offset:=Input("Offset", 0, 1000, 0); OD:=ExtFml("PowerPivots.TDataCreate",0, factor); CD:=ExtFml("PowerPivots.TDataCreate",3, factor); A1:=Mov((CD-OD),Periods,S); Sig:=Mov(A1,5,S); A1:=ExtFml("PowerPivots.TDataLocalize",A1, factor, offset); Sig:=ExtFml("PowerPivots.TDataLocalize", Sig, factor, offset); 0;A1;Sig; The above indicator can plot the Value of an indicator from a higher time frame Factor =1 plots just like a normal indicator Factor =2 Plots 2 X the base time frame IE; if you chart a 1 min chart factor =2 will plot the indicator from a 2 min chart onto the 1 min chart if you chart a 5 min chart factor =2 will plot the indicator from a 10 min chart onto the 5 min chart if you chart a daily chart factor =2 will plot the indicator from a weekly chart onto the daily chart

factor:=Input("TFactor", 0, 1000, 1); offset:=Input("Offset", 0, 1000, 0); CD:=ExtFml("PowerPivots.TDataCreate",3, factor); Raschke:= Mov(CD,3,S) - Mov(CD,10,S); A:=Mov(Raschke,16,E); Green:=If(A>Ref(A,-1),A,0); Red:=If(A<Ref(A,-1),A,0); Signal:=Mov(A,5,S); Green:=ExtFml("PowerPivots.TDataLocalize",Green, factor, offset); Red:=ExtFml("PowerPivots.TDataLocalize",Red, factor, offset); Signal:=ExtFml("PowerPivots.TDataLocalize",Signal, factor, offset); Signal; Green; Red;

factor:=Input("Time Factor", 0, 1000, 1); Trendfactor:=Input("Trend Factor", 0, 1000, 2); offset:=Input("Offset", 0, 1000, 0); TD:=ExtFml("PowerPivots.TrendDirection",1,TrendFactor); HD:=ExtFml("PowerPivots.TDataCreate",1, factor); LD:=ExtFml("PowerPivots.TDataCreate",2, factor); LL:=If(LD=LLV(LD,5),LD,If(Ref(LD,-1)=LLV(LD,5),Ref(LD,-1),If(Ref(LD,-2)=LLV(LD,5),Ref(LD,-2),If(Ref(LD,-3)=LLV(LD,5),Ref(LD,-3),If(Ref(LD,-4)=LLV(LD,5),Ref(LD,-4),0))))); HH:=If(HD=HHV(HD,5),HD,If(Ref(HD,-1)=HHV(HD,5),Ref(HD,-1),If(Ref(HD,-2)=HHV(HD,5),Ref(HD,-2),If(Ref(HD,-3)=HHV(HD,5),Ref(HD,-3),If(Ref(HD,-4)=HHV(HD,5),Ref(HD,-4),0))))); NH:=ValueWhen(1,HD>Ref(HHV(HD,5),-1),HD); NL:=ValueWhen(1,LD<Ref(LLV(LD,5),-1),LD); Set1:=HHV(HD,3)<HHV(HD,4); Set2:=LLV(LD,3)>LLV(LD,4); Val1:=ValueWhen(1,BarsSince(HD>Ref(HHV(HD,5),-1))=3 AND Set1=true,NH); Val2:=ValueWhen(1,BarsSince(LD<Ref(LLV(LD,5),-1))=3 AND Set2=true,NL); Val3:=ValueWhen(1,BarsSince(HD>Ref(HHV(HD,5),-1))=3 AND Set1=true,LL); Val4:=ValueWhen(1,BarsSince(LD<Ref(LLV(LD,5),-1))=3 AND Set2=true,HH); TB:=If(Sum(TD>0,2)>1,Val1,Val4); BB:=If(Sum(TD>0,2)>1,Val3,Val2); TB:=ExtFml("PowerPivots.TDataLocalize",TB, factor, offset); BB:=ExtFml("PowerPivots.TDataLocalize",BB, factor, offset); TB;BB; just make sure That trend factor is greater than Time factor