EVE Technology Lab

Tommy Fresh

Sebiestor Tribe

Minmatar Republic

Likes received: 1

#1 - 2016-10-16 17:42:14 UTC

Hey I've just started playing eve and been playing around with the API to pull data.

I've managed to get a basic trade sheet with buy/sell prices and margins etc

I am trying to add 2 more columns which will contain the buy orders and sell orders. It doesn't pull any data in to my sheet though. Here is how I got it set up.

=ImportXML(CONCATENATE(JBO,TypeID&JOIN(TypeID,$B5:$B19)),"//volume/buy")

http://api.eve-central.com/api/quicklook?typeid=

Then I have all the systems listed as....
http://api.eve-central.com/api/quicklook?usesystem=30000142

Here is a link to the sheet to make it easier.

https://docs.google.com/spreadsheets/d/1D7VIufnU1kbDzYWCMWbRWIdiXFeqr0fmIEGFbCl-8DQ/edit?usp=sharing

(Sell orders have been left blank due to hitting this brick wall)

Any help would be appreciated o7

Imperial Academy 72
Blacksmoke16 Imperial Academy Likes received: 72	#2 - 2016-10-16 20:45:42 UTC 1 Just use this: https://github.com/nuadi/googlecrestscript Will be easier, more features and more accurate.


Tommy Fresh Sebiestor Tribe Minmatar Republic Likes received: 1	#3 - 2016-10-18 13:30:08 UTC Blacksmoke16 wrote: Just use this: https://github.com/nuadi/googlecrestscript Will be easier, more features and more accurate. Thanks! Works much better :)