Originally Posted by: jhmathisjr

Hello,

Need assistance in writing a formula for a MACD Crossover on a Weekly basis. In other words, a MACD crossover as it occurs on a Weekly chart

Thanks

Hello,

The MetaStock formula language calculates on the interval of the chart. So if you are looking at a Weekly chart, a formula plotted on this chart would be operating off weekly values.

The basic formula for MACD crossing its (9 period exponential) signal line (using the built-in MACD function) is:

{Cross Up}

Cross(MACD(),Mov(MACD(),9,E))

{Cross Down}

Cross(Mov(MACD(),9,E),MACD())

Things get a bit more complicated if you want to calculate a Weekly MACD from Daily data, which essentially requires "compressing" the data programmatically. Such formulas can vary in complexity, accounting for holidays, differing end-of-week dates, etc.

Originally Posted by: jhmathisjr

Hello, Thanks for your reply - so here's what I'm wanting to do, write an exploration that executes the following: - Detect securities in which the MACD has previously crossed on a WEEKLY basis and - Detect from these securities when a MACD crossover has occurred on a DAILY basis (I know the formula for this) Thanks

You can run an exploration on the Weekly interval using the same formula, but if you want to have it all in one report using Daily data, then the formula gets more complicated as mentioned. Others have discussed this on the forum in the past, you can check out topics like https://forum.metastock.com/posts/m170829-Using-both-daily-and-weekly-data-in-one-exploration for some examples.

If that does not suffice and you are unable to get further help here, you can always request custom formula work via https://www.metastock.com/customer/resources/formulas/customformulaform.aspx