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

[healthraj]

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

Thanks Raj for yet another version...
this time u have added trends and also u have shown pivot of the current day in Renko....

Raj, one doubt regarding renko...How to know when to take trade in Renko...like when we see a green brick or two we can take long but at what rate...like how to know what rate is prevaling when the current brick is forming...and also what is the points used in for one brick formation....or do we enter seeing the calls that are generated in renko(buy above such n such level and vice-versa)...
plz throw some light into this...

If you are an aggressive trader you can Buy when you see Green and Sell when you see Red. But my safe recommendation is trade as per the Pivot Low and High, which is what I recommend as "BUY ABOVE" and "SELL BELOW" in the charts and the main sheet.

 

[healthraj]

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

Algorithm for the FLOW

1. Calculate the EMA on the closing prices (For 10min TF I have taken EMA(10))
2. Based on the values from Step 1 compare the nth value and (n+1) value and find out whether it is going "UP" or "DOWN"
3. Using 1 and 2, Now find out where the direction changes from "UP" to "DOWN" or "DOWN" to "UP". The place where it changes direction is called "PIVOT"
4. Now take all these pivots and join them using lines. (The Y coordinate would be the pivot values and X Axis values would be the time). In Excel I use the function called TREND to plot the lines between two points
5. To use different color for UP trend and DOWN Trend you need to split the trend into two sets of values
6. Plus you can also plot the "BUY" and "SELL" Signals after the pivot point
7. To find out the "BUY ABOVE" and "SELL BELOW" take the last pivot highs and pivot lows and draw the lines.

You can see the above steps in the hidden sheet "NF10MinFlow" in cells "AK" to "BA"

Also see the function TenMinuteNIFTYFlow in the VBA Code.

 

[hames]

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

when trying to save file it asks for password.

 

[healthraj]

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

when trying to save file it asks for password.

Always specify which version of the tool, which version of Excel... etc... If possible post the screenshot. Otherwise without head or tail we cannot make out anything with what you are saying. Please also post detail error message etc... Do not post messages like SMS

 

[sholay]

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

At last I finished setup of SP3. It requires almost 2GB free space in C drive. I freed the space and it got installed. Now online I have to check on Tuesday.
Thanks

 

[prabhsingh]

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

Raj,

Calculation of EMA(10) on closing prices is done in which function of VBA Code and which column of NF10MinFlow holds that value?

 

[healthraj]

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

Raj,

Calculation of EMA(10) on closing prices is done in which function of VBA Code and which column of NF10MinFlow holds that value?

The EMA(10) is in Column "AG"

 

[healthraj]

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

As you know the Moving Averages is lagging indicator and not a leading indicator. I have used EMA(10) for the FLOW and RENKO charts to generate pivots. If you want faster signals you can modify the EMA(10) to say EMA(5) so that you will get faster indicators and you will also get more intermediate pivots.

To change the EMA Period goto the sheets NF10MinFlow (For NIFTY) and BNF10MinFlow (For BankNIFTY) and you will see a Red box and you can change the value in the cell "X2" modify the EMA Period

 

[thiruwins]

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

hi i new to this thread friends. raj sir i want to download the excel .where i can get ?

 

[KiranKV]

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

hi i new to this thread friends. raj sir i want to download the excel .where i can get ?

thiruwins,

please navigate few posta back, you will find the links to excel downloads...

reply no - #576 posted around Yesterday, 11:13 PM by healthraj sir.