Get Kurs Nbu.txt

function kursnbu( date ) {
  if ( ! date ) {
    return 0;
  }
  
  var apiUrl = 'https://bank.gov.ua/NBUStatService/v1/statdirectory/exchange?valcode=USD&date=',
      dateApiFormat = Utilities.formatDate(date, "GMT+3", "yyyyMMdd"),
      
      url = apiUrl + dateApiFormat + '&json',
      response = UrlFetchApp.fetch( url ),
      json = response.getContentText(),
      data = JSON.parse(json);
  
  return data[0].rate;
}