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.
 

EVE Central Live Google Docs Spreadsheet

First post
Author
Andy Khentar
Hedion University
Amarr Empire
#1 - 2015-10-21 22:12:33 UTC
I need help making a spread sheet which will pull data from EVE Central directly into the spreadsheet, I need to be able to search an item such as Afterburner, and get the Highest Buy price, lowest sell price and profit margin. Thanks in advance
GonZoPT
JointMasters Corp
#2 - 2015-10-25 00:11:52 UTC
Hi ,

Have a look here https://github.com/nuadi/googlecrestscript


GonZoPT
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2015-10-25 02:33:12 UTC
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs if you want to deal with eve central, rather than crest (better for larger numbers)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Mr Twinkie
Republic Military School
Minmatar Republic
#4 - 2015-10-25 07:31:46 UTC
We seriously need a Google docs how too sticky. This question is super common
Hel O'Ween
Men On A Mission
#5 - 2015-10-25 09:17:30 UTC
Perhaps CCP could also implement a "Search" function for the forum ... oh, wait ... Roll

EVEWalletAware - an offline wallet manager.

Andy Khentar
Hedion University
Amarr Empire
#6 - 2015-11-01 15:28:59 UTC
How do I use that second link though? I see what it is and what not but how do I implement it?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2015-11-01 18:47:03 UTC
Andy Khentar wrote:
How do I use that second link though? I see what it is and what not but how do I implement it?


If you're talking about my link:

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

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Andy Khentar
Hedion University
Amarr Empire
#8 - 2015-11-03 19:40:17 UTC
Steve Ronuken wrote:
Andy Khentar wrote:
How do I use that second link though? I see what it is and what not but how do I implement it?


If you're talking about my link:

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


That doesnt seem to work, it gives me an error saying ' need typeids (line 71, file "") '
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#9 - 2015-11-03 19:53:09 UTC
Andy Khentar wrote:
Steve Ronuken wrote:
Andy Khentar wrote:
How do I use that second link though? I see what it is and what not but how do I implement it?


If you're talking about my link:

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


That doesnt seem to work, it gives me an error saying ' need typeids (line 71, file "") '



hmm. Are you handing it a single cell, or a list of them? (it needs multiple)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Andy Khentar
Hedion University
Amarr Empire
#10 - 2015-11-03 19:59:52 UTC  |  Edited by: Andy Khentar
Yeah, still not working though

http://imgur.com/CrASNSF