Apple Numbers STOCK Function: Attributes, Symbols and Reporting Controls

The official STOCK reference was retrieved October 15, 2026. The original introduction release and last functioning version are unknown from the checked first-party evidence. Current documentation is not a final supported-version endpoint or a test of every older Numbers client.

No native Numbers session was executed. Fixed examples below are independent controls; remotely supplied values are not claimed as current observations. First-party example values, when identified, remain source examples rather than newly retrieved native results.

STOCK(symbol, price)

symbol is a quoted market symbol or a cell reference containing one. Optional price is the attribute selector; 0 or omission requests price. Some instruments require an exchange suffix, with .CO and .L given by Apple as examples. Do not assume a short ticker uniquely identifies every international listing.

The page’s numeric selector map is:

The unavailable labels reflect Apple’s checked reference. A documented selector is not proof that its data is supplied for every symbol.

=STOCK("AAPL",0) requests price; =STOCK("AAPL","price") uses the named form shown by Apple. =STOCK("AAPL",1) requests the company name, illustrated in the source as Apple Inc.

If A2 contains a chosen symbol, =STOCK(A2,19) requests currency and =STOCK(A2,22) requests exchange. Keep those identifying fields alongside the value instead of inferring denomination from a displayed currency symbol.

No current stock price, listing verification or native data response was obtained for this guide.

Use a separate fixed-input model with two fictional positions:

The total value is 1200 in the common fictional currency. These prices are synthetic controls, not live STOCK observations. If one position is actually priced in another currency, adding the values without a specified conversion would lose their meaning.

For Example A, changing the fixed price to 52 gives 624, an increase of 24. The corresponding price return from 50 to 52 is 4%, and the fixed-share position has the same percentage change before fees or other cash flows.

For a fictional share price 50, annual dividend per share 2, trailing earnings per share 5, and 1000000 outstanding shares, independent arithmetic gives dividend yield 4%, price/earnings 10, and market capitalization 50000000.

These are controls illustrating units, not a claim that every service field can always be reconstructed from other rounded fields. The dividend input is per share, while market capitalization is a whole-company amount. A one-year analyst target is an estimate, not a guaranteed future price.

A fictional two-for-one split changes 10 shares at 40 into 20 shares at 20, leaving position value 400 in this simplified example. Comparing prices alone would show a 50% decline even though this split-only position value is unchanged.

Apple warns that splits and reverse splits can affect STOCK output. It does not establish a universal adjustment policy in this entry. Keep share-count changes and provider conventions visible when comparing observations across a corporate action.

Apple says entering the function without internet returns no value and that connectivity restoration updates it. The source illustrates wrapping a query in IFERROR with a text fallback, but replacing failure with zero would distort totals.

For change and percent-change attributes, the source says no trading in the stated interval can result in zero change. That is different from treating missing data as a zero share price. Check attribute meaning before interpreting a zero.

The source also gives precious-metal futures symbols. Those examples do not justify treating every instrument as a real-time stock quote; the main documented stock timing remains previous market close. Exact provider errors, refresh schedules and availability for every instrument were not native-tested.