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.    03 Feb 2017 #2
    Join Date : Aug 2016
    S/E England
    Posts : 4,765
    10 Home x64 (1709) (10 Pro on 2nd pc)

    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


Similar Threads
Thread Forum
How to make Excel 2016 the default app to open xls and xlsx data files
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.
Software and Apps
EXCEL 2016 script error when getting external (web) data
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...
Software and Apps
Solved Windows Update causing dual monitors to rotate in continuous loop
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...
Graphic Cards
Excel 2007 Won'l load complex spreadsheets after this morning's update
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...
Windows Updates and Activation
Outlook 2010 Data file import error to Outlook 2013
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...
Browsers and Email
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 17:01.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App

Windows 10 Forums