These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Eve Central API Call Throttle? I.E. My Google Spreadsheet Won't Update

Author
Deja Blue
Orion VII Inc.
#1 - 2017-03-04 15:41:36 UTC  |  Edited by: Deja Blue
Hey guys ;)

I just got back into EVE. I have played off and on for years and have an old spreadsheet:
https://docs.google.com/spreadsheets/d/1yKjKl2h5n3D0-bcJR8W4LUMNbQP8-hd_x2mYM8TlOGs/edit#gid=0

The EC API call formulas are on the far right side, you have to side scroll, and are in the Arkonor cell at the top of each column.

Once in a while it works, but usually it won't update and shows all 0s. I have plugged in each ore individually, instead of the list in one formula, to no avail as it too usually shows 0s:
https://docs.google.com/spreadsheets/d/1QLbAI5jxuk8fKbmDiRu_u-nK5fwQ57-_2ACVon9cqws/edit#gid=0

Is this an API throttle from Eve Central?

I can force it to update by changing anything in the formula and then fixing it. I usually change the end from "//buy/avg" to "/buy/avg", removing one slash "/" and then back to the original "//buy/avg" adding the slash back. But you can remove anything, hit enter, it will try to load, and then put it back to the original formula, hit enter again and it loads the whole list fine.

Thanks for your time and any assistance you can provide.

Cheers!

I'll give them heroics...and when everyone is super...no one will be.