Hello people, i wanted to make a profit calc ETC with google spreadsheets but i have the hardest time making it grab the prices.
=Index(ImportHtml(Concatenate("http://services.runescape.com/m=itemdb_rs/results.ws?query=guam"), "table", 1),4,3)
did not work, though this should work for the RS3 G.E. but it does not
the only way i hoped i could get it to work was via the find table thing as in the link above but the Oldschool RS G.E.
it has a table but no link i could copy paste in
if i go to the iron ore itself
now it isn't in a table it can grab the price from all i could find is that the price is between <h3> and </h3>
http://services.runescape.com/m=itemdb_oldschool/Iron_ore/viewitem?obj=440
thought it was simple just grabbing a price from the G.E. with google spreadsheets... but nope
all help will be appreciated