Currently all Magento default imports of currency are not working for a fresh demo install of Magento 2.2.4 and a couple of my active Magento 2.2.X projects.
I've tried with Yahoo Finance Exchange, WebserviceX and Fixer.io, but all return errors:
Yahoo Finance Exchange
We can't retrieve a rate from http://query.yahooapis.com/v1/public/yql?format=json&q=select+*+from+yahoo.finance.xchange+where+pair+in+%28%22USDCHF%22%2C%22USDCNY%22%2C%22USDEUR%22%2C%22USDHRK%22%2C%22USDKMF%22%2C%22USDUSD%22)&env=store://datatables.org/alltableswithkeys for CHF.
Webservicex
We can't retrieve a rate from http://www.webservicex.net/CurrencyConvertor.asmx/ConversionRate?FromCurrency=USD&ToCurrency=CHF.
Fixer.io
We can't retrieve a rate from
http://api.fixer.io/latest?base=HRK&symbols=EUR,HRK for EUR.
I've tried testing by changing the base currency and additional currencies in Configuration -> General -> Currency setup
but every time it's showing the above errors for all services.
Seems that the Fixer.io API endpoint is deprecated. And the new endpoint can't be used without a Fixer.io account. I guess Magento didn't adjust the endpoint yet…
Webservicex is returning a "Page not found" JSON response and Yahoo is returning a null value for the query.
I presume their APIs changed and Magento didn't adjust to the changes yet…
Can anyone suggest or provide a quick fix for one of the services?
EDIT
After installing the shopgo module for additional currency import services you get Google Finance as a new import option.
But it returns this error:
We can't retrieve a rate from http://www.google.com/finance/converter?a=1&from=USD&to=CHF.
When using the direct link you get this error:
I presume it's generic since my server isn't "sending automated requests to Google Finance API".
Best Answer
If you visit that URL, you'll notice it says:
{"code":"PAGE_NOT_FOUND","message":"Page not found"} Not good. If you then go to webservicex.net and scroll through its list of API, you'll notice that none refer to currency conversion. Also, not good.
If you web search for currency import in Magento 2, you'll come to this shopgo module, which says:
Three times the charm: webservicex.net is probably not going to work. Try installing the module from shopgo, which uses other providers.