New
#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