FrontAccounting forum — Update google url for currency converter

Re: Update google url for currency converter

null@example.com (ichtus) — Tue, 11 Sep 2018 01:56:40 +0000

thanks for info, just applied with add code below, now it works.

        elseif ($provider == 'CCA')
        {
                $val = getInnerStr($contents, '{"val":', '}}');
    }

boxygen wrote:

I am using free.CurrencyConverterAPI.com and it works for almost all Currencies

elseif ($provider == 'CCA') //free.currencyconverterapi.com
    {
        $filename = "/api/v5/convert?q={$curr_b}_{$curr_a}&compact=y";
        $site = "free.currencyconverterapi.com";
        $proto = 'https://';

    }

Re: Update google url for currency converter

null@example.com (apmuthu) — Fri, 07 Sep 2018 16:32:05 +0000

Thanks. Their free plan provides for:

Currency values are refreshed every 60 minutes.
Maximum of 100 requests/hr & 2 query conversions per request

Re: Update google url for currency converter

null@example.com (boxygen) — Thu, 06 Sep 2018 06:34:17 +0000

I am using free.CurrencyConverterAPI.com and it works for almost all Currencies

elseif ($provider == 'CCA') //free.currencyconverterapi.com
    {
        $filename = "/api/v5/convert?q={$curr_b}_{$curr_a}&compact=y";
        $site = "free.currencyconverterapi.com";
        $proto = 'https://';

    }

Re: Update google url for currency converter

null@example.com (apmuthu) — Wed, 05 Sep 2018 19:20:45 +0000

The following service providers support XCD:

Oanda
mataf.net
CoinMill.com
XE.com
GoodReturns.in

Maybe we should use a plugin system for Exchange rates.

Re: Update google url for currency converter

null@example.com (notrinos) — Wed, 05 Sep 2018 19:11:11 +0000

Google converter is no longer working and have not fixed yet.
Bloomberg has blocked requests also.
Yahoo shifted to: https://finance.yahoo.com/quote/GBPUSD=X?p=GBPUSD=X

Only ECB now is working.

Re: Update google url for currency converter

null@example.com (trentdavis) — Wed, 05 Sep 2018 18:13:56 +0000

What's the status on this? I'm trying to add Caribbean Dollars (XCD) in ver 2.4.4 but the get exchange rate does not work.

Re: Update google url for currency converter

null@example.com (apmuthu) — Sun, 29 Jul 2018 16:56:46 +0000

Shall we replace it with x-rates.com? The bash code for it is:

wget -q -O- "https://www.x-rates.com/table/?from=USD&amount=1" | \
grep "http://www.x-rates.com/graph/?from=" | \
cut -c71-1000 | \
sed -e 's###' | \
sed -e 's#&to=# #' | \
sed -e "s#'># #" | \
sort -u > output.txt

Re: Update google url for currency converter

null@example.com (notrinos) — Wed, 25 Jul 2018 10:49:56 +0000

Google finance API does not work anymore, should we stop chasing their updates ?

Re: Update google url for currency converter

null@example.com (apmuthu) — Fri, 25 May 2018 02:07:34 +0000

For those using FA 2.3.x - this will need to be backported.

Looks like this has been so for a couple of months atleast:

Re: Update google url for currency converter

null@example.com (joe) — Thu, 24 May 2018 20:03:18 +0000

Oops! Will be fixed asap. Thanks.

Joe

Re: Update google url for currency converter

null@example.com (notrinos) — Thu, 24 May 2018 14:06:02 +0000

Line 153 has an extra semicolons

Re: Update google url for currency converter

null@example.com (joe) — Thu, 24 May 2018 13:24:38 +0000

Commited to Repo with rerun cleanup.

/Joe

Re: Update google url for currency converter

null@example.com (joe) — Thu, 24 May 2018 11:38:29 +0000

Willdo later today.

Joe

Update google url for currency converter

null@example.com (notrinos) — Thu, 24 May 2018 06:30:32 +0000

Google currency converter url has been changed to finance.google.com/bctzjpnsun/converter?a=1&from=USD&to=EUR

So lines 153 and 221 of gl_db_rates.inc should be:

153 $filename = "/bctzjpnsun/converter?a=1&from={$curr_a}&to={$curr_b}";
221 $filename = "/bctzjpnsun/converter?a=1&from={$curr_b}&to={$curr_a}";