Learn how to create a stock portfolio tracker template in Google Sheets. In this video we'll use various function: GOOGLEFINANCE, IF, IFS, SUMIFS, SUMPRODUCT, INDEX, SPARKLINE and more to build a spreadsheet that will track stock portfolio based on transaction entries we make for different tickers.
Final Template (to use the template got to File - Make a copy): https://docs.google.com/spreadsheets/...

Web Version: https://docs.google.com/spreadsheets/...

With weighted averages: https://docs.google.com/spreadsheets/...

Video explanation:    • Google Sheets - Average, Weighted Ave...  

Learn how to use GOOGLEFINANCE function    • Google Finance - Stocks & Currency Ex...  

#Stock #Portfolio #Tracker #Spreadsheet #Template