Skip to content

Instantly share code, notes, and snippets.

@AGulev

AGulev/gist:f1d4ad5d695211cc27b7f11490fa96fb

Last active April 13, 2019 20:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AGulev/f1d4ad5d695211cc27b7f11490fa96fb to your computer and use it in GitHub Desktop.
Save AGulev/f1d4ad5d695211cc27b7f11490fa96fb to your computer and use it in GitHub Desktop.
Download ZIP
Exchange rate National Bank of the Republic of Belarus in Google Sheets
Raw
gistfile1.txt
Формула:
=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