| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sophia Jackson
Ladies Auxiliary Tuba Orchestra
Eve Engineering
6
   |
Posted - 2013.01.29 17:48:00 -
[1] - Quote
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®ionlimit=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!
|
Emma Royd
Maddled Gommerils
196
|
Posted - 2013.01.29 17:52:00 -
[2] - Quote
I've never relied on market data for reliable information, I've always used it as a guide and then manually checked, things can go very wrong if the wrong prices are used.
Treat it like a guide, if something still looks profitable then double check by manually checking the market.
|
Stigman Zuwadza
Repercussus
RAZOR Alliance
91
|
Posted - 2013.01.29 18:01:00 -
[3] - Quote
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®ionlimit=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
Its broken and its been broken for a long time and it'll be broken for some time to come. |
Sophia Jackson
Ladies Auxiliary Tuba Orchestra
Eve Engineering
6
|
Posted - 2013.01.29 18:08:00 -
[4] - Quote
Stigman Zuwadza wrote: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®ionlimit=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
Thanks so much! I'll tinker around with it and see!
|
Sugar Bunny InSpace
Toward the Terra
0
|
Posted - 2013.01.29 18:18:00 -
[5] - Quote
I use this for basic usage: Link |
Hilts Rads
V.E.I.
-Entropy-
0
|
Posted - 2013.01.31 05:00:00 -
[6] - Quote
Sugar Bunny InSpace wrote:I use this for basic usage: Link
This is a very helpful link. Thanks. |
Steve Ronuken
Fuzzwork Enterprises
1110
|
Posted - 2013.01.31 05:24:00 -
[7] - Quote
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.
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |