Forum Discussion
Solved
Obtaining Real Time Financial index Data (FTSE100, NASDAQ etc)
Hi Guys,
I'm struggling to set up a connection to certain specific Real Time Data on a worksheet such as FTSE100 & NASDAQ.
I can get real time Stock/Share Data no problem but am failing dismally with Indexes.
ANY help would be really appreciated.
Hi HoraceG
Some are available some aren't - Microsoft use a company called Refinititv and they don't appear to have all indices
Another option is to use Power Query to pull the data from a public website (see attached file)
- NASDAQ is available though.
- Most / Many Indexes aren't available...There's a user voice request for this https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/41606188-stockhistory
Hi Wyn Hopkins
Thank you for responding.
Do I understand that you are saying that it is not possible to achieve what I want to do?
Why is it possible to get specific Stock Prices onto a worksheet but not a current FTSE100 or DOW JONES value?
Hi HoraceG
Some are available some aren't - Microsoft use a company called Refinititv and they don't appear to have all indices
Another option is to use Power Query to pull the data from a public website (see attached file)
