2018-06-21

Currency conversion in Google Sheets using the GoogleFinance function

Formula:


[A2] --> =INDEX(GoogleFinance("CURRENCY:USDCAD","price",A2),2,2)

Example: