google-finance-api

How to use GOOGLEFINANCE((“CURRENCY:EURAUD”)) function

by

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 (the second … Read more

How do I get currency exchange rates via an API such as Google Finance? [closed]

by

Thanks for all your answers. Free currencyconverterapi: Rates updated every 30 min API key is now required for the free server. A sample conversion URL is: http://free.currencyconverterapi.com/api/v5/convert?q=EUR_USD&compact=y For posterity here they are along with other possible answers: Yahoo finance API Discontinued 2017-11-06### Discontinued as of 2017-11-06 with message It has come to our attention that … Read more