| Pages: 1 :: [one page] |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Jake Rake
The Forgotten Navy
Gentlemen's Agreement
2
   |
Posted - 2013.06.07 06:48:00 -
[1] - Quote
Before the Odyssey patch, I had some Google docs market spread sheets that pulled data so I dint have to have all the :effort: to calculate stuff myself. They are not working anymore tho, so I wonder if any of you can help me out with the debugging. Unfortunately I'm such a n00b in programming, so I can't debug it myself.
This is the a string:
=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&Join("&typeid=",22291)&"&usesystem=30000142&minQ=10000&hours=11","//buy/max")
where typeid is the objects ID and usesystem is which system i pull the price from. In this case its the price for Ballistic Control System II in Jita.
Can anyone help? |
Zappity
Kurved Space
109
|
Posted - 2013.06.07 08:28:00 -
[2] - Quote
You are pulling from eve-central so probably not Odyssey. I just checked my Google docs and they are updating fine from eve-central.
Sorry, not good enough to debug on my phone. Sure your query didn't change? Try another item ID.
Hooray, I'm l33t! -á(Kil2: "The higher their ship losses...the better they're going to be.") |
Jake Rake
The Forgotten Navy
Gentlemen's Agreement
2
|
Posted - 2013.06.07 08:39:00 -
[3] - Quote
Zappity wrote:You are pulling from eve-central so probably not Odyssey. I just checked my Google docs and they are updating fine from eve-central.
Sorry, not good enough to debug on my phone. Sure your query didn't change? Try another item ID.
I've tried with new IDs but those are broken as well.
Any chance I can have a peak at your sheet? 
|
Zappity
Kurved Space
109
|
Posted - 2013.06.07 08:57:00 -
[4] - Quote
=importXml("http://api.eve-central.com/api/marketstat?&hours="& $A$1 &"&typeid="&JOIN("&typeid=",$A3:$A115)&"&usesystem="& D1 &"","/evec_api/marketstat/type/sell/percentile")
Hours is static at A1, system in D1 and I use a join column for multiple itemID lookups.
Hooray, I'm l33t! -á(Kil2: "The higher their ship losses...the better they're going to be.") |
Jake Rake
The Forgotten Navy
Gentlemen's Agreement
2
|
Posted - 2013.06.07 09:50:00 -
[5] - Quote
Thx, I managed to solve it with you help.
I'm most grateful, and  |
Zappity
Kurved Space
109
|
Posted - 2013.06.07 10:03:00 -
[6] - Quote
Hooray, I'm l33t! -á(Kil2: "The higher their ship losses...the better they're going to be.") |
| |
|
| Pages: 1 :: [one page] |