Monday, June 27, 2016

Currency conversion in Google Sheets using the GoogleFinance function

Formula:


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

Example:




Link