What was Yahoo's lowest stock price ever

Include current stock and exchange rates in Numbers tables

Whether you're looking to keep an eye on your retirement investments, save up for university, or do financial research, Numbers lets you create spreadsheets that get stock market prices and data, as well as exchange rates, straight from the Internet.

Insert stock market data in tables

  1. Tap or click the cell in which you want to paste stock market data. *
    • On your iPhone, iPad, or iPod touch, tap Cell> Share Price. You may have to swipe up to see the option.
    • On the Mac, click the "Insert" button and choose "Share Price".
  2. Choose a stock from the list. When you're looking for a specific stock, type in the company's name or stock symbol.
  3. Choose the attribute you want to capture.
    • On iPhone, iPad, or iPod touch: tap the attribute you want to record in this cell. To the left of the attribute you are capturing, there will be a displayed. Tap on "Done".
    • On Mac: Choose which data you want to collect in this cell from the Attribute pop-up menu. Click outside the dialog box.

To see updated data on the previous day's closing price or to change the attribute you recorded, double-tap or double-click the cell.

You can also enter or edit stock market data in a cell using the "SHARES" formula. To edit the stock with a formula:

  • On your iPhone, iPad, or iPod touch, tap the cell, then tap "Cell" and then on "Edit formula".
  • On the Mac, double-click the cell, then click "Edit as Formula".

* You must be connected to the internet to add stock market data. If "Stock Price" is greyed out, you may not be connected to the Internet. Check the network connection. When you are offline, every cell that is actively drawing information from the Internet is empty.

Capturable share price attributes

When editing the "SHARES" formula, you can use the following strings or numbers to display various types of information:

  • "Course" (0 or empty): The price of a particular share at the close of trading on the previous trading day.
  • "Name" (1): The full name of a stock or company.
  • "Change" (2): The difference between the last trade on the previous trading day and the closing price on the previous trading day. If the exchange was closed during this period, the change will be indicated as "0".
  • "Change in the percentage" (3): The change as a percentage of the last two closing prices of the share.
  • "Opening Price" (4): The starting price at which the share was traded when trading began on the previous trading day.
  • "High" (5): The highest price at which the stock traded during the previous trading day.
  • "Deep" (6): The lowest price at which the stock traded during the previous trading day.
  • "Market Capital" (7): The total market value of all shares in circulation on the exchange on the previous trading day. The value is calculated as the total number of shares in circulation multiplied by the share price.
  • "Volume" (8): The number of shares of stock that were traded during the previous trading day.
  • "Yield" (9): The ratio of the annual return (distribution) per share as a percentage of the share price.
  • "1-year target" (10): The estimated annual target price that is forecast as the median target price by analysts trading the stock.
  • "52 week high" (11): The highest price for the stock in the past 52 weeks.
  • "52 week low" (12): The lowest price for the stock in the past 52 weeks.
  • "Average 3-month volume" (15): The monthly average of the total trading volume over the last 3 months divided by 22 days.
  • "Beta" (16): The degree of volatility (systematic risk) of a security or commodity compared to the market as a whole.
  • "Currency" (19): The currency of the share price.
  • "Annual dividend" (20): The annual dividend (distribution) per share.
  • "EPS" (21): Share Return - a company's total return divided by the number of shares in issue (the number of shares currently held by all shareholders).
  • "Exchange" (22): The exchange on which the stock is traded (such as NYSE, NASDAQ, Euronext, etc.).
  • "KGV" (23): The price / earnings ratio (P / E), calculated by dividing the current market price of the share by the share return achieved over the last 12 months.
  • "Previous day's closing price" (24): The closing price of the share for the trading day before the last reported trade.
  • "Symbol" (25): The share symbol (ticker symbol) that uniquely identifies the share.

Record the course of a share price

If you want to capture the history of a certain share price, use "AKTIENH". When you insert the formula, you need to specify the following attributes:

  • Symbol: An abbreviation used to uniquely identify shares of stock traded on a particular exchange, either as a string of characters enclosed in quotation marks or as a reference to a cell containing a stock symbol.
  • Attribute: An optional value that identifies the stock price attribute to be reported. Numbers automatically suggests "Close Price". Instead, you can also select "Open Price", "High", "Low" or "Volume".
  • Date: The date for which the historical stock price is to be determined.

Insert exchange rates in tables

With the help of the "CURRENCY" formula you can call up exchange rate data from the Internet and use it in the table. When you insert the formula, you need to specify the following attributes:

  • Currency-1: This is the currency code for the currency to be converted. Put the string in quotation marks.
  • Currency-2: This is the currency code for the currency into which the conversion is to be made. Put the string in quotation marks.

Numbers automatically suggests "Course" for the third attribute. If you enter "0" or omit this value, the cell will display the exchange rate from Currency-1 to Currency-2 in the form of Currency-2.

Recordable currency attributes

As you edit the formula, you can use the following strings or numbers to display various types of information:

  • "Name" (1): The codes of the currencies that appear in the formula used to calculate the currency rate.
  • "Change" (2): The difference between the exchange rate at the close of trading on the last two business days.
  • "Change in the percentage" (3): The change as a percentage of the last two closing rates of the exchange rate.
  • "Opening Price" (4): The exchange rate when trading opened on the previous business day.
  • "High" (5): The previous business day's highest exchange rate.
  • "Deep" (6): The previous business day's lowest exchange rate.
  • "52 week high" (7): The highest exchange rate in the past 52 weeks.
  • "52-week low" (8): The lowest exchange rate over the past 52 weeks.

Record the course of an exchange rate

If you want to record the history of a certain exchange rate, use "CURRENCY". When you insert the formula, you need to specify the following attributes:

  • "Currency-1": This is the currency code for the currency to be converted. Currency-1 is a string of characters enclosed in quotation marks.
  • "Currency-2": This is the currency code for the currency into which the conversion is to be made. Currency-2 is a string of characters enclosed in quotation marks.
  • "Attribute": An optional value that identifies the currency attribute to specify. Numbers automatically suggests "Close Price". Instead of "Closing Price" you can choose "Opening Price", "High", "Low" or any other currency attribute (see Recordable Currency Attributes).
  • "Date": The date for which the historical exchange rate is to be determined.

Release date: