Automatically determine If statement from multiple conditions selected?

**Marco123** · 11-27-2011, 10:51 AM

Hi All,

I’m trying to code an automated trading system that will perform a trade if certain conditions are met. Assume there are 5 conditions, and the user can select any one, two, three, four or five of the conditions together. This means the user could select any number of conditions, and any possible permutation of conditions of that size. Hence, there are dozens of distinct possible choices.

In my code, each condition is being determined by a function, where the function will return a true or false value. Let’s call them FunctionCondition1, FunctionCondition2, FunctionCondition3….etc.

For example, if the user selects condition 1 and condition 3, the vba would be as follows:

Please Login or Register  to view this content.

If the user selects conditions 3,4 and 5, the vba would be:

Please Login or Register  to view this content.

I’m wondering if it’s possible to code something that will be able to automatically construct or use an If statement (depending on the selected conditions) without having to list all the possible combinations of conditions in If statements. Therefore, at the start of the code it would pick up (using simple Booleans) how many and which conditions have been selected by the user, and from that it would be able to construct (or work out) the appropriate If statement to use.

Any ideas?

**Mordred** · 11-27-2011, 11:21 AM

Hi Marco123, is there any chance you can upload a mock workbook with mock data in it? It take the guess work away from those that will help.

**Marco123** · 11-27-2011, 05:42 PM

Hi Mordred, after posting on another forum I was given the solution. It is actually very simple and uses a combination of boolean variables. See below:

bTrade=true
If bMyCondition1 then bTrade = bFunctionCondition1
If bMyCondition2 then bTrade = bTrade and bFunctionCondition2
If bMyCondition3 then bTrade = bTrade and bFunctionCondition3

If bTrade then 'perform a trade

**mikerickson** · 11-27-2011, 06:05 PM

One way is to make a unique string for each combination of condition2

Please Login or Register  to view this content.

Note that Result looks like a binary number. This version returns those numbers,

Please Login or Register  to view this content.

**Marco123** · 11-28-2011, 05:25 PM

Hi mikerickson, thanks for your answer but I'm not sure if it works. It still seems that I would have to list all possible permutations in the case statements. Have I missed anything?

P.S. I have uploaded a mock workbook which has a solution in it that works.

**mikerickson** · 11-28-2011, 08:43 PM

I'm not sure what the question is. If you have 5 boolean values, there are 32 possibilities for their various combinations.
If each of those combinations is to be treated differently, your code will have to have a 32 way branch, of one form or another.

If statements are one way to achieve that branching. The SelectCase is another. I find Select case to be easier to read than If..ElseIf...ElseIf...End constructions, but there still has to be 32 branches.