Oct 02 2020 03:40 AM
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!
Oct 02 2020 08:19 AM
Oct 02 2020 08:56 AM
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'.
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)
Oct 04 2020 09:02 PM