Get a stock quote - Microsoft Support (2024)

FAQs

How to get stock price for a specific date in Excel? ›

For example, convert "xnas:msft" to a stock data type in cell A1, and in cell B1 you can write the formula =A1. [52 week high] to get the value. You can also configure your workbook to automatically refresh that value as described here.

You can use the function like =qm_stream_last (“MSFT“) or =qm-stream_last(B2) where cell B2 is the one that contains the stock symbol. As soon as you do that, the stock prices will start showing in your Excel cell.

Data Providers

Fundamental company data, historical data, real-time and delayed prices, fund summary and performance data are provided by Refinitiv.

Begin by doing a search using the company ticker symbol. Then choose "Historical Prices" from the blue bar on the left. Choose start and end date. Choose whether you need daily, weekly, or monthly data.

Online brokerage sites such as eTrade and TD Ameritrade or apps like Robinhood will have both real-time and historical quote data for customers and usually limited access for non-customers as well. Financial websites like Motley Fool or Google Finance will also provide quote information for both stocks and indices.

The Stock Connector add-in lets you link US stocks, market indexes, mutual funds, international stocks, currencies, crypto, precious metals futures, or ETFs to cells in the spreadsheet and updates them automatically.

Alpha Vantage offers a comprehensive Financial Stock Market API, providing developers with access to a diverse range of financial data. One of its unique points is the availability of a free tier that allows developers to access essential market data without a subscription.

Data and Tech Resources

Whether it's through our tier-five ICE Global Network (formerly SFTI®), a highly resilient private network built for the capital markets community, our award-winning data center facilities or an API connection, we've built the safest gateways to global markets.

Does Google Finance work in Excel? ›

In the Get External Data section of Excel, choose the 'From Web' option to initiate the process of importing stock prices from Google Finance. This action opens up a pathway for users to seamlessly extract real-time stock data from an online source directly into their Excel spreadsheets.

Excel: an easy-to-use solution for managing your stock

Excel is a versatile management solution, too. It can be used both for accounting and stock management: or for keeping files on customers or suppliers, for example.

The list of common Excel errors are #DIV/0, #N/A, #NAME, #NULL!, #NUM!, #REF!, #VALUE! and circular reference. To fix the formula errors in Excel, one must click on the “Insert Function” under the “Formulas” tab and choose “Help on this function.” To avert the #NAME?

For example: =DATE(C2,A2,B2) combines the year from cell C2, the month from cell A2, and the day from cell B2 and puts them into one cell as a date.

Stock Level: =[@[INITIAL STOCK]]+[@INCOMINGS]=[@OUTGOINGS] Excel can combine the formulas you have already into a new formula so you can see what your current stock level is based on the incomings and outgoings.