Obtaining Real Time Financial index Data (FTSE100, NASDAQ etc)

[HoraceG]

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.

[#2]

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

[#3]

NASDAQ is available though.

[#4]

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?

[#5 · Accepted solution]

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)

[#6]

Hi @Wyn Hopkins 

Looking Good! Will confirm tomorrow when the markets open!

Thanks for your response.

[#7]

Hi Wyn,

YES! Sorted!

Yahoo Finance has a 15 minute delay but this gives me exactly what I wanted.

Once again, thanks for your help! 

[#8]

Thank you very much, Wyn!