Market Discussions

I am sure Evernus can do it, in the scripting section of Statistics->advance->Script processing
However, I am too stupid to figure out how that work, even with the few examples on the Evernus homepage :-)

One way of doing it. is to go to Item History and select the mineral from the drop-down menu (might need to click combine all chars).
This will give you a graph of your buy and sell order balance for the item, assuming you only buy the minerals, you can take the total cost at the bottom and divide by the volume ( it is count, not m3 volume ).

However, this does not allow you to select a time-frame, as you also request.

Another way to do it, and this is a bit more labor intensive, is to go to Character transactions, show only buy orders and search the item in the search field, then select the time-frame you are interested in.
Mark all the rows and right click "Copy Rows" - note: The normal CTRL-C will not work for this, it copies only some.
Next, past it into a spreadsheet, make a calculation for each row being quantity x buy price x -1 ( to get a positive number ).
Then sum up for all the rows and divide by the sum of all quantity.

It is not very automated, you will need to adjust the formulas to span more rows, however you can cut'n'past fewer rows into the "template" and it will still work, so...

Did a quick example with formulas showing, also shows why it is bad idea to just take average of price of each order without taking into account how much you bought at each price :-)

http://imgur.com/a/YQypq

Hope it helps.

And if anyone out there have clue about the scripting, we are all ears :-D

/Ramek