These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

A few questions concerning my first trade excel spreadsheet.
Author
Previous Topic Next Topic
Caelis Magistran
University of Caille
Gallente Federation
#1 - 2016-10-28 14:24:43 UTC
Hi there,

Just made an excel spreadsheet that pulls data from the eve-central api.
I collect the buy/max and sell/min data.

Is there other data that is usefull in determining if an item is tradable?
I read that that the volume data isn't correct?

How big can I make the excel spreadsheet? Is there a limit at how many lines I can use? Can I pull all items (30K +) if I wanted?

How accurate is the sell and buy data, are they live data or do they have a delay?


Tx in advance
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2016-10-30 10:35:01 UTC  |  Edited by: Zad Murrard
Caelis Magistran wrote:
Hi there,
Is there other data that is usefull in determining if an item is tradable?


Yes.

Caelis Magistran wrote:

I read that that the volume data isn't correct?


Depends on the items, on the api(eve central has a lot of apis giving different results) and what you consider correct. Without knowing details cannot say.

Caelis Magistran wrote:

How big can I make the excel spreadsheet? Is there a limit at how many lines I can use? Can I pull all items (30K +) if I wanted?


Things are limited by network speed and your computer as well as excel. You need the source code of excel to see what kind of internal limits it has. Also eve central apis can be used in many ways. This has an effect on the performance.

Caelis Magistran wrote:

How accurate is the sell and buy data, are they live data or do they have a delay?


There is no live data. Everything you process is always a representation of the past.
Without knowing how you are pulling the data we cannot say how much delay it has.
As said eve-central has different apis.
If you are using some website you should try to find the delay information from that website.

To summarize:
- Don't be lazy. A lot of your questions have answers already elsewhere.
- If you want specific answers ask specific questions with all the details
- Don't be lazy. Try to look from the documentation / website for the technical details