Question: I need to find a way to automatically copy the output of the below GoogleFinance formula into another cell and make it stick, i.e. doesn't change when the exchange rate changes.

```
=A1*GOOGLEFINANCE("currency:AUDGBP")

```

I was going to use something like `=value(x)` but this would change every time the above formula generated a new value, whereas I want something to stick as soon as it's output an answer.

Answer: 
The GOOGLEFINANCE function has some optional parameters - one of them is the start date. 

If you request the exchange rate for a particular date then it won't change later on.

```
=GOOGLEFINANCE("Currency:AUDGBP", "price", "05/31/2019")

```

The output is a little different - a range with the date and value rather than a single cell, but the value for the exchange rate is correct and won't change.

You can then use the INDEX function to extract just the exchange rate

```
=INDEX(GOOGLEFINANCE("Currency:AUDGBP", "price", "05/31/2019"), 2, 2)

```

As described [here](https://stackoverflow.com/questions/13883933/returning-a-single-cell-from-an-array-formula)
if you want to play with button and script then:

```
function moveValuesOnly() { var ss = SpreadsheetApp.getActiveSpreadsheet();
                            var source = ss.getRange('Sheet1!A1');
                            source.copyTo(ss.getRange('Sheet2!A1'), {contentsOnly: true}); }

```

which will copy the value from **Sheet1!A1** into **Sheet2!A1**

---

otherwise `**`CTRL`**` + `**`C`**` and `**`CTRL`**` +
 `**`SHIFT`**` + `**`V`**` for manual copy