Stock splits are an issue for your data provider. MS is a charting tool. It will plot whatever data you feed it (within reason). If a split or consolidation has ocurred, your data provider should be making those adjustments for you. At least, a good data provider will do that for you. wabbit :D

I personally see little point in considering external DLLs, when a binary date function can be easily coded within MetaStock's formula language: [code:1:a5c615b028] =========== Date filter =========== ---8<--------------------------- { Date filter Plots +1 binary signal within user-input date period. For personal use only. http://www.metastocktools.com } { Date inputs } StDay:=Input("start Day",1,31,1); StMnth:=Input("start Month",1,12,1); StYear:=Input("start Year",1800,2200,2006); EnDay:=Input("end Day",1,31,31); EnMnth:=Input("end Month",1,12,3); EnYear:=Input("end Year",1800,2200,2006); { Selected date period } start:=Year()>StYear OR (Year()=StYear AND (Month()>StMnth OR Month()=StMnth AND DayOfMonth()>=StDay)); end:=Year()<EnYear OR (Year()=EnYear AND (Month()<EnMnth OR Month()=EnMnth AND DayOfMonth()<=EnDay)); { Plot in own window } start AND (end OR (start AND Alert(start=0,2))) ---8<--------------------------- [/code:1:a5c615b028] jose '-)

The binary date filter code above will return a date exactly three months after the first input date. It will also find the nearest trading day, so no need to worry about missing chart data on weekends or holidays. jose '-)

Well, i received the Message of all of you. I want to tell you that i am Grateful to all of you. My Trust and my Confidence to all of you is Extremely Big! I want to note here, that i put the Metastock Formula of my favourite Jose into my Indicator Builder of Metastock and then try the Formula. I quiet believe that the Formula does not work well. The reason of that is because i believe that Jose did not understand well my Thought. I am sorry for that. I am sure that my Favourite Jose can create that kind of Formula in Nanoseconds!!! This also, does not mean that other People can not create it! I want to repeat that i appreciate for everyone's Help!!! I will try to tell again the Problem!

---

Do you believe that exist Date Formula which can make the following thing: When a Formula occurs in any Day, for example the Formula/s: Fml("Max DLRL Delta 20") (or for example, the other Formula Fml("APO H 120") or any other Formula that someone can imagine if you like), then from the Day that the above Formula is TRUE, meaning that occurs, or we have TRUE Signal of it, until exactly after 3 Months (For Example), to be True or False the following Metastock Formula: (HHV(H, 20)-L)*100/HHV(H, 20) > 15 For example, suppose that the Fml("Max DLRL Delta 20") (or for example, the other Formula Fml("APO H 120") or any other Formula that someone can imagine if you like), occur exactly the 31/10/2005, then, when happen that, the (HHV(H, 20)-L)*100/HHV(H, 20) > 15, from 31/10/2005 until exactly 31/01/2006 to be True or otherwise False, so, to receive Price 1 for the True and 0 for the False. Do you believe that can exist a Formula like that? Kind Regards, George Kanellopoulos.

Wabbit, Thank you for your Message. I see it and i want to note, that suppose, the Signal occurs in 30 November 2005. Then the 3 Month Period is until and 28 February 2006. Suppose a Signal that occurs in 01 January 2005 then the 3 month Period after that Day, is until and 31 March 2005. Suppose a Signal that occurs in 15 January 2005 then the 3 month Period after that Day, is until and 14 April 2005. I do not remember well how Metastock Formula Language calculate theMonth() Period, i mean calculate it like the above examples or, like, Suppose the Signal occurs in 30 November 2005. Then the 3 Month Period is until and 28 February 2006. Suppose a Signal that occurs in 01 January 2005 then the 3 month Period after that Day, is until and 01 April 2005. Suppose a Signal that occurs in 15 January 2005 then the 3 month Period after that Day, is until and 15 April 2005. Etc. Kind Regards, George Kanellopoulos.

George, I have done some quick code..... --8<-------------------------------------- whichDay:=Fml("Max DLRL Delta 20"); theDay:=ValueWhen(1,whichDay,DayOfMonth()); theMonth:=ValueWhen(1,whichDay,Month()); theYear:=ValueWhen(1,whichDay,Year()); {add three months} theMonth:=theMonth+3; theYear:=If(theMonth>12,theYear+1,theYear); leapYear:=Mod(theYear,4)=0 AND Mod(theYear,100)<>0 OR Mod(theYear,400)=0; theMonth:=If(theMonth>12,theMonth-12,theMonth); theDay:= If(theMonth=4 OR theMonth=6 OR theMonth=9 OR theMonth=11,If(theDay>30,30,theDay), If(theMonth=2 AND leapYear, If(theDay>29,29,theDay), If(theMonth=2 AND leapYear=0,If(theDay>28,28,theDay),theDay))); {ddmmyy} theNewDate:=(theDay*10000)+(theMonth*100)+Mod(theYear,100); theNewDate; --8<-------------------------------------- See what you can do with this. theNewDate is the date exactly three months after the last instance that Fml("Max DLRL Delta 20") was true. You might need some latches or something toprevent multiple instances etc resetting the three months etc. The return date is just a date. It doesnt match to trading days or anything else so you are going to have work around that. Anyway, see how you go. Any problems, just let me know. Hope this helps. wabbit :D

George, You don't know me that well do you? Did you really think I was going to do all the work for you??? I had to leave you to do something yourself! Have a try at including your second criteria. You know when the first date event occurs, my code will tell you when the three months are up, there has been enough code to sink a battleship to decide if another date is between two dates, so all you have to do is put it all together, if(betweendates, if(second criteria, then, else), else ) etc Have a go. If you get stuck, ask for help. wabbit :D

"Hi George, This project was trickier to code than I thought, but I have tested it on several charts and it plots perfectly. Please see attached pic. I have added some useful extra options to the code - let me know what you think. And if you are happy with the code, please don't forget to mention it in the forum. ;) Regards, jose MetaStock -> Tools -> Indicator Builder -> New -> Copy and paste all three complete formulae between "---8<---" lines. Make sure all indicators are named correctly. ========================== George-K - Original signal ========================== ---8<----------------------------- { Place original signal code below. Example: } Cross(Mov(C,63,S),Mov(C,252,S)) ---8<----------------------------- =============================== George-K - Calendar Day counter =============================== ---8<------------------------------------ {Gregorian calendar Week/Day counter v3.0. Count is independent of any missing chart data. ©Copyright 2002~2006 Jose Silva. The grant of this license is for personal use only - no resale or repackaging allowed. All code remains the property of Jose Silva. http://www.metastocktools.com } { User inputs } adj:=Input("Week's start: [0]Sunday, [1]Monday",0,1,1); plot:=Input("Count: [1]Weeks, [2]Days",1,2,2); { Calendar counter engine } leap:=Frac(Year()/4)=0 AND Frac(Year()/100)<>0 OR Frac(Year()/400)=0; y:=Year()*365+Int(Year()/4) -Int(Year()/100)+Int(Year()/400)-730484; m:= If(Month()=2,31-leap, If(Month()=3,59, If(Month()=4,90, If(Month()=5,120, If(Month()=6,151, If(Month()=7,181, If(Month()=8,212, If(Month()=9,243, If(Month()=10,273, If(Month()=11,304, If(Month()=12,334, -leap))))))))))); DayNr:=y+m+DayOfMonth(); adj:=adj+If(DayNr<1,1,2) -(Frac(Year()/100)=0 AND Frac(Year()/400)<>0); WkCount:=Int((DayNr-adj)/7)+(Year()>=2000); { Plot in own window } If(plot=1,WkCount,DayNr) ---8<------------------------------------ ================================= George-K - Extended Binary signal ================================= ---8<----------------------------------- { Extends original binary signal by Nth weeks or months. Signal extension period is independent of any missing chart data. ©Copyright 2006 Jose Silva. The grant of this license is for personal use only - no resale or repackaging allowed. All code remains the property of Jose Silva. http://www.metastocktools.com } { User inputs } pds:=Input("Extend original signal by x periods",0,520,3); type:=Input("Extension periods, use: [1]Weekly, [2]Monthly",1,2,2); fill:=Input("Fill binary signal? [1]Yes, [0]No",0,1,1); { Reference signals } signal:=Fml("George-K - Original signal"); { Reference Calendar day/week counter } day:=Fml("George-K - Calendar Day counter"); week:=FmlVar("George-K - Calendar Day counter","WKCOUNT"); { Calendar month adjustment } m:=Month(); nuMonth:=m<>Ref(m,-1) OR Cum(1)=2; leap:=Frac(Year()/4)=0 AND Frac(Year()/100)<>0 OR Frac(Year()/400)=0; adj:=If(m=5 OR m=7 OR m=10 OR m=12,1, If(m=3,3-leap,0))*nuMonth; adj:=Cum(adj)-ValueWhen(1,signal,Cum(adj)); mthPds:=pds*31-adj; mthPds:=If(mthPds<1,1,mthPds); { Count Calendar periods since signal } counter:=day-ValueWhen(1,signal,day); wkCounter:=week-ValueWhen(1,signal,week); { Extended signal binary by x periods } weekSignal:=wkCounter>=0 AND wkCounter<pds; weekSignal:=If(signal AND weekSignal=0, signal,weekSignal); mthSignal:=counter>=0 AND counter<mthPds; { Select weekly or monthly extension } extSignal:=If(type=1,weekSignal,mthSignal); { Eye candy } even:=Frac(Cum(1)/2)=0; odd:=Frac(Cum(1)/2)<>0; { Plot in own window } If(fill*extSignal,even,0); If(fill*extSignal,odd,0); extSignal ---8<----------------------------------- "

Hi George, > The Formula is very complicated for to understand it with a first > look. I've added comments wherever possible to help understanding. > Let me ask you if the "Original Signal" , > meaning, the any first Formula, that i had mention in my Messages i > mean: > > Fml("APO L 120") > (or for example, the other Formula Fml("APO H 120") or any other > Formula that someone can imagine if you like) ? Exactly - you can put any code inside that indicator, such as Fml("APO L 120"), Fml("APO H 120"), or any MetaStock code. > Also i can not found where is the second Expression that must also > occurs, into your Formulas, i mean, > > (HHV(H, 20)-L)*100/HHV(H, 20) > 15 I've made the final "George-K - Extended Binary signal" without any secondary signals, so that it is easier for you to test if it is working accurately. I've also made the indicator as modular and flexible as possible, so that you can use it with other formula conditions as well. For your condition above, create a new indicator: ---8<--------------------------- (HHV(H,20)-L)*100/HHV(H,20) > 15 AND Fml("George-K - Extended Binary signal") ---8<--------------------------- It's as easy as that! :) Now the [(HHV(H,20)-L)*100/HHV(H,20) > 15] signal will only appear within the 3 month period from the original signal. You can also copy the original "George-K - Extended Binary signal" indicator, and change the last three lines of code: >From this: { Plot in own window } If(fill*extSignal,even,0); If(fill*extSignal,odd,0); extSignal To this: { Plot in own window } (HHV(H,20)-L)*100/HHV(H,20) > 15 AND extSignal Regards, jose

Dear Jose, Hello Again. I want to ask you something important. You include on all that Formula/s, the Day Phenomenon that exist in the February, every 4 Years with 29 Days? In my Message when, Suppose, the Signal occurs in 30 November 2005, Then the 3 Month Period for calculation is until and 28 and February 2006. But forgot to say the following: Suppose now, the Signal occurs in 30 November 2004. Then the 3 Month Period for calculation is until and 29 February 2004. So, you include and that in the Formula/s? Kind Regards, George Kanellopoulos.