Import Singapore Stock Prices into MS Excel 2019 Desktop version

%3CLINGO-SUB%20id%3D%22lingo-sub-1738814%22%20slang%3D%22en-US%22%3EImport%20Singapore%20Stock%20Prices%20into%20MS%20Excel%202019%20Desktop%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1738814%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20MS%20Office%20Professional%202019%20Desktop%20version.%20How%20do%20I%20import%20live%20stock%20prices%20from%20Singapore%20Stock%20Exchange%20into%20my%20Excel%20spreadsheet%3F%20I%20tried%20importing%20data%20from%20webpage%20but%20it%20doesn't%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1738814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1739673%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20Singapore%20Stock%20Prices%20into%20MS%20Excel%202019%20Desktop%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739673%22%20slang%3D%22en-US%22%3EWhat%20is%20the%20URL%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1739881%22%20slang%3D%22de-DE%22%3ESubject%3A%20Import%20Singapore%20Stock%20Prices%20into%20MS%20Excel%202019%20Desktop%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739881%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F817627%22%20target%3D%22_blank%22%3E%40JessSee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22q-text%20qu-display--block%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20far%20i%20know%2C%20Microsoft%20provides%20some%20ready-made%20connections%20to%20fetch%20stock%20quotes%2C%20indices%20and%20currency%20rates%2C%20which%20can%20be%20accessed%20from%20Existing%20connections%20from%20'Data%20Tab'.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EWe%20can%20fetch%20external%20data%20from%20'Get%20External%20data'%20group%20under%20'Data%20Tab'.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETo%20access%20this%2C%20Click%20on%20'Existing%20Connections'.%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-555276525%22%20id%3D%22toc-hId-555276497%22%3E%3CFONT%20size%3D%222%22%3EGet%20a%20stock%20quote%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReal%20time%20as%20in%20lag%20of%200%20second%2C%20haves%2C%20so%20far%20i%20can%20know%2C%20no%20free%20access%20.%20Real%20time%20stock%20data%20is%20valuable%20and%20HFT%20companies%20pay%20a%20lot%20of%20money%20to%20Reuters%20and%20Bloomberg%20for%20these%20data%20feeds.%20Hence%20the%20question%20from%20Mr.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3EJan%20Karel%20Pieterse%20%3C%2FA%3Eabout%20your%20URL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am using MS Office Professional 2019 Desktop version. How do I import live stock prices from Singapore Stock Exchange into my Excel spreadsheet? I tried importing data from webpage but it doesn't work. 

 Thanks!

3 Replies

@JessSee 

 

So far i know, Microsoft provides some ready-made connections to fetch stock quotes, indices and currency rates, which can be accessed from Existing connections from 'Data Tab'.

We can fetch external data from 'Get External data" group under 'Data Tab'.

To access this, Click on 'Existing Connections'.

Get a stock quote

https://support.microsoft.com/en-us/office/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

 

Real time as in lag of 0 second, haves, so far i can know, no free access . Real time stock data is valuable and HFT companies pay a lot of money to Reuters and Bloomberg for these data feeds. Hence the question from Mr. Jan Karel Pieterse  about your URL.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

 

But the stock data functionality seems to apply only to Office 365 and not the desktop version of Excel. I also tried to use "Get Data From Web" but it doesn't seem to recognise the table from Singapore Stock Exchange website https://www.sgx.com/securities/securities-prices.