How to create spreadsheets that auto refresh data(Prices) from websites

[davidm163]

Hello everyone.

I am an excel newbie and have a question. Is it possible to make a spreadsheet that automatically refreshes specific data pull from an internet website?

I am trying to do this in the context of textbooks. For example:

This particular books ISBN is 9780470843765. As of 6/10 6:30PM the used price on amazon is $20.00

Is is possible to have a spreadsheet with hundreds of entries with this information and have the price refresh every few hours or so?

Here is a screenshot link of what I imagine this looking like in my head


http://i60.tinypic.com/2v2chgm.png

Any information would be tremendously appreciated.

Thank you.