How to use GOOGLEFINANCE(("CURRENCY:EURAUD")) function

Question

This function:

GOOGLEFINANCE(("CURRENCY:EURAUD")) 

works well in Google Sheets, I have searched the web up and down for some documentation regarding this function and how it is used, the closest I've got was this

http://www.google.com/finance?q=EURAUD

Does anyone know how to use this one? or where to find documentation regarding this function?

Answer 1

The specific instructions for what you are looking for are in here: https://support.google.com/docs/answer/3093281

Remember your Google Spreadsheets Formulas might use semicolon (;) instead of comma (,) depending on Regional Settings.

Once made the replacement on some examples would look like this:

=GoogleFinance("CURRENCY:USDEUR") =INDEX(GoogleFinance("USDEUR","price",today()-30,TODAY()),2,2) =SPARKLINE(GoogleFinance("USDEUR","price",today()-30,today())) 

Those 3 cells would result in something like this:

Answer 2

Exchange rate from Euro to NOK on the first of January 2016:

=INDEX(GOOGLEFINANCE("CURRENCY:EURNOK"; "close"; DATE(2016;1;1)); 2; 2) 

The INDEX() function is used because GOOGLEFINANCE() function actually prints out in 4 separate cells (2x2) when you call it with these arguments, with it the result will only be one cell.