Excel Gurus - Import data from the web with continuous update


  1. Posts : 11,247
    Windows / Linux : Arch Linux
       #1

    Excel Gurus - Import data from the web with continuous update


    Hi folks

    anybody know an easy way to get data (in particular Stock data) from the internet, insert into a spreadsheet and continuously (or every so often) refresh and update the data.

    It's simple to get data from web but I'm not sure what I need to do to keep updating

    I'm using EXCEL 2016 (from Office 2016 PRO).

    For example here's the Dow (30) from yahoo

    http://finance.yahoo.com/quote/%5EDJ...nents?p=%5EDJI

    OK US market currently closed but similarly for UK FTSE 100

    http://finance.yahoo.com/quote/%5EFT...ents?p=%5EFTSE

    Any data would be OK -- but probably easiest to test with Stock data as it's available FREE and continuously updating.

    Cheers
    jimbo
      My Computer


  2. Posts : 31,398
    10 Home x64 (22H2) (10 Pro on 2nd pc)
       #2

    Task Scheduler would seem to be the way, some ideas here...
    excel - How to set recurring schedule for xlsm file using Windows Task Scheduler - Stack Overflow

    A word of warning though. Some sites don't take too kindly to their data being gathered in this way, they want you to read their pages - not extract the data. Excessive use of such techniques can result in your IP address being blocked from further access. You'll know if this has happened when you can no longer open the site in your browser.

    I haven't (yet) been blocked by Yahoo, but some others have blacklisted my IP. Fortunately my ISP assigns a different IP each time I restart my router.
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 06:00.
Find Us




Windows 10 Forums