Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less
To insert a stock price into Excel, first convert text into the Stocks data type. Then you can use another column to extract certain details relative to that data type, like the stock price, change in price, and so on.
Note: The Stocks data type is only available to Microsoft 365 accounts or those with a free Microsoft Account. You must also have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.
-
Type some text in cells. For example, type a ticker symbol, company name, or fund name into each cell.
-
Then select the cells.
-
Although it's not required, we recommend creating an Excel table. Later on, this will make extracting online information easier. To create a table, go to Insert > Table.
-
With the cells still selected, go to the Data tab, and then click Stocks.
-
If Excel finds a match between the text in the cells, and our online sources, it will convert your text to the Stocks data type. You'll know they're converted if they have this icon for stocks:
. -
Select one or more cells with the data type, and the Add Column button
will appear. Click that button, and then click a field name to extract more information. For example, for stocks you might pick Price. -
Click the Add Column button again to add more fields. If you're using a table, here's a tip: Type a field name in the header row. For example, type Change in the header row for stocks, and the change in price column will appear. Or type other field names like Last Trade Time, Previous Close, and Exchange.
Tips:
-
To see all of the fields available for a company or fund, click the stock icon (
) or select the cell and press Ctrl+Shift+F5. -
If you see
instead of an icon, then Excel is having a hard time matching your text with data in our online sources. Correct any spelling mistakes and when you press Enter, Excel will do its best to find matching information. Or, clickand a selector pane will appear. Search for data using a keyword or two, choose the data you want, and then click Select. -
You can also write formulas that reference data types or use the STOCKHISTORY function.
-
Stock information is delayed, provided "as-is", and is not for trading purposes or advice. See About our data sources for more information.
Stock quotes give information about a particular stock's recent trading activity on a given exchange. How close this data is to real time will depend on the exchange and where you are looking for the information. During the trading day, you can usually see both the prices buyers are willing to pay (bids) and the prices sellers are offering (asks), along with a range of other information. These quotes enable buyers and sellers to find each other and make trades.
Depending on market conditions, a stock's price can move quite a bit in either direction on a given day. If you're looking to buy a stock, be sure you know the live price or use specific order types such as buy-limit orders, to guard against paying more than you're comfortable paying.
For instance, if you wanted to know information about how shares of the Coca-Cola Company were trading, you'd look for the company's stock quote. You'd see its ticker symbol, which is KO. You'd also see the price of each share, which was $64.74 on May 6, 2022. The stock quote shows you much more than just the current share price. It includes valuable data that you can use to evaluate the company's shares as you decide whether to buy or sell.
Both buyers and sellers require data about a particular stock to make a decision and execute a trade. At the very least, they'll need the name of the stock, its ticker symbol, agreed-upon price, and the number of shares they want to buy or sell.
Whether you're trading on the New York Stock Exchange, the Nasdaq, or another stock exchange, a given stock quote will show some or all of the following information, often in an abbreviated format:
- Open: This is the stock's opening price. This and all prices are quoted to a hundredth of a cent.
- 52-week high and low (or range): These two numbers record the highest and lowest prices at which the stock traded during the previous 52-week period, but they do not include the previous trading day. The numbers may be adjusted for stock payouts or large dividends.
- Stock symbol (SYM): This is the stock ticker symbol. You can find the symbol for a given company on many financial websites by simply typing the name of the company.
- Dividend (DIV): A dividend is a portion of profits paid to a company's shareholders. Unless noted in a footnote, this reflects the annual price per share based on the last regular disbursement.
- Yield percentage (Yld%): The yield percentage expresses the dividends and any other disbursements paid to stockholders as a percentage of the stock’s price.
- Earnings per share (EPS): This is a company's net earnings divided by its total number of shares. A higher number indicates greater profitability.
- Price-to-earnings ratio (P/E): The price-to-earnings ratio is the price of the stock divided by its EPS. This number helps investors compare stock prices more directly to those of other companies.
- Sales volume (Sales 100s): This shows the total amount of stock sold that day, expressed in hundreds. In other words, sales volume is expressed with two zeros missing. For example, if the number reported is 1,959, that means sales volume for that stock was 195,900 for the day.
- High: This is the highest price paid for the stock during the previous day.
- Low: This is the lowest price paid for the stock during the previous day.
- Last (or close): This is the last price at which the stock traded on that day. It does not mean that is the price at which the stock will open the next day, however.
- Change: This describes the difference between the last trade and the previous day's price.
- Year-to-date percentage change (YTD% CHG): This number is the stock price percentage change for the calendar year. The percentage is adjusted for stock splits and dividends of more than 10%.
- Net change (CHG): The net change is calculated from the previous day’s close, so you are comparing what the stock closed at today to what it closed at yesterday.
You may also notice some footnotes throughout the listings. These point out any number of extraordinary circumstances, including new highs or lows, the first day of trading, or unusual dividends.
Once you understand how to read a stock quote, you can begin to make educated decisions regarding investments. With the data you gather, you can learn how to value a company and even make predictions about a stock's performance. You'll get to know how to read a stock's volatility and better gauge your risk when investing.
You can follow a stock's price throughout the day, although you should be aware that the quotes you see on many free internet sites are delayed. Data providers may delay quotes by 20 minutes or more, enabling them to sell truly live quotes at a premium.
Use a watchlist to track stocks you're interested in over time. Although past performance does not guarantee future results, tracking your picks helps you learn to identify stocks that meet your trading criteria. It also allows you to detect patterns that can help you in your trades.
- A stock quote shows the current price of a stock based on recent activity on its exchange.
- It also includes a wide range of additional information to help investors judge a stock's profit potential.
- Depending on where you are getting your stock quotes, prices could be delayed, which could affect your trades.