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
Bookmarks