Forum Discussion
leolapa
Sep 05, 2021Copper Contributor
Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)
I noticed by searching around that this is a topic that has been asked quite a bit with no clear answers that get to bottom of this issue. I'm well aware the Excel data types feature is still a w...
JerryDNYC
Mar 25, 2023Copper Contributor
I totally agree. It's incredible that the page you show above doesn't have a column for the symbol needed for the STOCKHISTORY function. And while the NAMES in the screenshot leolapa posted can be found using the Stock data type (which would have been MUCH more useable had he included the TEXT instead of just a screenshot), the "Ticker Symbol" for FOUR of the 14 names don't work with STOCKHISTORY!
I don't understand why all the major indexes aren't listed in one page as well as the CORRECT Ticker Symbol needed to use with the STOCKHISTORY function!
I don't understand why all the major indexes aren't listed in one page as well as the CORRECT Ticker Symbol needed to use with the STOCKHISTORY function!
- Almac42Mar 30, 2023Copper Contributorit is quite frankly astounding the lack of proper usable documentation on the available securities/ furtures/ etc. Very frustrating needless to say.