Windows 10: Excel Gurus - Import data from the web with continuous update
Excel Gurus - Import data from the web with continuous update
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.
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.
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...
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...