Pivot Based Trading - 1:2 risk reward ratio (Risk less Profit more)

[bandlab2]

bandlab2 & Radha,
I have attached an excel sheet for this method.

Setup:
1. Create your own porfolio in yahoo and link them in Sheet "Yahoo" using excel web qurey. This will fetch the real time 'last traded price' and 'time' from yahoo.

2. Copy and paste the previous day 'Bhavcopy' from naeindia.com in Sheet "Prev.Day" to get the previous day 'High' 'Low' "Close' price.

3. Buy and Sell Trigger price will be generated based on the different conditions.

3. If any of the trigger price of the scrip is closer to the 'Last trade price' then the particluar trigger will be automatically highlighted. Then we can place the order for the particular scrip.

4. We can set the required automatic refresh time in seconds.

5. We have to be remain logged in yahoo finance to get thre RT data.

Any qurey/comments/suggestion are welcome.

Regards,
Nava

thank you sir fo excllent work. how o we ensure the live ppices are taken at 10:30 and 1, R2, S1, S2... are calclated based on these and neve change after that, while live quotes are upated for triggers? is there a button for that? need to LOCK 1,R2,S1,S2... after 10:30

 

[Nava]

thank you sir fo excllent work. how o we ensure the live ppices are taken at 10:30 and 1, R2, S1, S2... are calclated based on these and neve change after that, while live quotes are upated for triggers? is there a button for that? need to LOCK 1,R2,S1,S2... after 10:30

Hi,

You can do the following.

1. Copy the formula cells S1,S2,S3,Pivot,R1,R2,R3 to the last row.

2. At 10:30 am copy all trigger price cells for all scrips and "paste special" the "values" only.

3. At the end of the day, copy the formula from the last row and past it again in all the trigger price cells.

Regards,
Nava

 

[bandlab2]

today i tracked NIFTY, SBI, RIL in futures. SBI hit target 0.75%. nifty, ril no show

 

[bandlab2]

thanks nava. is there a better way ? my question is not very clear. S1, S2, S3, Pivot, R1,R2,R3 depend on prev day values, so no problem with them. but the trigger values (buy/sell) keep changing based on LTP which is being updated every N seconds. can we add a new button update triggers, which will be clicked by user at 10:30 and trigger values are calculated. for this purpose, you may need to add new column to store 10:30 LTP. every N second we need to update LTP and use this for alerts. 10:30 LTP should be used for calcuating trigger values. also another thing, you can hide all calculation cells to save the realestate. instead of 6 cells for buy (1 for each rule) we can add a new cell thats maximum of these 6, this will be the actaul buy/sell trigger. also we could add target, stoploss cells with 0.75% (variable cell) and 0.5%.


i know i am asking too much, but this will really help the users. when i open this sheet at 10:30, i will just click on Update Trigger button and simply keep watching for alerts every 10 min. at EOD i copy the hi, lo, cl prices so that i am set for next day.

thanks once again for the initiative and helping others

Hi,

You can do the following.

1. Copy the formula cells S1,S2,S3,Pivot,R1,R2,R3 to the last row.

2. At 10:30 am copy all trigger price cells for all scrips and "paste special" the "values" only.

3. At the end of the day, copy the formula from the last row and past it again in all the trigger price cells.

Regards,
Nava

 

[bandlab2]

Hi All,

I want to introduce a very simple way of trading.

Everyone is aware of Pivots in charts.

It is very difficult to track real time pivot on intraday charts during trading hours.

After surfing lot of site and struggling, i found the way to calculate pivot based on previous day values.

After the pivot is calculated the resistance and support levels are found.

Resistance and support are of two types (using normal method and using fibonacci method.)

You can use any one of them. Both gives good result. Stick to any one method.

The system is as follows, please give your feedback and suggestions.

1. Firstly log to http : // pivottrading . 110mb . com (remove spaces)
2. Enter previous day high, low and close for any scrip.
3. Pivot is an important value here.
4. Look at the price of stock/underlying at 10:25-10:30 am. (half hour after market opens)
5. For Resistance and support values, you can choose normal values or fibonacci values. Both give good results. It depends upon you which suits you.
6. There are various scenarios which can occur.
-----1. The price is below the Pivot but above S1.
--------In this scenario, you should buy the stock/underlying above Pivot (If price reaches above Pivot) and sell below S1(if the prcies goes below S1).
----2. The price is above Pivot but below R1.
--------In this scenario, you should buy the stock/underlying above R1 (if the price reaches above R1) and sell below Pivot(if the price goes below Pivot).
----3. The price is very near to pivot (+/- 0.02%)
--------In this scenario, you should buy the stock/underlying above R1 (if the price reaches above R1) and sell below S1(if the price reaches below S1).
----4. The price is between R1 and R2.
--------In this scenario, you should buy the stock/underlying above R2 (if the price reaches above R2) and sell below Pivot(if the price reaches below Pivot). the important here is not to sell below R1. You must sell below Pivot.
----5. The price is between S1 and S2.
--------In this scenario, you should buy the stock/underlying above Pivot (if the price reaches above Pivot) and sell below S2(if the price reaches below S2). The important here is not to buy above S1, buy only above pivot.
----6. The price is between S2 and S3.
--------Same rule applies as rule 5. Buy above pivot sell below S3.
----7. The price is between R2 and R3.
--------Same rule applies as rule 4. Buy above R3 sell below Pivot.

Keep the profit, stoploss as below

Profit : 0.75% - 1%
Stoploss : 0.5%

Please please do reply with your suggestions.
I hope many of you already knows this.
No theory can become 99% successful without people's suggestions.
Do reply with your valuable comments.

radha,

prev day close means the last 15 min average price shown by exchange or the last tock price shown in the watch lists ?

 

[radha55]

radha,

prev day close means the last 15 min average price shown by exchange or the last tock price shown in the watch lists ?

I generally take the close price of stock/futures.

There are variances to take the close price.

Below are different variances. (they hardly make any difference in calculation.)

1. Instead of taking previous day close, take todays open price.
2. Instead of taking previous day close, take average of todays open, high and low till 10:05 am.
3. Instead of taking previous day close, take average of previous day close, todays's open, today's high, today's low till 10:05 am.

All these are variances for taking the closing price.

I would prefer better to take previous day close.
Others involve lot of calculation and takes time.

 

[radha55]

thanks nava. is there a better way ? my question is not very clear. S1, S2, S3, Pivot, R1,R2,R3 depend on prev day values, so no problem with them. but the trigger values (buy/sell) keep changing based on LTP which is being updated every N seconds. can we add a new button update triggers, which will be clicked by user at 10:30 and trigger values are calculated. for this purpose, you may need to add new column to store 10:30 LTP. every N second we need to update LTP and use this for alerts. 10:30 LTP should be used for calcuating trigger values. also another thing, you can hide all calculation cells to save the realestate. instead of 6 cells for buy (1 for each rule) we can add a new cell thats maximum of these 6, this will be the actaul buy/sell trigger. also we could add target, stoploss cells with 0.75% (variable cell) and 0.5%.


i know i am asking too much, but this will really help the users. when i open this sheet at 10:30, i will just click on Update Trigger button and simply keep watching for alerts every 10 min. at EOD i copy the hi, lo, cl prices so that i am set for next day.

thanks once again for the initiative and helping others

Hello,

Wait for this weekend.

I will come up with a tool which will give you all indicators like, buy at, sell at, 0.75% target, 1% target, stoploss, dynamic alerts.

These will be for NIFTY 50 stocks and NIFTY FUTURES.

Thanks to one who uploaded the excel file.

 

[Nava]

Hi radha,

Thanks for your initiative. Me too waiting for your tool.

Regards,
Navamani,

 

[radha55]

Hi,

Today
Nifty Futures May

At 10:25 - 10:30 am, the price was 2799- 2795.

As per the rule,
For normal values, this falls between R1 and R2.
So we should buy only above R2.
But high for today was 2818. So no buy call trigerred.

For Fibonacci values, this price is very near to R2.
We buy above R2.
Say we buy at 2797-2798.
0.75% target = 2817.9775 -2818.985

So our target for fibonacci is achieved.

After lunch, market reversed.

As per rule we should sell only if the price goes below pivot.

But the low for today was 2761. So no sell trigerred.

At the end of day, day ends in 0.75% profit.

For all those who want to know how this system works, please refer to first post of this thread.

 

[bandlab2]

Hi,

Today
Nifty Futures May

At 10:25 - 10:30 am, the price was 2799- 2795.

As per the rule,
For normal values, this falls between R1 and R2.
So we should buy only above R2.
But high for today was 2818. So no buy call trigerred.

For Fibonacci values, this price is very near to R2.
We buy above R2.
Say we buy at 2797-2798.
0.75% target = 2817.9775 -2818.985

So our target for fibonacci is achieved.

After lunch, market reversed.

As per rule we should sell only if the price goes below pivot.

But the low for today was 2761. So no sell trigerred.

At the end of day, day ends in 0.75% profit.

For all those who want to know how this system works, please refer to first post of this thread.

how its profitable as per fibonacci ? hi is only 2811, but the target is 2818. it hit SL.

As per norma levels, no buy triggered. sell triggered and achieved target