Thanks to Google Drive or more specifically Google Spreadsheet, tracking our dividend portfolio and dividend income using a dividend spreadsheet has made life a lot easier. I love using spreadsheets when it comes to tracking various items, so it shouldn’t surprise you that I use a spreadsheet to track our dividend portfolio. This is where using spreadsheets come in very handy. Once you have a few dividend paying stocks in your dividend portfolio it can get tricky to keep track of your cost basis and various information. Getting started on dividend investing is easy. I have decided to utilize ImportHTML function instead. Update 4: The ImportFromWeb add-on has a monthly pull limit so it’s not very reliable.

This should be very useful for any dividend investor. This new function should be able to pull dividend info reliably. I have updated the Google Finance dividend portfolio template with a slightly revised function that’d to the exact same thing. It seems to get errors from time to time due to how the webpages are set up. I have updated the formula to pull dividend & yield info from Yahoo Finance instead. Therefore, the old formula to pull dividend & yield info from Google Finance no longer works. Update 2: As of March 2018, Google Finance has changed its formatting. You can use the template for Google Finance Dividend. That will generate income and, because they are out of the money, leave room for some upside potential on the stock.Update:1 As per requests, I have created a Google Finance dividend portfolio template available to download.

So now we need to find out of the money covered calls that pay at least the prescribed cents/day amount of time premium. Also shown is the equivalent number of cents/day necessary to achieve each yield: Annual Yield total annual call premium received) would need to be to attain 3%, 5%, and 10% annual yields. With NVDA at 120.76, here's a table showing how big the annual 'dividend' (i.e. NVDA Dividend-Like Income Using Covered Calls Let's look at some recent prices (last updated Fri 4:16 PM ET): NVIDIA Corporation (NVDA)

Although NVDA has no upcoming (meaning, Board-approved and announced) dividends, you can sell covered calls on NVIDIA Corporation to create 12 extra dividend type payments per year to boost its yield.

Nvda dividend dates