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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

XML data for Google spreadsheet.

First post
Author
Previous Topic Next Topic
Pretty Obvious
Losing All Hope Was Freedom
#1 - 2015-05-31 18:02:36 UTC
Hey all,

So I've been wanting to get into Industry cause it attracts me for some reason, even though i'm reading everywhere that T1 Industry is based on very small margins.

I'm currently in the process of setting up an auto-updating spreadsheet for mineral prices. I've been reading a bunch of topics about it however I cannot seem to get the importXML formula right, everytime I enter one it concludes as an error.

Here is the importXML formula I thought was correct for tritanium sell prices :

=ImportXML("http://api.eve-central.com/api/marketstat?&usesystem=30000142&typeid=34","/evec_api/marketstat/type/sell/min"

It doesn't works. I'm really bad at all this stuff so if anyone could ELI5 this for me it would be nice.

Basically I think I just need a working importXML formula for Sell prices on a settled item, so then I could just adjust itemIDs for ships and other minerals so when I have all the spreadsheet set up I can figure out quickly what is worth producing or not.

Regards
Saeth Thara
Blue Printers Cooperative
#2 - 2015-05-31 21:09:00 UTC  |  Edited by: Saeth Thara
This is what I used to use (still works when i tried it just now)

=IMPORTXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN(",",$J9:$J85), "/evec_api/marketstat/type/sell/min")

With j9:j85 being the list of item Ids.

However i've found google sheets to be quite buggy since they updated it for xml, so i use the script from the Fuzzworks website (the evecentralprices.gs one).
Pretty Obvious
Losing All Hope Was Freedom
#3 - 2015-05-31 23:34:22 UTC
Saeth Thara wrote:
This is what I used to use (still works when i tried it just now)

=IMPORTXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN(",",$J9:$J85), "/evec_api/marketstat/type/sell/min")

With j9:j85 being the list of item Ids.

However i've found google sheets to be quite buggy since they updated it for xml, so i use the script from the Fuzzworks website (the evecentralprices.gs one).


Hi Saeth and thanks for the reply,

I've tried your formula (changed the &JOIN numbers to match the ones in my spreadsheet), and as you can see here , this one doesn't works for me either.

Yet again, this is pretty much the first time I'm using a spreadsheet, so I might have been doing something obviously wrong you can point out ?

As for the scripts, how do I install one onto my spreadsheet ? I've tried to copy paste the first scrip into the script editor in googledocs, but then when I enter the formula =loadSystemPrices(B4:B10) , it says it doesn't recognize the function. Yet again I have pretty much 0 knowledge about how those things works so I must be doing something blatantly wrong.

=loadFunction (Thank you for the help)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-06-01 11:52:49 UTC
for the importxml, replace the , after the join() with & and it should work.

as for the script, did you copy the loadSystemPrices function as well , or just the loadRegionPrices function? because that'd break ;)



Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter