topic Re: Generate missing Exchange Rate in App Development

Generate missing Exchange Rate

Anonymous — Tue, 19 Dec 2017 09:33:23 GMT

Hi all,

I have an exchange rate table.

However, some of the records are missing and i have to calculate the missing records.

For example:

I need to calculate the exchange rate from PHP to USD.

What i need to do is using the rate (PHP to AUD) * the rate (AUD to USD).

Is it possible to generate all cases like (MMK to USD) by scripting?

Best Regards,

Louis

YoussefBelloum — Tue, 19 Dec 2017 09:58:07 GMT

Hi,

how can you calculate the exchange rate ?

you should rather gather the exchanges rates and insert the values on your tables.. no ?

Anonymous — Tue, 19 Dec 2017 10:04:59 GMT

Hi youssef,

The exchange rate is provided in the excel file.

Some exchange rate are missing which i need to use other record to calculate.

For example:

the exchange rate from PHP to USD = the rate (PHP to AUD) * the rate (AUD to USD).

Best Regards,

Louis

t_chetirbok — Tue, 19 Dec 2017 10:06:29 GMT

Hi Louis,

It's possible if you always need to have the exact number of rates for each currency.

I mean 5 rows for AUD, 5 rows for PHP

t_chetirbok — Tue, 19 Dec 2017 10:33:25 GMT

In the attachment you can find a script with the example.

1. by default you can have only 5 currencies. if you need to add more, just put it to the inline load

2. AUD should always have all 5 rates

Anonymous — Thu, 21 Dec 2017 02:12:26 GMT

Thanks Tatsiana.

You give me a great help.