Saturday, August 14, 2010

Playing with the Grand Exchange database

From time to time I play a little "understand the Runescape market/mechanics" game with the Grand Exchange database. It's very simple, yet, I find it rather interesting and challenging.

Here is what I do:

  • Open the list of Top 100 most traded items for 7, 30 or 90 days
  • Start from the top and try to explain to why each item is there in the first place (whether it is due to some popular training method and, if yes, in which skill)
  • Try to figure out why some items are higher than the others in the list.
  • Try to find and explain patterns.
For instance, take Yew and Magic longbows. Those are the only non-stackable weapons in the list. Why are they in there? Of course, not because of a huge number of rangers, but because these bows are being high-alched for Magic training. So, those are in fact "commodity" items.
Or how would you explain huge gaps between raw and cooked lobsters (sharks, tuna) comparing to side by side positions of raw and cooked monkfish and swordfish? In my opinion it is a clear indication of lobsters, sharks and tuna being most common food items used in combat.

But there are a few items in there that puzzle me:
  • Astral runes being on top of Law runes. Why? The only explanation I have is that Astral runes are used in Magic training (making planks) and Law runes are not (at least not anymore). Is that it?
  • Presence of stripy feathers in the list. Who and why would buy them? How come they are on the market in such huge quantities?
  • Most recently (in 7 days only) a presence of unfinished Spirit Weed potion. What is up with it? Why is it there out of a sudden?
Any ideas?


Rafftank said...

Reckon you got it with astrals, they are used in large amounts for those whow ant to get 99 mage the fastest ways (as you said).

I have no hunch for the spirit weed pots, but I think the reason for the stripy feathers is because they can be used to make bolts, and making bolts can yield alot of exp per hour, even while training other skills such as woodcutting. (pro skillers would do it, getting as much as 1m exp in fletching per hour)

Vaskor said...

Rafftank, I think you are right about the feathers. I just checked, stripy feathers costs 1 gp LESS than normal feathers! Who would guess...

Trainguyrom said...

Stripy feathers are used for fishing Rainbow Fish.

Vaskor said...

Trainguyrom, yes, but very few people do that. It must be bolts and the fact that stripy feathers are cheaper than normal ones.

2006-2009 RuneWise, all rights reserved.
Reproducing or copying any material found on this page is not allowed.
Runescape is a trademark of Jagex 2000-2009 Andrew Gower