Hey guys, I'm having the same difficulties as you guys so i tried Steve's script (thank you!) I modified the script just a bit to get the system info instead of the region; I also got rid of rows I didn't want and kept only Buy Volume, Sell Volume, And min Sell. I just changed these parts :
function loadPrices(priceIDs,systemID,cachebuster){
if (typeof systemID == 'undefined'){
systemID=30000142; //Jita
}
...
var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"&usesystem="+systemID+"&typeid=";
...
rows[i].getChild("buy").getChild("volume").getValue(),
rows[i].getChild("sell").getChild("volume").getValue(),
rows[i].getChild("sell").getChild("min").getValue()];
This is working nicely, but I'm having a couple of issues with the spreadsheet I'm working on :
- I cannot do more than 159 calls with the functions, after that it gives me an
#ERROR! :
If I use : =loadPrices('trade sheet'!B4:B
163,30000142,1) >>> It works
If I use : =loadPrices1('trade sheet'!B4:
B164,30000142,1) >>> It doesn't
Request failed for http://api.eve-central.com/api/marketstat?cachebuster=1&usesystem=30000142
returned code 414
/ Truncated server response: URL length exceeds the configured limit of 2048 characters
(Use muteHttpExceptions option to examine full response). (line 29).
line 29 is :
var xmlFeed = UrlFetchApp.fetch(url+cleanTypeIds.join("&typeid="), parameters).getContentText();
- I cannot use vlookup to fetch the ID from the "price load" sheet, to get the price sell. It returns an
#ERROR! :
I use this formula :
=VLOOKUP(B4,price load!A:D,4,FALSE)
B4 : is the Type ID (fetched from another sheet. formula in B4 is : =iferror(vlookup(A4,TypeID!B:C,2,FALSE),"Error")
A4 : is the name of the Item
on the 'price load' sheet : A is the Type ID, B is buy volume, C is sell volume, and
D is sell minSo basically I want the vlookup to check the ID on sheet X, check it on sheet Y and returns the min sell which is in column D.
It keeps saying #N/A : Did not find value '22448' in VLOOKUP evaluation.
I tried the same vlookup process on non dynamic numbers, and it works, what am I missing ?
Thank you for your help, and I hope I deviat so much from the OP subject !
regards.