1

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?

Mayukh Bhattacharya
  • 12,541
  • 5
  • 21
  • 32
user8702720
  • 115
  • 1
  • 9
  • You might wanna try writing a simple script to capture the moving value to another cell as static value. just need to use ```getvalue()``` to get the value from the cell with the GOOGLEFINANCE and ```setvalue()``` to put it into the cell desired – Nami888 May 01 '22 at 00:09

1 Answers1

0

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

Rubén
  • 34,714
  • 9
  • 70
  • 166