Refactored GeckoPrice Function can't load within Google Custom Function timeout

[m0ranwad]

Really appreciate your work

Since implementing your V2 changes, the GeckoPrice API call no longer executes before the timeout limit set by Google. After reviewing your Sample Google Sheet, it appears this is happening on your side as well, but let me know if you need any additional data.

[Eloise1988]

Hi,
Thank you for your message. Yes my sheets have been struggling but I haven't understood why?
How can I improve it?
Thanks for your help,

[m0ranwad]

I suppose if it's on the server side with Goin Gecko's API there may not be much you can do. If I can find some time this week, I'll test making some API calls to Goin Gecko and focusing on the response times to confirm if that's the issue. At first, I thought the changes in V2 caused the performance drop, but I rolled back to V1 and it's also not loading data in time.

[pldelattre]

A likely explanation of the timeout :
#5 (comment)