Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from a website question
The scenario:
I have an Excell sheet that I want to keep up to date prices on widget X, Y or Z from different websites. I know how to make a hyperlink to a specific website. However, is there a way to scan or link directly to a changing value on the site. The Bottom Line: I want my spreadsheet to have cells that update each time I open it with updated prices from various websites. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from a website question
Hi,
You should be able to do it with a web query. Select where you want the data to go then Data|Import external data|New web query Paste the link of where your data is into the address bar. I used this http://newsvote.bbc.co.uk/1/shared/f...ew/default.stm Click GO All the tables you can import will have a yellow tick on the top left corner click one - I selected FTSE Click Import and your table will be created Right click the table to set update refresh frequency. If you use my link then you can watch the FTSE die in almost real time or if you prefer click the Dow Jones :) Mike "Rhynn" wrote: The scenario: I have an Excell sheet that I want to keep up to date prices on widget X, Y or Z from different websites. I know how to make a hyperlink to a specific website. However, is there a way to scan or link directly to a changing value on the site. The Bottom Line: I want my spreadsheet to have cells that update each time I open it with updated prices from various websites. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from a website question
Thanks a b unch Mike.
"Mike H" wrote: Hi, You should be able to do it with a web query. Select where you want the data to go then Data|Import external data|New web query Paste the link of where your data is into the address bar. I used this http://newsvote.bbc.co.uk/1/shared/f...ew/default.stm Click GO All the tables you can import will have a yellow tick on the top left corner click one - I selected FTSE Click Import and your table will be created Right click the table to set update refresh frequency. If you use my link then you can watch the FTSE die in almost real time or if you prefer click the Dow Jones :) Mike "Rhynn" wrote: The scenario: I have an Excell sheet that I want to keep up to date prices on widget X, Y or Z from different websites. I know how to make a hyperlink to a specific website. However, is there a way to scan or link directly to a changing value on the site. The Bottom Line: I want my spreadsheet to have cells that update each time I open it with updated prices from various websites. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grabbing data from another website | Excel Discussion (Misc queries) | |||
data linking/field matching/formula updating long question | Excel Discussion (Misc queries) | |||
How to extract one data from a website | Excel Discussion (Misc queries) | |||
Excel 2007 workbook not linking properly with authentic website | Excel Discussion (Misc queries) | |||
Linking to a website | Links and Linking in Excel |