...
When The Reader is run, it will map to this (these) Google Sheets and pull the content into the Chameleon Finance module. More information about the Chameleon Finance module can be found here: Financials
The Google Finance Reader also has support for currencies. The sheet format is different and looks like:
...
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.
As in stocks/indexes, copy the sheet ID into the Currencies tab’s grid to have the reader read the sheet:
...