Forum Discussion

JessSee's avatar
JessSee
Copper Contributor
Oct 02, 2020

Import Singapore Stock Prices into MS Excel 2019 Desktop version

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!

excel

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Oct 02, 2020

    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)

     

    • JessSee's avatar
      JessSee
      Copper Contributor
      Oct 05, 2020
      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.

Resources