How do I get the price of something based on the date in a separate column?

Question

I want to get the price of BTC on a certain date. Column A being this:

=GoogleFinance("CURRENCY:USDBTC","close","date")

Column B having the list of dates:

B1 - 11/02/2018 00:00:00
B2 - 12/02/2018 00:00:00
etc.

How do I get this to work?

=GoogleFinance("CURRENCY:USDBTC","close","B1")

Didn't work

score 0 · Answer 1 · edited Jun 24 '19 at 10:23

0

=INDEX(GoogleFinance("CURRENCY:BTCUSD","close",B2),2,2)

edited Jun 24 '19 at 10:23

player0

124,011
12
67
124

answered Jun 24 '19 at 08:05

Matt Bell

11

score 0 · Answer 2 · answered Jun 24 '19 at 10:37

0

=ARRAYFORMULA(IFERROR(VLOOKUP(TEXT(B1:B, "dd/mm/yyyy"), 
 {TEXT(GOOGLEFINANCE("CURRENCY:USDBTC", "close", MIN(B1:B), MAX(B1:B)+1), "dd/mm/yyyy"), 
       GOOGLEFINANCE("CURRENCY:USDBTC", "close", MIN(B1:B), MAX(B1:B)+1)}, 4, 0)))

answered Jun 24 '19 at 10:37

player0

124,011
12
67
124

How do I get the price of something based on the date in a separate column?

2 Answers2