Triggering a value based on a straight number of days 1 column is higher than the other

Hi again, I posted a question here awhile ago and it was solved really quickly. This is the reason everytime I have a problem, I go on this forum. :D
Right now, I have this sheet (attached), that compares the Company A average to the industry average from October 15, 2011 to now. There are two dropdown menus: Cell B1: Calendar or Business, Cell H1: 3, 4, or 5.

What I need is the value "YES" produced under column G if Company A's price is above the industry average for Cell H1 (3, 4, or 5) straight days or more IF Calendar is selected under cell B1. For example, if Company A's price is above industry average on October 15-18 (and 4 straight days is selected), they would all produce YES.

If Business is selected, then only prices on weekdays count as a streak. If Company A's Thursday, Friday, Saturday, Sunday, Monday' prices are above the industry average (and all other days above and below it is not), this is only a streak of 3 (Only Thursday, Friday, Monday count). So YES would be produced if Cell H1 was selected with 3. If 4 is selected, then it will produce nothing.

I'm not sure if this can be done without VBA but I would really appreciate it if someone can help. Thanks beforehand for everyone who read this!