In this Googlesheets video tutorial, I demonstrate how to create a stocks and shares tracker using the GOOGLEFINANCE function. The GOOGLEFINANCE function pulls live data into your spreadsheet relating to individual stocks, ETFs and mutual funds. It can also be used to retrieve historical data such a stock's price over x number of days, weeks or years.

GOOGLEFUNCTION: https://support.google.com/docs/answer/3093281?hl=en
TICKERS: https://www.google.com/finance/quote/GOOG:NASDAQ?hl=en
FEATURED TEMPLATE: https://docs.google.com/spreadsheets/d/1k-V3glmuNsqfctJbbWYZArhLyEYHYIB9rc-MM-H4Vcc/edit?usp=sharing

️Timestamps
00:00 Introduction
00:41 Track individual stock
00:51 Finding and using tickers for your individual stock
01:31 Introduction to the GOOGLEFINANCE function
02:26 GOOGLEFINANCE attributes overview
03:43 Apply formatting to your tracker
04:46 Create one formula that you can use across and down your tracker
05:55 Create in-cell graphs for your tracker using INDEX and SPARKLINE
09:53 Tracking ETFS
10:07 Tracking Mutual and Index Funds
10:57 Calculating the total value of your portfolio

#googlesheets #googlesheetstutorial #googlesheetstips