How to use Google Docs to extract GE prices ~By Brainymidget

[AgingMiser 0]

Got it.

 

 

 

=IF(Isnumber(http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22), http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22,MID(http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22,2,9))

 

 

 

Alternatively, if the price change is defined in [cell], you can use

 

 

 

=IF(Isnumber([cell]), [cell],MID([cell],2,9))

[GreenFire63 0]

I tried your second suggestion on that, after typing in:

 

=IF(Isnumber([D4]), [D4],MID([D4],2,9)) 

 

I got an error message and when I double clicked on the cell, this showed up....

 

=IF(Isnumber([R[-1]C[-5]]), [R[-1]C[-5]],MID([R[-1]C[-5]],2,9)) 

 

Any ideas?

[AgingMiser 0]

I tried your second suggestion on that, after typing in:

 

=IF(Isnumber([D4]), [D4],MID([D4],2,9)) 

 

I got an error message and when I double clicked on the cell, this showed up....

 

=IF(Isnumber([R[-1]C[-5]]), [R[-1]C[-5]],MID([R[-1]C[-5]],2,9)) 

 

Any ideas?

 

 

 

You're supposed to replace the brackets around [cell] too. So the correct code would actually be:

 

=IF(Isnumber(D4),D4,MID(D4,2,9)) 

[GreenFire63 0]

Silly me.

 

 

 

You're awesome. Many thanks.

[AgingMiser 0]

Silly me.

 

 

 

You're awesome. Many thanks.

 

 

 

Welcome. :]

[lamia_rog 0]

Thanks Brainy for the guide.

 

 

 

Made this Herblore Sheet with it.

 

http://spreadsheets.google.com/pub?key= ... utput=html

[opeious 0]

Pwnzorg guide 10/10!

 

 

 

Check out my puny :? enchanted bolt guide

 

http://spreadsheets.google.com/ccc?key= ... RcWc&hl=en

[brainymidget 1]

Oo Aging Miser I like it.

 

Edited that to include the Concat and it worked. Here's what I used for Dragon Pickaxe.

 

=MID(Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A5),"table",2),2,3), 1,3)*1000000

[TyrantElf 0]

I was wondering if i could copy this to another forum, You will get full credit, and i think it will really help!

[Shelby_Polo 0]

EDIT: Nevermind I figured out my question... :unsure:

[Maxingmck 139]

how do i turn something with k at the end (19.4k) for example to 19400

[AgingMiser 0]

If the price of an [item] is listed as ___k in the GE Database, use this code to isolate the number:

 

=MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22","table",2),2,3), 1,#)*1000

 

The code to isolate a number in the millions is almost identical:

 

=MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22","table",2),2,3), 1,#)*1000000

 

Good [cabbage], do people even bother to read the thread to see if their question's been answered yet?

[Maxingmck 139]

i didnt understand it lol

[broholt 0]

What mid does is to read what is says, as simple as that.

So you want it to read anything but the k and then multiply by 1000

like: 19.4k you want it to read: 1,4

1,4 is: 1 - 9 - . - 4

So it is now: 19.4

 

=MID(Index(ImportHtml("(InsertHtml)","table",2),2,3), 1,4)*1000

 

Mills: multiply by 1.000.000

199.4k

Is: 1,5

[Maxingmck 139]

so what would the entire code be? im using =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",C5), "table", 2),2,3)

 

right now hwo would i add the k in

[AgingMiser 0]

=MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22[item]%22","table",2),2,3), 1,#)*1000

 

You don't need to do anything EXCEPT input the name of the item. What you do is replace the [item] with the name of the item. You've made the same mistake in the concat func modification - you didn't tell the function what item to look at.

[Maxingmck 139]

=MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22clean ranarr%22","table",2),2,3), 1,#)*1000

 

i get #error

[AgingMiser 0]

=MID(Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=%22Ranarr%22","table",2),2,3), 1,#)*1000

 

"Clean ranarr" is not the name of an item you genius.

[Maxingmck 139]

o

[Maxingmck 139]

clean ranarr IS an item, check ge database, genious

 

 

EDIT: still says error

[Myweponsg00d 0]

Clean_ranarr

 

And you replace the # sign with a number.

[gorillekitue 0]

I only seem to get the Loading... message no matter how long I wait :/

[Kaphias 20]

I only seem to get the Loading... message no matter how long I wait :/

Occasionally this seems to happen. Best solution I've found is to simply wait and try again later.

[gorillekitue 0]

I only seem to get the Loading... message no matter how long I wait :/

Occasionally this seems to happen. Best solution I've found is to simply wait and try again later.

 

Works just fine today, thank you Kaphias

[Maxingmck 139]

soo whats the code for clean ranarr?

 

i was using =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",C6), "table", 2),2,3)