A
A
arr0w2020-08-30 16:49:20
Google Sheets
arr0w, 2020-08-30 16:49:20

How to get the exchange rate for a specified date?

There is a formula showing the current exchange rate of the dollar against the ruble:
= GoogleFinance("Currency:USDRUB")
How to supplement this formula to get the exchange rate for the specified date?
For example 07/11/2015

Answer the question

In order to leave comments, you need to log in

1 answer(s)
0
0nkery, 2020-08-31
@arr0w

GOOGLEFINANCE("Currency:USDRUB"; "price"; ДАТА(2014;1;1); ДАТА(2014;12;31); "DAILY")
GOOGLEFINANCE("Currency:USDRUB"; "price"; СЕГОДНЯ()-30; СЕГОДНЯ())

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question