open All Channels
seplocked Science and Industry
blankseplocked Making spreadsheets: importing market data into Google Docs.
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Gribzor
Advanced Engineering and Research
Posted - 2011.02.19 19:03:00 - [1]
 

Hey guys,

I'm making a bunch of spreadsheet for myself to use with EVE manufacturing, but I'm having a hard time importing data from EVE Market CSV files.

Even though I can of course enter the prices myself in one worksheet and link all the other worksheets to that data, it would be one hell of a lot easier to automatically do it with a macro.

Unfortunatly, it looks to be not as easy as I hoped to import data into Google Docs. Seems to be possible with Google Scripting (or what it is called), but I haven't figured out how to do it.

Any of you guys importing data into Google Docs, and if so, how do you do it?

Tnx!

Lutz Major
Posted - 2011.02.20 21:09:00 - [2]
 

I don't think that it is possible to automatically (scripting) upload local files to google docs.

You must upload them manually or store them on the internet always under the same name, then you can simply hit reload and google docs will fetch the new content.

Sigras
Gallente
Conglomo
Posted - 2011.02.21 06:07:00 - [3]
 

Edited by: Sigras on 21/02/2011 06:08:14
there used to be a good tutorial on eve metrics about how to use the importXML feature to import the XML files from eve metrics/eve central

Anyway type into the cell

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=34®ionlimit=10000002", "/EveCentral/type/Jita/sell/minimum")

I think that's what it is

Anyway, eve central seems to be down ATM so more on this when they come back up, but the long and short of it is that eve-central.com provides an updating XML of current market prices, "typeid=34" means thats the type ID we're going to be looking at (I think its trit) and "regionlimit=10000002" is the region we're using to look up the prices (I think its jita)

if you type that first part into a web browser it will show you an XML file with all of the data in it, the second part just tells google docs where to point to in the XML to pull the data because that XML has a TON of data in it.

In this case, we're looking into the jita region at the minimum sell orders.

Edit
Grrrr . . . then I re-read the OP and figured out that wasnt what you were talking about . . . ugh

Cerrydwin
Posted - 2011.02.25 02:23:00 - [4]
 

Edited by: Cerrydwin on 25/02/2011 02:31:24
Interesting... I briefly had that running for the last month or two that eve metrics was up, but I'm having trouble with eve central. I can get to the xml response directly, but using an ImportXML query never seems to load in google spreadsheets.

for reference:
=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634®ionlimit=10000002", "/evec_api/marketstat/type/sell/avg")
which should input the average Jita sell order price for atmospheric gases.

I also tried "type/sell/avg" and "/marketstat/type/sell/avg"as my xpath query, with no luck. Is anyone using this successfully?


update: the following query will produce the Jita average sell prices for all raw moon materials in alphabetical order, in one column and 20 rows.

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634&typeid=16643&typeid=16647&typeid=16641&typeid=16640&typeid=16650&typeid=16635&typeid=16648&typeid=16633&typeid=16646&typeid=16651&typeid=16644&typeid=16652&typeid=16639&typeid=16636&typeid=16649&typeid=16653&typeid=16638&typeid=16637&typeid=16642®ionlimit=10000002", "/evec_api/marketstat/type/sell/avg")

UfoTRADER
Relentless Technologies
Quod Erat Demonstrandum
Posted - 2011.03.16 21:01:00 - [5]
 

Edited by: UfoTRADER on 16/03/2011 21:29:43


Originally by: Cerrydwin
Edited by: Cerrydwin on 25/02/2011 02:31:24
Interesting... I briefly had that running for the last month or two that eve metrics was up, but I'm having trouble with eve central. I can get to the xml response directly, but using an ImportXML query never seems to load in google spreadsheets.

for reference:
=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634®ionlimit=10000002", "/evec_api/marketstat/type/sell/avg")
which should input the average Jita sell order price for atmospheric gases.

I also tried "type/sell/avg" and "/marketstat/type/sell/avg"as my xpath query, with no luck. Is anyone using this successfully?


update: the following query will produce the Jita average sell prices for all raw moon materials in alphabetical order, in one column and 20 rows.

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634&typeid=16643&typeid=16647&typeid=16641&typeid=16640&typeid=16650&typeid=16635&typeid=16648&typeid=16633&typeid=16646&typeid=16651&typeid=16644&typeid=16652&typeid=16639&typeid=16636&typeid=16649&typeid=16653&typeid=16638&typeid=16637&typeid=16642®ionlimit=10000002", "/evec_api/marketstat/type/sell/avg")



Instead of ®ionlimit=10000002, it has a registered icon.

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=16634&typeid=16643&typeid=16647&typeid=16641&typeid=16640&typeid=16650&typeid=16635&typeid=16648&typeid=16633&typeid=16646&typeid=16651&typeid=16644&typeid=16652&typeid=16639&typeid=16636&typeid=16649&typeid=16653&typeid=16638&typeid=16637&typeid=16642&R E G I O N limit=10000002", "/evec_api/marketstat/type/sell/avg")

This one is wrong, which I also ran into on multiple browsers and multiple operating systems

&typeid=16642®ionlimit=10000002",


hours Statistics from the last X specified hours.
typeid Can be specified more than once
minQ minimum quantity in an order to consider it for the statistics
regionlimit Restrict statistics to a region.
usesystem Restrict statistics to a system.


Example, =importXml("http://api.eve-central.com/api/marketstat?&hours=6&typeid=11549&usesystem=30000142&minQ=5000","//buy/max")

hours=6 (Last six hours)
typeid=11549 (antimatter reactor)
usesystem=30000142 (Jita)
minQ=5000 (Min quantity 5k)

buy/max (Max buy order)

This will drop in the pricing for the buy order greater than 5k in Jita, within the last six hours.

I add all of the items I watch as off the wall buy orders, then use libevecache to update eve central before shopping. . :)

Cheers


Jin Kass
Posted - 2011.03.16 22:05:00 - [6]
 

Edited by: Jin Kass on 16/03/2011 22:08:21
This evening i tried to import eve central datas by the 'importxml' function of google doc.

It worked but the only values i get back were all "0.00" i don't know why.

So i used the "importdata" to import the whole .xml sheet in the spreadsheet and all fields were 0.00.

Some would say that eve central was down but typing the xml adress in a new browser window opened it with the right values.

Someone could tell me why?

UfoTRADER
Relentless Technologies
Quod Erat Demonstrandum
Posted - 2011.03.16 22:20:00 - [7]
 

Originally by: Jin Kass
Edited by: Jin Kass on 16/03/2011 22:08:21
This evening i tried to import eve central datas by the 'importxml' function of google doc.

It worked but the only values i get back were all "0.00" i don't know why.

So i used the "importdata" to import the whole .xml sheet in the spreadsheet and all fields were 0.00.

Some would say that eve central was down but typing the xml adress in a new browser window opened it with the right values.

Someone could tell me why?


Paste your =importxml value and I will look at it, but I have ran into a multitude of weirdness at times. I can't for certain determine if it's EC or Google, but in more cases than not I suspect it's Google not liking the =importxml.



Jin Kass
Posted - 2011.03.16 22:48:00 - [8]
 

It work now, but didn't change anything since the last time...

Jin Kass
Posted - 2011.03.17 07:54:00 - [9]
 

Edited by: Jin Kass on 17/03/2011 15:16:13
New issue:

Google doc only support 50 xml import per spreadsheet.

Anyone find a way to pass through this limit?

Edit: found how to solve the problem just reading post above :D

Ramakilla
Posted - 2011.04.14 21:00:00 - [10]
 

Found out how to work around the limit without using multiple spreadsheets.
I'm pretty stoked right now.

Mordiss Nex
Posted - 2011.05.12 21:46:00 - [11]
 

Originally by: Ramakilla
Found out how to work around the limit without using multiple spreadsheets.
I'm pretty stoked right now.


Would you be so kind as to share please?

Gelvina
Posted - 2011.06.29 11:46:00 - [12]
 

You can import multiple items with one XML command..

=importXML("http://api.eve-central.com/api/marketstat?typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&typeid=11399&minQ=5000®ionlimit=10000002","//all/median")

that imports all the mineral prices in jita for example..
it fills up the cells below the one you put this in.


Joe SMASH
You Got A Purty Mouth
Posted - 2011.06.29 14:00:00 - [13]
 



 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only