Pages: 1 [2] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Mr Tesla
Eagles of Stars
15
|
Posted - 2017.01.20 07:45:39 -
[31] - Quote
Bump! It is very important. |
Somi Zulfi
Pandemic Horde Inc. Pandemic Horde
5
|
Posted - 2017.01.20 13:44:56 -
[32] - Quote
Hoping for a good news soon :) |
Conquerer Taygeta
4S Corporation Goonswarm Federation
5
|
Posted - 2017.01.31 17:41:28 -
[33] - Quote
Bump |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6408
|
Posted - 2017.01.31 19:37:52 -
[34] - Quote
No need to bump.
It's out now. (I've not quite implemented it yet on my market site, but it's out)
Only downside: you request the market per citadel. (but you get everything they have)
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Akhillez
Sons-of-Liberty Manifesto.
3
|
Posted - 2017.02.12 04:01:53 -
[35] - Quote
So has anyone figured out how to get the price data into a google sheet yet? |
Somi Zulfi
Pandemic Horde Inc. Pandemic Horde
9
|
Posted - 2017.02.13 14:50:12 -
[36] - Quote
Steve Ronuken wrote:No need to bump.
It's out now. (I've not quite implemented it yet on my market site, but it's out)
Only downside: you request the market per citadel. (but you get everything they have)
Greetings,
How can I extract that from your website tools?
Is it possible?
Thanks |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6465
|
Posted - 2017.02.13 16:06:19 -
[37] - Quote
Citadels are now implemented on my site :)
However, I'm just rolling them into the region, wrt the prices I'm providing via the api on the site.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Somi Zulfi
Pandemic Horde Inc. Pandemic Horde
9
|
Posted - 2017.02.13 19:35:43 -
[38] - Quote
Steve Ronuken wrote:Citadels are now implemented on my site :)
However, I'm just rolling them into the region, wrt the prices I'm providing via the api on the site.
do you have excel guide to querying through your api? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6465
|
Posted - 2017.02.13 20:56:57 -
[39] - Quote
on the API page :D
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Somi Zulfi
Pandemic Horde Inc. Pandemic Horde
9
|
Posted - 2017.02.17 10:45:28 -
[40] - Quote
Steve Ronuken wrote:on the API page :D
I put the id of the citdel but i got null values in return.... |
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6484
|
Posted - 2017.02.17 12:50:00 -
[41] - Quote
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
Pandemic Horde Inc. Pandemic Horde
9
|
Posted - 2017.02.17 13:06:56 -
[42] - Quote
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
29
|
Posted - 2017.02.17 20:52:10 -
[43] - Quote
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
Pandemic Horde Inc. Pandemic Horde
0
|
Posted - 2017.03.09 21:45:15 -
[44] - Quote
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
6544
|
Posted - 2017.03.09 22:26:58 -
[45] - Quote
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 Solyaris Chtonium
2
|
Posted - 2017.03.10 17:25:57 -
[46] - Quote
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
Pandemic Horde Inc. Pandemic Horde
0
|
Posted - 2017.03.12 18:49:41 -
[47] - Quote
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
6546
|
Posted - 2017.03.12 19:29:46 -
[48] - Quote
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
Pandemic Horde Inc. Pandemic Horde
0
|
Posted - 2017.03.12 21:29:44 -
[49] - Quote
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
6546
|
Posted - 2017.03.12 21:36:05 -
[50] - Quote
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
Pandemic Horde Inc. Pandemic Horde
0
|
Posted - 2017.03.12 21:43:00 -
[51] - Quote
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
29
|
Posted - 2017.03.13 21:10:30 -
[52] - Quote
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 screenshotsIt'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
Pandemic Horde Inc. Pandemic Horde
0
|
Posted - 2017.03.14 19:43:55 -
[53] - Quote
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
6550
|
Posted - 2017.03.14 20:08:56 -
[54] - Quote
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
Pandemic Horde Inc. Pandemic Horde
0
|
Posted - 2017.03.14 20:50:02 -
[55] - Quote
Steve Ronuken wrote:https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/
Finally got round to writing it :D
<3 Thx |
|
|
|
Pages: 1 [2] :: one page |
First page | Previous page | Next page | Last page |