Pattern Trigger Betting using Excel

[Blacktiger1]

Every Data that is being entered in "Enter Data" Column, is being collected in a set of three in actual patterns column. And those sets in Actual patterns are being compared with 8 patterns in the frequency table.

What do I want to do?

1. As soon as I am left with only one pattern out of the other 8 patterns (frequency table) with zero count, It should print the trigger in the "bets" column and
2. If next three data entered in Enter Data column, matches with that pattern (of which we are talking in point 1) then it should calculate our score +3.
   1. For e.g only pattern left with zero frequency was PBP, and new data entered is also PBP.
3. If it does not exactly match, then it should count how many entries of the set match
   1. for e.g PBP was our only pattern left with zero frequency and our new three data are PBB, then only two data of set matched, it should calculate our score as +1 +1 -1 = net +1
   2. If only one data of the set match, +1 -1 -1 = -1
   3. if none of the data of the set matched, -1 -1 -1 = -3
4. If it does not exactly match, then it should count how many entries of the set match, then only two data of the set matched, it should calculate our score as +1 +1 -1 = net +1+1

 

[Blacktiger1]

This is the link of my cross-post.

Trigger Betting Function

I have attached a spreadsheet. As soon as only one pattern from the 8 patterns(given in the G column) is left with zero frequency, It prints a trigger in the Bets column and then waits for a new set of three values, if the pattern of the new three values is totally (all three values) with...

www.excelforum.com

 

[Blacktiger1]

Please tell