NBPExchangeRates – action downloading the NBP exchange rate of the choosen currency in PLN as per the day indicated
Where you can use action:
CellAddress (type: Text) – the address of the cell to which the exchange rate will be added
Currency (type: String) – exchange rate currency
Date (type: Date) - cell address or formula with date (day of currency exchange rate)
You can use this action step in two ways:
- checking a single course
a spreadsheet cell should be entered as the cell address, and the currency and date can be entered manually in the parameter or taken from the cell. This way, you can check one exchange rate at a time.
- checking several courses at the same time
you need to create a table in which the results will be entered in one column, and in the second and third it will be possible to enter the currency and date for which you want to see the rate. This way, you can check several courses at once.