These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Getting Market data out of game?

First post
Author
Previous Topic Next Topic
Caluran
Dark Ghost Industries
#1 - 2015-07-07 16:27:26 UTC
Been out of the game for a while and came back to find that the googledocs spreadsheet I used to use to work out profit per item no longer pulls from the API anymore.

Is there any way to get access to that data using the new API system or is it back to manually updating books in excel?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-07-07 17:14:26 UTC
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs


It never used the Eve api.

(if it's to do with the order api for your own orders, google finally stopped their dumb 'we'll lowercase everything for xpath' policy, which confused the hell out of people. So you'll need to properly capitalize things)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Caluran
Dark Ghost Industries
#3 - 2015-07-07 17:27:51 UTC
Ahh thank you that's just what I was looking for.
Enison
Moira.
#4 - 2015-07-14 16:58:43 UTC
dumb question and sorry to hijack, but how do you use those functions with excel?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-07-14 17:18:14 UTC
Enison wrote:
dumb question and sorry to hijack, but how do you use those functions with excel?



You can't, unfortunately.

You'd have to rewrite them in VBA, which is a pain to do, and then save it as a macro enabled sheet.

It's not impossible, but it's a pain in the neck.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Enison
Moira.
#6 - 2015-07-15 00:57:41 UTC
oh, sorry i should rephrase. How do i get them into a spreadsheet application? i dont see how you integrated it into yours
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2015-07-15 11:48:04 UTC
Enison wrote:
oh, sorry i should rephrase. How do i get them into a spreadsheet application? i dont see how you integrated it into yours



https://youtu.be/wNIfpPOOo0M?t=10m28s

Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kennedy Lincoln
Federal Defense Union
Gallente Federation
#8 - 2015-07-15 12:41:26 UTC
Holy crap you guys are smart. I cannot wait to try and tackle this. Old programmer here and I am ready to learn! Anyone remember assembler? Fortran?
Bad Bobby
Bring Me Sunshine
In Tea We Trust
#9 - 2015-07-15 13:22:05 UTC
Kennedy Lincoln wrote:
Anyone remember assembler?
I'm actually debugging an assembler I/O routine for a Sega Megadrive multi-tap atm.
Enison
Moira.
#10 - 2015-07-16 00:03:52 UTC
cool so i got it to work, but I guess i cant use the function to call a large amount of data. i have a list of all the type_ids in the game and im trying to get them all, but it looks like you cant get more then 2000 things at a time. doing =loadSystemPrices(Sheet1!A2:A23700) results in an error. I had to make like 11 different calls to get everything
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2015-07-16 00:35:05 UTC
Not entirely sure why it doesn't work with more than 2k things, as it splits it into batches of 150 and does them separately.

may be a memory issue, with the larger result set. If so, nothing I can do about it, it's just google saying 'nah'

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter