Problems with Spreadsheet HELP!

Hey all, I have build a spreadsheet to help me seed stations for my corp!
I have been having issues with load times and I suspect I have hit my import limit. Is there any way to create the xml import so that it gets the same info with less queries? (Specifically under “Items to stock” columns I - L.

Thanks in advance!

You can condense your market calls down to 1 pull:

=importxml(“https://api.evemarketer.com/ec/marketstat?typeid=”&{Range of IDs}&“&usesystem=30000142”, “//sell/min”)

Now for the “Range of IDs” you can just do “{$F$2:$F$25}”, on your Items to Stock sheet, instead of pulling each individually you just pull all of them in 1 (one) single call; you may have to transform the return to make it fill down in the column.

3 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.