Stock DRIP Log for Google Sheets
 
A Basic Spreadsheet to Track your Dividend reinvestment Purchases


Canadian DRIP FAQ  U.S. DRIPs  Letters  Canadian DRIP & SPP List  Links  Contact Us


A basic spreadsheet to keep track of your
DRIP & SPP purchase dates and reinvestments.


Due to changes in Web Data Queries in Excel, they are no longer functioning.

I recommend using Google Sheets since it's free and Google Finance can provide stock quotes.
Sample available here.

Select "File" - "Make a Copy" to make a copy to your Google Sheets account.

Instructions

From
your Statement from the Transfer Agent:

  1.  Fill in purchases manually, except for the last "Total" line which will be calculated.

  2.  Then fill in all cells for reinvested dividends (using discounted price if applicable).  Bottom line totals will be calculated.

  3. For current share price, use the Google Finance function eg. =GOOGLEFINANCE("BCE.to", "price") for BCE.

  4. Add more lines to either "Purchases" or "Dividends" by right-clicking on the NUMBER of a blank row and selecting "Insert".


Totals at bottom will be calculated automatically

Total return is a simple return including fees paid.
Adjust Cost Base is total cash value of all share purchases including any fees, plus all reinvested dividends.

 

In case you want the old spreadsheet

Download the Old Log File  (.xls)



In the Event of a Stock Split


If a company that you DRIP decides to declare a stock split, or issue a share dividend, it will be important to maintain proper ACB Per Share if you ever sell/transfer a single share.

Remember, a Stock Split does not change your Adjusted Cost Base, since the total amount of money you have invested or had reinvested from dividends has not changed.