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...
leolapa The simplest solution to this annoyance is to find an equivalent ETF that tracks the index you're interested in. For example:
- Russell 2000 > iShares Russell 2000 ETF (IWM)
This ETF can be tracked as any other stock.
There is another issue with available indexes such as:
- NASDAQ Composite Index (COMP)
- DOW JONES INDU AVERAGE NDX (DJI)
- S&P 500 INDEX (INX)
and it is that the date & time of the quote is not fetched (because it's not a tradeable instrument). This issue is also solved by using an equivalent ETF.
I made a custom GPT for Excel inquiries: https://chat.openai.com/g/g-nbUfJ7DV4-excel-wizard. I encourage anyone to try asking for a solution to this issue.