I like to use the 5 EMA of the WEEKLY closing data as part of my filtering system
...to see if it is moving up or down?
I can calculate this in Excel.. but it’s just a bit fiddly to incorporate with daily data. I’d like to keep my spreadsheet simpler.
Would anyone know which daily EMA is the closest mathematically to a 5 EMA weekly.
Logically it would appear to be the 25 EMA (5 days *5 weeks) but 20 EMA daily sometimes looks closer when I chart them.
Is it calculatable? Or am I trying to compare oranges and apples?
Thank you for your help.