Science & Industry

Looks interesting... No legend; what are the blue vs red horizontal bars in the bar graph indicate?

And maybe a *separate* set of fields for people to put in their own ore/mineral prices in the event they're outside the trade hubs so they can do their own analysis of local trade vs. trade with transport costs?

What you'll find by using EC/EMD/EMK data is that:

- The Forge (or any of the market hub regions) often has people who muck with the values. Either by putting up fake buy orders (margin trading scams) or by putting up very high sell orders in order to break the average sell price. In my calculations, I generally take an average of the (4) market hub regions rather then rely on any single market hub price.

- I also prefer to use a "5% buy sim" price (buying the 5% of the market volume, then calculating the price) over just taking a "highest/lowest" value. While the 5% buy/sell sim prices can be gamed, it's a bit harder to do so when it comes to items that trade in very large volumes (like minerals).

- Other then the (4) main market hub regions (Forge, Domain, Heimatar, Sinq Laison), the sites like EC/EMK/EMD tend to have very spotty data. There's not enough people out there who run the market scanner and upload results nightly (or even a few times per week). So trying to let people pick any of the 67 regions probably won't work, while letting them pick the top 4 market regions would be better.

http://www.evemarketeer.com/statistics/regions
http://eve-marketdata.com/reports.php?step=UploadStats&type=market

Those (2) links should give you a feel for how spotty the data is across various regions. It's improving, and the new upload client at the EVEMarketeer site feeds all (3) of the major price sites now (EC/EMK/EMD), so there's potential there that all of the sites should get better data on average.

Wow, this tool is brilliant...
I was thinking about to trying to make a spreadsheet like this myself but was struggling getting going, this is just amazing.

Im assuming that if I download an excel version Ill be able to amend any mineral values to match wherever I am in game...

Thanks a lot for this...

It's not the highest 5 buy orders, it's the top 5% of all buy order volume. If there are buy orders for a total of 1 million units of Tritanium, then it calculates a price based on a simulated sell of 50,000 units of Tritanium to the buy orders.

buy_highest5 : the average price of the top 5% of the buy market

For very high volume items, with narrow margins, buy_highest5 is not a bad thing to use. But for any product where the buy orders are significantly below sell price, the sell_lowest5 is a better price to use. Products sold to end-users usually have very large gaps between buy/sell unless someone is competing in the market. Raw materials tend to have narrower margins as manufacturers compete over obtaining their supply of inputs.

Thanks for the info! With this in mind, I am definitely going to end up splitting the sheets into one per major hub. I should be able to squeeze in 3 tabs to cover buy_highest5, avg, and sell_lowest5.
After I get the tabs pulled together in a manner I'll see if there are any chart templates that can compare that many variables without looking like complete crap. If so I'll place it full page in tab 1 as the default view and leave the option to check through the numbers in the back three sheets for anyone that wants to verify/copy the coding or double check my math.