Google sheets help

[madago227]

how can I grab an item price from osrs g.e page and input it into a cell in google sheets? Is this possible?

[WillOSB]

Method 1:

 

=Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_oldschool/results.ws?query=Logs), "table", 1),2,3)

 

This returns the price of the first item in the table when you search for "Logs"

 

Just change logs to whatever you need to look for.

 

Method 2:

 

=Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_oldschool/results.ws?query=", encode(A3)), "table", 1),2,3)

 

This looks up the item name you have written in cell "A3" in the spreadsheet - then returns the same as Method 1.

 

 

If an item like "Logs" returns many values, you change the "2" in the above URL to the correct number. 

 

Item 1 in the table = #2

Item 2 in the table = #3  

 

etc etc

 

Hope this helps.

Edited August 16, 2016 by WillR

[Solzhenitsyn]

Use parse method from your browser's javascript to read rsbuddy's price json.