The LION stock portfolio tracker is a personal stock portfolio tracker built with Google Sheets and Google Data Studio. The transactions of a stock portfolio are registered in Google Sheets. The tracker uses the GOOGLEFINANCE built-in function in Google Sheets to have the historical and current prices of stocks. The tracker has a small Google Apps Script program to do some complex computation, such as generating automatically the stock portfolio's daily change and comparing it with alternative investments. The stock portfolio is then visualized on a beautiful and interactive dashboard with Google Data Studio. This guide shows how to create a personal stock portfolio tracker with Google Sheets and Google Data Studio.
Link to the post 'Create personal stock portfolio tracker with Google Sheets and Google Data Studio'
