Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
You can’t perform that action at this time.