Eve Excel Addin Formulas: Buy and Sell Prices in various Regions

A very useful formula is to look at what the maximum priced Buy Order and Minimum priced Sell Order is in a Regional Market, typically Jita.

In all cases, the Cell B5 is the item name we are looking up.  I.e obelisk.

The Minimum Jita Sell Price

=EVEONLINE.MARKET_ORDERS_STATS(10000002,EVEONLINE.INVENTORYSEARCH(B5,1).id).sell.min

Lets break this down.

EVEONLINE.INVENTORYSEARCH(B5,1) will show the name of the item you are looking up.

The Cell B5 has the name we are searching for.

The ",1" in the formula means that the the name and only the name is searched for.  If i had ",0" i would get all items that included the word "obelisk" in it - in this case some 33 items, hence we need to nail it down with the ",1"

using the .id method then brings up the id which is generally what we need to go further.

EVEONLINE.INVENTORYSEARCH(B5,1).id

we can then put that id in the formula to look up market orders:

EVEONLINE.MARKET_ORDERS_STATS(10000002,EVEONLINE.INVENTORYSEARCH(B5,1).id)

10000002 is the Regional Code for Jita.

and we add the .sell method to show the Sell Orders only.

and finally the .min method to show the minimum Sell Order.

The Regional Codes for other Regions:

Dodixie 10000032

Amarr 10000043

Rens 10000030

Hek 10000042

The Maximum Jita Buy Price

=EVEONLINE.MARKET_ORDERS_STATS(10000002,EVEONLINE.INVENTORYSEARCH(B5,1).id).buy.max

Which is a very similar explanation to the Sell Order except using the method .buy to bring up Buy Orders and we are looking for the maximum value,