Windows 10: Excel Gurus - Import data from the web with continuous update

  1.    03 Feb 2017 #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

    OK US market currently closed but similarly for UK FTSE 100

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

      My ComputerSystem Spec

  2. Posts : 5,993
    10 Home x64 (1709) (10 Pro on 2nd pc)
       03 Feb 2017 #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 ComputersSystem Spec


Related Threads
I know how I'm supposed to do it, SETTINGS==>DEFAULT APPS==>CHOOSE THE DEFAULT APP BY FILE TYPE, but Excel 2016 is not an option. Instead, it tries to send me to the App Store. I think I have tried everything except reinstalling Office.
Hi there Trying to download data from web into a spreadsheet I keep getting Script Error. This worked perfectly in EXCEL 2010 (and still does). Get external data -->web The query simply takes the components of the London FTSE 100 (like the...
Last night one of the Windows (anniversary?) updates messed up the connection to my second monitor (which is a TV and only used to watch movies) and as a result whenever I switch to it or even duplicate my screen it keeps hanging in a continuous...
Two days ago, Windows Update deleted my printer and its drivers from my system. I was able to get the drivers from Canon and put everything back together, but was not happy about it. Then this morning I found that another update had caused Excel...
My employer (School Board) requested all staff laptops be returned over summer so the OS could be upgraded from Win 7 Enterprise, so I did an export of my Outlook 2010 file to work on from home- they now want all Outlook profiles below 50 MB. My...
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 20:06.
Find Us