11-03-2014, 09:31 AM
(11-03-2014, 02:27 AM)earthtodan Wrote: You can create a portfolio in Google Sheets by entering some formulas that stream stock prices, and building in some metrics like gains and losses on your cost basis. So, at the risk of spending even more time thinking about investing than I already do, I decided I might as well test out a few strategies with virtual portfolios and see how they perform over time. The only complication will be tracking dividend payments and manually reinvesting the dividends.
There are 5 strategies being compared.
DGI: Classic dividend growth stocks
Deep value: Oversold or special situation stocks, i.e. extreme buy-the-dips
High yield: Unapologetic yield chasing
Growth: High earnings growth (dividend optional)
Debt free: Debt/equity ratio at or near 0
Each portfolio starts with exactly $100k divided up into 5-8 positions, roughly evenly weighted as of the weekend of 11/2/14. There is a small cash balance to round up to $100k to start. Since I don't know of any notification system for dividends received on positions I don't own in real life, I plan to scan for dividend payments every month or so and add them to the cash balance. At the end of each month, I will deploy the cash. All accumulated cash is invested into whatever presents the best value at the time, not necessarily the stock that paid the dividend (no DRIP). Trade fees are assumed to be $0. I decided not to add any virtual cash contributions to these portfolios over time, because that would make it very difficult to track the internal rate of return.
The spreadsheet can be viewed here:
https://docs.google.com/spreadsheets/d/1...sp=sharing
As I write this on a Sunday night, all positions are at the cost basis and all gains/losses are 0, so all text is black and all portfolios are exactly $100k. In the morning when the market opens, positions will start showing red and green. It should be interesting to see how they do against each other.
I like it, thanks for sharing. Will be following along with the progress.
I'm a spreadsheet junkie as well, love my google docs.