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.
 

excel api market data
Author
Previous Topic Next Topic
Uzhu Yaken
Caldari Provisions
Caldari State
#1 - 2017-02-03 17:35:30 UTC
greetings all

my market spreadsheet still works fine though I noticed that after pulling the data that it does not refresh the next time I pull them , for example a market item is listed at 500 isk , sheet shows 500 isk sweet ok market item now changes to 501 isk , sheet after each refresh for the last 20 min keeps showing the old data 500 isk .

am I missing something ? did something change ? or any idea what I can perhaps look at ?

thanks in advance

o7
Althalus Stenory
Flying Blacksmiths
#2 - 2017-02-03 22:22:45 UTC
Where do you pull you prices from ? Without knowing your sources, it'll be hard to help you :)

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Uzhu Yaken
Caldari Provisions
Caldari State
#3 - 2017-02-04 07:59:16 UTC  |  Edited by: Uzhu Yaken
Althalus Stenory wrote:
Where do you pull you prices from ? Without knowing your sources, it'll be hard to help you :)


oeps my bad pull them via : http://api.eve-central.com/api/marketstat

add region and and type ID followed by Buy and max/min

the way I do it is I export my market orders via ingame wallet that tiny export butten thingy , then I import it into a sheet , from that sheet it then pulls the type ID and my price from it as well as the escrow value into another sheet on that sheet it then pulls the market data for the sysem I am trading in and lists the low for sell and high for buy for the type ID in the region/system , so I just refresh it normally every few min to see who out bids me so I can go change that order , with close to 300 open orders using the ingame click on each to check takes forever
Althalus Stenory
Flying Blacksmiths
#4 - 2017-02-04 13:20:36 UTC
wondering, did you check eve central to see if the price was updated there ? Because it's probably not a problem in your side, but from where you pull the data :)
I don't know where eve-central get their data actually, but depending how / where they get their data, they might not be up to date as quickly as you want them to be.

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Uzhu Yaken
Caldari Provisions
Caldari State
#5 - 2017-02-04 14:10:21 UTC
Althalus Stenory wrote:
wondering, did you check eve central to see if the price was updated there ? Because it's probably not a problem in your side, but from where you pull the data :)
I don't know where eve-central get their data actually, but depending how / where they get their data, they might not be up to date as quickly as you want them to be.



good idea I will poke them a bit as well , if I may ask if you where trying to do what I am doing where would you grab your data from ?
Althalus Stenory
Flying Blacksmiths
#6 - 2017-02-06 12:00:06 UTC
I'm currently getting my price data from the ESI market endpoints (for other uses) but, if I were going to do something like you, i'd use the same.
https://esi.tech.ccp.is/latest/#!/Market/get_markets_region_id_orders

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Uzhu Yaken
Caldari Provisions
Caldari State
#7 - 2017-02-06 12:01:15 UTC
Althalus Stenory wrote:
I'm currently getting my price data from the ESI market endpoints (for other uses) but, if I were going to do something like you, i'd use the same.
https://esi.tech.ccp.is/latest/#!/Market/get_markets_region_id_orders


ty ty will give that one a try :)

thank you for the info mate