Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Durin Sarga
|
Posted - 2010.07.21 23:02:00 -
[1]
So I've been thinking.
I have a (outdated) spreadsheet which automatically downloaded and ran the EVE-Central data for the market equilibrium price of every mineral in the mineral basket. This was a fair indicator of the current price value you could find in most markets in-game.
The problem is that I was using a HUGE spreadsheet to capture all the data off eve-central, and the macro took about 1hr to refresh the spreasheet every day. It also only calculated the mineral basket. I didn't spend the time and know how to program the spreadsheet to allow variable product type.
Which leads to the question. Why doesn't eve-central do this themselves? I would imagine it could be fairly easy to program having the database already on their servers. On top of that, the market equilibrium point is much more valuable than the 'average' price.
If we use the 'average' price then it includes the ding-dong who place 100M trit on market for 100 ISK/unit, which skews the average. Or it includes the 100M trit on buy orders for 0.01 ISK/unit, which skews the average.
If we use the market equilibrium then it takes the shape of the supply and demand curve into account when determining the equilibrium price. Oddly enough, the supply curve in EVE tends to look S-shaped (don't know if you've looked at that before)
Thoughts? Anyone have a more efficient spreadsheet which calculates this? My programming Kung Fu is not strong enough.
|
Mithril Ryder
Genstar Inc
|
Posted - 2010.07.21 23:17:00 -
[2]
Do you have this somewhere you could share it? I'm no excel master, but I'd like to take a look at the work that you did, and try running it for S&G on a quad core with 8 gigs of ram and an SSD :D
|
Durin Sarga
|
Posted - 2010.07.21 23:26:00 -
[3]
hmmm.... I r have no online server to post it at. Guess I could sign up to eve-files and post there.
I'll 'jury-rig' something together later tonight and post here. But I don't know... I haven't trained that skill to Lvl 5 yet. lol.
|
ChrisIsherwood
|
Posted - 2010.07.21 23:57:00 -
[4]
(After I think a suggestion from the forums) EveMetrics has a "simulated" price so one trit at 2 and 100m @ 2.5 is handled. Nor will 250m at 5 or .1 change the simulated price the way average/medians do.
simulated - estimated price paid per unit for buying 5% of the volume on the market or fulfilling 5% of sell orders on the market, after order filtering, weighted by available volume. Note that if there are insufficient numbers of orders to calculate a simulated result with any degree of accuracy, the API will provide the average price as a simulated result.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |