The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
I like the fact that I can enter a formula for stock quotes, but confused about update. Does it always show yesterdays's closing price by default?
Is there any way to show current prices while the market is open?
MacBook Air 13", macOS 10.14
Simply put, no.
MAYBE you could accomplish something through invoking a complex AppleScript, but there's no "setting" to change to make it easily accessible.
https://help.apple.com/numbers/mac/6.1/#/tan2e9e6d2d4
You can, however, do some pretty cool stuff with the Stock table template and building upon it.
Thank you.
Stock Quote in Numbers
