How to get a YTD dynamically in Google Sheets (Google Finance)?

Ask Question

Asked 2 years, 6 months ago

Modified 2 years, 6 months ago

Viewed 2k times

I want to display the YTD of a stock listed in C.

=(GOOGLEFINANCE(C5,"price")/INDEX(GOOGLEFINANCE(C5,"close","01/01/2021", today()),2,2))-1

I do not want to change "01/01/2021" each year to the current year. Is there any possibility to make something like "01/01/YEAR(TODAY()".

serenesat

9,91530 gold badges31 silver badges49 bronze badges

asked Jun 2, 2021 at 11:32

Cold Avenue

393 bronze badges

Add a comment |

1 Answer 1

Sorted by:

I got it: just leave the year out.

Solution: =(GOOGLEFINANCE(C5,"price")/INDEX(GOOGLEFINANCE(C5,"close","01/01", today()),2,2))-1

answered Jun 2, 2021 at 13:36

Cold Avenue

393 bronze badges

Add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.