Science & Industry

I notice that google docs is not very reliable.

Go to your formula and just delete a character and put it back. If it turns all green then it will work again.

Confirmed, importXML sucks ballz. Use Steve's script.

I will try with FuzzySteve's function then. One question though - what is the cachebuster parameter for, what values it should have and would it be a good idea to remove it?

That's why I modified your function to return single values:

function loadPriceCell(typeID,systemID,cachebuster){
  if (typeof systemID == 'undefined'){ 
    systemID=30000142; //Jita
  }
  if (typeof typeID == 'undefined'){
    throw 'need typeids';
  }
  if (typeof cachebuster == 'undefined'){
    cachebuster=1;
  }

  var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"&usesystem="+systemID+"&typeid="+typeID;
  var parameters = {method : "get", payload : ""};
  var xmlFeed = UrlFetchApp.fetch(url, parameters).getContentText();
  var xml = XmlService.parse(xmlFeed);
  
  if(xml) {
    var rows=xml.getRootElement().getChild("marketstat").getChildren("type");
    var price = rows[0].getChild("sell").getChild("min").getValue();
  }
  return price;
}

and typing
= loadPriceCell(11399)
in a cell (naturally I don't memorize or copy/paste all the TypeIDs, but use vLookup)
gives me minimum sell value of Morphite in Jita, hooray!

Is it because of cachebuster, or because there's bound to be multiple calls in my sheets?
If it's the former, then I just remove that parameter (or call the function without it) and problem fixed.
If it's the latter, it's going to present a spreadsheet challenge for me, since I use a separate sheet (tab) for every blueprint (which is probably not the most efficient way to run spreadsheets, but I only recently started doing this stuff). Though I just noticed that typing something like
=loadPrices(B2:E2)
in my sheet will fill the cells with price data for materials I need, just not the cells where I want the data to be (though that's hardly a problem) . And I still need one call for every sheet.

I use the ingame Notepad for that

Though I could reduce the number of calls further by considering the fact that some blueprints use the same materials and by using named ranges

And thank you for your help of course