Generate Buy Signal with Camarila Pivots

[ranahimanshu57]

Hiii,
Trying to generate Buy Signal when Current Month ML3 of Camarilla is greater than last month MH4 Camarilla pivot.
Using this code but not getting any signal

PMH =  TimeFrameGetPrice("H", inMonthly, -1);    
PML =  TimeFrameGetPrice("L", inMonthly, -1);
PMC =  TimeFrameGetPrice("C", inMonthly, -1);

MH5 = (PMH/PML) * PMC ;
MH4 = PMC + (PMH - PML) * 1.1 / 2.0;
MH3 = PMC + (PMH - PML) * 1.1 / 4.0;
ML3 = PMC - (PMH - PML) * 1.1 / 4.0;
ML4 = PMC - (PMH - PML) * 1.1 / 2.0;
ML5 = PMC - (MH5 - PMC);

Buy = (ML3>ref (MH3,-1))AND Cross(C,MH3);

[fxshrat]

ML3 being greater than Ref(ML3,-1) of posted code can only differ at start of each new month because ML3 is a "straight line" (if ML3 being drawn on chart) for entire month in shorter intervals. So Cross (which is impulse signal) would have to return TRUE at start of month too in order to make Buy returning TRUE (if current cam is greater than previous one).

So how likely is that one to occur? Not so much, isn't it.

So you have to set start of month flag and use ValueWhen to keep cam result of start of month available from start to end of month (in your code case).

PMH =  TimeFrameGetPrice("H", inMonthly, -1);    
PML =  TimeFrameGetPrice("L", inMonthly, -1);
PMC =  TimeFrameGetPrice("C", inMonthly, -1);

MH5 = (PMH/PML) * PMC ;
MH4 = PMC + (PMH - PML) * 1.1 / 2.0;
MH3 = PMC + (PMH - PML) * 1.1 / 4.0;
ML3 = PMC - (PMH - PML) * 1.1 / 4.0;
ML4 = PMC - (PMH - PML) * 1.1 / 2.0;
ML5 = PMC - (MH5 - PMC);

mth = Month();
new_mth = mth != Ref(mth,-1);
Buy = ValueWhen(new_mth, ML3>ref (MH3,-1)) AND Cross(C,MH3);

[ranahimanshu57]

@fxshrat

mth = Month();
new_mth = mth != Ref(mth,-1);
Buy = ValueWhen(new_mth, ML3>ref (MH3,-1)) AND Cross(C,MH3);

Thanks @fxshrat ....

[ranahimanshu57]

How to refer value of Last to Last month? I was using below code but not working.

mth = Month();
new_mth = mth != Ref(mth,-1);
new_mth1 = Month(1)!=(Ref(mth,-2);
Longtrade = (ValueWhen(new_mth,MH3<Ref(MH3,-1)) AND ValueWhen(new_mth1,Ref(MH3,-1)<Ref(MH3,-2)) AND Cross(C,MH3));

[portfoliobuilder]

@ranahimanshu57 your formula is not working the way you think so you need to learn how to debug your code.

How do I debug my formula?

Continuing the discussion from How do I learn AFL?: Many new users with zero programming experience struggle when their formula works incorrectly. Here are few hints that everyone should use to make finding errors easier. First of all: you have to get insight into what the formula is actually doing, not what you think it does. Typically new user has no idea what is happening inside. Pretty often you make an assumption that things work one way but in fact they work differently. Do not assume t…

In your case specifically perhaps you could learn how to properly use ValueWhen.
https://www.amibroker.com/guide/afl/valuewhen.html

// your code was using
ValueWhen(new_mth, ML3>ref (MH3,-1))

I'm not sure I understand what you mean "Last to Last month". It appears to me that you want to know value the previous time your Expression was true.
ValueWhen(EXPRESSION, ARRAY, n = 2 )

[fxshrat]

@ranahimanshu57

I was using below code but not working.

mth = Month();
new_mth = mth != Ref(mth,-1);
new_mth1 = Month(1)!=(Ref(mth,-2);
Longtrade = (ValueWhen(new_mth,MH3<Ref(MH3,-1)) AND ValueWhen(new_mth1,Ref(MH3,-1)<Ref(MH3,-2)) AND Cross(C,MH3));

@portfoliobuilder

In your case specifically perhaps you could learn how to properly use ValueWhen .
https://www.amibroker.com/guide/afl/valuewhen.html

// your code was using
ValueWhen(new_mth, ML3>ref (MH3,-1))

It appears to me that you want to know value the previous time your Expression was true.
ValueWhen(EXPRESSION, ARRAY, n = 2 )

No, multiple Valuewhen calls are not good way to get to sum of values / occurences.
Doing this

Buy = ValueWhen(new_mth,MH3<Ref(MH3,-1)) AND 
      ValueWhen(new_mth,MH3<Ref(MH3,-1), 2) AND 
      ValueWhen(new_mth,MH3<Ref(MH3,-1), 3) AND 
      ValueWhen( ....

is just awful and inflexible way of handling repetitions.

Instead (in case of existing code of post #1) use Sparse* and Sum.

Or simply do complete rewrite and use TimeFrameSet and Sum but not TimeFrameGetPrice as you did in first post.

Isn't this much cleaner than multiple ValueWhen and new_mth and what not code mumbo jumbo?

period = 3;
TimeFrameSet(tmfrm = inMonthly);
	MH5 = (H/L) * C;
	perc_range = (H - L) * 1.1;
	MH4 = C + perc_range / 2.0;
	MH3 = C + perc_range / 4.0;
	ML3 = C - perc_range / 4.0;
	ML4 = C - perc_range / 2.0;
	ML5 = C - (MH5 - C);
	rc_cond = Sum(ROC(ML3,1)<0, period) == period;
TimeFrameRestore();

MH3 = TimeFrameExpand(MH3, tmfrm);
rc_cond = TimeFrameExpand(rc_cond, tmfrm);

Buy = rc_cond AND Cross(C,MH3);

[ranahimanshu57]

@fxshrat, @portfoliobuilder Thanks.... I can use both the codes...........

Can you please suggest some book/site for learning the AFL programming with examples?? I am novice in AFL programming.

[portfoliobuilder]

@ranahimanshu57 many resources listed in the posts of this thread,

How do I learn AFL?

Programming in AmiBroker Formula Language (AFL) is not that different from programming in any other language. If you are looking for general introduction to programming any language tutorial would do because programming is not about the syntax but about general concepts such as variables, functions, loops, etc. AmiBroker Formula Language is syntactically similar to plain old C and JScript but easier to use. It also has lots of functions that are trading related but general concepts are common i…

and although the above thread mentions some books, there are additional books listed in this thread,

AmiBroker Books

Here is the thread where books featuring AmiBroker are listed. Feel free to add your own suggestions

[fxshrat]

You don't need books by chief advertisers. All you need is AB manual and this forum.
All those books guys try to make money from existing information (and even copy existing code 1:1).

[empottasch]

i use Camarilla pivots also and I think you mean something different than is answered here.

first off all your question is not clear because you first talk about current month ML3 and last month MH4, but then in the buy line you use the current month ML3 and last month MH3. So I assume you mean current month ML3 and last month MH3. Then below the code how you calculate this.

This months levels MH3 level is called MH30 and last months MH3 level is called MH31

// current month's levels
PMH =  TimeFrameGetPrice("H", inMonthly, -1);    
PML =  TimeFrameGetPrice("L", inMonthly, -1);
PMC =  TimeFrameGetPrice("C", inMonthly, -1);

MH50 = (PMH/PML) * PMC ;
MH40 = PMC + (PMH - PML) * 1.1 / 2.0;
MH30 = PMC + (PMH - PML) * 1.1 / 4.0;
ML30 = PMC - (PMH - PML) * 1.1 / 4.0;
ML40 = PMC - (PMH - PML) * 1.1 / 2.0;
ML50 = PMC - (MH50 - PMC);

// the levels 1 month before current month 
PMH =  TimeFrameGetPrice("H", inMonthly, -2);    
PML =  TimeFrameGetPrice("L", inMonthly, -2);
PMC =  TimeFrameGetPrice("C", inMonthly, -2);

MH51 = (PMH/PML) * PMC ;
MH41 = PMC + (PMH - PML) * 1.1 / 2.0;
MH31 = PMC + (PMH - PML) * 1.1 / 4.0;
ML31 = PMC - (PMH - PML) * 1.1 / 4.0;
ML41 = PMC - (PMH - PML) * 1.1 / 2.0;
ML51 = PMC - (MH51 - PMC);

GraphXSpace = 5;
SetChartOptions( 0, chartShowDates );
Plot( C, "\nPrice", IIf( C > O, ColorRGB( 0, 255, 0 ), IIf( C <= O, ColorRGB( 255, 0, 0 ), colorLightGrey ) ), 64, Null, Null, 0, 0 );

Plot( MH30, "MH30", ColorRGB( 0, 255, 0 ), styleThick, Null, Null, 0, -1 );
Plot( ML30, "ML30", ColorRGB( 255 - 0, 255 - 255, 255 - 0 ), styleThick, Null, Null, 0, -1 );
Plot( MH40, "MH40", ColorRGB( 0, 100, 0 ), styleThick, Null, Null, 0, -1 );
Plot( ML40, "ML40", ColorRGB( 255 - 0, 255 - 100, 255 - 0 ), styleThick, Null, Null, 0, -1 );

Plot( MH31, "MH31", ColorWhite, styleThick | styleDots, Null, Null, 0, -1 );

Buy = Cross( C, MH30 ) AND ML30 > MH31;
BuyPrice = C;

PlotShapes( IIf( Buy, shapeUpArrow, shapeNone ), colorDarkGreen, 0, L, -15 );
PlotShapes( IIf( Buy, shapeSmallCircle, shapeNone ), colorWhite, 0, BuyPrice, 0 );

[fxshrat]

No Ed, it is not different than what he was posting as code (with syntax errors).

This is what he posted

mth = Month(); 
new_mth = mth != Ref(mth,-1); 
new_mth1 = Month(1)!=(Ref(mth,-2); 
Longtrade = (ValueWhen(new_mth,MH3<Ref(MH3,-1)) AND 
             ValueWhen(new_mth1,Ref(MH3,-1)<Ref(MH3,-2)) AND 
             Cross(C,MH3));

---

Now (different example for explanation).... this one

cond1 = C<Ref(C,-1) AND Ref(C,-1)<Ref(C,-2);

is getting the same end result as this one

cond2 = Sum(ROC(C,1)<0, 2) == 2;

First one is inflexible complicated way while second one can be applied to any period quickly.

Here is proof that both are the same (you may use explorer also)

---

And your one is different one than what he posted later yesterday as it it just compares one month to previous one time (also you use ML3 > previous MH3 while in his code he was using MH3 only and smaller as).

But I guess you refer to first post of thread.

But also your long one can be simplified to just this

TimeFrameSet(tmfrm = inMonthly);   
   MH5 = (H/L) * C;
   perc_range = (H - L) * 1.1;
   MH4 = C + perc_range / 2.0;
   MH3 = C + perc_range / 4.0;
   ML3 = C - perc_range / 4.0;
   ML4 = C - perc_range / 2.0;
   ML5 = C - (MH5 - C);
   rc_cond = ML3 > Ref(MH3,-1);
TimeFrameRestore();

MH3 = TimeFrameExpand(MH3, tmfrm);
rc_cond = TimeFrameExpand(rc_cond, tmfrm);

Buy = rc_cond AND Cross(C,MH3);

Plot( C, "Price", colorDefault, styleBar );
PlotShapes( Buy * shapeUpArrow,colorGreen, layer = 0, L );

Or by using expandFirst (as the codes of this thread using TimeFrameGetPrice use expandFirst also, so just showing that you can do it differently also)

TimeFrameSet(tmfrm = inMonthly);   
   H = Ref(H,-1);
   L = Ref(L,-1);
   C = Ref(C,-1);   
   MH5 = (H/L) * C;
   perc_range = (H - L) * 1.1;
   MH4 = C + perc_range / 2.0;
   MH3 = C + perc_range / 4.0;
   ML3 = C - perc_range / 4.0;
   ML4 = C - perc_range / 2.0;
   ML5 = C - (MH5 - C);
   rc_cond = ML3 > Ref(MH3, -1);
TimeFrameRestore();

MH3 = TimeFrameExpand(MH3, tmfrm, expandFirst);
rc_cond = TimeFrameExpand(rc_cond, tmfrm, expandFirst);

Buy = rc_cond AND Cross(C,MH3);

Plot( C, "Price", colorDefault, styleBar );
PlotShapes( Buy * shapeUpArrow,colorGreen, layer = 0, L);

Results are same ones as of your longer code

(BTW code of 2nd post is getting same result too already)

[empottasch]

I didn't read your whole post but I didn't look at his code but at his description. Maybe I am wrong but what i think he means is that he wants to buy at the cross of MH3 only if this months ML3 is greater than the MH3 level of the prior month.

So because he uses Monthly intervals he probably trades within the daily or weekly interval. So the chart in the daily will look like this (see below). So the price crosses MH30 and is only valid because ML30 is greater than MH31. If I misunderstood then my apologies but the question was also not particularly clear (as per usual). Prior to my first answer I quickly ran your code and I was not getting the same signals my code produces and therefor I assumed you interpreted his question differently. But since I use Camarilla levels myself I think he means it like I showed in my code.

[fxshrat]

Once again...
code of 2nd post returns same result as your code (just with difference of yours being more code). Also code of post #11 returns same results. I have put all three ones into one AFL with explorer output.

Just do explore:

/// version 1
/// https://forum.amibroker.com/t/generate-buy-signal-with-camarila-pivots/20737/2
PMH =  TimeFrameGetPrice("H", inMonthly, -1);    
PML =  TimeFrameGetPrice("L", inMonthly, -1);
PMC =  TimeFrameGetPrice("C", inMonthly, -1);

MH5 = (PMH/PML) * PMC ;
MH4 = PMC + (PMH - PML) * 1.1 / 2.0;
MH3 = PMC + (PMH - PML) * 1.1 / 4.0;
ML3 = PMC - (PMH - PML) * 1.1 / 4.0;
ML4 = PMC - (PMH - PML) * 1.1 / 2.0;
ML5 = PMC - (MH5 - PMC);

mth = Month();
new_mth = mth != Ref(mth,-1);
Buy1 = ValueWhen(new_mth, ML3>ref (MH3,-1)) AND Cross(C,MH3);


/// ################################################################
/// version 2
/// @link  https://forum.amibroker.com/t/generate-buy-signal-with-camarila-pivots/20737/11

TimeFrameSet(tmfrm = inMonthly);	
	H = Ref(H,-1);
	L = Ref(L,-1);
	C = Ref(C,-1);	
	MH5 = (H/L) * C;
	perc_range = (H - L) * 1.1;
	MH4 = C + perc_range / 2.0;
	MH3 = C + perc_range / 4.0;
	ML3 = C - perc_range / 4.0;
	ML4 = C - perc_range / 2.0;
	ML5 = C - (MH5 - C);
	rc_cond = ML3 > Ref(MH3, -1);
TimeFrameRestore();

MH3 = TimeFrameExpand(MH3, tmfrm, expandFirst);
rc_cond = TimeFrameExpand(rc_cond, tmfrm, expandFirst);
Buy2 = rc_cond AND Cross(C,MH3);



/// ################################################################
/// @empottasch version
/// @link https://forum.amibroker.com/t/generate-buy-signal-with-camarila-pivots/20737/10

// current month's levels
PMH =  TimeFrameGetPrice("H", inMonthly, -1);   
PML =  TimeFrameGetPrice("L", inMonthly, -1);
PMC =  TimeFrameGetPrice("C", inMonthly, -1);

MH50 = (PMH/PML) * PMC ;
MH40 = PMC + (PMH - PML) * 1.1 / 2.0;
MH30 = PMC + (PMH - PML) * 1.1 / 4.0;
ML30 = PMC - (PMH - PML) * 1.1 / 4.0;
ML40 = PMC - (PMH - PML) * 1.1 / 2.0;
ML50 = PMC - (MH50 - PMC);

// the levels 1 month before current month 
PMH =  TimeFrameGetPrice("H", inMonthly, -2);
PML =  TimeFrameGetPrice("L", inMonthly, -2);
PMC =  TimeFrameGetPrice("C", inMonthly, -2);

MH51 = (PMH/PML) * PMC ;
MH41 = PMC + (PMH - PML) * 1.1 / 2.0;
MH31 = PMC + (PMH - PML) * 1.1 / 4.0;
ML31 = PMC - (PMH - PML) * 1.1 / 4.0;
ML41 = PMC - (PMH - PML) * 1.1 / 2.0;
ML51 = PMC - (MH51 - PMC);

Buy3 = Cross( C, MH30 ) AND ML30 > MH31;

/// ################################################################
/// Explorer output

Filter = buy1 OR buy2 OR buy3;

AddSummaryRows(1, 1);

for( i = 1; i <= 3; i++ )
	AddColumn(VarGet("Buy"+i), "Buy" + i, 1 );

Exploration result run on 500 symbols
So it is rock solid clear that all those three versions return same signals at same time.

[empottasch]

ah ok, sorry about that. I didn't go into details of your code, I just ran it and it seemed to give different signals than mine. But we have the same interpretation of his question so thats good

[ranahimanshu57]

Hii, I am not getting same results for the solution provided earlier. Please find below both the codes. I have mentioned below my code.
In addition, while plotting Buy signal, I am unable to remove additional signal while already in the trade.

//Monthly High, Low, Close
PMH =  TimeFrameGetPrice("H", inMonthly, -1);    
PML =  TimeFrameGetPrice("L", inMonthly, -1);
PMC =  TimeFrameGetPrice("C", inMonthly, -1);
PMH1 =  TimeFrameGetPrice("H", inMonthly, -2);    
PML1 =  TimeFrameGetPrice("L", inMonthly, -2);
PMC1 =  TimeFrameGetPrice("C", inMonthly, -2);

// Monthly Camarilla

MH5 = (PMH/PML) * PMC ;
MH4 = PMC + (PMH - PML) * 1.1 / 2.0;
MH3 = PMC + (PMH - PML) * 1.1 / 4.0;
ML3 = PMC - (PMH - PML) * 1.1 / 4.0;
ML4 = PMC - (PMH - PML) * 1.1 / 2.0;
ML5 = PMC - (MH5 - PMC);
MH32 = PMC1 + (PMH1 - PML1) * 1.1 / 4.0;

mth = Month();
new_mth = mth != Ref(mth,-1);
Buy1 = (ValueWhen(new_mth,MH3<Ref(MH3,-1)) AND ValueWhen(new_mth,MH3<Ref(MH3,-2),2) AND Cross(C,MH3));

===============================================================


period = 3;
TimeFrameSet(tmfrm = inMonthly);
	MH5 = (H/L) * C;
	perc_range = (H - L) * 1.1;
	MH4 = C + perc_range / 2.0;
	MH3 = C + perc_range / 4.0;
	ML3 = C - perc_range / 4.0;
	ML4 = C - perc_range / 2.0;
	ML5 = C - (MH5 - C);
	rc_cond = Sum(ROC(ML3,1)<0, period) == period;
TimeFrameRestore();

MH3 = TimeFrameExpand(MH3, tmfrm);
rc_cond = TimeFrameExpand(rc_cond, tmfrm);

Buy2 = rc_cond AND Cross(C,MH3);


Filter =Buy1 OR Buy2;

AddSummaryRows(1, 1);

for( i = 1; i <= 2; i++ )
	AddColumn(VarGet("Buy"+i), "Buy" + i, 1 );
=========================================================

Stoplength = 4*ATR(10);

Buy =Buy1;
Sell = 0;


PlotShapes(Buy*shapeSquare,colorGreen, 0, L, Offset=-40);
PlotShapes(Buy*shapeSquare,colorLime, 0,L, Offset=-50);
PlotShapes(Buy*shapeUpArrow,colorWhite, 0,L, Offset=-45);

ApplyStop(stopTypeTrailing,stopModePoint,Stoplength,2,True,1);

Equity(1,0);
intrade=Flip(Buy,Sell);
SetOption("Everybarnullcheck", True);
stopline = IIf(intrade,HighestSince(Buy,H-Stoplength),Null);
Plot(stopline,"Stoploss",colorRed,styleLine);

[ranahimanshu57]

[fxshrat]

@ranahimanshu57

I am not getting same results for the solution provided earlier.

You should not just copy and paste but actually understand code.

1. I have used period = 3 on purpose. And we can see expected result now of you just copy & pasting without actually understanding. You just look back at two occurrences and compare it to three lookback periods.
2. I was using ML3 variable. You use MH3 variable
3. You use default expandFirst (in TimeFrameGetPrice). I use default expandLast.

Again, don't just copy & paste but read documentation and learn basics.

And again Sum function is way to go to for getting results of whatever lookback period. One line of code and one single function.

So in the end if you compare apples to apples you will get same results on e.g. 500 symbols.

[ranahimanshu57]

Got it thanks.. By Using "expandlast" in "Timeframeexpand", it is not providng signals on the last day of the month.

Unable to remove excess Buy signals using below code. Can you please provide some hint. I am using Exrem but in this case Sell =0. How to apply exrem for Applystop

Stoplength = 4*ATR(10);

Buy =Buy1;
Sell = 0;
Buy=Exrem(Buy,Sell);

PlotShapes(Buy*shapeSquare,colorGreen, 0, L, Offset=-40);
PlotShapes(Buy*shapeSquare,colorLime, 0,L, Offset=-50);
PlotShapes(Buy*shapeUpArrow,colorWhite, 0,L, Offset=-45);

ApplyStop(stopTypeTrailing,stopModePoint,Stoplength,2,True,1);

Equity(1,0);
intrade=Flip(Buy,Sell);
SetOption("Everybarnullcheck", True);
stopline = IIf(intrade,HighestSince(Buy,H-Stoplength),Null);
Plot(stopline,"Stoploss",colorRed,styleLine);

[ranahimanshu57]

Please help me on above query....

[TrendSurfer]

@ranahimanshu57,

Only users with "Verified Badge" are allowed to post on this forum.

Search "Verified Badge" for more information on how to get verified.