In this Microsoft Excel 365 video tutorial I demonstrate how to create a stock, ETF and Fund tracker. Using the Stock data type you can retrieve live data such as price change, day high, day low etc. I also demonstrate how to use the STOCKHISTORY function to retrieve historical data on a stock, ETF or fund.

️Timestamps
00:00 Introduction
00:20 Using the Stock data type
04:01 Apply conditional formatting
04:56 Introduction to the STOCKHISTORY function
09:41 Create a Sparkline chart

#exceltips #exceltutorial #exceltricks