Help identifying trends and patterns

Hello,

I have not been able to figure out a formula that detects patterns. I have tried some conditional formulas, but haven't been able to figure it out. I attached an example.

I need several formulas that identify several patterns. I need the formulas for the following situations:

1. % of time after a profitable day, we have a profitable day
2. % of time after 2 profitable days, we have a profitable day
3. % of time after 3 profitable days, we have a profitable day
and so on

I also need:
1. % of time after a negative day, we have a profitable day
2. % of time after 2 negative days, we have a profitable day
3. % of time after 3 negative days, we have a profitable day
and so on

I enter new information every day, ideally I would like all the formulas to automatically update every day. They could give me the % of a profitable day today based on the recent history. I also need the formulas to constantly adjust to the new information, meaning if a month ago there was a 60% of a profitable day after a negative day, but recent results have changed that, I need the formulas to roll with the new data that is entered every day.
Pattern example.xlsx
Thank you. I really appreciate the help.
Steve

Pattern example.xlsx

Hello,
For some reason, I missed your reply, I apologize.

I cleaned up the sheet. Please see attached.

Hi

I do not know if that's what you want

See the file Pattern example.xlsx

For some reason, I don't get emails anymore when someone replies to my posts. I apologize for the delay.

Thank you Jose. I'm not exactly sure what you did. Does L7 state there is only an 18% chance of having a profitable day after 2 profitable days in a row? Does L8 state there is only a 26% chance of having a negative day after having 2 negative days in a row.

Hi Dbogey

No.
K7 value represent the number of isolated days (K1 days=1), i.e.
[Non rentable] [Rentable] [Non rentable] = 54% chance of having a profitable day between two non profitable days

L7 value represent the number of pair days (L1 days=2), i.e.
[Non rentable] [Rentable] [Rentable] [Non rentable] = 18%

The same for line 8 with non rentable days.

I hope you understand

I'm not sure I understand. If you are stating, L7 states there is an 18% chance of the specific pattern, negative, positive, positive, negative, that is interesting.

But what I need is simpler, I would think. I need the % of time there are 2 positive days in a row, 3 positive days in a row, 4 positive days in a row, etc. I also need the % of time there are 2 negative days in a row, 3 negative days in a row, 4 negative days in a row, etc.

Does your sheet state that anywhere? If not, is there a way to do that?

Thanks for the help