Stocks and SharesIn this lesson you'll learn how Excel can use real data from the web.
Once again we'll use a feature from the 'Data' tab at the top, this is called 'from web' 
|
|
The information we'll be using is an list of stock prices from Reuters. These are updated every minute, so they are constantly changing. You'll be able to see the effect of those changes in Excel by just pushing a button.
Click here to see the original web page from Reuters
There are a number of steps to include the right data into your spreadsheet, so care is required to select the right table - the part of the webpage that contains the data you want.
Click here to see the original web page from Reuters
There are a number of steps to include the right data into your spreadsheet, so care is required to select the right table - the part of the webpage that contains the data you want.
Extension:
Excel can create a live link to any data on a web page that is formatted as a table. Try some of these web pages and see what you can do with the information:
Live train departures from Rickmansworth
Live bus information (example) - put in your postcode here and then find the page for you
You're hacking - in the best possible way. Using data that's out there to do something new.
Check out some of the hacks from Young Rewired State's Festival of Code
Excel can create a live link to any data on a web page that is formatted as a table. Try some of these web pages and see what you can do with the information:
Live train departures from Rickmansworth
Live bus information (example) - put in your postcode here and then find the page for you
- Can you think of other data that might be useful to you?
- Is it formatted in a way that Excel can use?
- Can you make your own spreadsheet which uses it?
You're hacking - in the best possible way. Using data that's out there to do something new.
Check out some of the hacks from Young Rewired State's Festival of Code
