How can I add a GBP quote in numbers (rather than a stock quote)?
I see that you can add a stock quote directly into numbers, but any idea how to add a currency (for example GBPUSD)? Thanks.
MacBook Pro, Mac OS X (10.4.6)
Use CURRENCY ( or CURRENCYH ) function. It is similar to STOCK ( or STOCKH ) for stock quote but needs to enter the funcion manually.
For more information about the functions, check them at the financial section in function browser or "Formulas and Functions Help" at Help menu.
Here is an example
A2, B2 : currency codes
C2 = CURRENCY($A2,$B2,0)
D2 = CURRENCY($A2,$B2,1)
Edit:
You can also read a quick quidance at
The page can be reached by
- Select "What's New in Numbers" in Help menu on Numbers.
- Click "Complete feature list" ( Safari will be activated )
- Click "Learn more" under "Live Stock Info"