YD Scuba Diving Forums banner
1 - 3 of 3 Posts

·
Team Starburst
Joined
·
5,275 Posts
Discussion Starter · #1 ·
I have an Excel file that is monitoring the prices of a number of investment funds. I can create hyperlinks to the correct pages, which is part of the solution I want.

However being extremely lazy I want to extract a specific price from a web page such as from the link shown below?
https://www.skandiais.co.uk/fundprice.asp?fundManID=95&FunManName=Ignis Asset Management&PreviousPage=peformanceall
Any ideas how I can arrange this?
 

·
Registered
Joined
·
1,249 Posts
There are a couple of things you can do so have a play with them;

In recent versions of Excel (definitely in 2007, maybe earlier) there is an option to link data from a web source - go to the Data tab and choose "From Web", input your URL (the one you provided doesn't work so I can't do an example) and select the table you're importing.

You can also use something like a scripting tool - in Firefox I use iMacros which allows you to run a script which scrapes data off websites and can input that into a file.

If you want to get really cleaver then you can use a combination of Google Docs, Many Eyes Wikified and Yahoo Pipes to turn almost any website/data source into a constant data feed.
Check out this example of pulling data out of Wikipedia and have a hunt through this blog for other ideas of what you can do with these tools.

There are even more options if you can find an RSS feed of the data but I'll leave that for now!
 

·
Team Starburst
Joined
·
5,275 Posts
Discussion Starter · #3 ·
There are a couple of things you can do so have a play with them;

In recent versions of Excel (definitely in 2007, maybe earlier) there is an option to link data from a web source - go to the Data tab and choose "From Web", input your URL (the one you provided doesn't work so I can't do an example) and select the table you're importing.
Brilliant
I have saved several web queries so that updating the data links downloads all the web pages into a sheet and then Vlookup does the rest for me.
 
1 - 3 of 3 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top