2

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?

Jonas Kaufmann-Ludwig
  • 31
  • 1
  • 4

2 Answers2

1

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

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

Raymond Tran
  • 274
  • 1
  • 5
0

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

Arun Augustin
  • 21
  • 2