Excels for Help, in trading !!!

ajeetsingh

ajeetsingh

Well-Known Member
#12
#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

ajeetsingh

Well-Known Member
#19
#19
PANKIT3011 said:
if possible then pls share it

[email protected]
Click to expand...
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
 
P

PANKIT3011

New Member
#20
#20
ajeetsingh said:
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
Click to expand...
thanx very much but sir that orange price lines and arrow not appear
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
R Metatrader4 is helpful? General Trading & Investing Chat 0
C help needed in plotting OI as a line to staircase or Step Line AmiBroker 1
F banknifty OI excelsheet download link Software 1
B Volatility in ExcelSheet Software 0
Shailu Help required to make excelsheet with real time data Day Trading 3

Similar threads