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.
Find something in Eve Online that you want to price check like a contract, cargo scan result, etc. Press CTRL + A, CTRL + C, then click on the lovely box to the left or above this and press CTRL + V. Submit and you should see a price breakdown of all the items. What all can I paste in there? 0G-A25 VI - Moon 20 - True Power Mining Outpost 0IRK-R IX - Jove Navy Testing Facilities 0IRK-R VIII - Moon 3 - Jovian Directorate Academy 0LTQ-C V - Moon 18 - Intaki Space Police Assembly Plant 0M-M64 VI - Prosper Depository 0M-M64 VII - Moon 5 - Jovian Directorate Bureau 0N-3RO VII - Moon 14 - Blood Raiders Testing Facilities 0T-AMZ IX - Moon 6 - Aliastra Retail Center 0T-AMZ VII - Moon 10.
- 1API Call construction
- 3Importing API Call into Spreadsheet
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.
- https://api.evemarketer.com/ec/marketstat?typeid=215 returns the market data for Iron Charge S (typeid 215).
- https://api.evemarketer.com/ec/marketstat?typeid=215,216 returns the market data for Iron Charge S (typeid 215) and Tungsten Charge S (typeid 216).
- https://api.evemarketer.com/ec/marketstat?typeid=215&typeid=216 is an alternative form that also returns the market data for Iron Charge S (typeid 215) and Tungsten Charge S (typeid 216).
- https://api.evemarketer.com/ec/marketstat?typeid=215&usesystem=30000142 returns the market data for Iron Charge S (typeid 215) for Jita (usesystem 30000142)
- https://api.evemarketer.com/ec/marketstat?typeid=215®ionlimit=10000068 returns the market data for Iron Charge S (typeid 215) for Verge Vendor (regionlimit 10000068)
- https://api.evemarketer.com/ec/marketstat/json?typeid=215 returns the market data for Iron Charge S (typeid 215) in JSON format.
Obtaining the typeID
TypeIDs are unique identifiers specifying an item. There are several ways to get access to this information. Here are a few:
- Most websites providing Eve Market data use typeid to reference the specific examples (Eve Marketer for Iron Charge S)
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:
- Eve Marketer can specify specific regions or systems. The identifier is available in the url.(Example: Iron Charge S in Domain)
- main trade hubs: Jita usesystem=30000142, Amarr usesystem=30002187, Rens usesystem=30002510, Dodixie usesystem=30002659
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:
- Basic call form: https://api.evemarketer.com/ec/marketstat?typeid=<typeid><®ionlimit=<regionid> &usesystem=<systemid>>
- Example call for Iron Charge S for all Eve data: https://api.evemarketer.com/ec/marketstat?typeid=215
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.
- =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
Did you miss GamesBeat Summit 2021? Watch on-demand here!
All the excitement around GameStop’s stock has bled into GamesBeat’s discussions around the metaverse. And it turns out that stock market manipulation isn’t exclusive to the physical world.
“We had forms of short squeezes happening in the economy of Eve Online,” said CCP CEO Hilmar Petursson of the MMO’s in-game economy. “It was kind of a form of what’s happening to GameStop right now.”
Petursson joined moderator Mike Vorhaus of Vorhaus Partners to discuss Eve Online’s role as one of the earliest metaverses during GamesBeat’s Into The Metaverse event. Petursson and Vorhaus also discussed what it means to be a metaverse and the growth of Eve Online during the panel.
Petursson didn’t go into specifics about the in-game short squeezes, but added that gamers have manipulated their market in the same ways the real stock market is being manipulated right now.
“Reality is giving us a run for our money right now,” Petursson said. Eve Online did have a player-made stock market for a short time, but it isn’t currently in the game and hasn’t been available for the majority of its 17-year lifespan.
GameStop is currently going through a bit of a crowdsourced phenomenon. A large group of loosely organized retail traders have snatched up GameStop stocks in order to increase their value. Hedge funds that have shorted those stocks have had to pay up after losing their bet. The situation is ongoing.
Eve Online’s in-game systems are vast and complicated, so it’s not difficult to imagine how players could use the in-game economy in similar ways. The MMO’s capability to replicate real-world constructs, like religion and the stock market, have been key in making it a metaverse, according to Petursson.
“Eve Online is somewhere between a virtual world and game,” he said, talking about the word metaverse actually means. He combined the literal meaning of each word, “meta” and “verse,” to create a makeshift definition. “Verse meaning a world,” he added. “If you think of a world — a planet is a world. So if you’re building a virtual world, you’re building a habitat.”
Petursson then summarized the “meta” aspect of metaverses as something that exists in multiple worlds. He talked about the friendships, love stories, and rivalries that have come to fruition in the game. They exist both in and outside Eve Online.
“For the first 10 years we didn’t think of it as a metaverse,” he said, adding that their view changed as they witnessed more interactions as the game grew.
Eve Online added 1.3 million new players in 2020, continuing it’s 17-year streak of success. It, alongside games like Ultima Online, is one of the earliest examples of studios developing online metaverses for players to live in.
And as we’ve seen, even a metaverse can be subject to outside manipulation.
Eve Online Live Market TodayGamesBeat's creed when covering the game industry is 'where passion meets business.' What does this mean? We want to tell you how the news matters to you -- not just as a decision-maker at a game studio, but also as a fan of games. Whether you read our articles, listen to our podcasts, or watch our videos, GamesBeat will help you learn about the industry and enjoy engaging with it.
Eve Online Live Market StreamHow will you do that? Membership includes access to:
- Newsletters, such as DeanBeat
- The wonderful, educational, and fun speakers at our events
- Networking opportunities
- Special members-only interviews, chats, and 'open office' events with GamesBeat staff
- Chatting with community members, GamesBeat staff, and other guests in our Discord
- And maybe even a fun prize or two
- Introductions to like-minded parties