hillsborough nj
Experience: Advanced
Platform: Tradestation/Excel
Broker: TradeStation
Trading: emicro
Posts: 98 since Sep 2018
Thanks Given: 18
Thanks Received: 46
|
Hi,
I use Excel VBA for analysis and have made a few posts on here.
I don't consider dividends in my analysis, but have been sort of rethinking that. Theoretically, as long as adjusted prices are used, dividends can be ignored - certainly makes programming easier to do that. I'm slightly interested in total return analysis and have been considering including dividends; however it is a non-trivial amount of work to set up and the benefits are doubtful.
Your chart Base 100 Dividends is not convincing - stock prices and dividends are rising over time (16 years) but not sure what that suggests other than that the company (or whatever you are looking at) is viable.
Your arrangement of multiple securities prices horizontally in columns is a bit questionable. Each security should have its own worksheet. When a summary type display is necessary, that should be built from the individual detail security worksheets that one is interested in. The columnar arrangement is a design flaw that probably has to be corrected if you want to improve your analysis.
Correlation matrices are easy to set up (google - correlation matrix excel vba). In this case, you have a little advantage in that your data is already set up in columns.
InvestExcel is a decent place to get excel examples.
Good luck in your research, it looks like you have made a good start.
|