| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Pretty Obvious
Perkone
Caldari State
0
   |
Posted - 2015.05.31 18:02:36 -
[1] - Quote
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
9
|
Posted - 2015.05.31 21:09:00 -
[2] - Quote
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
Perkone
Caldari State
0
|
Posted - 2015.05.31 23:34:22 -
[3] - Quote
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
5311
|
Posted - 2015.06.01 11:52:49 -
[4] - Quote
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 X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |