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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Issues with my Google drive trading sheets
Author
Previous Topic Next Topic
Tecliso Avelon
Emperor Industries
#1 - 2015-05-07 20:56:53 UTC
Dear master traders,

I am wondering if any of you can aid me with my google drive sheets.
The issue i am having is that I pull up market data from eve-central, but the prices do not match up with what i see in game.
What I suspect is a time lag between the servers of eve-central and what is happening in my game client

Can anyone confirm this, or please enlighten me why my sheets are not showing the real current prices?

This is the code i am using for example is the following:
=importXML("http://eve-central.com/api/marketstat?usesystem=30000142&typeid=642&typeid=643&typeid=24692","//type/sell/min")

Thanks for the aid!
Jonah Gravenstein
Machiavellian Space Bastards
#2 - 2015-05-07 21:14:32 UTC  |  Edited by: Jonah Gravenstein
Eve Central prices aren't real time, they can be anything up to 24 hours old due to the way in which the data is collected.

In the beginning there was nothing, which exploded.

New Player FAQ

Feyd's Survival Pack
Tecliso Avelon
Emperor Industries
#3 - 2015-05-08 07:31:44 UTC
Thanks Jonah!
Dextrome Thorphan
#4 - 2015-05-08 09:08:07 UTC
You might want to look into using CREST for up-to-date prices, though I don't think you'll be able to implement that in a google spreadsheet.
Soldarius
Dreddit
Test Alliance Please Ignore
#5 - 2015-05-08 14:44:15 UTC
I read somewhere that eve-central was now using CREST to pull data. But what eve-central shows does not match CREST. Furthermore, what eve central shows on its website does not match what is available in its api feed, nor do they agree with the orders that they are showing right on their front page. I ran some calculations and found that they are doing some fuzzy math with their feed numbers, especially the high/low values.

I'm a little concerned with the way eve-central is massaging its numbers.

http://youtu.be/YVkUvmDQ3HY