Jump to content
brainymidget

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

Recommended Posts

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))


d9f84e76d7.png

Share this post


Link to post
Share on other sites

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?


Billionaire status as of 7/19/2009

Share this post


Link to post
Share on other sites
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)) 


d9f84e76d7.png

Share this post


Link to post
Share on other sites

Pwnzorg guide 10/10!

 

 

 

Check out my puny :? enchanted bolt guide

 

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


Opeious.pngopei.png

 

Barrows Drops:....................................................Dragon Drops:...............Other Drops:

Dharok: 2 Helms, 1 Top, 2 Legs, 4 Axes.......................2 Claws Split..................1 Bandos Tassets

Karil: 1 Coif, 1 Top, 2 Skirt, 2 Crossbows......................3 Plate legs...................4 Berserker Rings

Ahrim: 3 Hood, 2 Top, 3 Skirt, 1 Staff..........................2 Plate Skirts.................2 Warrior Rings

Verac: 1 Helm, 3 Tops, 2 Skirts, 1 Flail..........................1 Med........................1 Archer Ring

Guthan: 2 Helm, 5 Tops, 1 Skirt, 0 Spear.....................1 Shield Half.................1 Seers Ring

Torag: 2 Helms, 2 Tops, 5 Legs, 1 Hammer....................4 Hatchets..................1 Missed Divine Sigil (was at bank -,- fml)

Share this post


Link to post
Share on other sites

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


Brainymidget.png

multimultiza9.gif

Share this post


Link to post
Share on other sites

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


Proud Ubuntu User!

There are no stupid questions, just stupid people. -Scott Adams

A computer once beat me at chess, but it was no match for me at kick boxing.-Emo Phillips

My Blog!

TyrantElf.png

TyrantElf.png

Share this post


Link to post
Share on other sites

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


mck.pngMck.png

Noobs: We pay we say

JaGeX: How much will you pay?

 

Share this post


Link to post
Share on other sites

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?


d9f84e76d7.png

Share this post


Link to post
Share on other sites

i didnt understand it lol


mck.pngMck.png

Noobs: We pay we say

JaGeX: How much will you pay?

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

=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.


d9f84e76d7.png

Share this post


Link to post
Share on other sites

=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.


d9f84e76d7.png

Share this post


Link to post
Share on other sites

o


mck.pngMck.png

Noobs: We pay we say

JaGeX: How much will you pay?

 

Share this post


Link to post
Share on other sites

clean ranarr IS an item, check ge database, genious

 

 

EDIT: still says error


mck.pngMck.png

Noobs: We pay we say

JaGeX: How much will you pay?

 

Share this post


Link to post
Share on other sites

Clean_ranarr

 

And you replace the # sign with a number.


Myweponsgood.gif

Need assistance in any of these skills? PM me in game, my private chat is always ON

Share this post


Link to post
Share on other sites

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.


Salamoniesunsetsig5.png

8,325th to 99 Firemaking 3/9/08 | 44,811th to 99 Cooking 7/16/08

4,968th to 99 Farming 10/9/09 | Runescaper August 2005-March 2010

Tip.it Mod Feb. 2008-Sep. 2008 | Tip.it Crew Sep. 2008-Nov. 2009

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.