MACD Weekly

[the pro]

Hi Guys

I have just designed a spreadsheet which tells me if my limit order will point the MACD in the right direction if it hits the limit price. managed to code it for Daily numbers 12,26,9 can anyone point me to some code on how to calculate the 12,26,9 weekly numbers. It's not the same as 60,130,45 on the daily, close but not close enough.

Any help greatly appreciated, i am working in excel.

Thanks

 

[Purple Brain]

The only difference is the data going through the calculation.

I presume you're working with daily data? If so, simply use just Friday's close from each week's data.

 

[the pro]

The only difference is the data going through the calculation.

I presume you're working with daily data? If so, simply use just Friday's close from each week's data.

Hi Purple Brain

That's it is it, simply take the Friday, close.

Okay, thanks alot will re-jig spreadsheet