Jump to content

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


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

  • Replies 116
  • Created
  • Last Reply

Top Posters In This Topic

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

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

  • 1 month later...

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)

Link to comment
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

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

  • 2 weeks later...

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
Link to comment
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

Link to comment
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
Link to comment
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

Link to comment
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.