My primary reason for this post however is to get your opinions on how you might prefer to see my portfolio on here. I've recently taken a look at GoogleDocs and their spreadsheets. The main attraction is that it will auto update the stock prices for me, saving time! (Will include how to in my next Excel Spreadsheet post)
I am looking for any comments on which look better, preferred table and readability? Please comment below and let me know! I may also include some more info within the Google spreadsheet.
My Portfolio as of August 15, 2014 (GoogleDoc Spreadsheet)
Ticker | Shares | Current Price | Book Value | Market Value | Yearly Dividends | % P/L | Adjusted % P/L | Portfolio % |
AQN | 89 | $8.52 | $615.29 | $758.28 | $34.00 | 23.20% | 26.90% | 7% |
BCE | 21 | $44.33 | $1,005.63 | $930.93 | $51.87 | 0.80% | 3.10% | 9% |
BNS | 6 | $66.46 | $393.60 | $398.76 | $15.36 | 10.40% | 13.30% | 4% |
CLF | 11 | $16.77 | $213.82 | $184.47 | $7.38 | -0.40% | 1.10% | 2% |
D.UN | 61 | $28.95 | $1,748.70 | $1,765.95 | $136.88 | 1.00% | 4.50% | 16% |
NA | 6 | $48.84 | $267.00 | $293.04 | $11.52 | 9.80% | 12.90% | 3% |
PPL | 23 | $33.81 | $959.80 | $777.63 | $40.02 | 14.50% | 15.50% | 10% |
PZA | 60 | $24.96 | $810.00 | $1,497.60 | $48.02 | -1.60% | 0.60% | 7% |
RY | 7 | $73.34 | $511.35 | $513.38 | $19.88 | 9.30% | 10.30% | 5% |
TD | 18 | $52.03 | $941.04 | $936.54 | $33.84 | 8.40% | 9.20% | 9% |
VSN | 98 | $18.77 | $1,708.14 | $1,839.46 | $97.96 | 7.70% | 8.20% | 17% |
ZDV | 26 | $18.69 | $476.26 | $485.94 | $19.34 | 2.00% | 3.00% | 4% |
$9,650.63 | $10,381.98 | $516.07 | 7.58% |
My Portfolio as of July 23, 2014. (Microsoft Excel)
They both look good to me but if you want another option you might want to check out the plugin Tablepress. It's a plugin that allows you to build tables and looks very clean to me. Here is my portfolio using Tablepress http://divhut.com/portfolio/
ReplyDeleteThanks for the feedback and letting me know about Tablepress, I think iv seen a few people using it. Seems like its a good option for displaying larger portfolio and the like,
ReplyDelete