Get Result of GOOGLEFINANCE (Google Sheets) Into Single Cell

May 25, 2019

Single cell

=GOOGLEFINANCE("GOOG","price", "2019-05-01")

Output as 2x2 cells

Date    Close
01/05/2019 16:00:00 1168.08

Use INDEX to extract only price into single cell

=INDEX(GOOGLEFINANCE("GOOG","price", "2019-05-01"), 2, 2)

Output

1168.08

Merge multiday results into single cell

This will generate 50+1 rows

=GOOGLEFINANCE("GOOG","price", "2019-01-01", 50)
Date    Close
02/01/2019 16:00:00 1045.85
03/01/2019 16:00:00 1016.06
04/01/2019 16:00:00 1070.71
07/01/2019 16:00:00 1068.39
...

Extract price only

=INDEX(GOOGLEFINANCE("GOOG","price", "2019-01-01", 50), ,2)
Close
1045.85
1016.06
1070.71
1068.39
...

Calculate average

=AVERAGE(INDEX(GOOGLEFINANCE("GOOG","price", "2019-01-01", 50), ,2))
1106.6056

NOTE: You can also use MEDIAN, MIN, MAX, etc.

This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.