Generate missing Exchange Rate

[Anonymous]

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]

Hi,

how can you calculate the exchange rate ?

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

[Anonymous]

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]

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 · Accepted solution]

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]

Thanks Tatsiana.

You give me a great help.