Need an Expert to fetch historical data

This spreadsheet goes to Yahoo finance and pulls down historical data for whatever stock I select. I also select a date range. The spreadsheet “Results” tab then shows me over that selected date range, the times the stock had consecutive days up or down. It also provides some additional info (highs and lows within that timeframe). Here what is needed: The spreadsheet does not retrieve the historical data from Yahoo anymore. The link looks correct, but it is not getting the data anymore. I think something changed on the website. Once that is fixed, would it be possible to measure how far the stock continues in the original direction after the pullback? Would also like to have a selectable timeframe here to measure this continuation.