I am desperately looking for some help in calculating 2000, 500, and 100 period hull moving average on a big dataset. I understand to do this I would need to first calculate the weighted moving average of each of these periods also (but I am unsure how to do this without having to type in an extremely long formula (especially for the 2000 period weighted average as every data point would have a different moving average).
The dataset is the Dow Jones Industrial Average Daily Price from 1900 to present. Therefore a 2000 weighted and hull moving average would start on the 2000th trading day in the data and any formula would easily be able to be dragged down to the rest of the data set.
Any help would be great, I was looking to attach the dataset and columns I am trying to work out to the post but it appears that is not allowed.
Thank you.
FYI I have no experience of using code but if this is the most feasible option please let me know.
The dataset is the Dow Jones Industrial Average Daily Price from 1900 to present. Therefore a 2000 weighted and hull moving average would start on the 2000th trading day in the data and any formula would easily be able to be dragged down to the rest of the data set.
Any help would be great, I was looking to attach the dataset and columns I am trying to work out to the post but it appears that is not allowed.
Thank you.
FYI I have no experience of using code but if this is the most feasible option please let me know.