robinhood-google-sheets
robinhood-google-sheets copied to clipboard
rghuckins
Exceeded Maximum Execution Time (line 0)
Getting error due to what the title says. Heard maximum execution time on google sheets is 5-6 minutes yet I get this errors almost immediately.
Hey folks, first I want to say thank you all for your great work putting this piece of machinery together. This particular execution time issue is trying my patience as well. Google custom functions time out after 30 seconds, but script runtimes are 6 minutes per execution. https://developers.google.com/apps-script/guides/services/quotas
Generally you'll get timed out if, say your orders history is too long (mine is nearing 500 rows). Should be possible to rewrite each of these custom functions to just execute in the apps script, and then populate or overwrite a named sheet. ... I'm very slowly working towards making this happen, as I'm a noob to Javascript/GAS. Any help or thoughts are welcome.
And once again, thanks for making this repo happen, everybody.
having the same problem when pulling options from RH. lemme know if you guys figure anything out. thanks!
I'm not sure if this is a separate issue, but I've been able to get the script to work only some of the time. It seems like certain times of the day make it impossible to populate the data. I honestly have a specific small number of items that I want to populate. I use filters and groupings to remove what I don't want from my view. I'll see if I can't simplify the original code to my own needs and see if that helps. If there is an issue connecting to robinhood rather than just a timeout issue, does anyone know where to look to confirm that?
