📈Live Stock, ETF and Fund Tracker in Excel 365 | + Get Historical Stock Prices in Excel
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
Watch video 📈Live Stock, ETF and Fund Tracker in Excel 365 | + Get Historical Stock Prices in Excel online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 16 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 96 once and liked it 3 people.