Nbp

Description of formula:
Returns exchange rate of given currency for PLN in given day, using data from Narodowy Bank Polski (NBP The National Bank of Poland)

External data sources
Function uses API of Narodowy Bank Polski, so data are taken from external source. Function will start working when you open admin and External Data Sources tab, choose source you want and turn on. To do this, you need to check Enabled.
Syntax:
Nbp(currencyCode,date)
Parameters:
currencyCode
(type:text) Code respoding to currency, which you want exchange for PLN. This is three-letter code and you can find it here: https://en.wikipedia.org/wiki/ISO_4217
date
(type:date) date, for which you want exchange rate
Returned type:
Number
Examples:
=Nbp('GBP',today())
=Nbp('USD',date(2020,4,7))
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk