Leila Gharani teaches us to pull live stock data in Excel with Stock data types.
With Excel’s stock data feature you can get live stock information. Stock data types allows users to quickly pull stock information into Excel from various exchanges.
In this tutorial I’ll show you how you can pull data related to stocks, bonds, currency, and even crypto-currency such as Bitcoin into your spreadsheet. This way you can easily calculate your portfolio value directly from within Excel. You’ll learn to build your very own stock portfolio in Excel. We’ll use Excel tables together with conditional formatting.
With stock data types you can retrieve stock prices, stock volume, 52 week high, 52 week low, shares and a lot more. If the stock data type is showing you an incorrect stock or the wrong exchange, you can easily change it. I’ll show you how to in the video.