TheCurrency Convertermacro converts an amount of money to multiple target currencies based on the last close of day exchange rate. The reference rates are usually updated around 16:00 CET on every working day, except on target closing days. They are based on a regular daily concertation procedure between central banks across Europe, which normally takes place at 14:15 CET.
Previously (v5.2.10 and earlier), Yahoo was used before their service was retired
To get the last daily exchange rate just provide a validAmount, and then select theFromandTocurrencies. You can see those three fields in the following image: