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/d/18VhrYN9Q50EJeh4EqieyczIbA5wQXgjv-TXkvtTjtww/edit?usp=sharing

Web Version: https://docs.google.com/spreadsheets/d/e/2PACX-1vQEEmkkdFdgMh5Pp-tAq216XAujJkLf-Hk43MA448GUsHVAEzPc70k-PYQ8FXGvRs6O7Jk2vRPOyCZj/pubhtml

With weighted averages: https://docs.google.com/spreadsheets/d/1zPjmwmAtQiQ1Ovfnp8_eiWmTx9iyLsf9GoW1r9WYhZ4/edit?usp=sharing

Video explanation: https://youtu.be/aOUgMraeC9Q

Learn how to use GOOGLEFINANCE function https://youtu.be/HRRrB_cjtZA

#Stock #Portfolio #Tracker #Spreadsheet #Template