Difference between revisions of "Importing market data into Excel"

From EVE University Wiki
Jump to: navigation, search
(Created page with "<big>'''Work in progress''' -- ~~~~</big> == Introduction == In EVE Online we have lot of third part software that helps players to plan their activities ('''always reseach ...")
 
(Replaced with guide to using the Eve Marketer API using Google Sheets)
Tag: New redirect
 
(15 intermediate revisions by 5 users not shown)
Line 1: Line 1:
<big>'''Work in progress''' -- [[User:Victor corlleone|Victor corlleone]] ([[User talk:Victor corlleone|talk]]) 21:26, 25 September 2016 (CDT)</big>
+
#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]
 

Latest revision as of 23:23, 7 March 2020