Forum Discussion
Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)
leolapa I would add that Canada's newest equity exchange is not there, yet because it has started small, it is no doubt the fastest-growing equities and ETF exchange in Canada. Originally dubbed the NEO Exchange when it was created in 2014, it has been acquired by CBOE (yes, THE leader in options trading), and is now called CBOE Canada. This marks CBOE's entry into regular equities trading, an initiative that is intended to grow into a multi-national network of equities markets world-wide. (To be clear, this is a STOCK market, not an options market.) CBOE Canada is also the only Canadian exchange that lists Canadian Depositary Receipts (CDRs), which allow Canadians to buy major US securities without currency risk (much like ADRs in the US). In short,I think that we're all in agreement that Microsoft needs to escalate it's efforts to fill in the gaps in it's promise to deliver stock prices and other timely information for all equities exchanges, not just the major US ones.
As a (2nd best) alternative to the (many?) outstanding flaws in the Microsoft/Refinitive implementation of the Stocks data type and STOCKHISTORY function, you can always use Web Queries in your spreadsheets to access data from any web site that provides stock data in tabular form. It's kludgy, but once implemented it works better than data downloads and cut&paste. My dynamically-updated stock exchange indexes spreadsheet gets it's numbers (probably slightly delayed) from Yahoo! Finance. I just set up a watchlist there with all the indexes I want and put it's URL into a web query. A click on Refresh All gets the latest numbers, just as with the Stock Type/STOCKHISTORY approach.
However, that may not solve the other problem of Refinitiv (or Microsoft?) not allowing access to some exchanges and ALL of the listed companies on them. As an example, I used Canada's NEO Exchange (now called CBOE Canada). But since my last post, I've noticed that they seem to be working on that. With the NEOE: prefix I can now get a few of the stocks and CDRs of companies listed there. E.g. NEOE:ETHC gets me quotes on Ether Capital Corp, and I can get CDR quotes on IBM and Costco with NEOE:IBM and NEOE:COST. So far I haven't be able to access any of the ETFs listed on that exchange or very many other common shares. At least it's a step in the right direction.
