EVE Technology Lab

Ive done a search of this forum and google and haven't found an answer yet, not saying there isn't one but for what its worth I did try to find it on my own first.... my disclaimer is I have been told that my google search skills can be lacking at times.

Anyway I was writing some stuff in excel to make my life easier... I know how to pull Crest market data in it, I know how to use some of the eve API but is it possible to use the eve SSO in excel?

I know its mainly used for ppl making their own apps and programs or websites... but I have no clue how to go about it in excel.

I dont need a complete step by step, unless you have one handy... but if nothing else can you guys say if its possible or not and maybe point me in the right direction as to my figuring out the steps?

Thanks.

Thanks!

So followup question about crest..

Ive been looking at the public crest options now that I know I can use it in excel...

http://eveonline-third-party-documentation.readthedocs.io/en/latest/crest/eve/eve_market.html


On that site I see I can either download a full regions market data which I can see a lot of possibilities with or I can focus the results down to say 1 regions sell orders of a specific item.

So My question is this... which is easier on both excel and on the crest server... getting the entire market once then refreshing it say every half hour or hour and using vlookup and index and such to index the bulk market orders

or would it be better to lookup multiple items with a very specific item query? So I would run multiple queries, again every half hour or so.

I'd suggest getting the SDE to prevent a requirement to do lookups against the api, for static data :)

Either load it, or just import the sheet.


(tbh, I'd suggest using something other than excel to get the market data in the first place, and dump it in a database)