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.
Previous page123
 

Citadel Market Data

First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#41 - 2017-02-17 12:50:00 UTC
As I said, I'm rolling citadel prices into the regional averages.

(in an attempt to keep the data down to a minimum)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Somi Zulfi
Federal Navy Academy
Gallente Federation
#42 - 2017-02-17 13:06:56 UTC
Steve Ronuken wrote:
As I said, I'm rolling citadel prices into the regional averages.

(in an attempt to keep the data down to a minimum)


is there any other way to get market data from a particular citadel?

As you may have gathered im a noob :)
Haile Korhal
Professional Amateurs
#43 - 2017-02-17 20:52:10 UTC
I haven't looked into this much in a while, I am glad the data is out there. I assume that means there is a way to extract the information out of a particular Citadel now? My original use case was, I had a list of 20 Citadels spread across New Eden and I needed to extract the market data from them, so that the owning alliance knows the "stocks" some markets had, and could restock the markets as sales happened.

I will be looking into these things again in a couple of weeks, what a time to be alive! Thanks Steve for making these confusing things understandable to the likes of us normal folk.

Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
Amodos Oblivion
Science and Trade Institute
Caldari State
#44 - 2017-03-09 21:45:15 UTC
Hello,

i'm trying to use API too, but i fail when i search for citadel market data, and i didn't find it on your website.
Is it still possible to get it ?

Thx !
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#45 - 2017-03-09 22:26:58 UTC
Right now, I'm not providing an API which gives order data down to that level.

If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Professor JinMine
Project Fruit House
#46 - 2017-03-10 17:25:57 UTC
Haile Korhal wrote:
My original use case was, I had a list of 20 Citadels spread across New Eden and I needed to extract the market data from them, so that the owning alliance knows the "stocks" some markets had, and could restock the markets as sales happened.


Our corp uses a Google Spreadsheet that does exactly what you say.
Here are some screenshots

It's backed by a modified version of Google Script posted here some weeks ago (here's the forum link).

Unfortunately I don't have the permission to share the sheet...just wanted to let you now it can be done and how we do it.
Amodos Oblivion
Science and Trade Institute
Caldari State
#47 - 2017-03-12 18:49:41 UTC
Steve Ronuken wrote:
Right now, I'm not providing an API which gives order data down to that level.

If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that.



Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this.

Maybe i did wrong or corp can hide it ?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#48 - 2017-03-12 19:29:46 UTC
Amodos Oblivion wrote:
Steve Ronuken wrote:
Right now, I'm not providing an API which gives order data down to that level.

If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that.



Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this.

Maybe i did wrong or corp can hide it ?



The easiest way to get a structure ID is by bookmark, by job, by market order or by asset.
(there is a list of public structures. but you need to look at each one to find out where it is)

You also have to authenticate with SSO to be able to retrieve market orders from structures, with ESI. (this is so it can handle private markets)

That auth requirement makes it somewhat harder to manage in powerquery (I've yet to get that working. but I've only put in a few hours). Doing it with googledocs shouldn't be too hard. doing it in excel with xlwings should be dead easy.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Amodos Oblivion
Science and Trade Institute
Caldari State
#49 - 2017-03-12 21:29:44 UTC
Steve Ronuken wrote:
Amodos Oblivion wrote:
Steve Ronuken wrote:
Right now, I'm not providing an API which gives order data down to that level.

If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that.



Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this.

Maybe i did wrong or corp can hide it ?



The easiest way to get a structure ID is by bookmark, by job, by market order or by asset.
(there is a list of public structures. but you need to look at each one to find out where it is)

You also have to authenticate with SSO to be able to retrieve market orders from structures, with ESI. (this is so it can handle private markets)

That auth requirement makes it somewhat harder to manage in powerquery (I've yet to get that working. but I've only put in a few hours). Doing it with googledocs shouldn't be too hard. doing it in excel with xlwings should be dead easy.


Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#50 - 2017-03-12 21:36:05 UTC
Amodos Oblivion wrote:

Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D



No tutorial at the moment.

It's entirely possible to do though.

First you set up a new application on developers.eveonline.com, with the appropriate scopes.

Then you use something like postman ( https://www.getpostman.com/ ) to do the initial authentication, to get the refresh token.

Then, finally, in google sheets, you write a custom function which uses that refresh token to authenticate, then retrieve the data.

I'll try and get something written up.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Amodos Oblivion
Science and Trade Institute
Caldari State
#51 - 2017-03-12 21:43:00 UTC
Steve Ronuken wrote:
Amodos Oblivion wrote:

Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D



No tutorial at the moment.

It's entirely possible to do though.

First you set up a new application on developers.eveonline.com, with the appropriate scopes.

Then you use something like postman ( https://www.getpostman.com/ ) to do the initial authentication, to get the refresh token.

Then, finally, in google sheets, you write a custom function which uses that refresh token to authenticate, then retrieve the data.

I'll try and get something written up.



xD
I'll watch it, looks like pretty cool but hard to make :D
Btw, thx for reactivity, you're insane bro !
Haile Korhal
Professional Amateurs
#52 - 2017-03-13 21:10:30 UTC
Steve is a monster at this stuff, it breaks my brain. Pretty much all of this is well over my head, which is unfortunate, because I want to be able to understand these things. I just have so much trouble teaching myself how these things should work. Sigh. I'll happily wait for tutorials though and maybe I can reverse engineer the method behind the madness.

Professor JinMine wrote:
Haile Korhal wrote:
My original use case was, I had a list of 20 Citadels spread across New Eden and I needed to extract the market data from them, so that the owning alliance knows the "stocks" some markets had, and could restock the markets as sales happened.


Our corp uses a Google Spreadsheet that does exactly what you say.
Here are some screenshots

It's backed by a modified version of Google Script posted here some weeks ago (here's the forum link).

Unfortunately I don't have the permission to share the sheet...just wanted to let you now it can be done and how we do it.


So... Your script pulls the "current sell orders" for items from all of your citadels and compares it to a list of pre-determined quantity thresholds so that you can know when a particular citadel's "stock of X" gets low, so someone can take more of x to it and list it for sale? That's amazing if so, I would love to have a point of contact to email questions to. I've been beating my head against this thing for going on 6 months now and I've all but given up. Knowing it's possible just blows my mind, why cant I figure it out? :(

Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
Amodos Oblivion
Science and Trade Institute
Caldari State
#53 - 2017-03-14 19:43:55 UTC
Hello again,

i did what you said, use postman to get token. Btw, postman is really cool.

Then, i still use it to get the json market data.

I wanted to use a a script to extract data from this json (https://gist.github.com/paulgambill/cacd19da95a1421d3164)
I saved the json on my computer, but can't access it from googlesheet without if it's not on web, so i tried to use a site to store it (http://myjson.com/) but the file is too big.

i'm actully blocked, what can i do ?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#54 - 2017-03-14 20:08:56 UTC
https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/

Finally got round to writing it :D

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Amodos Oblivion
Science and Trade Institute
Caldari State
#55 - 2017-03-14 20:50:02 UTC  |  Edited by: Amodos Oblivion
Steve Ronuken wrote:
https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/

Finally got round to writing it :D


<3 Thx

Btw, just an mistake at 

var price=[json[i].duration,
                 json[i].is_buy_order,
                 json[i].issued,
                 json[i].location_id,
                 json[i].min_volume,
                 json[i].order_id,
                 json[i].price,
                 json[i].range,
                 json[i].typeid,
                 json[i].volume_remain,
                 json[i].volume_total
                ];


It's type_id and not typeid.
Previous page123