CODEWITHSUNDEEP
google-sheets-formulagoogle-finance
Jonas Kaufmann-Ludwig
Jonas Kaufmann-Ludwig

Reputation: 31

How to use TODAY() function with GOOGLEFINANCE() function in GoogleSheets

I am trying to create a sheet with stock data from the current day and yesterday.

Neither this:

=GOOGLEFINANCE(B2;"price";TODAY())

Nor this:

=GOOGLEFINANCE(B2;"price";DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY())))

works.

But this does:

=GOOGLEFINANCE(B2;"price";DATE(2020;1;17))

Can anyone help?

Upvotes: 2

Views: 4203

Answers (2)

Arun Augustin
Arun Augustin

Reputation: 21

I have stocks in columns. 1 option is to simply hide the date columns! :-)

Upvotes: 0

Raymond Tran
Raymond Tran

Reputation: 274

Make another cell with the formula TODAY(). For ex. A1: =TODAY().

Then A2: =GOOGLEFINANCE(B2;"price";$A$1)

Upvotes: 1

Related Questions