Do you believe that the technical analysis in the stock market works? If your answer is yes, you can try to use excel to help you make an informed decision and choose the optimal parameters. I chose the moving average (MA) as an example of technical analysis, the MA and its different combinations have been used for a long time in the stock market to support investments. Now with Excel you can download time series of any stock automatically and start building your own analysis. I calculated the optimal MA for all stocks in the SP&500 using data tables. Excel is very flexible when you want to implement new methods and ideas. Enjoy!
Optimal Moving Average
Technical details: Install the Stock Market Functions add-in (link) and use data tables. The link to my excel file is here.If you found this helpful, please share.
No comments:
Post a Comment