Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Importing market data into Excel: Difference between revisions

From EVE University Wiki
No edit summary
Line 42: Line 42:
=== Importing multiple data ===
=== Importing multiple 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''' ;-]
To import multiple data you only need to add "&typeid='number'" to URL, so we will add to our data the typeid number 223, that is the number of Iron Charge M. In this way we will have the following URL http://api.eve-central.com/api/marketstat?typeid=215&typeid=223&usesystem=30000142 . We can see at Image 3 the final result of importing multiple data.
 
[[File:Import_data_to_excel_3.png|thumb|center|400px|alt=Image 3|Image 3.]]
 
== Final considerations ==
 
It is important to say that you can not trust only in imported data, you need to check the in game market to make sure you are doing the right choice. This happens because XML data of EVE Central is updated each hour, so it can be some deprecated data on it.
 
On the other hand, you can import multiple data at your Excel to monitor multiple markets, it can help traders to look for better business opportunities.
 
Another thing that you must know is that after imported, data will not update automatically, so you will need to update imported data everytime you want clicking at button showed at Image 4.
 
[[File:Import_data_to_excel_4.png|thumb|center|100px|alt=Image 4|Image 4.]]
 




[[Category:Trading]]
[[Category:Trading]]