How to pull up exchange rates in Google Sheets
How to add exchange rates to a Google Sheet is a question many financiers and entrepreneurs ask, as constantly searching for exchange rates on the Central Bank's website and pasting them into a Google Sheet is very inconvenient. I think everyone is trying to simplify their work by automatically inserting exchange rates into a Google Sheet formula. I'm sure many people use the dollar exchange rate very often.
The video doesn't cover theory, only the essentials about using the tool. You just need to copy the formulas from Google Sheets
https://docs.google.com/spreadsheets/...
Here are the formulas themselves
To pull the exchange rate from the Central Bank website
=IMPORTXML("http://www.cbr.ru/scripts/XML_dynamic..."&TO_TEXT(ADDRESS OF CELL WITH DATE)&"&date_req2="&TO_TEXT(ADDRESS OF CELL WITH DATE)&"&VAL_NM_RQ="&ADDRESS OF CELL WITH CODE; "//Value")
To pull the exchange rate from Google Finance
=INDEX(GOOGLEFINANCE("USDRUB";"Price";ADDRESS OF CELL WITH DATE);2;2)
Support the author https://pay.cloudtips.ru/p/8a8a50fa