API access to market data

From EVE University Wiki
Revision as of 15:08, 29 March 2021 by Eonay (talk | contribs) (→‎Google Sheets Method: - corrected TypeID for "Iron Charge S" in example URLs from 216 to 215 (see https://www.fuzzwork.co.uk/api/typeid.php?typename=Iron%20Charge%20S))
Jump to: navigation, search

Out-of-game Eve data access is provided by CCP through the EVE_Swagger_Interface. However, this access method is not convenient for casual use. Fortunately, third-party services have arisen to provide better access for the casual player. Eve Market data can be accessed through an API provided by EVEMarketer. This service replaces a previous service provided by the defunct Eve Central. EVEMarketer API access methods are very similar to those used by Eve Central, but different enough that previous calls will not work. These API calls can be used in a spreadsheet (e.g., Google Sheets, Excel) to provide programmatic access to Market Data even for casual users.

API Call construction

EVEMarketer provides an endpoint accepting POST or GET methods and returns data in either XML (/marketstat) or JSON (/marketstat/json) formats. The call requires a item identifier (typeID) and has optional parameters to limit data to either a system (usesystem) or a region (regionlimit). A single call can contain up to 200 different items. By default the data returned is XML and for all of Singularity. The following method describes how to use the GET access method. The GET call method produces a URL that can be directly entered into a web browser to provide data without any additional tools or knowledge. Users interested in the POST method, should be able to construct the request given the GET method construction.

GET Examples


Obtaining the typeID

TypeIDs are unique identifiers specifying an item. There are several ways to get access to this information. Here are a few:

Obtaining the system and region IDs

The other two parameters, systemID and regionID are also unique identifiers specifying a singular region or solar system in Eve. There are several ways to access this information. Here are a few:

Constructing the GET API Call

Once you have a typeid and have chosen your area of interest (all of Eve, system, or region), you can place them into a call:

The complete url can then be entered into a standard web browser, see above for further examples.

XML Market Data Structure

The returned data object contains Market Order information for both Buy and Sell orders. The relevant fields available are:

  • volume: Volume of buy or sell orders
  • avg: Average buy or sell price
  • max: Maximum buy or sell price
  • min: Minimum buy or sell price
  • stddev: Standard deviation of buy or sell prices
  • median: Median buy or sell price
  • percentile: 95th percentile buy or sell price


Importing API Call into Spreadsheet

The following instructions are for API calls in Google Sheets, but should be readily transferable to other spreadsheet programs (e.g., Excel).

Google Sheets Method

Google Sheets uses the IMPORTXML function to make API calls and process XML. This function requires two parameters, the API URL and the XML field to retrieve. The API URL was constructed above (e.g., https://api.evemarketer.com/ec/marketstat?typeid=215). The XML fields available are described by the Data structure above and are specified by the form //<sell|buy>/<field>. The IMPORTXML function can be used in conjunction with cell functions (e.g., CONCATENATE, INDEX, LOOKUP, etc) to automate the market data retrieval based on cell references.

Examples

  • =importxml("https://api.evemarketer.com/ec/marketstat?typeid=215", "//buy/median") Median buy price for Iron Charge S
  • =importxml("https://api.evemarketer.com/ec/marketstat?typeid=215&usesystem=30000142", "//sell/min") Minimum sell price for Iron Charge S in Jita
  • =importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?typeid=", A1)), "//sell/volume") Volume of sell orders for the typeid in cell A1
  • =importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?",typeid&JOIN(typeid,$B2:B201)), "//sell/median") Median sell price for each typeid provided in cells B2 through B201. Remember that the API limits you to 200 items per call.
  • =importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?usesystem=30000142","&typeid="&JOIN("&typeid=",$B2:B201)), "//sell/median") Same as above except looking at Jita specifically and if you aren't using the named variables referenced in the Market Data Spreadsheet linked below.

Functional Google Sheets Market Data Spreadsheet