Hi, anyway you can make this pop out? Scrolling back and forth to match the quarters with the dividends with the symbols is frustrating.
Anonymous,My I.T. skills are very limited so at this time the answer is no. However if anyone can walk me through the process with Blogger I would be happy to try it out. The good news is that in five weeks we will be back to January! :-)MDP
What works for me:Click on "Design" and then "Pages". Click on "edit" for the "Page" you want to edit. At the top left hand corner, you have the option of selecting "Compose" or "HTML". Click on "HTML" and increase the number between quotation marks for height and width.I don't know how to make it "pop out" though.
Thanks ADY. That helped. It's not exactly centered at least you can see every month!
MDP,This looks like a really nice dividend machine you have built for yourself. I like that you are tracking your portfolio weight, you are ensuring diversification, and also using timesaving tools like google docs.Good luck in your dividend investing journey!Dividend Growth Investor
Another easy thing is to add the tickers again in the final column on the right side of your spreadsheet, this is easy to do and particularly useful when looking at the second half of the year.
follow "Average dividend Yield" instructions and after you click "HTML" write the following on at the very beginning of the text field, ((((remove the new lines, I added them to make this comment system accept the text)))):<a href="https://docs.google.com/spreadsheet/pub?key=0AidxnMznC0jgdEI4dXBXY3E3OXYtZ042RzdQUnI4NUE&output=html&widget=true" target="_blank">View a full screen version of my profile</a><br>
Much, much better. Thank you!
Hello SIr,i am from Germany and i can not found the shares in your first column for example AHITX. It is possible to write in a extra colum the isin number to identify this shares on my financial sites? Or do you have a extra overview about that?Thank you very much in advance.BrgdsSky
Sky,Sorry about that. I had the share count in 2014 and just forgot to add it to 2015.MDP
No Problem. I think i used the wrong words. I would say that i can not understand the company´s behind your short term. For Example AHITX. I would like find this company but i can not find it because my search engine dont know it.
And this company CAIBX !
Sky,No problem. CAIBX and AHITX are mutual funds. CAIBX is comprised mostly of dividend stocks with some bond holdings and AHITX is a high yield (junk bond) fund that makes monthly interest payments.I hope that helps.MDP
Great looking spreadsheet there. I should probably do something more along those lines so I know exactly what months the companies I own usually pay in. We have a bunch of the same companies so at least I've got a head start!Thanks
Great Looking portfolio, I hope one day to get there!
I am currently in Australia, in AU, the dividend tax can be paid off by the enterprise, when they enterprises start the announcement of dividend payment, they will have a frank value in percentage, which means the ratio of dividend tax the company will pay for investors. Not sure if America has this?
Great sheet! This does provide 100% insight in your status. Do you make any graphics with that for yourself? Cheers and keep up the good work!
And you're invited at https://thedutchlakehouse.blogspot.nl/ ;)
Walter,No graphs. They are beyond both my capability and my patience levels. :-)MDP
I like your Dividend spreadsheet, I'me going to try the same in my blog. I'm learning about you and all comunity.
How do you calculate your YOY row? Thanks.
Simply the NEW year amount minus the PREVIOUS year amount (on the same month).For ex. =SUM(D103-D104)