Importing market data into Excel: Difference between revisions

Line 1:

{{~~cleanup|Grammar and sentence structure needs some revision, and altering from first person~~}}

~~== 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.

There is various third party software which can be used to assist players to plan their activities in EVE Online. In particular, traders may find it useful to import market data from [https://eve-central.com/ EVE-Central] to Excel, to transfer the information to a spreadsheet format and allow them to process the data. This guide assumes the use of Excel 2007.

== ~~What you will need?~~ ==

== Getting started ==

To ~~start you~~ will need to ~~have some data~~. ~~These data~~ and ~~how~~ to ~~get them are listed below~~:

To get started a player will need the typeID, and either the stationID or systemID or regionID (depending on what data they want to show).

=== Obtaining the typeID ===

One way to get the typeID is to use [https://www.fuzzwork.co.uk/tools/api-typename-to-typeid/ Fuzzwork's API search]. To use this, direct your browser to {{co|#7acdef|<nowiki>https://www.fuzzwork.co.uk/api/typeid.php?typename=</nowiki>}} and add the name of the item. Note that any spaces in the item name should be replaced with {{co|#7acdef|%20}}.

{{example|'''For example'''<br />

To obtain the typeID for {{co|wheat|Iron Charge S}} you would go to {{co|#7acdef|<nowiki>https://www.fuzzwork.co.uk/api/typeid.php?typename=Iron%20Charge%20S</nowiki>}} which gives the result: {{co|lightgreen|<nowiki>{"typeID": 215,"typeName": "Iron Charge S"}</nowiki>}}, meaning the typeID is {{co|wheat|215}} }}

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

@@ Line 1: / Line 1: @@
-{{cleanup|Grammar and sentence structure needs some revision, and altering from first person}}
+{{Work in progress}}
-== 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.
+There is various third party software which can be used to assist players to plan their activities in EVE Online. In particular, traders may find it useful to import market data from [https://eve-central.com/ EVE-Central] to Excel, to transfer the information to a spreadsheet format and allow them to process the data. This guide assumes the use of Excel 2007.
-== What you will need? ==
+== Getting started ==
-To start you will need to have some data. These data and how to get them are listed below:
+To get started a player will need the typeID, and either the stationID or systemID or regionID (depending on what data they want to show).
+=== Obtaining the typeID ===
+One way to get the typeID is to use [https://www.fuzzwork.co.uk/tools/api-typename-to-typeid/ Fuzzwork's API search]. To use this, direct your browser to {{co|#7acdef|<nowiki>https://www.fuzzwork.co.uk/api/typeid.php?typename=</nowiki>}} and add the name of the item. Note that any spaces in the item name should be replaced with {{co|#7acdef|%20}}.
+{{example|'''For example'''<br />
+ To obtain the typeID for {{co|wheat|Iron Charge S}} you would go to {{co|#7acdef|<nowiki>https://www.fuzzwork.co.uk/api/typeid.php?typename=Iron%20Charge%20S</nowiki>}} which gives the result: {{co|lightgreen|<nowiki>{"typeID": 215,"typeName": "Iron Charge S"}</nowiki>}}, meaning the typeID is {{co|wheat|215}} }}
-# 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]