How do I get only the highest price?

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

In cell C2 is my character. Then in cell C2 I pull market orders:
=EVEONLINE.CHARACTER_ORDERS(B2)

Then in D2 I pull all orders of the same type:
=EVEONLINE.MARKET_ORDERS(C2.region_id, C2.type,FALSE)

But I only want to know the highest price, not all the sell orders. How do I get only the highest priced order? Something like:

=EVEONLINE.MARKET_ORDERS(C2.region_id, C2.type,FALSE).highest ??!

I want to simulate EveTycoon market orders where it shows how much your price is undercut.

2

You might want to check out Eve Guru… It is a new program that works quite well.

3

but they want this in the eve excel add-on… telling them another program isn’t helping them.

4

I stumbled on the answer myself thanks to Oz’s video on the Skill Dashboard. Turns out it’s an excel function. In this case INDEX but I wrapped that around SORT because I’m not sure if MARKET_ORDERS always returns highest price first? It seems to but I can’t find any documentation so using SORT to be safe.

=INDEX(SORT(EVEONLINE.MARKET_ORDERS(C2.region_id, C2.type,FALSE).price),1)

5

MARKET_ORDERS is the raw output of the list, so sorting via the .price is solid.

You can minimize the processing time by using the MARKET_ORDER_STATS version that will do the numbers min/max etc. for you.

So for the highest buy order you can do =EVEONLINE.MARKET_ORDERS_STATS(region_id, type_id).buy.max

and .sell.min for the lowest sell price

2 Likes
6

That is an amazing answer Thanks! For some reason I did not look at market_orders_stats.