'How to prevent GOOGLEFINANCE from recalculating?
I'm using a GOOGLEFINANCE formula, but it keeps updating. I would like it to stay a fixed amount once it has been calculated the first time but I can't seem to figure out a way to do that. I tried Googling for the answer but came up empty-handed. I went to File > Spreadsheet Settings > Calculation, but there doesn't seem to be an option there to prevent recalculations, there only exist options to delay them.
It seems that feature is not built into Google Sheets. But maybe someone who is really good at formulas or a script. Can think of a super smart way to do it with a formula or a script?
Solution 1:[1]
There is no way to stop a Google Sheets formula, including those that use GOOGLEFINANCE function to recalculate.
You might replace the formula by it's result. One simple way to do this is by doing copy-paste as value only.
P.S. GOOGLEFINANCE data can't be retrieved by Google Apps Script.
Related
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Rubén |