Forums › English Language Forums › General › Wiki Editors

Search

A project to record the dynamic of crown/energy exchange rate(and is it possible?)

4 replies [Last post]
Sun, 08/28/2011 - 22:56
Cyril9
Legacy Username

Are all the players located on the same server?
If so there is basically only one stock market. I decided it would be fun to record how energy price changes in order to help people choose at what price to sell/buy. I've already posted a google Form on the wiki energy talk page (http://wiki.spiralknights.com/Talk:Energy) where those willing to participate can enter price data. https://docs.google.com/spreadsheet/viewform?formkey=dDRYZEFUYXpLQ2w4WXc...

Here is a spreadsheet with two graphic representations of energy prices for 4 recent days.
Do you think one of the charts is worth being pit on the energy page? http://wiki.spiralknights.com/Energy

What do you think guys?

Mon, 08/29/2011 - 00:57
#1
Trias's picture
Trias
Having a long term record of

Having a long term record of the price fluctuations on one of the wiki pages might be a good idea. It might help mitigate the flood of "Help the sky is falling" threads every time the price goes up.

Tue, 08/30/2011 - 16:37
#2
Antistone
Legacy Username
Bad Data

Well, you've already got a griefer--there's now a data point in there for 6 billion. Though I doubt anyone's going to be fooled, it makes the graph unusable due to the auto-scaling.

Options I see:
1. Regularly and aggressively go in and prune bad data points by hand
2. Set up some kind of filtering that prevents the input of prices outside a plausible range, or at least prevents the graph from scaling to them
3. Log IP addresses and start banning ones that provide bad data
4. Only collect data from a small number of authenticated players

I don't know how technically difficult any of those are under the service you're using.

A data point at 6 billion is, of course, a very serious blow to usability, but also easily diagnosed. The subtler problem you may run into is if people start poisoning the data with incorrect but plausible prices, so it's hard to figure out which data points are real.

Sat, 09/10/2011 - 11:18
#3
Thetric's picture
Thetric
Pruning

well, when you're taking datapoints, there's always an expected range of increase and decrease. acceleration and deceleration.
using those could very easily help prune data.

another method is to evaluate data in chunks. so when it does update, only "mean values" would be the ones recourded.

I happened to notice that some ce sold for 1cr to 100ce >,< dang I wished I had seen that.

Another possible change is limiting how long offers last.

Tue, 09/13/2011 - 18:27
#4
Antistone
Legacy Username
There's a data point at 5

There's a data point at 5 trillion, which has been there for over 48 hours.

I do like this project, but if vandalism continues to leave the graph unusable a significant portion of the time, I may stop contributing before long.

Powered by Drupal, an open source content management system