GOOGLE FINANCE Function | Retrieving Stock Data

[@patty1768]

Excellent!

[@kennethprice4292]

Awesome, thanks for sharing.

[@MrDomitros]

Very helpful!

[@sonialiu1330]

👍👍👍👍👍

[@manis9360]

how to get "change %" for n number of day.?

[@PlanetFinanceOfficial]

Hey!
You can try this:
=100*(googlefinance("AAPL";"price")/index(googlefinance("AAPL";"price";
date(year(TODAY())-1;12;31));2;2)-1)

[@anandmenezes2779]

Hi, how to add any other header in the attribute such as delivery quantity and delivery percentage

[@PlanetFinanceOfficial]

Hey! For list of attributes that can be used please find access here: support.google.com/docs/answer/3093281

[@prazra]

Hi,
Is there any way in Google Finance to find out the IPO Listing date of a stock ?
Thanks

[@PlanetFinanceOfficial]

Hello, the only answer I've been able to find is here: support.google.com/docs/thread/148414084/using-google-sheets-to-fetch-the-ipo-price-and-possibly-the-date-as-well?hl=en

[@agusaziz9610]

Why in my spreadsheet can not get historical data after july 1, 2021?

[@PlanetFinanceOfficial]

Hey! Feel free to share you spreadsheet with me to see where the issue is coming from! [e-mail]