Excel is one of the best platforms to do stock quote analysis. However, you traditionally had to pull this data either manually, or using third party tools. Now, you can do this using built-in Excel features if you are running Office 365.
Excel will automatically find the matching stock quote information. Enter names into a column and select them. Optional: Convert your range into a table by pressing Ctrl + T. Aside from a table ‘s own advantages, you will automatically get titles of the information you will get online . Next step is defining the selections as a Data Type.
On June 5th, 2019 Microsoft released a feature to Office 365 that allows Excel users to pull real-time stock prices into their spreadsheets. This feature was never truly supported in Excel until now, even though many Excel users used to pull stock data from Yahoo! Finance until the capability end in 2018 (thanks Verizon !).
How to extract the information on stock prices in Excel?
But let’s move on now and see how we can extract the information on stock prices in column C. You’ll see a list of options from which you can choose the type of data you need. Since we want to get prices, we’ll click on ‘Price’ and here we go!
So, beside the price, there’s some more useful information.
When you select a cell that is linked to stock data, you’ll notice a small Add Field icon in the upper right-hand corner of your selected cell.
How to get the current price of a stock in Excel?
You’ll see a list of options from which you can choose the type of data you need. Since we want to get prices, we’ll click on ‘Price’ and here we go! The current price for each stock now appears in column C. To use other data types, just open the list again and choose whichever necessary.
When I was reading we ran into the inquiry “How to get the current stock price for Delta in Excel?”.
Some believe that you can see the resulting formula in cell B3, which returns the current stock price for Delta, is =A3.price. This functionality works even better when an Excel Table is involved, as follows.