• From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Topic: Update google url for currency converter

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}";

Phuong

notrinos's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Update google url for currency converter

Willdo later today.

Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Update google url for currency converter

Commited to Repo with rerun cleanup.

/Joe

  • From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Re: Update google url for currency converter

Line 153 has an extra semicolons

Phuong

notrinos's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Update google url for currency converter

Oops! Will be fixed asap. Thanks.

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Update google url for currency converter

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:

apmuthu's Website

7 Reply by notrinos (edited by notrinos 07/25/2018 10:59:40 am)

  • From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Re: Update google url for currency converter

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

Phuong

notrinos's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Update google url for currency converter

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#</a></td>##' | \
sed -e 's#&amp;to=# #' | \
sed -e "s#'># #" | \
sort -u > output.txt

apmuthu's Website

  • From: Antigua and Barbuda
  • Registered: 07/09/2010
  • Posts: 25

Re: Update google url for currency converter

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.

10 Reply by notrinos (edited by notrinos 09/05/2018 07:20:15 pm)

  • From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Re: Update google url for currency converter

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.

Phuong

notrinos's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Update google url for currency converter

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.

apmuthu's Website

  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 650

Re: Update google url for currency converter

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://';

    }
www.boxygen.pk

boxygen's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Update google url for currency converter

Thanks. Their free plan provides for:

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

apmuthu's Website

  • From: Indonesia, Surabaya
  • Registered: 01/08/2012
  • Posts: 36

Re: Update google url for currency converter

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://';

    }

ichtus's Website