Forum Discussion

HoraceG's avatar
HoraceG
Copper Contributor
Feb 08, 2021
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 wi...
excel
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Feb 09, 2021

    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)

HoraceG's avatar
HoraceG
Copper Contributor
Feb 09, 2021

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?

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Feb 09, 2021

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)

  • Aerox666's avatar
    Aerox666
    Copper Contributor
    Nov 06, 2023
    Thank you very much, Wyn!
  • HoraceG's avatar
    HoraceG
    Copper Contributor
    Feb 09, 2021

    Hi Wyn Hopkins 

     

    Looking Good! Will confirm tomorrow when the markets open!

     

    Thanks for your response.

    • HoraceG's avatar
      HoraceG
      Copper Contributor
      Feb 10, 2021

      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! 

Resources