madago227 Posted August 16, 2016 Posted August 16, 2016 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 Posted August 16, 2016 Posted August 16, 2016 (edited) 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 Posted August 16, 2016 Posted August 16, 2016 Use parse method from your browser's javascript to read rsbuddy's price json.
