A common question for many Excel users is how to get live stock prices in Excel. The good news is that it's actually straightforward. This blog post will teach you the easiest ways to get live stock data in your Excel spreadsheet that can be refreshed as you wish.
Identify the stock tickers you wish to track
The first step is to identify the stock tickers you wish to track. If you are unsure of how to find a company's ticker, simply do a Google search for "stock symbol *company name*" (i.e., "stock symbol Apple"). Once you have your list of desired stocks, enter them into cells in your spreadsheet in the order you desire (see the example below).
Use the WISEPRICE formula to get the live stock data
With the =WISEPRICE formula, you can easily get live stock data from your previously saved stocks.
The function takes the following parameters =WISEPRICE("ticker", "parameter/s").
For example, to get Apple's real-time price, all you need to do is enter the following formula on any cell of your spreadsheet:
The parameters covered include the following (see full list):
- Changes Percentage
- Day Low
- Day High
- Year High
- Year Low
- Market Cap
- Price Avg 50
- Price Avg 200
- Avg Volume
- Previous Close
- Shares Outstanding
- Earnings announcement
Using this knowledge, you can reference the stock cells and parameters from where you saved the list of stock symbols to get the price.
The best part is that you can press the refresh button on the WISEPRICE menu of Wisesheets to get the most up-to-date data as often as you desire.
After this, you can easily change the ticker or parameter to get a different value without the pain of having to copy-paste the data manually.
Stock exchanges covered by Wisesheets
One of the most important factors to consider when getting live stock data is the number of stock exchanges covered by the service. Luckily, Wisesheets offers 50+ major stock exchanges worldwide from which you can get live stock data on your Excel spreadsheet.
The list includes (see full list):
- XETRA (Germany)
- NSE (India)
- LSE (London)
- MCX (Russia)
- SIX (Switzerland)
- HKSE (Hong Kong)
- ASX (Australia)
- OSE (Norway)
- NYSE (US)
- NASDAQ (US)
- AMEX (US)
- EURONEXT (Europe)
- TSX (Canada)
How to get live stock prices in Excel for international exchanges?
Getting live stock data for international stocks is simple. All you have to do is use the =WISEPRICE function, as shown above, with the only difference being the ticker.
Wisesheets uses the same ticker system as Yahoo Finance, so all you have to do is enter the ticker with the extension you can find there. So for example, to get the data from Telus, a company listed on the Toronto stock exchange, all you have to do is use the ticker "T.TO"
Important things to know
The method outlined above requires you to have a Wisesheets account which you can get here for free. Once you have your account, you can download the Wisesheets Excel add-in and sign in.
Unlike other stock live data retrieval methods, you don't need to know how to code,e and you can also get the company's financials with the =WISE function (see the full guide here).
Now you know how to get stock live stock prices in Excel for 50+ different stock exchanges extremely quickly without having to waste time copy-pasting the data.
We hope this post helps you save time and allow you to make better stock investments!
The Wisesheets Team
Are the prices actually live or upto 20mins delayed similar to Google Finance/Sheets
It is very difficult to get live data at the exact second but we have achieved a delay of only 15 minutes which is on par with sites like Bloomberg and Yahoo Finance. Let us know if you have any additional questions.
Why are the price averages limited to 50 and 200 day MA?? 20 and 100 day (for example) are also very commonly used averages.
This was before we just released some new price change data you can check out here: https://www.wisesheets.io/pages/excel-available-data.html
You can also calculate price change based on custom dates using the data available.