|
|
| (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]
| |
