Forum Discussion
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...
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
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.
