Difference between revisions of "Importing market data into Excel"

From EVE University Wiki
Jump to: navigation, search
(Replaced with guide to using the Eve Marketer API using Google Sheets)
Tag: New redirect
 
(12 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{WIP}}
+
#REDIRECT [[API access to market data]]
== Introduction ==
 
 
 
In EVE Online we have lot of third part software that helps players to plan their activities ('''always reseach a lot before installing third part software'''), but what to do if you can't find information you want? Here I will teach unistas how to import market data from [https://eve-central.com/ eve-central] to Excel 2007, in this way you can use creativity to process data and create the information you want in a spreadsheet.
 
 
 
== What you will need? ==
 
 
 
To start you will need to have some data. These data and how to get them are listed below:
 
 
 
# You will need to know the typeid of the item you are looking for. To get the typeid you can use [https://www.fuzzwork.co.uk/tools/api-typename-to-typeid/ FuzzworkAPI]. In this example we will import data from "Iron Charge S" (to use space in this method type "%20", so Iron Charge S = Iron%20Charge%20S), so type the following URL at your browser: https://www.fuzzwork.co.uk/api/typeid.php?typename=Iron%20Charge%20S . We will get the following answer {"typeID": 215,"typeName": "Iron Charge S"}, so Iron Charge S typeid is 215;
 
# You will need to know the folowing data: stationID or systemID or regionID, you can find this alphabetical ordered at this [https://docs.google.com/spreadsheets/d/1HkBZ_KvCYQeFf3awm91fmoPdHTBWugvVKpcwZUv7gXM/edit?usp=sharing Spreadsheet] ;
 
# You will need Excel 2007 [:-P]
 
 
 
== So, let's start work! ==
 
 
 
=== Importing data ===
 
 
 
As said before, we will import the price of "Iron Charge S", this itemID is 215. We will do this to a system (Jita, systemID = 30000142) and to a region (The Forge, regionID = 10000002).
 
 
 
To do this to Jita system we will use the URL http://api.eve-central.com/api/marketstat?typeid=215&usesystem=30000142 , if you want to do this to a diferent item or a diferent system you can change the number at "typeid=215" with a different typeid or change the number at "usesystem=30000142" with a diferent systemid.
 
 
 
We need to open Excel 2007, go to "Data > Get External Data > From Web", see "Image 1" below:
 
 
 
[[File:Import_data_to_excel_1.png|thumb|center|400px|alt=Image 1|Image 1.]]
 
 
 
After that, a browser will pop-up at your spreadsheet, type our URL at the address and click at import. A new window will pop-up asking you where you want to put the data, choose "Existing worksheet" and type "$A$2" and click import again.
 
 
 
To do this to The Forge region we will repeat the process with the link http://api.eve-central.com/api/marketstat?typeid=215&regionlimit=10000002 , so go to "Data > Get External Data > From Web", type the URL, click at import, choose "Existing worksheet" and, now type "$A$3" to import data to cell "A3". The result will be as the image below:
 
 
 
[[File:Import_data_to_excel_2.png|thumb|center|400px|alt=Image 2|Image 2.]]
 
 
 
=== Understanding imported data ===
 
 
 
As soon as possible I will continue this article. If you have any doubt you can send an in game message to '''Victor Corlleone''' ;-]
 
 
 
 
 
 
 
[[Category:Trading]]
 

Latest revision as of 23:23, 7 March 2020