Jerrod & William,
Have you ever tried something simpler? For simplicity, you cannot beat the followings: “Rank > 99” (to enable the buy filter) and “Rank > -99” (to disable the buy filter).
Old buy rules:
0 or (Rank>99) … // Enable
1 or (Rank>99)… // Disable
New buy rules:
Rank>99…// Enable. Buy, if rank is higher than 99.
Rank>-99…// Disable. Rank > -99 is always true.
Old sell rules:
1 AND (Rank<99)…// Enable
0 AND (Rank<99)…// Disable
New sell rules:
Rank<99…// Enable. Sell, if rank is lower than 99.
Rank<-99…// Disable. Rank < -99 is always false.
Advantage #1: Your sim will be simpler and easier to write.
Advantage #2: Your sim will be easier to manage. There will be no more confusion about zeroes and ones.
Advantage #3: Your sim will be Fast.
Advantage #4: Save time and money. There will be no need for the feature request that Marco has just bumped up to higher priority.
All of the above should work in Excel.
I hope this helps.
Robert