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.
 

What will CREST do

First post
Author
Previous Topic Next Topic
Rumbaldi
Tannhauser C-Beam
Lux Collective
#1 - 2014-12-22 22:35:13 UTC
As a person that has not the first clue about coding, but as a person who uses spreadsheets in game for trade and manufacturing coul dsomeone please explain to me an laymens terms how will crest help me (assuming my spreadsheets are updated using it (if that is a thing).

I know the above is a little vague, apologies, but I am not sure what specifics to ask.

Thanks
Pete Butcher
The Scope
Gallente Federation
#2 - 2014-12-23 06:26:20 UTC
Rumbaldi wrote:
As a person that has not the first clue about coding, but as a person who uses spreadsheets in game for trade and manufacturing coul dsomeone please explain to me an laymens terms how will crest help me (assuming my spreadsheets are updated using it (if that is a thing).

I know the above is a little vague, apologies, but I am not sure what specifics to ask.

Thanks



Crest will pretty much give you real time market data for any item in any region. There is at most 5min delay between the actual orders and the ones you import.

http://evernus.com - the ultimate multiplatform EVE trade tool + nullsec Alliance Market tool
Grauth Thorner
Vicious Trading Company
#3 - 2014-12-23 11:23:34 UTC  |  Edited by: Grauth Thorner
Rumbaldi wrote:
As a person that has not the first clue about coding, but as a person who uses spreadsheets in game for trade and manufacturing coul dsomeone please explain to me an laymens terms how will crest help me (assuming my spreadsheets are updated using it (if that is a thing).

I know the above is a little vague, apologies, but I am not sure what specifics to ask.

Thanks


For me it's pretty much the other way around... I know about coding but I rarely use spreadsheets. With CREST you will be able to pull data from the server, by sending certain headers to a certain URL. This will return an XML-file including the information. Will it be possible to use this XML-file directly through the spreadsheet? I don't know, but I have my doubts. On the other hand, quite some third-party devs will be using CREST to create a great variance of tools/(web)apps so whatever you want to do with it might be possible with one of those third-party apps.

Depending on the data you want, your data will have a delay which will probably be smaller than the delay you have now. http://wiki.eve-id.net/APIv2_Char_Notifications_XML states that this data can only be requested once per 30 minutes (it can be requested more often, but cached data will be returned or in other words data you already should have meaning that requesting it more often is rather useless), but this might be different for, for instance, market data (assuming Pete Butcher is right, this is only 5 minutes).

View real-time damage statistics in-game

>EVE Live DPS Graph application forum thread

>iciclesoft.com
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-12-23 12:14:50 UTC
CREST isn't particularly suitable for use with spreadsheets, due to the required authentication steps, and walking of the nodes. It's possible, but far from simple.

Ideally, you'll use an aggregation service which takes care of all of that for you.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Ortho Loess
Escalated.
OnlyFleets.
#5 - 2014-12-23 12:28:32 UTC
Grauth Thorner wrote:

Depending on the data you want, your data will have a delay which will probably be smaller than the delay you have now. http://wiki.eve-id.net/APIv2_Char_Notifications_XML states that this data can only be requested once per 30 minutes (it can be requested more often, but cached data will be returned or in other words data you already should have meaning that requesting it more often is rather useless), but this might be different for, for instance, market data (assuming Pete Butcher is right, this is only 5 minutes).


You're mixing up CREST and the old XML API (still very much in use)

XML API query the backend database directly (which is not guaranteed to be in sync with the game, for *reasons*) and returns XML. It can be used directly in spreadsheets, but it's a bit dodgy doing so usually. It has rather long came timers, mostly 1 hour, assets is 6 hours, I think something is 24 hours. Some things you can keep requesting and get cached data, others you'll get an error if you do a second request inside the cache timer.

CREST is the new kid on the block. It queries the actual game server itself, so you get exactly the same info that you would in game, subject to server-side caching, hence the 5 minutes. CREST returns JSON, which is more modern and generally easier to work with than XML.

CREST isn't finished yet, and the data you can get from it is still very limited, but it does have the live market data, which is very sexy.

As Steve said, using it directly in a spreadsheet would be a PITA. Mostly because of authentication.
Rumbaldi
Tannhauser C-Beam
Lux Collective
#6 - 2014-12-23 15:42:43 UTC
Thanks for the replies all, I have a better, if rudimentary, understanding of how it works now.

Although perhaps the spreadsheets still will not be useful once it is all done and dusted. I know the spreadsheets use pricing from eve-central so my thoughts were that ive eve-central updated using this crest malarky, and my spreadsheets get the prices from eve-central then my spreadsheets will show up to date pricing.

Either that or I need to find someone to develop and application for me, and well... I would certainly be treading deep water there.

Thanks again

R
Pete Butcher
The Scope
Gallente Federation
#7 - 2014-12-23 16:13:43 UTC
Rumbaldi wrote:
Thanks for the replies all, I have a better, if rudimentary, understanding of how it works now.

Although perhaps the spreadsheets still will not be useful once it is all done and dusted. I know the spreadsheets use pricing from eve-central so my thoughts were that ive eve-central updated using this crest malarky, and my spreadsheets get the prices from eve-central then my spreadsheets will show up to date pricing.

Either that or I need to find someone to develop and application for me, and well... I would certainly be treading deep water there.

Thanks again

R


Or you can use this.Blink

http://evernus.com - the ultimate multiplatform EVE trade tool + nullsec Alliance Market tool
Rumbaldi
Tannhauser C-Beam
Lux Collective
#8 - 2014-12-23 17:32:25 UTC
Pete Butcher wrote:
Rumbaldi wrote:
Thanks for the replies all, I have a better, if rudimentary, understanding of how it works now.

Although perhaps the spreadsheets still will not be useful once it is all done and dusted. I know the spreadsheets use pricing from eve-central so my thoughts were that ive eve-central updated using this crest malarky, and my spreadsheets get the prices from eve-central then my spreadsheets will show up to date pricing.

Either that or I need to find someone to develop and application for me, and well... I would certainly be treading deep water there.

Thanks again

R


Or you can use this.Blink


That looks pretty good, is it free? I cannot see a price so I assume so
Pete Butcher
The Scope
Gallente Federation
#9 - 2014-12-23 18:36:31 UTC
Rumbaldi wrote:
Pete Butcher wrote:
Rumbaldi wrote:
Thanks for the replies all, I have a better, if rudimentary, understanding of how it works now.

Although perhaps the spreadsheets still will not be useful once it is all done and dusted. I know the spreadsheets use pricing from eve-central so my thoughts were that ive eve-central updated using this crest malarky, and my spreadsheets get the prices from eve-central then my spreadsheets will show up to date pricing.

Either that or I need to find someone to develop and application for me, and well... I would certainly be treading deep water there.

Thanks again

R


Or you can use this.Blink


That looks pretty good, is it free? I cannot see a price so I assume so


Both free and open source.

http://evernus.com - the ultimate multiplatform EVE trade tool + nullsec Alliance Market tool
Rumbaldi
Tannhauser C-Beam
Lux Collective
#10 - 2014-12-23 19:35:54 UTC
Result... cheers Pete I will be downloading that shortly.
Grauth Thorner
Vicious Trading Company
#11 - 2014-12-23 21:05:01 UTC
Ortho Loess wrote:
Grauth Thorner wrote:

Depending on the data you want, your data will have a delay which will probably be smaller than the delay you have now. http://wiki.eve-id.net/APIv2_Char_Notifications_XML states that this data can only be requested once per 30 minutes (it can be requested more often, but cached data will be returned or in other words data you already should have meaning that requesting it more often is rather useless), but this might be different for, for instance, market data (assuming Pete Butcher is right, this is only 5 minutes).


You're mixing up CREST and the old XML API (still very much in use)

XML API query the backend database directly (which is not guaranteed to be in sync with the game, for *reasons*) and returns XML. It can be used directly in spreadsheets, but it's a bit dodgy doing so usually. It has rather long came timers, mostly 1 hour, assets is 6 hours, I think something is 24 hours. Some things you can keep requesting and get cached data, others you'll get an error if you do a second request inside the cache timer.

CREST is the new kid on the block. It queries the actual game server itself, so you get exactly the same info that you would in game, subject to server-side caching, hence the 5 minutes. CREST returns JSON, which is more modern and generally easier to work with than XML.

CREST isn't finished yet, and the data you can get from it is still very limited, but it does have the live market data, which is very sexy.

As Steve said, using it directly in a spreadsheet would be a PITA. Mostly because of authentication.

I already had my doubts, I should've noticed it when posting the URL. Thanks for clearing it up, changed my post.

View real-time damage statistics in-game

>EVE Live DPS Graph application forum thread

>iciclesoft.com
Bob Maths
Federal Navy Academy
Gallente Federation
#12 - 2014-12-23 21:07:38 UTC
You could always use CREST for your own local SQL database and tools.
Rumbaldi
Tannhauser C-Beam
Lux Collective
#13 - 2014-12-25 23:08:00 UTC
Steve Ronuken wrote:
CREST isn't particularly suitable for use with spreadsheets, due to the required authentication steps, and walking of the nodes. It's possible, but far from simple.

Ideally, you'll use an aggregation service which takes care of all of that for you.


Steve, Does your website, for the blueprints use Crest for the pricing?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#14 - 2014-12-26 15:35:33 UTC
Rumbaldi wrote:
Steve Ronuken wrote:
CREST isn't particularly suitable for use with spreadsheets, due to the required authentication steps, and walking of the nodes. It's possible, but far from simple.

Ideally, you'll use an aggregation service which takes care of all of that for you.


Steve, Does your website, for the blueprints use Crest for the pricing?



Not yet.

I've been working up a backend for it. but haven't made it live yet.

It is getting a feed from EMDR atm, which is being ported over to use CREST as its source, instead of people.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter