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

  1.    3 Weeks Ago #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 System SpecsSystem Spec

  2. Bree's Avatar
    Posts : 1,445
    10 Home x64 (1607), Pro x86 (1511 & 1607)
       3 Weeks Ago #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 System SpecsSystem 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.
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...
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...
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 17:03.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums