Hi, I want to test buying and selling on a MONTHLY MACD that uses the standard period setting of 12, 26, 9 periods. Which brings this formula: (Mov(C,360,E))-(Mov(C, 780, E)) I multiplied the periodes with 30 days for this, but Metastock starts to complain that "its out of valid range of the MOV function". Is there a way around? If this after all seemed easy i would like to finish on my monthly system test formula, where i want to simulate selling when MACD turns down (above 0) and buy when MACD turns up (below 0). For this far i came up with: {MACD conversion to a monthly 12, 26, 9 period for system test} {Parameters} {MACD-line (periods in days x 30 days a month)} A:= (Mov(C,360,E))-(Mov(C, 780, E)); {Signal-line, MACD} B:= Mov(A, 270, E); Positive:= A>0; Negative:= A<0; {Buy conditions} Buy:= Cross(A, B) AND Negative; Sell:= Cross(B, A) AND Positive >> NOW I NEED THE END THAT TRIGGERS BUY AND SELLS. This i dont understand to well, alt[censored]gh kind JJstein already thought me a lot as beginner ;) Thanks. Michel

Hi, Yes i had to change from account because i (already) lost my psw and the forum is unbelievable slow here to reset things. There seemed to be no forumadmin when i emailed. So for now its Michel11 and i note the psw. The formula worked wel thanks for your bright look on the month data. I skipped this part: Positive:=A>0; Negative:=A<0; That gave better results. Now my remaining issue is how to include short-selling positions directly after selling-moments. I guess almost the same formula needs to be put under the tab "sell short order" within the System editor, isn't it? Thank you again. Michel

Hi, Got it working. I was now building on the exploration editor to identify the postive crossings of MACD with signal lines in securities WITHIN THE LAST 5 DAYS. Therefore i came up with the alert function in the end, but i am not sure that it actually is enough this way... I came up with {MACD-line (periods in days x 20 days a month)} A:=(Mov(C,240,E))-(Mov(C,520,E)); {Signal-line, MACD} B:=Mov(A,180,E); {Buy conditions} P:=Cross(A,B); Alert(P, 5) It is finding loads of securities that apply to this and certainly not only the ones that crossed within the last 5 days on the montlhy graph. Any finals on this one would be highly appreciated again. grtz Michel

Hi, I now put the formula in the filter tab and used POS instead of P. It didnt notice it because i wrote in the 'NOTE' area :/ (oh me). I also changed it to the normal macd values 12, 26. {MACD-line 12,26} A:=(Mov(C,12,E))-(Mov(C,26,E)); {Signal-line, MACD} B:=Mov(A,9,E); {Buy conditions} Pos:=Cross(A,B); Alert(Pos,36)

---

In the options tab i selected MONTHLY, because i want to see the monthly crossings only of MACD 12, 26 and the 9 period signal-line. These seems to be the more succesful trade signals. I see from the NASDAQ COMP graph that the latest crossing took place halfway 2009. Unfortunatly the explorer is not yet selecting the event with the above used formula in the filter tab. I searched with the alert-function in the last 36 periods (months) as you see, so it should have seen it. I wonder why... Do you see whats the missing part? Thanks, Michel

Thanks Johnatan. Your knowledge has no boundaries. grtz Michel