My Pivot - Resistance -Support Calculator

[kkseal]

hi Kalyan, in Joymitali's pivot calculator .... u can calculate Camarila Pivot also....

try it..


chintan

Yes i can, but from one of your own previous post (#51) it seems this one has problem loading data from a single EOD file, whereas i suggest using upto last 1 mth data from the database we already have.

Regards,
Kalyan.

 

[chintan786]

Hi joy... I'm using ur calculator and find it very useful... I have one query regarding Camarilla Pivot Point.

I want to know wht formula u have used for Carmilla Pivot... Because I am having a Pivot AFL whch is based on classical formula .... in this AFL i want to use Carmilla Pivot Point.

I have done some net practise .... and get some mixed results.

I am pasting my modified AFL...

/***************************************/
/*PIVOT POINTS ver 1.1 written by Avi b*/
/***************************************/

// please note: i use the current value for the NEXT DAY
h1= SelectedValue (Ref(H,0) );
l1= SelectedValue (Ref(L,0) );
c1= SelectedValue (Ref(C,0) );

// PIVOT Calculation
p = ( H1+ L1 + C1 )/3;
s1 = p - (H1 - L1)*1.1/12;
r1 = p + (H1-L1)*1.1/2;
s2 = p -(H1 - L1)*1.1/6;
s3 = p - (H1-L1)*1.1/2;
r2 = p +(H1 - L1)*1.1/6;
r3 = p +(H1-L1)*1.1/12;

// PIVOT mid points
MIDR1 = (P+R1)/2;
MIDR2 = (R1+R2)/2;
MIDR3 = (R2+R3)/2;
MIDS1 = (P+S1)/2;
MIDS2 = (S1+S2)/2;
MIDS3 = (S2+S3)/2;


// Graphs & values plot
Plot (p,"Pivot",25,1);
Plot (r1,"R1",12,1);
Plot (r2,"R2",12,1);
Plot (r3,"R3",12,1);
Plot (s1,"S1",3,1);
Plot (s2,"S2",3,1);
Plot (s3,"S3",3,1);

/*
Plot (MIDR1,"midr1",12,32);
Plot (MIDR2,"midr2",12,32);
Plot (MIDR3,"midr3",12,32);
Plot (MIDS1,"mids1",12,32);
Plot (MIDS2,"mids2",12,32);
Plot (MIDS3,"mids3",12,32);
*/

Plot (C,"Close",16,64);
// side might be ajusted depends on data array
Hight =33;
side = Param("side",73,0,1000,1);

for( i = 0; i < BarCount; i++ )
{
if(i+side== BarCount) PlotText( "Pivot = "+P, i+Hight,P, colorGreen );
if(i+side== BarCount) PlotText( "R1 = "+R1, i+Hight,R1, 12 );
if(i+side== BarCount) PlotText( "R2 = "+R2, i+Hight,R2, 12 );
if(i+side== BarCount) PlotText( "R3 = "+R3, i+Hight,R3, 12 );
if(i+side== BarCount) PlotText( "S1 = "+S1, i+Hight,S1, 3);
if(i+side== BarCount) PlotText( "S2 = "+S2, i+Hight,S2, 3 );
if(i+side== BarCount) PlotText( "S3 = "+S3, i+Hight,S3, 3 );
}

// text section

"HIGH /LOW /CLOSE = " +H +" / "+ L+" / "+ C +"\n";
"H1 /L1 /C1 = " +H1 +" / "+ L1+" / "+ C1 +"\n";

"R3 = " +R3;
"midr3 = " +MIDR3;
"R2 = " +R2;
"midr2 = " +MIDR2;
"R1 = " +R1;
"midr1 = " +MIDR1;
"*************";
"p = " +p;
"*************";
"mids1 = " +MIDS1;
"S1 = " +S1;
"mids2 = " +MIDS2;
"S2 = " +S2;
"mids3 = " +MIDS3;
"S3 = " +S3;



the actula formula I get for carmilla is..

Camarilla Pivot Points

R4 = C + RANGE * 1.1/2
R3 = C + RANGE * 1.1/4
R2 = C + RANGE * 1.1/6
R1 = C + RANGE * 1.1/12
PP = (HIGH + LOW + CLOSE) / 3
S1 = C - RANGE * 1.1/12
S2 = C - RANGE * 1.1/6
S3 = C - RANGE * 1.1/4
S4 = C - RANGE * 1.1/2


in this first I replaced the range by ( H1 - L1) in abv formula ... results are horrible..

then replacde C1 by p... then also things cme in line but how much reliable they are. only u can tell me.
Chintan

 

[santoshkj]

Hi..

Good Job....Keep it going...Thanks

 

[sharadkarkar]

Thanks joy,
i will use it definately. as i m using my own developed applications which i have made in excel...

sharad

 

[abhishakg]

Dear Joi

I am unable to open your calc. its saying fpr password. Tell me password for this.

Thanks
Abhishak Gupta

Hi all,
I have made a Pivot--Resistance -Support Calculator---which I whish to share with everybody-----The work is not complete--still in progress---

Even though a lot of such calculators r present in the net-----but most of them r very simple----Only one of them I found interesting---on whose basis I have made this calculator-----

I m sure ---when this entire project gets completed-----this will become a real handy tool in trading---specially for those ---who cannot get hold of expensive softwares-----

I will be more than happy---if I get a few responses---Critisisms and suggestions ---regarding what more implementations will transform it to a very good tool----r truely welcome---
Regards,
joy_mitali

 

[raja281]

can any one give ur support and resistance calculator to me.....

 

[kpprakash24]

Yes, I am also getting the same msg "macros disabled", please help me to open... I am using MS Office 2007

 

[padhyesanjeev]

Hi Joy, thanks, you r doing gr8 job
sanju

 

[hello_betu]

Thanks for sharing such a wonderful file.

Can anyone please explain what is meant by " Con-1, Con-2,Con-3,Con-4,Con-5,Con-6 " in columns relating to Buy Trigger price and Sell trigger price.That will help me to understand and utilize the file well.

Thanks !

 

[ravinder_1215]

Hi all,
I have made a Pivot--Resistance -Support Calculator---which I whish to share with everybody-----The work is not complete--still in progress---

Even though a lot of such calculators r present in the net-----but most of them r very simple----Only one of them I found interesting---on whose basis I have made this calculator-----

I m sure ---when this entire project gets completed-----this will become a real handy tool in trading---specially for those ---who cannot get hold of expensive softwares-----

I will be more than happy---if I get a few responses---Critisisms and suggestions ---regarding what more implementations will transform it to a very good tool----r truely welcome---
Regards,
joy_mitali

Hi Mitali,

Can you tell me the passord for your calculator, it will be great helpfull for me

Thanks in advance!