=googlefinance() for dividends? A workaround for getting dividends into Google Sheets
The =googlefinance() function in Google Sheets does not yet have an automatic way to bring in the dividend yield, so it must be done manually. In this video I show a very quick way to update dozens of dividends in just a few clicks. While it is possible to write a script / macro to pull in the information automatically, this is a very simple, no-code way. I spend 7 minutes discussing the method, but in reality, you could apply it in just 1 minute. This isn't something that needs to be done all the time, generally every few months is good enough. The extra benefit of keeping a list of all of your positions in Yahoo Finance, is that you can also skim through the other information that they provide, such as ex dividend, and payment dates. You can get the dividend stock screener I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use the link above, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW
CAD and USD Google Sheets Dividend Tracker
Massive update! The Google Sheets Dividend Tracker is now on V3, and supports USD and CAD stocks, cash, dividends, deposits, withdrawals. I works regardless of which broker you use, as long as you are diligent about inputing everything correctly! Buy US stocks with CAD? No problem. Pay a CAD trading fee on a USD transaction? No problem. Works well with Questrade and Wealthsimple Trade. If you're still using TD Direct Invest or CIBC Investor's Edge, it will work too. Use a US trading app? No problem. Other improvements from the previous version include customizable sectors, quickly display currency conversions, corrected "Average Price", buy/selling in various currency combinations, hyperlinks to Yahoo finance work for NYSE, NASDAQ, TSX, and TSXV now, and a whole bunch of other USD/CAD stuff throughout.
I'm documenting the growth of a Canadian dividend investing portfolio and make videos about dividend investing, Canadian stocks, Wealthsimple Trade, Google Sheets, personal finance, and passive income.