With transactions registered, it is easy to create a dividend income tracker with Google Sheets. However, a dividend income tracker in Google Sheets is not interactive. Instead of having different pivot tables and switching forth and back among them, I can create an interactive dividend income tracker with a single-page report on Google Data Studio. In this post, I explain how to create a dividend income tracker with Google Data Studio. Manage stock transactions with Google Sheets Create a report in Google Data Studio and connect to Transactions data sources in the spreadsheet Use Time series chart to track annual dividend amount Use Pie chart to visualize the contribution of dividend among stocks Use Pivot table to track annual dividend per share and annual dividend yield of stocks Use Pivot table to track dividend amount by month and by year Demo Conclusion References
leverage free tools to make life easier