These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Retrieve Market Orders
Author
Previous Topic Next Topic
Mortaliton
Industrialist and Manufacturers Directorate
#1 - 2012-01-04 13:33:24 UTC
I'm not quite sure how to do this. but i want to import via xml (eve central) into excel/.

I see in api

Vertification code, = api?
ID = Account id?
Access Mask. = char ID

I found a code

wget -O \Eve_Market_orders\Market_orders_temp.xml http://api.eve-online.com/char/MarketOrders.xml.aspx?apiKey=ABC&characterID=ABCD&userID=ABC

I seems i can get it directly from the eve server?

Kind of confused but at a loss of where to go now? all i find on google is for the old api and i dont want to do alot of work for a api that will be disabled soon.

Mort.
Jognu
French Kiss Singularity
#2 - 2012-01-04 14:00:29 UTC
With the eve server you only get your orders.
With eve-central you can get all orders.
It's not the same thing !

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Mortaliton
Industrialist and Manufacturers Directorate
#3 - 2012-01-04 14:14:36 UTC  |  Edited by: Mortaliton
I just want my orders. How do i go about doing this?

What I want to do is. I have a list of every item in eve and its ID #. I want it to look at all orders i have on the market via the type id. once it finds that it adds how many of that item i have and multiplies it by manufacturing price and selling price. This will show me how much profit is possible from what i have on the market.

EDIT:

Its all working except i cannot figure out to get it working with the new api keys.

&

=IF(Table418[@duration]>0,VLOOKUP(Table418[@typeID],'Tech I'!B20:C1157,2,FALSE),0)

I look up my data on another excell sheet but i need it to check multiple. I get errors for to many arguments.
Mortaliton
Industrialist and Manufacturers Directorate
#4 - 2012-01-04 17:41:26 UTC  |  Edited by: Mortaliton
Sry for double post but i solved it,

Formula

=IF(ISNA(IF(ISNA(IF(ISNA(IF(ISNA(IF(ISNA(IF(Table418[@duration]>0,VLOOKUP(Table418[@typeID],'Tech I'!B20:C1157,2,FALSE),0))=TRUE,VLOOKUP(Table418[@typeID],'Tech II'!B16:C553,2,FALSE),2))=TRUE,VLOOKUP(Table418[@typeID],Invention!B12:C28,2,FALSE),2))=TRUE,VLOOKUP(Table418[@typeID],'Production Materials'!B12:C269,2,FALSE),2))=TRUE,VLOOKUP(Table418[@typeID],Components!C4:D185,2,FALSE),2))=TRUE,VLOOKUP(Table418[@typeID],'Planetary Interaction Items'!B5:C101,2,FALSE),2)

still needs work to hold value once found but it searches all of the sheets now

Mort.

EDIT:

FINAL WORKING FORMULA

=IF(TRUE=(ISNA(VLOOKUP(Table418[@typeID],'Tech I'!B17:C1154,2,FALSE))), IF(TRUE=(ISNA(VLOOKUP(Table418[@typeID],'Tech II'!B13:C550,2,FALSE))), IF(TRUE=(ISNA(VLOOKUP(Table418[@typeID],Invention!B9:C25,2,FALSE))), IF(TRUE=(ISNA(VLOOKUP(Table418[@typeID],'Production Materials'!B9:C266,2,FALSE))), IF(TRUE=(ISNA(VLOOKUP(Table418[@typeID],Components!C1:D182,2,FALSE))), VLOOKUP(Table418[@typeID],'Planetary Interaction Items'!B2:C98,2,FALSE), VLOOKUP(Table418[@typeID],Components!C1:D182,2,FALSE)), VLOOKUP(Table418[@typeID],'Production Materials'!B9:C266,2,FALSE)), VLOOKUP(Table418[@typeID],Invention!B9:C25,2,FALSE)), VLOOKUP(Table418[@typeID],'Tech II'!B13:C550,2,FALSE)), VLOOKUP(Table418[@typeID],'Tech I'!B17:C1154,2,FALSE))