EVE Technology Lab

For some reason I am failing at google atm since I cant find this information..

a year or so back I remember seeing a way to instead of importing the min or max price in jita or even the average, a way to import the mean price

basically it would allow you to ignore the crazy high prices or crazy low depending if its a sell or buy order and yet still get a good idea at the average price

I'll be doing very large mineral buy or sell orders and want to have a spreadsheet to forcast potential cost of purchase or profit of a sale so just the min/max is not a good way to forcast this but I need to look at the say the min 10-15 prices or so since it will take that many to get the numbers I needed

So I figured the average price would be idea, but then you need to ignore the ppl who are willing to say .01 isk for a 10billion item and such.



Does anyone know the best way to achieve this? if I recall correctly there is a way, I just dont remember how and cant find it.

Thanks