Add current stock quotes and currency exchange rates in to your spreadsheets in Numbers

Whether you are tracking investments for retirement, saving for college, or doing financial research, use Numbers to create spreadsheets that pull current and historical stock performance and live exchange rates directly from the internet. 


      

Add stock information to your spreadsheet

  1. Tap or click the cell you want to add stock information to.1 
    • On your iPhone, iPad, or iPod touch, tap  > Stock Quote. You might need to swipe up to see it.

    • On your Mac, click , then choose Stock Quote.
  2. Choose a stock in the list. If you want to search for a specific stock, enter the company name or stock symbol. 
  3. Choose the attribute you want to track. 
    • On your iPhone, iPad, or iPod touch, tap the attribute you want to track in this cell. The attribute you’re tracking has a  to the left of it. Tap Done.
    • On your Mac, in the Attribute pop-up menu, choose what information you want to track in this cell. Click outside the dialog.

You can also enter stock information into a cell by using the STOCK formula. If you want to see live information or change the attribute you're tracking, double-click on the cell. If you want to edit the STOCK as a formula, double-click on the stock then click Edit as Formula.

1You must be connected to the Internet to add stock information. If Stock Quote is gray, the Internet might be unavailable. Check your network connection. When you're offline, any cell that actively pulls information from the internet is empty.

Stock attributes that you can track

 

When you edit the formula, you can use any of these strings or numbers to show different pieces of data: 

 

  • “price” (0 or omitted): The current share price of the specified stock.
  • “name” (1): The full name of the stock or company.
  • “change” (2): The change in the stock’s share price between the last trade and the closing price on the previous day. If the stock hasn’t traded today, the change reported is “0.”
  • “percent change” (3): The percentage change in the stock’s price since the close of trading on the previous day.
  • “open” (4): The starting price at which the stock traded at the opening of trading on the current day.
  • “high” (5): The highest price at which the stock has traded on the current day.
  • “low” (6): The lowest price at which the stock has traded on the current day.
  • “market cap” (7): The total market value of all the outstanding shares of the stock on the current day. This is calculated as the total number of outstanding shares multiplied by the current price per share.
  • “volume” (8): The number of shares of the stock that have changed hands on the current day.
  • “yield” (9): The ratio of the stock’s annual dividend (cash payout) per share as a percentage of the share price.
  • “1-year target” (10): The one-year target price estimate, which is the median target price as forecast by analysts covering the stock.
  • “52-week high” (11): The stock’s highest trade price in the last 52 weeks.
  • “52-week low” (12): The stock’s lowest trade price in the last 52 weeks.
  • “ask price” (13): The price sellers are willing to accept for the stock (the offer price).
  • “ask size” (14): The number of shares of the stock that sellers are offering at the ask price.
  • “avg. 3-month volume” (15): The monthly average of the cumulative trading volume during the last 3 months divided by 22 days.
  • “beta” (16): The measure of the volatility (systematic risk) of a security or commodity in comparison to the market as a whole.
  • “bid price” (17): The highest price that buyers are willing to pay for the stock.
  • “bid size” (18): The number of shares bid at bid price.
  • “currency” (19): The currency in which the stock is priced.
  • “annual dividend” (20): The yearly dividend (cash payout) amount per share.
  • “eps” (21): Earnings per share—calculated as a company’s total earnings divided by the number of outstanding shares (the stock currently held by all its shareholders).
  • “exchange” (22): The stock exchange on which the stock is traded (for example, NYSE, NASDAQ, Euronext, and so on).
  • “p/e ratio” (23): The price/earnings ratio, calculated by dividing the stock’s current market price by trailing 12-month Earnings Per Share.
  • “previous close” (24): The stock’s closing price for the trading day prior to the last trade reported.
  • “symbol” (25): The stock symbol (ticker symbol) that uniquely identifies the stock.

Track stock history

If you want to track the history of a specific stock, use STOCKH. When you add the formula, you must define these characteristics:

  • Symbol: An abbreviation that uniquely identifies publicly traded shares of a stock on a particular stock market, enclosed in quotes, or a reference to a cell that contains the symbol.
  • Numbers automatically suggests "close." Instead of close, you can choose open, high, low, or volume. 
  • Date: The date for which you want the historical stock price information

Add currency exchange rates to your spreadsheet

You can use the CURRENCY formula to pull current data about currency exchange rates from the Internet and use them in your spreadsheet. When you add the formula, you must define these characteristics:

  • Currency-1: This is the currency code for the currency from which you’re converting. Use quotes around your string.
  • Currency-2: This is the currency code for the currency to which you’re converting. Use quotes around your string.

For your third characteristic, Numbers automatically suggests “price." If you enter 0 or omit this item entirely, the cell shows the current exchange rate of currency-1 to currency-2, expressed as currency-2.

 

Currency attributes that you can track

When you edit the formula, you can use any of these strings or numbers to show different pieces of data:

  • “name” (1): The currency codes of the specified currencies, shown in the formula for calculating the exchange rate.
  • “change” (2): The change in the exchange rate since the close of trading on the previous day.
  • “percent change” (3): The percent of change in the exchange rate since the close of trading on the previous day.
  • “open” (4): The exchange rate at the opening of trading on the current day.
  • “high” (5): The highest exchange rate on the current day.
  • “low” (6): The lowest exchange rate on the current day.
  • “52-week high” (7): The highest exchange rate in the last 52 weeks.
  • “52-week low” (8): The lowest exchange rate in the last 52 weeks.
  • “ask price” (9): The price in currency‑2 that sellers are asking for currency‑1.
  • “bid price” (10): The price in currency‑2 that buyers are willing to pay for currency‑1.

Track currency history

If you want to track the history of a specific currency, use CURRENCYH. When you add the formula, you must define these characteristics:

  • Currency-1: The currency code for the currency from which you’re converting. currency‑1 is a string enclosed in quotes.
  • Currency-2: The currency code for the currency to which you’re converting. currency‑2 is a string enclosed in quotes.
  • Numbers automatically suggests “close" as your third characteristic. Instead of close, you can choose open, high, or low.
  • Date: The date for which you want the historical exchange rate information.

 

 

Published Date: