Skip to content

Instantly share code, notes, and snippets.

@AGulev
Last active April 13, 2019 20:25
Show Gist options
  • Save AGulev/f1d4ad5d695211cc27b7f11490fa96fb to your computer and use it in GitHub Desktop.
Save AGulev/f1d4ad5d695211cc27b7f11490fa96fb to your computer and use it in GitHub Desktop.
Exchange rate National Bank of the Republic of Belarus in Google Sheets
Формула:
=IMPORTXML(CONCATENATE("http://www.nbrb.by/Services/XmlExRates.aspx?ondate=", TEXT(A1,"mm/dd/yyyy")),"/DailyExRates/Currency[@Id='145']/Rate/text()")
Нужно заменить A1 ячейкой с датой.
Валюты:
145 - USD
292 - EUR
298 - RUB
Остальные коды валют можно посмотреть в оригинальном xml:
http://www.nbrb.by/Services/XmlExRates.aspx?ondate=07/14/2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment