Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)

[leolapa]

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 work in progress, but by now the dev team could've done a better job on this one. The data selector search tool for instance couldn't be any worse - it really SUCKS!!!

So, this is a list of mainstream stock exchanges that Microsoft claims they are supported according to the link below, but I've tried every possible code/ticker related to them that I could and no sucess at all to have them linked to Excel data types.

About the Stocks financial data sources

Index	Exchange	Country	Codes/tickers attempted
AEX	Euronext Amsterdam	Netherlands	AEX, XAMS
CAC 40	Euronext Paris	France	CAC 40, CAC40, PX1, XPAR
FTSE MIB	Borsa Italiana	Italy	FTMIB, MIB, FTSE MIB, XMIL
FTSE 100	London Stock Exchange	United Kingdom	FTSE, FTSE100, FTSE 100, UKX, XLON
Hang Seng	HKEX - Hong Kong Exchanges	Hong Kong	HSI, Hang Seng, XHKG
IBEX 35	Bolsa de Madrid	Spain	IBEX, IBEX35, IBEX 35, BMEX
MOEX Russia	MOEX - Moscow Exchange	Russia	MOEX, IMOEX, MISX
FTSE JSE SA Top 40	JSE - Johannesburg Stock Exchange	South Africa	JSE, FTSE JSE, FTSEJSE, JTOPI, XJSE
Kospi	KRX - Korea Exchange	South Korea	KS11, KOSPI, KRX, XKRX
IPC	Grupo BMV	Mexico	IPC, MXX, XMEX

And come on, we're mostly talking about MAJOR exchanges here, and that are supported by this service according to Microsoft's own support page, so there's no excuse that no one can't find them for crying out loud!!!

[#2]

@leolapa 

Refinitiv doesn't provide Exchange Indexes here. List of supported exchanges only means you may find information about papers traded on such Exchanges.

[#3]

@Sergei Baklan I beg to differ...

Please take a look at the screenshot of an Excel schedule I put together of global markets indexes I was able to link with Excel stock data types, and the data card of one of them not only does provide the correct points from the last trading day close, but it also clearly indicates on the bottom righthand corner under "Instrument type" as an "INDEX".

I individually checked each one of the 15 indexes' data cards from the above list and they all provide accurate information from Refinitiv.

So, back to my prior question: What about those others I'd listed? Why no one can manage to find them if they are from markets covered by the Excel data type feature according to Microsoft's support page about this topic?

[#4]

I am having the same issue. Have you found any resolution @leolapa?

I am equally shocked that some major exchanges are easily accessible, while others are completely unattainable.

Thanks

[#5]

Nothing so far...
I also learned as I was developing some more complex tables to fetch historical stock data via STOCKHISTORY function (which also pulls data from the data types functionality) that this data fetching feature is still ways to go in order to get to some robust state. It still does a lot of data lagging, compromises sheet processing performance, etc.
I'm currently giving up that route and fetching financial instruments historical data and other related info using Power Query scripts via Yahoo! Finance links, and that also applies to global stock exchanges indexes.

[#6]

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!

[#7]

it is quite frankly astounding the lack of proper usable documentation on the available securities/ furtures/ etc. Very frustrating needless to say.

[#8]

@leolapa 

After a couple of years I still can't find the AEX-index (mayor index in Amsterdam, The Netherlands) in Excel-stocks.