Get Result of GOOGLEFINANCE (Google Sheets) Into Single Cell

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

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.

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.