Build a previous-market-close stock information table and check data limits in Apple Numbers

Quick answer: On Mac, select a cell and choose Insert → Stock Quote, search for a stock, and choose an Attribute. Numbers supplies information from the previous market close, not a live trading feed. Keep the selected symbol, attribute, and your observation time beside the result.

Scope and prerequisites

Use Numbers 15.4 for Mac with an internet connection. This is a software-data exercise, not investment advice or a recommendation to buy the example company. Apple documents previous-market-close information; the price visible during your session is not promised to match an intraday quote elsewhere. No brokerage account or transaction is needed.

Create a Blank spreadsheet and save stock-observation-before.numbers locally in Numbers Practice. Use File → Save As for stock-observation-work.numbers. In the first table use one header row with these five columns:

Requested stock	Attribute chosen	Returned result	Observed at	Check note
AAPL	leave empty initially	leave empty initially	leave empty initially	not yet checked

The “leave empty initially” entries above are instructions: keep those cells genuinely blank, without typing that phrase.

Column A is a manual identification label, not a formula driver in this exercise. Changing A2 alone will not change the query you insert into C2. That distinction prevents a misleading table where the visible label and the actual query refer to different companies.

Insert one documented query

1. Select C2. Click Insert in the toolbar and choose Stock Quote.
2. Search for AAPL, Apple’s example symbol, and select the matching Apple company result. Do not select a similarly named result without checking its identity.
3. Open the Attribute pop-up menu and select an available attribute you want to inspect. While the insertion dialog is still open, use Edit as Formula to inspect the generated query if needed; check its stock and attribute against your choices, then click the OK button when finished. Record that attribute’s exact displayed name in B2 after dismissing the dialog. If you choose a numeric price field, note its currency or other displayed context rather than assuming a unit from the number alone.
4. Record your actual observation date and time, with time zone, in D2 as text. In E2 write Previous-market-close data; query identity checked only after checking the selected company and attribute.

The expected result is a populated stock-information cell or a visible error that you investigate, not a fixed number supplied by this tutorial. An observation timestamp records when you inspected the sheet; it does not certify when the underlying market value was updated.

Check the query rather than trusting its label

Verify the company and attribute during insertion, before you close the dialog; do not infer the query from a label typed separately. Apple’s Functions Browser provides the STOCK argument definitions under Financial → STOCK. This guide focuses on inserting and documenting observations, rather than teaching the full function syntax or specifying an undocumented refresh schedule. If you later doubt which query produced a result, insert a new query into a fresh empty cell and verify its choices before replacing the old observation.

For a second observation, add one body row to the table. Enter AAPL in A3, then use Insert → Stock Quote in C3 again and select a different available attribute. Write its exact name in B3, your observation timestamp in D3, and an appropriate check note in E3. You now have two distinct observations of one company, not two companies. Check that B2 and B3 differ and that each query matches its label.

If you instead need a ready-made list, Apple’s My Stocks template includes a stock table: adding a row and entering a symbol in its first column fills other cells. That template has its own layout; do not assume this practice table’s A column has the same behavior.

Preserve the report without calling it live

Save the working file as stock-observation-final.numbers. Close and reopen it while online, then inspect both returned results, recorded attribute labels, and check notes. Do not use an unchanged result as proof that data is current, or a changed result as proof of a particular refresh interval.

For a static record, make a clearly dated table snapshot. Label it with the observation time and previous-market-close scope. The query table and the static report answer different questions: one can retrieve information, while the other preserves what you captured. A snapshot is not proof of market accuracy.

Troubleshoot missing or unexpected information

• If Stock Quote is dimmed, check the internet connection, as Apple recommends. Do not replace a missing value with zero; zero would look like real data.
• If a query fails, retain the error or a clear unavailable note until the symbol, selected attribute, and connection have been checked. Do not invent a price to complete the example.
• If a comparison site differs, compare the instrument, currency, attribute, and market period before treating the difference as an arithmetic error.
• If you edit the company or attribute inside the query, update its manual labels and observation note too. The labels are your responsibility.

Keep the untouched starting file for another attempt. This tutorial does not claim exchange coverage, guaranteed availability, real-time updates, or suitability for executing trades.

Documentation and verification

Apple’s version-pinned 15.4 guides below were retrieved on 20 October 2026, except the table-row guide reused from 19 October where cited. The worked scenario and arithmetic are independently checked, not native application tests. Save/reopen, synchronization, media playback, and device behavior must be verified on your own installation. No native screenshots are supplied.

• Numbers User Guide for Mac
• Add stock information in Numbers on Mac
• Save and name a spreadsheet in Numbers on Mac
• Add or remove rows and columns in Numbers on Mac
• Create a snapshot of a table in Numbers on Mac