How do I modify the "My Stocks" template in Numbers to work with the ASX (Australian Stock Exchange)?

Question

PeterBreis0807 Author

Level 8

41,227 points

How do I modify the "My Stocks" template in Numbers to work with the ASX (Australian Stock Exchange)?

The Template uses a special look up to extract information on the particular stock using the Stock Symbol.

Double clicking on the Symbol cell shows this Symbol Inspector:

The Stock Exchange "NASDAQ" is not editable anywhere I can see. In my case I want to change it to ASX.

Clicking on Edit as Formula does not show anyway to edit the Exchange that I can find.

I have tried the manual method of Symbol.Exchange eg "CBA.ASX" but it produces an error and the Formula editor constantly tries to change what I type in.

Is it possible this is only a function available for USA exchanges?

I am in the Current initial release of macOS Tahoe and Numbers version 14.4 (7043.0.93).

MacBook Pro 14″, macOS 26.0

Posted on Sep 17, 2025 09:46 PM

Reply

Answer 1

Top-ranking reply

PeterBreis0807 Author

Level 8

41,227 points

Sep 17, 2025 10:48 PM in response to PeterBreis0807

After a great deal of hunting, I noticed the yahoo!finance logo in the bottom corner and hunted down what yahoo calls the exchanges.

The ASX is referred to as AX by yahoo, so CBA.AX works in the formula.

I started in Pages two weeks ago (where I eventually found it won't work at all) and finally succeeded in Numbers!

Reply

Answer 2

SGIII

Level 8

37,238 points

Sep 18, 2025 06:04 AM in response to PeterBreis0807

Yes, the key is to realize that Numbers gets the data from Yahoo! Finance. Go to the Yahoo! Finance site to determine that symbol and use that in the Numbers formula. In many cases that will work, though the data feed is not perfect. I treat it more as a convenience for reference purposes rather than a reliable source.

SG

Reply