|
PureBytes Links
Trading Reference Links
|
Thanks, Terry.:) I'd almost given up, but I think I can get there
now. Your short but clear explanation of AB's array processing
characteristic is something I "get" now that I didn't before.
Luck,
Sebastian
--- In amibroker@xxxxxxxxxxxxxxx, Terry <MagicTH@xxxx> wrote:
> Sebastian,
>
> Your line of code DEFINES Cond3, but you are trying to reference
the
> prior value of Cond3 within the definition of condition 3, hence
the
> error. I had this same difficulty coming to AB from Excel. The
problem
> here is understanding the ARRAY nature of AB.
>
> There are a couple of ways around this and one way is to use
looping
> code where you define each bar one bar at a time. Then your
reference to
> yesterday's value of Cond3 IS valid while trying to set today's
value
> because yesterday's value has already been defined. In array
processing
> no values are defined so you cannot refer to yesterday's C3.
(Arrays
> don't process one bar at a time, they process all bars at once.)
>
> The other way is to define Cond3 using only Cond1 and Cond2 as in:
>
> Cond3 = Flip(Cond1,Cond2); //Flip fills in all bars between
conditions with same value
>
> To display the result you will have to convert numeric values to
string
> values with NumToStr(). Your other choice is to PLOT the results.
>
> Note: your parenthesis and use of IIF statements in your example
below
> is incorrect. The format you used is:
> IF(A,1,IF(B) AND IF(C),0,D);
> It needs to be:
> IF(A,1,IF(B AND C),0,D));
> Terry
>
> sebastiandanconia wrote:
>
> >In Excel I have an "IF" statement that tells what to display in a
> >cell, like this:
> >
> >=IF(E65>MAX(E25:E64),1,IF(AND(H64=1,E65<MIN(E45:E64)),0,H64))
> >
> >The "E" column is closing security prices, the "H" column displays
a 1
> >or 0 telling me whether the trend is up or down, and the formula
> >continues all the way down to the last row of closing prices. If
> >there's no change from the previous day's value in column "H", the
> >previous day's value is displayed.
> >
> >I don't need AB to do anything with the result, just display the
> >result, so I think I need to use "IIF" and not "IF-ELSE" or
looping.
> >(??)
> >
> >I have Cond1 defined as being the upside breakout (MAX) and Cond2
as
> >the downside breakdown (MIN). Cond3 is the IIF statement I'm
trying to
> >create, like this:
> >
> >Cond3=IIF(Cond1==1,1,IIF(Ref(Cond3,-1)==1 AND IIF(Cond2==1)),0,Ref
> >(Cond3,-1);
> >
> >Then I'll use Cond3's output of 1 or 0 as a binary signal to
identify
> >uptrend or downtrend.
> >
> >I can't get it to work for me, though. The AFL checker tells me
I'm
> >using Cond3 before it's been initialized, but I don't know how to
get
> >around that.
> >
> >TIA for any guidance, and it's okay to laugh if I did something
really
> >dumb.:)
> >
> >
> >Luck to all,
> >
> >Sebastian
> >
> >
------------------------ Yahoo! Groups Sponsor --------------------~-->
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|