{"id":2210,"date":"2011-04-22T10:20:26","date_gmt":"2011-04-22T10:20:26","guid":{"rendered":"http:\/\/www.amibroker.org\/userkb\/?p=2210"},"modified":"2018-09-02T19:49:43","modified_gmt":"2018-09-02T19:49:43","slug":"using-iif-if-and-switch-functions","status":"publish","type":"post","link":"http:\/\/www.amibroker.org\/editable_userkb\/2011\/04\/22\/using-iif-if-and-switch-functions\/","title":{"rendered":"Using IIF(), IF() and Switch() functions"},"content":{"rendered":"

Many newcomers to AFL are confused by the IF(), IIF() and Switch(). This post gives a few simple examples of their use. The IF() and Switch() are program flow control statements, the IIF() is a function that acts on all elements of an input array and returns an output array. <\/p>\n

In all but the simplest applications the Switch() is the preferred method to the IF() to change program flow. It can be used to code complex decision trees<\/a> and state machines<\/a>, for example as these are often needed in automated trading systems.<\/p>\n

For more detailed explanations click IF()<\/a>, IIF()<\/a>, or Switch()<\/a>. A search of the afl library<\/a> will also get you many more examples.<\/p>\n

The IIF() function<\/h3>\n

It is possible to use if()s to individually test and modify each bar in an array for a condition. An example on how this would be done is shown in the function below (copied from the AmiBroker help). This function is an AFL equivalent for the IIF() function.<\/p>\n

<\/span>function <\/span>IIF_AFL<\/span>( <\/span>condition<\/span>, <\/span>inputA<\/span>, <\/span>inputB <\/span>)\r{\r    <\/span>result <\/span>= <\/span>Null<\/span>;\r    for( <\/span>bar <\/span>= <\/span>0<\/span>; <\/span>bar <\/span>< <\/span>BarCount<\/span>; <\/span>bar<\/span>++ )\r    {\r       if( <\/span>condition<\/span>[ <\/span>bar <\/span>] )\r           <\/span>result<\/span>[ <\/span>bar <\/span>] = <\/span>inputA<\/span>[ <\/span>bar <\/span>];\r       else\r           <\/span>result<\/span>[ <\/span>bar <\/span>] = <\/span>inputB<\/span>[ <\/span>bar <\/span>];\r     }\r    return <\/span>result<\/span>;\r}<\/span><\/pre>\n
While the above approach works, using the IIF() function always provides a better and faster solution. The IIF() is very powerful and should be used whenever possible. Below are a few simple examples to get started. btw, It is highly unlikely that you will be able to improve on execution time by using a loop or writing a DLL. <\/p>\n
To color all bars that fall on a Monday White:<\/p>\n
Color <\/span>= <\/span>IIf<\/span>( <\/span>DayOfWeek<\/span>()==<\/span>1<\/span>, <\/span>colorWhite<\/span>, <\/span>colorBlack<\/span>);\r<\/span>Plot<\/span>( <\/span>C<\/span>, <\/span>"Close"<\/span>, <\/span>color<\/span>, <\/span>styleBar <\/span>);<\/span><\/pre>\n
IIF()s Can be nested. This example colors Monday bars White, Wednesday bars Blue and Friday bars Yellow:<\/p>\n
D <\/span>= <\/span>DayOfWeek<\/span>();\r<\/span>Color <\/span>= <\/span>IIf<\/span>(<\/span>D<\/span>==<\/span>1<\/span>, <\/span>colorWhite<\/span>, <\/span>IIf<\/span>(<\/span>D<\/span>==<\/span>3<\/span>, <\/span>colorBlue<\/span>, <\/span>IIf<\/span>(<\/span>D<\/span>==<\/span>5<\/span>, <\/span>colorYellow<\/span>, <\/span>colorBlack<\/span>)));\r<\/span>Plot<\/span>( <\/span>C<\/span>, <\/span>"Close"<\/span>, <\/span>color<\/span>, <\/span>styleBar <\/span>);<\/span><\/pre>\n
The IF() Statement<\/h3>\n
One of the most common applications for the if() is to select what you want to see on your chart:<\/p>\n
\rPlot<\/span>( <\/span>C<\/span>, <\/span>"Close"<\/span>, <\/span>colorBlack<\/span>, <\/span>styleBar <\/span>);\r<\/span>ShowMA10 <\/span>= <\/span>ParamToggle<\/span>( <\/span>"Moving Average"<\/span>, <\/span>"MA|EMA"<\/span>, <\/span>0 <\/span>);\r\rif ( <\/span>ShowMA10 <\/span>)\r{\r<\/span>Plot<\/span>( <\/span>MA<\/span>( <\/span>C<\/span>, <\/span>10 <\/span>), <\/span>"MA10"<\/span>, <\/span>colorWhite<\/span>, <\/span>styleLine <\/span>);\r}\relse\r{\r<\/span>Plot<\/span>( <\/span>EMA<\/span>( <\/span>C<\/span>, <\/span>10 <\/span>), <\/span>"MA10"<\/span>, <\/span>colorWhite<\/span>, <\/span>styleLine <\/span>);\r}\r<\/span><\/pre>\n
In the above example the IF() basically selects one of two sections of code.\u00a0 To select one of many options you could the use the else-if extension:<\/p>\n
\rSelectedIndicator <\/span>= <\/span>ParamList<\/span>( <\/span>"Show"<\/span>, <\/span>"MA10,MA50,MA100"<\/span>, <\/span>1 <\/span>);\r\rif ( <\/span>SelectedIndicator <\/span>== <\/span>"MA10" <\/span>)\r{\r<\/span>Plot<\/span>( <\/span>MA<\/span>( <\/span>C<\/span>, <\/span>10 <\/span>), <\/span>"MA10"<\/span>, <\/span>colorBlue<\/span>, <\/span>styleLine <\/span>);\r}\relse\rif ( <\/span>SelectedIndicator <\/span>== <\/span>"MA10" <\/span>)\r{\r<\/span>Plot<\/span>( <\/span>EMA<\/span>( <\/span>C<\/span>, <\/span>50 <\/span>), <\/span>"MA10"<\/span>, <\/span>colorRed<\/span>, <\/span>styleLine <\/span>);\r}\relse\rif ( <\/span>SelectedIndicator <\/span>== <\/span>"MA100" <\/span>)\r{\r<\/span>Plot<\/span>( <\/span>EMA<\/span>( <\/span>C<\/span>, <\/span>100 <\/span>), <\/span>"MA100"<\/span>, <\/span>colorYellow<\/span>, <\/span>styleLine <\/span>);\r}\r<\/span><\/pre>\n
The Switch() Statement<\/h3>\n
When there are many conditions, the lengthy If() expressions can become confusing, difficult to compose, and difficult to modify.  In such cases it is often better to use the Switch() statement. Using a simple Switch() the last example looks much cleaner:<\/p>\n
\rSelectedIndicator <\/span>= <\/span>ParamList<\/span>( <\/span>"Show"<\/span>, <\/span>"MA10,MA50,MA100"<\/span>, <\/span>1 <\/span>);\rswitch ( <\/span>SelectedIndicator <\/span>)\r{\r\rcase <\/span>"MA10"<\/span>:\r<\/span>Plot<\/span>( <\/span>MA<\/span>( <\/span>C<\/span>, <\/span>10 <\/span>), <\/span>"MA10"<\/span>, <\/span>colorBlue<\/span>, <\/span>styleLine <\/span>);\rbreak;\r\rcase <\/span>"MA50"<\/span>:\r<\/span>Plot<\/span>( <\/span>MA<\/span>( <\/span>C<\/span>, <\/span>50 <\/span>), <\/span>"MA50"<\/span>, <\/span>colorBlue<\/span>, <\/span>styleLine <\/span>);\rbreak;\r\rcase <\/span>"MA100"<\/span>:\r<\/span>Plot<\/span>( <\/span>MA<\/span>( <\/span>C<\/span>, <\/span>100 <\/span>), <\/span>"MA100"<\/span>, <\/span>colorBlue<\/span>, <\/span>styleLine <\/span>);\rbreak;\r}\r<\/span><\/pre>\n
There are times that you will have many individually named variables that you would like to process in a Switch() statement. Even though the Switch() can only accept a single variable name as argument you can use the method below to work around this limitation:<\/p>\n
<\/span>function <\/span>SayOnce<\/span>( <\/span>Text <\/span>)\r{\r    if ( <\/span>StaticVarGetText<\/span>( <\/span>"Lastsay" <\/span>) != <\/span>Text <\/span>)\r    {\r        <\/span>Say<\/span>( <\/span>Text<\/span>, <\/span>False <\/span>);\r        <\/span>StaticVarSetText<\/span>( <\/span>"LastSay"<\/span>, <\/span>Text <\/span>);\r    }\r}\r\r<\/span>RequestTimedRefresh<\/span>(<\/span>1<\/span>);\r<\/span>Trigger1 <\/span>= <\/span>ParamTrigger<\/span>( <\/span>"Trigger 1"<\/span>, <\/span>"TRIGGER1" <\/span>);\r<\/span>Trigger2 <\/span>= <\/span>ParamTrigger<\/span>( <\/span>"Trigger 2"<\/span>, <\/span>"TRIGGER2" <\/span>);\r<\/span>Trigger3 <\/span>= <\/span>ParamTrigger<\/span>( <\/span>"Trigger 3"<\/span>, <\/span>"TRIGGER3" <\/span>);\r<\/span>Trigger4 <\/span>= <\/span>ParamTrigger<\/span>( <\/span>"Trigger 4"<\/span>, <\/span>"TRIGGER4" <\/span>);\r\rswitch( <\/span>1 <\/span>)\r{\r    case <\/span>Trigger1<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"One" <\/span>);\r    break;\r\r    case <\/span>Trigger2<\/span>:\r    case <\/span>Trigger4<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"2 or 4" <\/span>);\r    break;\r\r    case <\/span>Trigger3<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"Three" <\/span>);\r    break;\r\r    default:\r    <\/span>SayOnce<\/span>( <\/span>"Default" <\/span>);\r    <\/span>\/\/ Here you can place code that will execute\r    \/\/ repeatedly while no other case is true\r<\/span>}<\/span><\/pre>\n
The Switch() argument can be a string or number. Using strings makes code easier to read. Another advantage of using the Switch() is that they format nicely using Edit->Prettify Selection in you editor window, using too many else-if statements tends to run the if()s of the page. As shown above you can stack case statements to have multiple conditions trigger the same task. <\/p>\n
To implement a simple State Machine you pass the system “state” to the Switch(). This way you can have any event trigger any sequence of tasks, and do so in any desired order. In a real application the SayOnce() functions in the example code below would be replaced by the task you want to be performed in the state. The next state would usually be conditionally set inside each state, for example you only want to proceed to the next state after an order is filled, or a price is crossed. You can use multilevel Switch()s or if()s inside each case section. This use of Switch() statements is very useful in Automated Trading systems. For example to process order status (Pending, Filled, Error, etc) and parsing TWS error messages. <\/p>\n
Since states are saved in a Static Variables they remain valid over multiple AFL executions, and can last indefinitely. You can also save states in Persistent Variables.<\/p>\n
States are processed in sequential afl executions, i.e., if you change the state in a case statement this next state will be processed in the next AFL refresh. In some applications this delay can cause problems. To ensure responsive code you might want to use a 0.1 second refresh rate. You could remove the delay by using the Switch() inside a loop\/while statement, anf loop until a stable state is reached.  <\/p>\n
<\/span>function <\/span>SayOnce<\/span>( <\/span>Text <\/span>)\r{\r    if ( <\/span>StaticVarGetText<\/span>( <\/span>"Lastsay" <\/span>) != <\/span>Text <\/span>)\r    {\r        <\/span>Say<\/span>( <\/span>Text<\/span>, <\/span>False <\/span>);\r        <\/span>StaticVarSetText<\/span>( <\/span>"LastSay"<\/span>, <\/span>Text <\/span>);\r    }\r}\r\r<\/span>RequestTimedRefresh<\/span>(<\/span>1<\/span>);\rif( <\/span>ParamTrigger<\/span>( <\/span>"Reset System"<\/span>, <\/span>"RESET" <\/span>) ) <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"RESET" <\/span>);\rif( <\/span>ParamTrigger<\/span>( <\/span>"Task 1"<\/span>, <\/span>"TASK 1" <\/span>) ) <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"TASK1" <\/span>);\rif( <\/span>ParamTrigger<\/span>( <\/span>"Task 2"<\/span>, <\/span>"TASK 2" <\/span>) ) <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"TASK2" <\/span>);\rif( <\/span>ParamTrigger<\/span>( <\/span>"Task 3"<\/span>, <\/span>"TASK 3" <\/span>) ) <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"TASK3" <\/span>);\r\r<\/span>State <\/span>= <\/span>StaticVarGetText<\/span>( <\/span>"State" <\/span>);\rswitch( <\/span>State <\/span>)\r{\r    case <\/span>"RESET"<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"Reset" <\/span>);\r    <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"READY" <\/span>);\r    break;\r\r    case <\/span>"READY"<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"Ready" <\/span>);\r    <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"IDLE" <\/span>);\r    break;\r\r    case <\/span>"TASK1"<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"Task 1" <\/span>);\r    <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"IDLE" <\/span>);\r    break;\r\r    case <\/span>"TASK2"<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"Task 2" <\/span>);\r    <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"TASK1" <\/span>);\r    break;\r\r    case <\/span>"TASK3"<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"Task 3" <\/span>);\r    <\/span>StaticVarSetText<\/span>( <\/span>"State"<\/span>, <\/span>"TASK2" <\/span>);\r    break;\r\r    case <\/span>"IDLE"<\/span>:\r    <\/span>SayOnce<\/span>( <\/span>"Idle" <\/span>);\r    break;\r}<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"
Many newcomers to AFL are confused by the IF(), IIF() and Switch(). This post gives a few simple examples of their use. The IF() and Switch() are program flow control statements, the IIF() is a function that acts on all elements of an input array and returns an output array. In all but the simplest […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[],"_links":{"self":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/2210"}],"collection":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/comments?post=2210"}],"version-history":[{"count":77,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/2210\/revisions"}],"predecessor-version":[{"id":3520,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/2210\/revisions\/3520"}],"wp:attachment":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/media?parent=2210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/categories?post=2210"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/tags?post=2210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}