How to get the exchange rate for a specified date through GoogleFinance?

M

M

Max2019-04-02 14:28:00

Google Sheets

Max, 2019-04-02 14:28:00

How to get the exchange rate for a specified date through GoogleFinance?

= GoogleFinance("Currency:USDRUB")
Shows the current dollar exchange rate. And how to get the course for example on 01/01/2010?

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

so through IMPORTXML, but it doesn't show for some currencies...

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Andrew B, 2022-02-01
@doommyyy

= GoogleFinance("Currency:USDRUB"; "price"; "01.01.2010" ;)

Similar questions

D

dpmain2020-12-14 17:27:59

Checkbox in google sheets with condition? 3Reply

A

Alex Quban2019-04-03 09:22:23

Sorting data in Google sheets. How to assign a value? 1Reply

K

KIRILL2019-04-18 16:09:39

How to collect documents from google drive to google spreadsheet? 1Reply

Z

z_e_l_o2020-12-29 05:47:12

How to implement so that each user fills in the table after and in the end it is possible to sort them by items? 2Reply

A

Artem Morozov2019-05-02 13:39:51

How to change the color of a cell in Google Spreadsheets when the "=IF" condition is met? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question