How do I get only the highest price?

[Abbrey_Agittain]

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.

[Aallin_Gicquet]

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

[Geo_Eclipse_Oksaras]

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

[Abbrey_Agittain]

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)

[Hundasuupa]

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

[Abbrey_Agittain]

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

[Bewarriot_Bre_Maricadie]

For Buy order =MAX(EVEONLINE.MARKET_ORDERS(10000002, $A4.id, 1,$D$2.id).price)
For Sell order =MIN(EVEONLINE.MARKET_ORDERS(10000002, $A4.id,0,$D$2.id).price)