...
The following example shows price, change, volume and last trade data based on these formulas: for price, =GOOGLEFINANCE(C2), where C2 is the stock symbol, =GOOGLEFINANCE(C2, "change"), =GOOGLEFINANCE(C2, "volume"), and =GOOGLEFINANCE(C2, "tradetime")
...
The columns must be defined as above. Seven columns are required with the order exactly as above.
The tabs at the bottom of the sheet are important. The reader will create different finance topic names for every tab you have. Any hidden tabs will be ignored. Also sheets that have the prefix ! will be ignored.
...
In the above example, the formula to get the quote is located in the E column and looks like =GOOGLEFINANCE("CURRENCY:"&$A2&C2).In this example, the source currency is in column A2 and the destination currency is in C2. There’s a large number of currencies and crypto currencies supported by the GOOGLEFINANCE function. Five columns in exactly the order as above is required.
As in stocks/indexes, copy the sheet ID into the Currencies tab’s grid to have the reader read the sheet:
...