=EVEONLINE.UNIVERSE_MARKET_PRICES([@[Item ID]]).adjusted_price

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

I am trying to pull the EIV and Copilot is telling me that is how you do it rather that using Market Average price then multipling total mineral amounts on top of it.

I dont use ESI which I suspect is how everyone else does it (poor brain cannot cope) so should this work in Excel addon?

2

To calculate EIV you need to do a SUMPRODUCT of the Adjusted Prices for all the materials used. The formula for the Adjusted Price is not as you put in your title, instead it’s:

=EVEONLINE.TYPE().[Adjusted Price]

You will need to put the item id inside the rounded brackets (). For example:

=EVEONLINE.TYPE(645).[Adjusted Price]

Or, if you are using referencing another column or using a table, either of which i recommend:

=EVEONLINE.TYPE(A2).[Adjusted Price]

=EVEONLINE.TYPE([@ID]).[Adjusted Price]

[@ID] is the name of an example column, it can be whatever you want.

Note, that if you are making an item which is made of items which themselves are made of items such as T2 ships, you only use the adjusted price of the items immediately going into your item. For example, if you are making a T2 ship, you don’t need to calculate the EIV for the T1 ship, you just use it’s adjusted price.