Numbers on MacOS is amazing.

[Nagato]

So, I'm not American, but it's really cool that I can get Apple's stock price via a formula and than convert the amount into my currency. I know this is simple and can be done in other programs, but nonetheless it's really cool.

Now, I want to be able to multiple the converted amount by ounces and quantity, which I haven't worked out how to do.

Gold:

CURRENCYCONVERT(STOCK("GC=F"),"CODE")

Edit: the messy way that works is to change the amount and remember the value isn't 2 ounces.