Excels for Help, in trading !!!

ajeetsingh

Well-Known Member
#12
Cash Excel update:

Today again happened the same....
Till 2.35pm price hovered near entry point of 695.50 in Havells and then hit target !!!
Delayed file showed call at 10.34am


 

ajeetsingh

Well-Known Member
#19
C++:
_SECTION_BEGIN("Graphics");
share = Param("Lots",1,1,5,1);
perc = Param("Target Per",1.0,0.3,8.0,0.1);
//sig = ParamToggle("Signals","Show|Hide",1);
//bs = ParamToggle("Buy/Sell","Show|Hide",1);
//share = round(Amnt/C) ;
dshar = share*2 ;
ev = EMA(V,5) ;
//Vol = round(ev) ;
Vol = Ref(V, -1) ;
per = ((H-L)/C)*100 ;
perr = (round(per*100))/100 ;
trgtup = round(C*(100+perc))/100 ;
trgtdn = round(C*(100-perc))/100  ;
Title =  Name() + "\n" + Date() + ", Op=" + Open + ", Hi=" + High + ", Lo=" + Low + "\nNo. of lots= " + share + " / " + dshar + "\nTrgt Up=" + trgtup + ", Trgt Dn=" + trgtdn + "\n© Ajeet Singh" ;
SetChartOptions(1,chartShowArrows|chartShowDates|chartWrapTitle);
GraphXSpace = 15;
SetBarFillColor(IIf(C>O,colorGreen,IIf(C<=O,colorRed,colorLightGrey)));
Plot(C,"",IIf(C>O,colorDarkGreen,IIf(C<=O,colorRed,colorLightGrey)),64,0,0,0,0);
SetChartBkGradientFill(colorLightYellow,colorSeaGreen,colorLightYellow);
_SECTION_END();

_SECTION_BEGIN("Display");
md = round(MACD(12,26)*100) ;
sgl = round(Signal(12,26,9)*100) ;
co = IIf(md>sgl ,colorBrightGreen,IIf(md < sgl,colorRed,colorGrey50));
Plot(2, "", Co,styleArea+styleOwnScale | styleNoLabel, -1, 100);
_SECTION_END();



_SECTION_BEGIN("Magnified Market Price");
//AJEET SINGH 8178773712//
FS=28;
GfxSelectFont("Arial", FS, 700, italic = False, underline = False, True );
GfxSetBkMode( colorBlack );
GfxSetTextColor( colorDarkBlue );
Hor=1000;
Ver=1;
GfxTextOut(""+C,Hor , Ver );
YC=TimeFrameGetPrice("C",inDaily,-1);
DD=Prec(C-YC,2);
xx=Prec((DD/YC)*100,2);
GfxSelectFont("Arial", 12, 700, italic = False, underline = False, True );
GfxSetBkMode( colorWhite );
GfxSetTextColor(colorDarkBlue );
//GfxTextOut(""+DD+" ("+xx+"%)", Hor-25, Ver+45 );
GfxTextOut("       Vol= "+V+"", Hor-25, Ver+45 );
_SECTION_END();

_SECTION_BEGIN("PIVOTS");
DayH1 = TimeFrameGetPrice("H", inDaily, -1);
DayHI1 = LastValue (DayH1,1);// yesterdays high
DayL1 = TimeFrameGetPrice("L", inDaily, -1);
DayLI1 = LastValue (DayL1,1); // yesterdays low
DayC1 = TimeFrameGetPrice("C", inDaily, -1); // yesterdays close
DayO1 = TimeFrameGetPrice("O", inDaily); // current day open
//DayH = TimeFrameGetPrice("H", inDaily);
//DayL = TimeFrameGetPrice("L", inDaily);
DayH = H ;
DayL = L ;
numbars = LastValue(Cum(Status("barvisible")));
hts = -33.5;
Today = LastValue(Day());
// Pivot Levels //
PP1 = (DayL1 + DayH1 + DayC1)/3;
PPI1 = LastValue (PP1,1); // Pivot
R11 = (PP1 * 2) - DayL1;
R1I = LastValue (R11,1); // Resistance 1
S11 = (PP1 * 2) - DayH1;
S1I = LastValue (S11,1); // Support 1
R21 = PP1 + R11 - S11;
R2I1 = LastValue (R21,1); // Resistance 2
S21 = PP1 - R11 + S11;
S2I1 = LastValue (S21,1); // Support 2
R31 = PP1 + R21 - S11;
R3I1 = LastValue (R31,1); // Resistance 3
S31 = PP1 - R21 + S11;
S3I1 = LastValue (S31,1); // Support 3
Today = LastValue(Day());

PPL = ParamToggle("Pivot Levels","Show|Hide",1);
if(PPL==1) {
Plot(PP1, "PP",colorLightBlue,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(R11, "R1",colorRed,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(S11, "S1",colorGreen,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(R21, "R2",colorRed,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(S21, "S2",colorGreen,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(R31, "R3",colorRed,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(S31, "S3",colorGreen,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
}
_SECTION_END();
It has nothing except pivot lines
 
#20
C++:
_SECTION_BEGIN("Graphics");
share = Param("Lots",1,1,5,1);
perc = Param("Target Per",1.0,0.3,8.0,0.1);
//sig = ParamToggle("Signals","Show|Hide",1);
//bs = ParamToggle("Buy/Sell","Show|Hide",1);
//share = round(Amnt/C) ;
dshar = share*2 ;
ev = EMA(V,5) ;
//Vol = round(ev) ;
Vol = Ref(V, -1) ;
per = ((H-L)/C)*100 ;
perr = (round(per*100))/100 ;
trgtup = round(C*(100+perc))/100 ;
trgtdn = round(C*(100-perc))/100  ;
Title =  Name() + "\n" + Date() + ", Op=" + Open + ", Hi=" + High + ", Lo=" + Low + "\nNo. of lots= " + share + " / " + dshar + "\nTrgt Up=" + trgtup + ", Trgt Dn=" + trgtdn + "\n© Ajeet Singh" ;
SetChartOptions(1,chartShowArrows|chartShowDates|chartWrapTitle);
GraphXSpace = 15;
SetBarFillColor(IIf(C>O,colorGreen,IIf(C<=O,colorRed,colorLightGrey)));
Plot(C,"",IIf(C>O,colorDarkGreen,IIf(C<=O,colorRed,colorLightGrey)),64,0,0,0,0);
SetChartBkGradientFill(colorLightYellow,colorSeaGreen,colorLightYellow);
_SECTION_END();

_SECTION_BEGIN("Display");
md = round(MACD(12,26)*100) ;
sgl = round(Signal(12,26,9)*100) ;
co = IIf(md>sgl ,colorBrightGreen,IIf(md < sgl,colorRed,colorGrey50));
Plot(2, "", Co,styleArea+styleOwnScale | styleNoLabel, -1, 100);
_SECTION_END();



_SECTION_BEGIN("Magnified Market Price");
//AJEET SINGH 8178773712//
FS=28;
GfxSelectFont("Arial", FS, 700, italic = False, underline = False, True );
GfxSetBkMode( colorBlack );
GfxSetTextColor( colorDarkBlue );
Hor=1000;
Ver=1;
GfxTextOut(""+C,Hor , Ver );
YC=TimeFrameGetPrice("C",inDaily,-1);
DD=Prec(C-YC,2);
xx=Prec((DD/YC)*100,2);
GfxSelectFont("Arial", 12, 700, italic = False, underline = False, True );
GfxSetBkMode( colorWhite );
GfxSetTextColor(colorDarkBlue );
//GfxTextOut(""+DD+" ("+xx+"%)", Hor-25, Ver+45 );
GfxTextOut("       Vol= "+V+"", Hor-25, Ver+45 );
_SECTION_END();

_SECTION_BEGIN("PIVOTS");
DayH1 = TimeFrameGetPrice("H", inDaily, -1);
DayHI1 = LastValue (DayH1,1);// yesterdays high
DayL1 = TimeFrameGetPrice("L", inDaily, -1);
DayLI1 = LastValue (DayL1,1); // yesterdays low
DayC1 = TimeFrameGetPrice("C", inDaily, -1); // yesterdays close
DayO1 = TimeFrameGetPrice("O", inDaily); // current day open
//DayH = TimeFrameGetPrice("H", inDaily);
//DayL = TimeFrameGetPrice("L", inDaily);
DayH = H ;
DayL = L ;
numbars = LastValue(Cum(Status("barvisible")));
hts = -33.5;
Today = LastValue(Day());
// Pivot Levels //
PP1 = (DayL1 + DayH1 + DayC1)/3;
PPI1 = LastValue (PP1,1); // Pivot
R11 = (PP1 * 2) - DayL1;
R1I = LastValue (R11,1); // Resistance 1
S11 = (PP1 * 2) - DayH1;
S1I = LastValue (S11,1); // Support 1
R21 = PP1 + R11 - S11;
R2I1 = LastValue (R21,1); // Resistance 2
S21 = PP1 - R11 + S11;
S2I1 = LastValue (S21,1); // Support 2
R31 = PP1 + R21 - S11;
R3I1 = LastValue (R31,1); // Resistance 3
S31 = PP1 - R21 + S11;
S3I1 = LastValue (S31,1); // Support 3
Today = LastValue(Day());

PPL = ParamToggle("Pivot Levels","Show|Hide",1);
if(PPL==1) {
Plot(PP1, "PP",colorLightBlue,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(R11, "R1",colorRed,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(S11, "S1",colorGreen,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(R21, "R2",colorRed,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(S21, "S2",colorGreen,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(R31, "R3",colorRed,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
Plot(S31, "S3",colorGreen,styleDots|styleNoLine|styleNoRescale|styleNoTitle);
}
_SECTION_END();
It has nothing except pivot lines
thanx very much but sir that orange price lines and arrow not appear
 

Similar threads