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

%3CLINGO-SUB%20id%3D%22lingo-sub-2721052%22%20slang%3D%22en-US%22%3ECan't%20find%20several%20stock%20exchange%20indexes%20on%20Excel%20stock%20data%20type%20(i.e%3A%20FTSE%2C%20CAC%2040%2C%20Hang%20Seng...)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2721052%22%20slang%3D%22en-US%22%3E%3CP%3EI%20noticed%20by%20searching%20around%20that%20this%20is%20a%20topic%20that%20has%20been%20asked%20quite%20a%20bit%20with%20no%20clear%20answers%20that%20get%20to%20bottom%20of%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20well%20aware%20the%20Excel%20data%20types%20feature%20is%20still%20a%20work%20in%20progress%2C%20but%20by%20now%20the%20dev%20team%20could've%20done%20a%20better%20job%20on%20this%20one.%20The%20data%20selector%20search%20tool%20for%20instance%20couldn't%20be%20any%20worse%20-%20it%20really%20SUCKS!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20this%20is%20a%20list%20of%20mainstream%20stock%20exchanges%20that%20Microsoft%20claims%20they%20are%20supported%20according%20to%20the%20link%20below%2C%20but%20I've%20tried%20every%20possible%20code%2Fticker%20related%20to%20them%20that%20I%20could%20and%20no%20sucess%20at%20all%20to%20have%20them%20linked%20to%20Excel%20data%20types.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAbout%20the%20Stocks%20financial%20data%20sources%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22102.73653314917127%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2257px%22%3E%3CU%3E%3CFONT%20color%3D%22%23333399%22%3E%3CSTRONG%3EIndex%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FU%3E%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2257px%22%3E%3CU%3E%3CFONT%20color%3D%22%23333399%22%3E%3CSTRONG%3EExchange%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FU%3E%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2257px%22%3E%3CU%3E%3CFONT%20color%3D%22%23333399%22%3E%3CSTRONG%3ECountry%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FU%3E%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2257px%22%3E%3CU%3E%3CFONT%20color%3D%22%23333399%22%3E%3CSTRONG%3ECodes%2Ftickers%20attempted%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FU%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2230px%22%3EAEX%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2230px%22%3EEuronext%20Amsterdam%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2230px%22%3ENetherlands%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2230px%22%3EAEX%2C%20XAMS%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2230px%22%3E%3CP%3ECAC%2040%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2230px%22%3EEuronext%20Paris%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2230px%22%3EFrance%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2230px%22%3ECAC%2040%2C%20CAC40%2C%20PX1%2C%20XPAR%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2210px%22%3E%3CP%3EFTSE%20MIB%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2210px%22%3EBorsa%20Italiana%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2210px%22%3EItaly%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2210px%22%3EFTMIB%2C%20MIB%2C%20FTSE%20MIB%2C%20XMIL%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2257px%22%3EFTSE%20100%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2257px%22%3ELondon%20Stock%20Exchange%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2257px%22%3EUnited%20Kingdom%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2257px%22%3EFTSE%2C%20FTSE100%2C%20FTSE%20100%2C%20UKX%2C%20XLON%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2230px%22%3EHang%20Seng%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2230px%22%3EHKEX%20-%20Hong%20Kong%20Exchanges%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2230px%22%3EHong%20Kong%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2230px%22%3EHSI%2C%20Hang%20Seng%2C%20XHKG%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2230px%22%3EIBEX%2035%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2230px%22%3EBolsa%20de%20Madrid%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2230px%22%3ESpain%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2230px%22%3EIBEX%2C%20IBEX35%2C%20IBEX%2035%2C%20BMEX%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2230px%22%3EMOEX%20Russia%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2230px%22%3EMOEX%20-%20Moscow%20Exchange%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2230px%22%3ERussia%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2230px%22%3EMOEX%2C%20IMOEX%2C%20MISX%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2257px%22%3EFTSE%20JSE%20SA%20Top%2040%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2257px%22%3EJSE%20-%20Johannesburg%20Stock%20Exchange%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2257px%22%3ESouth%20Africa%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2257px%22%3EJSE%2C%20FTSE%20JSE%2C%20FTSEJSE%2C%20JTOPI%2C%20XJSE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2257px%22%3EKospi%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2257px%22%3EKRX%20-%20Korea%20Exchange%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2257px%22%3ESouth%20Korea%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2257px%22%3EKS11%2C%20KOSPI%2C%20KRX%2C%20XKRX%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220.994475138121548%25%22%20height%3D%2230px%22%3EIPC%3C%2FTD%3E%3CTD%20width%3D%2236.74033149171271%25%22%20height%3D%2230px%22%3EGrupo%20BMV%3C%2FTD%3E%3CTD%20width%3D%2212.709970776975528%25%22%20height%3D%2230px%22%3EMexico%3C%2FTD%3E%3CTD%20width%3D%2232.29518541227215%25%22%20height%3D%2230px%22%3EIPC%2C%20MXX%2C%20XMEX%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20come%20on%2C%20we're%20mostly%20talking%20about%20MAJOR%20exchanges%20here%2C%20and%20that%20are%20supported%20by%20this%20service%20according%20to%20Microsoft's%20own%20support%20page%2C%20so%20there's%20no%20excuse%20that%20no%20one%20can't%20find%20them%20for%20crying%20out%20loud!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2721052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2722012%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20several%20stock%20exchange%20indexes%20on%20Excel%20stock%20data%20type%20(i.e%3A%20FTSE%2C%20CAC%2040%2C%20Hang%20Seng%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2722012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134010%22%20target%3D%22_blank%22%3E%40leolapa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERefinitiv%20doesn't%20provide%20Exchange%20Indexes%20here.%20List%20of%20supported%20exchanges%20only%20means%20you%20may%20find%20information%20about%20papers%20traded%20on%20such%20Exchanges.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2723146%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20several%20stock%20exchange%20indexes%20on%20Excel%20stock%20data%20type%20(i.e%3A%20FTSE%2C%20CAC%2040%2C%20Hang%20Seng%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2723146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20beg%20to%20differ...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20take%20a%20look%20at%20the%20screenshot%20of%20an%20Excel%20schedule%20I%20put%20together%20of%20global%20markets%20indexes%20I%20was%20able%20to%20link%20with%20Excel%20stock%20data%20types%2C%20and%20the%20data%20card%20of%20one%20of%20them%20not%20only%20does%20provide%20the%20correct%20points%20from%20the%20last%20trading%20day%20close%2C%20but%20it%20also%20clearly%20indicates%20on%20the%20bottom%20righthand%20corner%20under%20%22Instrument%20type%22%20as%20an%20%22INDEX%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel_IBOV.png%22%20style%3D%22width%3A%20599px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308235i38396FF19F7B8C1D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel_IBOV.png%22%20alt%3D%22Excel_IBOV.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20individually%20checked%20each%20one%20of%20the%2015%20indexes'%20data%20cards%20from%20the%20above%20list%20and%20they%20all%20provide%20accurate%20information%20from%20Refinitiv.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20back%20to%20my%20prior%20question%3A%20What%20about%20those%20others%20I'd%20listed%3F%20Why%20no%20one%20can%20manage%20to%20find%20them%20if%20they%20are%20from%20markets%20covered%20by%20the%20Excel%20data%20type%20feature%20according%20to%20Microsoft's%20support%20page%20about%20this%20topic%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

 

IndexExchangeCountryCodes/tickers attempted
AEXEuronext AmsterdamNetherlandsAEX, XAMS

CAC 40

Euronext ParisFranceCAC 40, CAC40, PX1, XPAR

FTSE MIB

Borsa ItalianaItalyFTMIB, MIB, FTSE MIB, XMIL
FTSE 100London Stock ExchangeUnited KingdomFTSE, FTSE100, FTSE 100, UKX, XLON
Hang SengHKEX - Hong Kong ExchangesHong KongHSI, Hang Seng, XHKG
IBEX 35Bolsa de MadridSpainIBEX, IBEX35, IBEX 35, BMEX
MOEX RussiaMOEX - Moscow ExchangeRussiaMOEX, IMOEX, MISX
FTSE JSE SA Top 40JSE - Johannesburg Stock ExchangeSouth AfricaJSE, FTSE JSE, FTSEJSE, JTOPI, XJSE
KospiKRX - Korea ExchangeSouth KoreaKS11, KOSPI, KRX, XKRX
IPCGrupo BMVMexicoIPC, 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!!!

4 Replies

@leolapa 

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

@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".

 

Excel_IBOV.png

 

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?

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

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.