MACD Weekly

the pro

Member
65 0
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

Experienced member
1,613 179
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

Member
65 0
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
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock