Add stock information in Numbers on iPhone

When you’re connected to the internet, you can add stock information from the previous market close to any table. To simplify the entry of stock information, you can use a special stock template or a predesigned stock table style included with Numbers.

Add stock information to a table cell

You need to be connected to the internet to enter stock information in a table cell.

  1. Go to the Numbers app on your iPhone.

  2. Open a spreadsheet, tap a cell, then tap the Cell Action menu button at the bottom of the screen (or tap the Action menu button in the top-right corner of the keyboard).

  3. Tap Stock Quote (you may need to swipe up to see it).

    Note: If Stock Quote is dimmed, the internet may be unavailable. Check your network connection.

  4. Tap a stock in the list, or to search for a stock, type its company name or stock symbol in the search field.

  5. Tap the stock attribute you want to enter in the cell (you may need to swipe up to see all the options).

    To go back and choose a different stock instead, tap the current stock name.

    The stock quote popover, with the stock name at the top, and selectable stock attributes including price, name, change, percent change, and open listed below.
  6. Tap the Done button when you’re finished.

Tip: To learn how to use the STOCK function to add stock information from the previous market close, see Insert a function. For details about the STOCK function, open the Functions Browser, tap Categories, then tap the Info button next to STOCK (you may need to swipe up to see it).

Add stock information to predesigned tables

You need to be connected to the internet to enter stock information in the My Stocks template or to tables with the predesigned stock table style.

  1. Go to the Numbers app on your iPhone.

  2. Do any of the following:

    • In the My Stocks template: Open the template (from the template chooser), then tap the table near the bottom of the sheet. Tap the Add Row button in the bottom-left corner of the table to add a row, then enter a stock symbol (for example, AAPL) in column A to populate other cells of the row with information about that stock.

    • In a table with the stock style: To add a stock table to a sheet, tap the Content Hub button, tap the Tables And Charts button, then tap the stock table style (shown below). Enter a stock symbol (for example, AAPL) in column A. The other cells in the row fill with information about that stock.

      The Table button selected, with table styles displayed below.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.