Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sati Saraki
The Naari Corporation
0
|
Posted - 2015.12.10 03:00:01 -
[1] - Quote
Hello!
I'm mucking about with some spreadsheeting in Google Calc. To make a long story short I'm getting some weird values.
For Isogen I'm getting a value of 133.31.00, while the value of Pyerite was 12.53, so no problem there.
When I try to change the format, the value changes to 5,56.
I use this call
=importXML("http://api.eve-central.com/api/marketstat?typeid=37&usesystem=30000142";"//evec_api/marketstat/type/sell/avg")
And also, how do I get an overview over all the Xpath arguments?
Thank you |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5754
|
Posted - 2015.12.10 13:04:04 -
[2] - Quote
importxml is somewhat flaky
Which is why I wrote the following script. https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs
it takes a list of typeids, and returns all the information for them
Which you can then use vlookup to get the bit you actually want. More efficient, and less prone to issues.
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Sati Saraki
The Naari Corporation
0
|
Posted - 2015.12.10 13:31:01 -
[3] - Quote
Ah yes I actually had a look at that afterwards, and yes it seems to a lot easier to play with. One thing though, if I want to return a single typeid I get an error in line 38 - is it possible to import 1 typeid at a time rather than eg A2:A20?
And how do i get it to grab only the values i need, say, instead of all 15 marketstats maybe just 2 or 3? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5754
|
Posted - 2015.12.10 16:00:57 -
[4] - Quote
It's designed, mostly, for use with the prices going onto a separate sheet, and then being used with vlookup. more efficient. (you have to get all the data anyway. so might as well store it). And there aren't many sheets which require only one price.
If you _really_ want to cut down how much gets pulled, you could just remove them from the array build.
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Sati Saraki
The Naari Corporation
0
|
Posted - 2015.12.10 16:27:25 -
[5] - Quote
Thank you, I will have a play around. Do you have a website with more information?
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5754
|
Posted - 2015.12.10 19:37:17 -
[6] - Quote
Well, there's the site in my bio
Doesn't talk a great deal about the google docs stuff though. Mostly because by the time you understand vaguely what it does, it's close to self explanatory, if that makes sense? The way it loops through is pretty simple.
There's https://www.youtube.com/watch?v=wNIfpPOOo0M too, which I think is kinda flawed, but the best I have yet.
If you ever have any specific questions, feel free to lob them my way, here, or evemail, or in #devfleet on the tweetfleet slack
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Sati Saraki
The Naari Corporation
0
|
Posted - 2015.12.10 19:58:20 -
[7] - Quote
Thank you, very much appreciated. I'm slowly starting to do the ground work, but once I get properly going I will no doubt have questions! |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |