The TD direct investing platform offers useful return calculations (effectively shows your simple rate of return, and does not accurately handle contributions / withdrawals). Will give this a try, thanks for sharing.
Yes it does calculate your portfolio return using both methods.
The money-weighted return is simpler to calculate, leveraging the XIRR formula built into Google Sheets.
The time-weighted return is calculated using a script that cycles through each month in your trading history, calculating the starting balance / investment return / ending portfolio balance at each month. Those monthly rates of return are then chained together to calculate your aggregate time-weighted return.
Portfolio Slicer is very comprehensive, but there are some drawbacks:
- Doesn't work on Macs
- User is required to maintain their own csv files containing daily pricing data for their stocks
- For the point above, yes this can be somewhat automated with scripts, but it is still a finicky process
The spreadsheet I posted works on any operating system and uses google finance formulas to automate the pulling in of pricing data for any stock at any date.
Yes, your mechanism is better (portable, automatic updates, etc.).
How hard would it be to add the Postfolio Slicer stuff to your spreadsheet?
Postfolio Slicer is not well maintained, I would be happy to send you some $$$ if you can integrate what is missing (allocation per sector, support of asset allocation ETF's, missing charts, etc).
I will work on building those extra charts / features.
BTW -- the allocation per sector chart is already available on the Dashboard tab. You can tag each stock with an investment category on the Setup drive, which then drives that chart.
"User is required to maintain their own csv files containing daily pricing data for their stocks".
FYI, this is not correct, the daily quotes are automatically retrieved from Yahoo Finance (or others) and the CSV is automatically generated. Doing this manually would be a pure nightmare!
10 comments
[ 4.1 ms ] story [ 35.4 ms ] thread- Uses Google Finance formulas to automatically pull the current share price of your investments daily
- Calculates the $ and % return of your portfolio between any range of dates
- Comparison of your portfolio’s performance versus the S&P 500 index and any custom benchmark of your choice
- Dividend tracking
- Reporting on realized gains (super helpful during tax time!)
- Flexibility to group your investments into custom categories (e.g., domestic stocks, international stocks, bonds, etc.)
- Tracks assets in multiple countries, and converts all values into one common currency
- Automated re-balancing calculations versus your target asset allocation
- Supports up to 250 stock tickers, 10 investment accounts, 25 investment categories, and 5 currencies
The money-weighted return is simpler to calculate, leveraging the XIRR formula built into Google Sheets.
The time-weighted return is calculated using a script that cycles through each month in your trading history, calculating the starting balance / investment return / ending portfolio balance at each month. Those monthly rates of return are then chained together to calculate your aggregate time-weighted return.
- Doesn't work on Macs - User is required to maintain their own csv files containing daily pricing data for their stocks - For the point above, yes this can be somewhat automated with scripts, but it is still a finicky process
The spreadsheet I posted works on any operating system and uses google finance formulas to automate the pulling in of pricing data for any stock at any date.
How hard would it be to add the Postfolio Slicer stuff to your spreadsheet?
Postfolio Slicer is not well maintained, I would be happy to send you some $$$ if you can integrate what is missing (allocation per sector, support of asset allocation ETF's, missing charts, etc).
BTW -- the allocation per sector chart is already available on the Dashboard tab. You can tag each stock with an investment category on the Setup drive, which then drives that chart.
FYI, this is not correct, the daily quotes are automatically retrieved from Yahoo Finance (or others) and the CSV is automatically generated. Doing this manually would be a pure nightmare!