GE prices in Excel automatically

[De_Lille_D]

Is it possible find a link/command that can give me the price of a specific GE item in Excel (latest version)? I want top make spreadsheet that calculate the best method to train, but for that I need the prices of a lot of items and it takes a long time to put them in manually.

 

 

 

So, can i make some of the cells in the spreadsheet get the price automatically?

 

 

 

 

 

This is how a link to an item works (page with graph):

 

 

 

http://itemdb-rs.runescape.com/viewitem.ws?obj=1217

 

 

 

with the number at the end = the item number

 

 

 

Link to graph:

 

 

 

http://itemdb-rs.runescape.com/2670_gra ... 17&scale=0

 

 

 

 

 

EDIT: Progress! If I press "get external data" (literally translated) I can get the price in a big list, but I still have to browse to the exact website ...

[Johannas]

Does this help at all?

 

 

 

viewtopic.php?f=180&t=782319

[De_Lille_D]

Kinda, but I don't want to have to use Google docs, if I can do it in Excel.

 

 

 

Does anyway know if there's a command similar to "ImportHtml" in Excel?

[De_Lille_D]

I decided to do is in Google Docs anyway, and I think I found a good way to import price. Based on the item number (found in the link to the item's graph page) I can extract price with this file: http://spreadsheets.google.com/ccc?key= ... vRX0HfY7Ug