forex(amount: number, origin: text, destination: text, d: date) 🡒 number, pure function
amount expressed in the currency
origin into the equivalent amount in the currency
destination according to the historical rates at the specified date
The currencies should be encoded with their canonical three-letter codes. Lokad supports about 30 currencies leveraging the data provided by the European Central Bank. Rates are mostly updated on a daily basis.
table T = with [| as Year |] [| 2016 |] [| 2017 |] [| 2018 |] [| 2019 |] [| 2020 |] show table "1 USD in EUR" a1b6 with forex(1, "USD", "EUR", date(T.Year, 1, 1))