1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures - Bac

[ron7]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -


Your Excel file is working fine with me. As I am using Windows 7 Ult. & MS Excel 2013 versions. Only one thing, as I open your hidden sheet CData it show #NAME? in columns N to S, I think that maybe the part of the Flow icon i.e. Under development & Performance improvement, if not please check. Very Good work - Thanks

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Thanks Raj for yet another version and also incorporated various new things...have not gone through it in details but will go through it very soon...u have written it as FINAL, that means u are not going to come up with any new updates???

First of all Congrats for doing an excellent work...also the flow chart is not available...Renko is working and there is no error message also...

Secondly wanted to know that u have incorporated 5, 10 and 30tf in the excell, so trades should be taken with higher tf in context, but the buy and sell seen in the main excell is in 5tf???? so entry is in 5tf? with respect to higher tf?

Welcome back...

Coming to your question on the call wrt Timeframes...

5min TF - Used only to calculate the Support and Resistance for the Day.
Whatver timeframe you choose in "Flow using", is used for the direction of stock. so it would be always a higher timeframe. I prefer 30 minutes TF. This is used in "Flow Signal" column.

Whatever TF you choose in "Pivots using" is used for the Pivots or the "Add more@" column.

The "Buy Or Sell @" is irrespective of the Timeframe. The high price and low price is used to calculate. Only the trend is taken from the Higher timeframe...

If you do not understand I would probably explain it with the charts and values

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Your Excel file is working fine with me. As I am using Windows 7 Ult. & MS Excel 2013 versions. Only one thing, as I open your hidden sheet CData it show #NAME? in columns N to S, I think that maybe the part of the Flow icon i.e. Under development & Performance improvement, if not please check. Very Good work - Thanks

Don't worry about this sheet. It is not used in this version. In fact I should have deleted this sheet.

 

[guptak03]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Excel is not getting update even after updating all ,it is not showing 2days value ...

 

[aimer]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Welcome back...

Coming to your question on the call wrt Timeframes...

5min TF - Used only to calculate the Support and Resistance for the Day.
Whatver timeframe you choose in "Flow using", is used for the direction of stock. so it would be always a higher timeframe. I prefer 30 minutes TF. This is used in "Flow Signal" column.

Whatever TF you choose in "Pivots using" is used for the Pivots or the "Add more@" column.

The "Buy Or Sell @" is irrespective of the Timeframe. The high price and low price is used to calculate. Only the trend is taken from the Higher timeframe...

If you do not understand I would probably explain it with the charts and values

Plz do explain with a chart when u r free...
Also will request for something more as always "DIL MANGE MORE"
I am very much after the RENKO System...I am putting down the prerequisites...plz see whether it can be incorporated in the excell...

1) Can a Button be added in Renko Chart so that we can change the brick size.

2)Suppose I consider Buy/Sell after we get 3 bricks in either side. so as soon as 3 bricks gets formed...there will be a buy signal generated in the buy column(with proper values)...and vice versa for short trade.

3)Renko gets refreshed automatically after 1sec so that we get signals at proper time without time delay...I understand refreshing per second will be a prob due to huge data size but seeing this we can limit the number of scrips to just two without any indices...

There are many more but if this is done then only we can move in for some more prerequisites...Hope u get my questions and plz see whether this can be done or not...
Awaiting for ur reply...Thanks

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Excel is not getting update even after updating all ,it is not showing 2days value ...

If you are using the latest version either EXE or XLSM, then the problem might be with your setup. Please go through the Readme sheet and see if you have done the correct settings.

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

In a GAPUP or GAPDOWN days, I am thinking of using

Pivots using --> to 5 Min TF (Instead of 10 min TF) and
Flow using --> 15 min TF (Instead ofusing 30 min TF)

The main change is using a Faster signal for the change of Trend like 15 min instead of 30 min.

5min or 10min is used only to get the Next Buy or Sell Levels

What do you Experts say ?

When I change to the above Timeframes, I get the following calls

OR the Question to the Experts is What is the Best Timeframe to be set. As the per the SAINT's AMBUSH Method it is 5min and 15 min... But I never like the 5min TF because it had a lot of noise and whipsaws. So on a normal day I would use 10 and 30. So my question is more for the GAPUP or GAPDOWN days. Because the Law of averages do not work on GAPUP and GAPDOWN days.

I know the best strategy is to wait for some 3 hours so that the averages get normal...
But what IF I want to still trade?

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Plz do explain with a chart when u r free...
Also will request for something more as always "DIL MANGE MORE"
I am very much after the RENKO System...I am putting down the prerequisites...plz see whether it can be incorporated in the excell...

1) Can a Button be added in Renko Chart so that we can change the brick size.

2)Suppose I consider Buy/Sell after we get 3 bricks in either side. so as soon as 3 bricks gets formed...there will be a buy signal generated in the buy column(with proper values)...and vice versa for short trade.

3)Renko gets refreshed automatically after 1sec so that we get signals at proper time without time delay...I understand refreshing per second will be a prob due to huge data size but seeing this we can limit the number of scrips to just two without any indices...

There are many more but if this is done then only we can move in for some more prerequisites...Hope u get my questions and plz see whether this can be done or not...
Awaiting for ur reply...Thanks

The Problem with custom Renko size is that in Excel Charts there is a limitation, which is you cannot have more than 225 values (or candles) in the chart.

so in the Renko Chart I normally start with 1/12 of 1% and if it the number of points is more than 225 I increase the Renko block size so that it fits in 225 values.... So any upward revision of Renko Block size should be posssible and not a Downward revision.

For example take NIFTY. 1% is 50 points. 1/12 is around 4 points. So If I am not able to draw using 4 points in NIFTY, I will revise the renko Block size so that the number of blocks is not more than 225.

Anyway I will go through your suggestion and see if it can be implemented.

 

[pradeepsingh]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

raj ji its giving wrong support/resistance for every stocks. i think it taking same value for every stock

 

[narendra.mandravat]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

can anyone give me gyan when to buy or when to sell using xcel. as im not able to understand all this TA things.

Please anyone make me understand in Layman language...pls pls

Regards
Narendra Mandravat