|
|
| (14 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]
| |
| − | | |
| − | [[Category:Trading]]
| |
