Exemplary Google Sheets Dividend Tracker

Ad Track your shares dividends DRPs investment tax corporate actions CGT more.

Google sheets dividend tracker. I like charts because they give good visual summaries. List the stocks you own. IEX is an exchange that provides an Application Programming Interface api to get dividend data for free and reliably.

Your one-stop shop for managing all your investment performing tax reporting. Google Sheets is also cool because certain fields can update with live data using the GoogleFinance function. Fortunately google created a special function which fetches current or historical securities information from Google Finance.

Google Sheets is a powerful tool and it allows us to enter an insane amount of data. Google Spreadsheet and Google Finance for tracking dividend portfolio dividend income Google Spreadsheet has a very useful function called GOOGLEFINANCE which allows you to fetch current and historical security information from Google Finance. Below are step-by-step instructions for creating your own investment spreadsheet in Google Sheets.

Unfortunately you find that the. However data options are limited. Track Dividend Income with Google Sheets.

When your dividends start rolling in you enter those on the Income sheet by date and ticker. Double-click Dividend Spreadsheetxlsx to open it. Thanks for checking out my Dividend Stock Portfolio tracking spreadsheet.

In order to use google sheet as a dividend portfolio tracker tool you need to learn how to import any information from websites into the sheet. Its one of my favorite tools I use online. To create these 3 charts first I had to create three separate tables with the appropriate data.