The end of the year is approaching and I decided to get
my portfolio tracking spreadsheets caught up.
Not exact matches
The screen is
tracked publicly as a continuous hypothetical
portfolio with a starting balance of $ 100,000 on Scott's Investments (see the right hand column for a link to the
spreadsheet).
For
tracking portfolios and stock watch lists, I use a combination of Yahoo Finance and
spreadsheets.
First, I keep a
spreadsheet (similar to the ones I have published on this site for my
portfolios) that
tracks all of my holdings, div / share, annual income, yield, etc..
The
spreadsheet will
track portfolio allocations and 10 month SMA signals.
The Ivy
Portfolio spreadsheet track the 10 month moving average signals for two
portfolios listed in Mebane Faber's book The Ivy
Portfolio: How to Invest Like the Top Endowments and Avoid Bear Markets.
The screen is
tracked publicly as a continuous hypothetical
portfolio with a starting balance of $ 100,000 on Scott's Investments (see the right hand column for a link to the
spreadsheet).
To keep
track of how the
portfolios he's built are doing, he learned how to calculate annualized returns with a
spreadsheet.
I have an expense
tracking spreadsheet, a net worth
spreadsheet, and a
portfolio analyzer
spreadsheet.
We have a
spreadsheet that we use to keep
track of our dividends stock
portfolio but will certainly give this a try.
I hope & presume you have an (Excel)
spreadsheet to keep
track of your
portfolio?
I
track this
portfolio (and others) monthly on Scott's Investments using a
spreadsheet.