There are a number of known issues/limitations with the Google Add-On. Please see below, or contact us if you don't see your issue listed below:
Pricing data is not updating once the Google Sheet is open
Google Editor Add-Ons, such as the custom OPENBULLION() function, have a known limitation in that they only update their data in two scenarios:
When the sheet is opened/refreshed
When the inputs of the OPENBULLION() function change
The simplest workaround is to reload/refresh your open Google Sheet (typically F5 in your browser) whenever you need to update the OPENBULLION() supplied pricing.
Alternatively, you can pass the OPENBULLION() function data that updates periodically, such as the output from the built-in GOOGLEFINANCE() function. Each time a new value is pushed to OPENBULLION() via this parameter, it will retrieve updated pricing data.
An example:
Set a fixed cell (A1 in our example) to =GOOGLEFINANCE("CURRENCY:USDEUR")
Pass the value of A1 as needed =OPENBULLION("XAU", "USD", "OZ", $A$1)
Now each time that the built-in GOOGLEFINANCE() function updates (every ~10 minutes), a new value will be passed to OPENBULLION(), triggering a pricing update.
You can see a working demo of this in our 'Periodic Updates' example sheet.
