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.
 

market spread info
Author
Previous Topic Next Topic
Solanis Charen-Teng
Garoun Investment Bank
Gallente Federation
#1 - 2016-07-21 09:42:05 UTC
hay all

maybe some one can help me that has more excel know how then me :)

I have a spread that pulls prices ect over a 5 system range for me , everything works pretty dam fine though at random with random items I get a #VALUE error , once I click on that cell and hit enter it goes away again .

any ideas tips or napalm suppliers you know off that could help maybe ?
Areen Sassel
Dirac Angestun Gesept
#2 - 2016-07-21 19:00:29 UTC
Solanis Charen-Teng wrote:
maybe some one can help me that has more excel know how then me :)
I have a spread that pulls prices ect over a 5 system range for me , everything works pretty dam fine though at random with random items I get a #VALUE error , once I click on that cell and hit enter it goes away again .
any ideas tips or napalm suppliers you know off that could help maybe ?


I am a Perl programmer. If you wanted me to debug a Perl script, you'd have to _show it to me_.

Maybe Excel is different somehow, but I doubt it.
Plleasure Hub
Municorn
#3 - 2016-07-23 06:29:05 UTC
It sounds like it might be an issue caused by too-frequent API calls. Most APIs have automatic rules for how often you can call them. Since Excel and Google Spreadsheets will execute the call basically on any edits, random time intervals, or whenever, it causes loads of problems.

I'd recommend switching to Google Spreadsheets, put your API call into a custom function in Apps Script, and then create a clickable image trigger that will only call the API when clicked. Alternatively, you can limit it to fire no more than once an hour, etc. You need to slow down the rate of the calls somehow.

Just a guess. I hope it helps.

"There's no meaningful difference between a real and a virtual world. It's pointless to ask anyone who they really are. All you can do is accept and believe in them, because whoever they are in your mind, is their true identity." — Kazuto Kirigaya