Science & Industry

Dear S&I,
I come assuming you all are far, FAR more knowledgeable about these things than I am, and so I put myself at the mercy of your spreadsheets-fu.

I've recently had some screwy-ness happen with my T2 build sheets where the market-pull on certain component prices is off; not by a lot per say, but enough to throw my profit margins way off on the worksheet. For instance, Fernite Armor Plates are a hair over 8k isk sell order in Jita, but my sheet is pulling data that gives their price at 8.9k isk. I'm using the following data pull on my worksheet:

=importxml("http://api.eve-central.com/api/marketstat?typeid=11542&regionlimit=10000002","//sell/median")

Again, not being the worlds greatest spreadsheets wizard, I copied that from somewhere ("Spreadsheets in Space for Dummies", "Where Did I Come From? - How to Talk to Your Keres About Their Invention"), and it worked just fine until recently when some of the prices went off track.

Is there a better formula out there I should be using? Or is that taking a medium of all the sell prices of that item, which would explain the off numbers? Thanks in advance!

If I'm understanding my XML maps, you could just change the median for min.

=importxml("http://api.eve-central.com/api/marketstat?typeid=11542&regionlimit=10000002","//sell/min")

However, if you're just selling through Jita you might do well to use a System ID instead, something like:

=importxml("http://api.eve-central.com/api/marketstat?typeid=11542&usesystem=30000142","//sell/min")

I'd hazzard a guess and say you could sub your URL with that one.

This would then give you the Jita Minimum Sell Order Value, which may be more accurate for your calculations.

You can find out more info about using the System IDs on Eve-Central.

Fly safe. o7

I use this for basic usage: Link

I would suggest using the 'percentile' value. It's based of a percentage buy or sell of the market.

so the average price per unit you'd pay, if you were to buy 5% of all the trit on the market, in that region.