Newsroom Update
New features come to Apple services this fall. Learn more >
New features come to Apple services this fall. Learn more >
Is there a way to get UK stocks to be recognised in Numbers or can it only, as it appears, do US stocks?
Have tried prefixing LSE eg. LSE:BVIC for Britvic but it doesn't help.
Thanks
H
MacBook Pro 15″, macOS 10.15
Numbers gets its stocks data from Yahoo! Finance. So you need to use the exact symbol that Yahoo! Finance uses. In this case BVIC.L should work. Embedded in a formula it would be "BVIC.L" but it is usually better to enter the price in a cell and refer to that cell in the formula, as is done the My Stocks template at File > New in your menu.
Keep in mind that the prices are not updated intraday. They are the closing price of the previous trading day.
SG
Numbers gets its stocks data from Yahoo! Finance. So you need to use the exact symbol that Yahoo! Finance uses. In this case BVIC.L should work. Embedded in a formula it would be "BVIC.L" but it is usually better to enter the price in a cell and refer to that cell in the formula, as is done the My Stocks template at File > New in your menu.
Keep in mind that the prices are not updated intraday. They are the closing price of the previous trading day.
SG
That’s excellent. Didn’t know it linked to Yahoo and wouldn’t have guessed a simple L suffix.
It works now, thank you.
H
Showing UK stock prices in a spreadsheet.
