With my spreadsheet I mainly just track the cost basis, dividend yield, yield on cost and total returns on the main sheet. Then I have a tab set up for all of my reinvested dividend shares, another tab tracking the dollar value of dividends received for each holding and a final tab for my transactions.
I have a separate spreadsheet set up where I enter information for dividend increases, splits and other important info for each of my stocks.
I also have a portfolio with the holdings entered into Yahoo Finance and Seeking Alpha so I can get news on the companies and track the fundamentals.
When doing my research I focus on historical earnings and dividend growth, projected earnings, debt load and shareholder friendliness of the company. I use Fastgraphs.com, David Fish's CCC list http://dripinvesting.org/Tools/Tools.asp and Robert Allen Schwartz's dividend CAGR site http://www.tessellation.com/dividends/streaks.html to research.
I have a separate spreadsheet set up where I enter information for dividend increases, splits and other important info for each of my stocks.
I also have a portfolio with the holdings entered into Yahoo Finance and Seeking Alpha so I can get news on the companies and track the fundamentals.
When doing my research I focus on historical earnings and dividend growth, projected earnings, debt load and shareholder friendliness of the company. I use Fastgraphs.com, David Fish's CCC list http://dripinvesting.org/Tools/Tools.asp and Robert Allen Schwartz's dividend CAGR site http://www.tessellation.com/dividends/streaks.html to research.