Refresh Interval for GECKOPRICEBYNAME
Closed this issue · 4 comments
The refresh interval in the documentation doesn't say how often the data is refreshed meaning what is the time interval. If I put in 10 is that 10 minutes, 10 days or 10 weeks?
Hi,
By default, as shown on the above picture the cache is 10 minutes (600 seconds).
If you wish to lower it, you can change it manually. For example if you wish for 1min, you would need to put 60 instead of the 600 seconds.
Sorry I didn't define it in the code, I will add a comment in the future code versions. Thank you.
ok now if you manually set it in the syntax states - Syntax: GECKOPRICEBYNAME(id_coin, currency,[optional refresh attribute])
what is the "optional refresh attribute" timer value minutes, days, weeks, years?
The optional cell is when you want to refresh a group of formulas at the same time, it's not linked to the refresh timing.
Let's say the optional refresh cell is A1, each time you modify the value in A1, it will load all formulas that are linked to cell A1 as the optional refresh attribute.
Cell M11 acts as the refreshing cell
