Is it possible to parse the current dollar exchange rate into a table?

Question

Google Sheets

Is it possible to get the USD/RUB exchange rate from profinance.ru for a specific day and paste it into a cell?
If it is possible, then how to insert the date from the table into this formula?
Table example:

This method is possible to implement, but only the article was able to google, how to parse the course from cbr.ru. But the formula, for some reason, breaks down when it wants to, and the values ​​are: #N/A.
The dollar exchange rate for the day you are interested in can be viewed on this page .

Answer 1

=IMPORTXML("http://www.cbr.ru/scripts/XML_daily.asp"; "//ValCurs/Valute[CharCode=""USD""]/Value")
= GoogleFinance("Currency:USDRUB")

If these sources do not suit you, then do the same through the IMPORTXML + xPath request (which can be peeped in the F12 console )

=importxml("https://www.profinance.ru/currency_usd.asp";"(//table[1]//b/font[@color='Red'])[1]")