Given the daily open and close price of a stock in the past 10 years

Provided is a Google sheet data with 3 columns:

Date Open Close

Data example:
Day 1: Open 100 Close 101 (daily change 1%)
Day 2: Open 101 Close 101.5 (daily change 0.495%)
Day 3: Open 101.5 Close 99.5 (daily change -1.97%)

and so on... for the past 10 years

Suppose the price of the stock is at $100 on April 1st, 2021
1) What's the most likely price of the stock at the end of June 2021 if it's only going up every day?
2) What's the most likely price of the stock at the end of June 2021 if it's only going down every day?

I need the Google sheets formula
Thank you anons