OK guys ive been trying this for years now without any luck at all. Ive done my own research and to be honest I have no effing clue what to actually search for. I have asked a few times here without any pointers.

I really want your help on this.

I want to be able to queue market prices from Jita 4-4. Specifically the moon minerals, simple and complex reactions. YES ALL OF THEM.

I need POS fuel queues as well.

I have built a spreadsheet that you input the fuel block cost per unit, you input your sell and buy orders from the market.
It automatically outputs what reactions either simple or complex are worth doing with percent gains on investment. It also calculates how much it will cost you to buy the materials to run the reaction on a daily, weekly, bi-weekly and monthly basis.
It does all this using fuel calculations to keep the pos up as well.

But it requires a lot of tedious manual input for every item.
What is the code in order to just open the spreadsheet and it runs the market queue?
Is it possible to have it only run once a day or only every time the sheet is opened? I dont want to spam the server either.

I am at a total loss here. Please help.

=importXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=4246","evec_api/marketstat/type/sell/min")

http://eve-marketdata.com/developers/item_prices2.php

specifically:
http://api.eve-marketdata.com/api/item_prices2.xml?char_name=Zathor%20Baal&buysell=s&solarsystem_ids=30000142

load that up as a new sheet (data, from web). It'll give you pretty much all the prices in jita for things.

Does not work google disk only allows you 50 ithems to be pulled by api

if you wanna import prices of things automatically, then you can use the market API to do this..

I use them myself when working out fuel costs, and production costs.



For instance, that in there, is the import for Minmitar fuel blocks, through sell orders

typeid: the id of the product you want to grab

List of Type IDs

sell/min: obviously, this is the type of order, so sell or buy, and the min,max or average i think..

I use Googledocs for mine, but bear in mind, i think there is a limit to the amount of XML imports you can do in a file...

I've been manually entering mineral, moon products, and ice products, into my spreadsheet for years. Takes very little time.

However, I did write a PHP web page for estimating the value of all Sleeper drops based on eve-central prices. It is easier to use, but FAR FAR LESS accurate. I found fetching the prices from eve-central to be quite slow, but not as slow as manually entering them.

Just beware that with automated price retrieval from a place like eve-central, you are not getting current market prices nor volumes.

Does not work google disk only allows you 50 ithems to be pulled by api

Right but even if its off by a few isk here and there, im not going to be pulling my hairs over it. I dont do jita runs everyday, I do them maybe once a week or two, so its not a big deal. Thank you for the heads though.

So this is exactly what you're looking for
https://docs.google.com/spreadsheet/ccc?key=0Av6bUJhtOy5qdHJQSGNtMzk1bmpwOFZZZkdXOU53OGc

Nahla, while trying to use your spread to calc profits, i noticed there is an error with your working for 'PPD Fullerine Fibres'. You have it down as needing 100 of each c50 and c60, where it is actually 300 C50 and 100 C60. Almost had me investing in a potentially loss making reaction there.. hehe.

Im so sorry, the whole hybrid reactions part is new and I havent personally used it yet so there might be more errors in it.
Thanks for letting me know tho, its fixed now!

Right click the Cell -> Conditional Formatting.

Set it so if it is 'Less Than' 0, the text colour is red.. :D

Thank you very much!