An idea would be to collect the last X weekly Close and make their average. The hard part is to calculate the Standard Deviation on a non linear data serie and without array.
That method can also be applied and I might have the solution for Standard Deviation but it needs to be performed on Spreadsheet.
I have confirmed with the author and he said that 5×20=100 can work fine. It will be not the same but quite good enough. Further analysis can be performed.
Thank you guys for your input. I really appreciate it.
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.