My Pivot - Resistance -Support Calculator

HI JOY MITALI, PKJHA,.. and all those ppl whp need not to load data manually. Can any body tell me how to load EoD file and use Symbol Box.

wht I doing right now.....

selected " ENTER OHLC FROM EoD FILE"----- then click on " SELECT DIR.... FILE"---- WRITE NAME OF SYMBOL IN SYMBOL BOX---- HITTING BUTTON --" LOAD OHLC DATA".

NOW REAL PROBLEM STRTS... NOTHING IN "OPEN" .. HIGH ,, LOW , CLOSE BOX.

I ALWAYS AFTER THT NEED TO ENTER PRICES MANUALLY.... WHYYYY??

CAN ANY ONE TELL ME WHY.

I TRIED BOTH DATA FILE FROM PKJHA'S UTILITY AND FILE FRM NSE IN CSV FORMAT. BUT NO GAIN...


PLZ HELP ME OUT


CHINTAN

Hi,

Does anybody know of a Pivot calculator that calculates pivots based on Camarrilla Eqns ? Can be easily implemented in Excel, but a small desktop application that

i) loads the symbols from a database
ii) has dropdowns to select the symbol, date & timeframe (daily, wkly, mthly etc)
iii)loads the HLC data from same database as in (i) (based on the TF selected)
iv) allows the computed pivot values (alongwith Symbol, date & TF) to be saved to a txt file /Excel sheet
v) Has a 'Compute' & 'Save' button (with obvious functionality)

would be handy.

(To avoid complexity, only daily data can be allowed to begin with. Later other TFs can be incorporated)

Will the S/W development experts in the forum give it a thought?

Regards,
Kalyan.

P.S. : Can also allow computing other kinds of Pivots (Floor, Woodies etc.) through another 'Pivot Type' dropdown. (The corresponding formula can then be selected internally through a CASE or IF-ELSE construct. The 'Pivot Type'/alias will also need to be saved in this case to avoid confusion later )

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.

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

Hi..

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

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

sharad