I want to take the market price from items on the rs grand exchange site and display them in my spreadsheet like the item database does. I have the spreadsheet made already, I just need the values from the GE.

Anybody know how i can acquire these numbers and plug them into the spreadsheet? Even if you know of a website which would explain how to do this, i would be happy to read up on it.

It's an herblore cost to gain in exp analysis chart for those wondering. If i can get these numbers to add in, i plan on making a couple more versions.

The following should do the trick:

 

=Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query='Item Name to Get Price of", "table", 2),2,3)

 

I'd mention the following:

 

• Obviously replace "Item Name to Get Price of" with the Item's Name you're searching for.
  
• The last instance of 2 I believe refers to the position to retrieve data from. 2 will retrieve the price from the topmost search result, increase according to the position that the item is returned in the search.
  

 

For example, if I was looking for the price of Clean Guam, the following would retrieve it:

 

=Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query='Guam'", "table", 2),4,3)

 

Of-course, one could simply refine the search query to be more specific, but I've found the G.E searching can be slightly temperamental at times to retrieve your exact item as the first result. ;)

I'll get straight away to adding this into the spreadsheet. Ty ty!