GoogleFinance for Price Open on a specific date

Question

I can only get a price open for a stock on the latest trade day?

=GOOGLEFINANCE("BB","priceopen")

However, adding a date returns #NA.

=GOOGLEFINANCE("BB","priceopen", "2020/12/17")

score 1 · Accepted Answer · answered Dec 19 '20 at 23:41

1

every day the open price will close, so if you want to know the past value for some date use:

=GOOGLEFINANCE("BB", "close", "2020/12/17")

answered Dec 19 '20 at 23:41

player0

score 0 · Answer 2 · answered Dec 20 '20 at 16:49

0

You just need to use "open" instead of "priceopen".

answered Dec 20 '20 at 16:49

MattKing

2 Answers2