Correct. ESI doesn’t provide a way to do that so you’ll need to parse all the data and filter down to the type(s) you want. Given the list is for a specific structure, if you wanted the lowest sell value I think you could use MINIFS - Google Docs Editors Help to find the lowest price given non sell orders and your desired type ID. Something like =MINIFS(G2:G, I2:I, 8419,B2:B,false)
. Could then have another sheet where you have the type names/IDs you care about, use this function to grab the related prices for that type, then can VLOOKUP
the price from there where needed.