How is Apple doing financially

Add stock information in Numbers on Mac

If you're connected to the internet, you can enter stock information from the previous market close into a spreadsheet. To make entering stock information easier, you can use a specific stock template or predefined stock table style available in Numbers.

Add stock information to a table cell

You must be connected to the Internet to enter stock information in a table cell.

  1. Click the cell where you want to add the stock information.

  2. Click in the toolbar and select "Share Price".

    Note: If the “Share Price” option is grayed out, you may not be connected to the Internet. Then check your network connection.

  3. Click on a stock in the list or search for a stock by entering the associated company name or the stock symbol in the search field.

  4. When you see the information for that stock, click the Attribute pop-up menu, choose a stock attribute, then click anywhere outside the window.

    To view and edit the stock price as a function, click "Edit as Formula", enter the function arguments, and then click .

Tip: You can also add stock information from the previous market close by adding the "Stocks" function in a cell. For more information, see Inserting a Function. For details about the “Shares” function, you can open the function overview and click “Financial” and then “Shares” (swipe up if you don't see this option).

Add stock information to predefined tables

You must be connected to the Internet to enter stock information in the “My Stocks” template or in tables with the predefined table style for stocks.

  • In the "My shares" template: Open the template in the template selector and click on the table at the bottom of the sheet. Click in the bottom left of the table to add a line. Then type a stock symbol (like AAPL) in column A to fill other cells in the row with information about that stock.

  • In a table with the stock style: To add a stock table to a sheet, click on the toolbar and then on the table style for stocks (see below).

    Enter a stock symbol (such as AAPL) in column A. This will populate the other cells in the row with information about that stock.

See alsoEnter text and numbers in Numbers on MacFormat dates, currencies, and other types of data in Numbers on Mac