How to get the exchange rate for the date specified in the cell?

Question

Google Sheets

How can I get the exchange rate for the date specified in the cell?

I tried this option, but I can't get the date from the cell

=IMPORTXML("http://www.cbr.ru/scripts/XML_daily.asp?date_req=28.11.2021"; "//ValCurs/Valute[CharCode=""UAH""]/Value")/10

Google Finance has tried all the formulas in general, does not want to work, maybe someone has an option right away with the date in the cell.

You need a rate for only one specified date without additional data.

Answer 1

For today

=IMPORTXML(
  "http://www.cbr.ru/scripts/XML_daily.asp?date_req="&TEXT(TODAY();"dd.MM.yyyy");
  "//ValCurs/Valute[CharCode=""UAH""]/Value"
)/10

For date in another cell

=IMPORTXML(
  "http://www.cbr.ru/scripts/XML_daily.asp?date_req="&TEXT(C1;"dd.MM.yyyy");
  "//ValCurs/Valute[CharCode=""UAH""]/Value"
)/10

Answer 2

they wrote that googlefinance is not supported (although some tickers work) they
advise using YAHOOFINANCE , click on google sheet formulabuilder there it is more than clear all
ps formulas return tabular data at once, so either pick it with scripts or through an adjacent table