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): http://bit.ly/3aEC6pe

Subscribe: https://www.youtube.com/c/LearnGoogleSpreadsheets/featured

#google-sheets

Stock Portfolio Tracker Spreadsheet - Google Sheets Template
3.10 GEEK