Question on getting sell orders from private markets

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

So I’m currently trying to setup a spreadsheet for market orders on a Keepstar from my alliance. I want it to return only the sell orders of the items. Yet this does not seem to work somehow and only reutnrs “#NAME”. I set it up like this:

=EVEONLINE.MARKET_STRUCTURE_ORDERS(structure_ID; Item_ID; FALSE)

If I leave out the boolean, it of course shows everything, including buy orders which I don’t want. Also if there are multiple sell orders, is there a way to only show the min price buy order?

2

Found the issue, it seems to return the #NAME error, because I use a localized version of Excel, which is why “FALSE” is not the same boolean for my Excel.

1 Like