Getting Price data from Yahoo
Posted: January 25th, 2018, 4:12 pm
I am building a spreadsheet to contain information about the shares I hold. I am using Numbers the Apple spreadsheet program, Which has a useful function called STOCK, that allows the download of a look of information about each share, in particular the previous days closing price.
STOCK uses EPIC codes to identify indivual shares and has worked well for most shares, expect for BT(BT.A) and Compass(CPG), which don't seem to work. STOCK gets the information from Yahoo Finance. Yahoo only seems to have the US listing for BT in Dollars and no London listing. However, it has the London listing for Compass and all the Information about it.
I note that HYPTUSS uses Yahoo for prices and works for both BT.A and Compass. Has anyone got any idea what the problem could be?
STOCK uses EPIC codes to identify indivual shares and has worked well for most shares, expect for BT(BT.A) and Compass(CPG), which don't seem to work. STOCK gets the information from Yahoo Finance. Yahoo only seems to have the US listing for BT in Dollars and no London listing. However, it has the London listing for Compass and all the Information about it.
I note that HYPTUSS uses Yahoo for prices and works for both BT.A and Compass. Has anyone got any idea what the problem could be?