SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2117478%22%20slang%3D%22en-US%22%3EObtaining%20Real%20Time%20Financial%20index%20Data%20(FTSE100%2C%20NASDAQ%20etc)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117478%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3EI'm%20struggling%20to%20set%20up%20a%20connection%20to%20certain%20specific%20Real%20Time%20Data%20on%20a%20worksheet%20such%20as%20FTSE100%20%26amp%3B%20NASDAQ.%3C%2FP%3E%3CP%3EI%20can%20get%20real%20time%20Stock%2FShare%20Data%20no%20problem%20but%20am%20failing%20dismally%20with%20Indexes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EANY%20help%20would%20be%20really%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2117478%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119890%22%20slang%3D%22en-US%22%3ERE%3A%20Obtaining%20Real%20Time%20Financial%20index%20Data%20(FTSE100%2C%20NASDAQ%20etc)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119890%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wyn%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYES!%20Sorted!%3C%2FP%3E%3CP%3EYahoo%20Finance%20has%20a%2015%20minute%20delay%20but%20this%20gives%20me%20exactly%20what%20I%20wanted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20again%2C%20thanks%20for%20your%20help!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119246%22%20slang%3D%22en-US%22%3ERE%3A%20Obtaining%20Real%20Time%20Financial%20index%20Data%20(FTSE100%2C%20NASDAQ%20etc)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119246%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20Good!%20Will%20confirm%20tomorrow%20when%20the%20markets%20open!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20response.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118970%22%20slang%3D%22en-US%22%3ERE%3A%20Obtaining%20Real%20Time%20Financial%20index%20Data%20(FTSE100%2C%20NASDAQ%20etc)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118970%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959035%22%20target%3D%22_blank%22%3E%40HoraceG%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20are%20available%20some%20aren't%20-%20Microsoft%20use%20a%20company%20called%20Refinititv%20and%20they%20don't%20appear%20to%20have%20all%20indices%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20747px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253575i4905E6326DECC0E7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20option%20is%20to%20use%20Power%20Query%20to%20pull%20the%20data%20from%20a%20public%20website%26nbsp%3B%20%26nbsp%3B(see%20attached%20file)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118936%22%20slang%3D%22en-US%22%3ERE%3A%20Obtaining%20Real%20Time%20Financial%20index%20Data%20(FTSE100%2C%20NASDAQ%20etc)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118936%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20responding.%3C%2FP%3E%3CP%3EDo%20I%20understand%20that%20you%20are%20saying%20that%20it%20is%20not%20possible%20to%20achieve%20what%20I%20want%20to%20do%3F%3C%2FP%3E%3CP%3EWhy%20is%20it%20possible%20to%20get%20specific%20Stock%20Prices%20onto%20a%20worksheet%20but%20not%20a%20current%20FTSE100%20or%20DOW%20JONES%20value%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2117563%22%20slang%3D%22en-US%22%3ERE%3A%20Obtaining%20Real%20Time%20Financial%20index%20Data%20(FTSE100%2C%20NASDAQ%20etc)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117563%22%20slang%3D%22en-US%22%3ENASDAQ%20is%20available%20though.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2117561%22%20slang%3D%22en-US%22%3ERE%3A%20Obtaining%20Real%20Time%20Financial%20index%20Data%20(FTSE100%2C%20NASDAQ%20etc)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117561%22%20slang%3D%22en-US%22%3EMost%20%2F%20Many%20Indexes%20aren't%20available...There's%20a%20user%20voice%20request%20for%20this%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F41606188-stockhistory%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F41606188-stockhistory%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

6 Replies
NASDAQ is available though.

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?

Best Response confirmed by HoraceG (Occasional Contributor)
Solution

Hi @HoraceG 

 

Some are available some aren't - Microsoft use a company called Refinititv and they don't appear to have all indices

 

image.png

 

Another option is to use Power Query to pull the data from a public website   (see attached file)

Hi @Wyn Hopkins 

 

Looking Good! Will confirm tomorrow when the markets open!

 

Thanks for your response.

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!