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

hi nava, can you explain what are the table 15,18 on your web query? what does this indiacte? also can you explain this web query in detail and how to map to yahoo finance

 

[Nava]

hi nava, can you explain what are the table 15,18 on your web query? what does this indiacte? also can you explain this web query in detail and how to map to yahoo finance

Hi bandlab,

1. First Create ur own portfoilo in yahoo finance by adding ur required scrips symbols (see attached sample images 1 & 2).


2. In excel, sheet "Yahoo" select cell 'A1'.
From pulldown menu select 'Data -> Import External Data -> New web query.



3. Then Copy and paste your yahoo portfoilo url and import. (see attached images 3 & 4).


This will trasnfer the your yahoo portfoilo data to excel sheet.

Regards,
Nava,

 

[radha55]

Any dam theory will work in todays market.

Nifty Futures target achieved for March, April, May Series.

I am not attaching the calculation image.

0.75% achieved 1% achieved.

No chance of stop loss hit today.

One directional market.

I however not happy since holding PUT.

Do reply about your trades.

 

[radha55]

As shown in the above image,

Nifty Futures March series

At 10:25 10:30 am price was 2972-2974.

R1 for normal values and R2 for fibonacci is 2975-2977.

Lets say we buy above this. We buy at 2980.

0.75% = 3002.35 (achieved)

1% = 3009.8 (achieved)

See the high 3018.

Our Next resistance says 3013-3015 (for fibonacci and normal values)

So again day ends in profit.

both targets achieved.

Those who want to know how this theory works please refer to first post of this thread.

 

[rkpahwa]

As shown in the above image,

Nifty Futures March series

At 10:25 10:30 am price was 2972-2974.

R1 for normal values and R2 for fibonacci is 2975-2977.

Lets say we buy above this. We buy at 2980.

0.75% = 3002.35 (achieved)

1% = 3009.8 (achieved)

See the high 3018.

Our Next resistance says 3013-3015 (for fibonacci and normal values)

So again day ends in profit.

both targets achieved.

Those who want to know how this theory works please refer to first post of this thread.

Hi Radha,

Yesterday at 10.25 - 10.30 the range was 2976-2986 (Nifty Future March)
and why R1 from normal and R2 from fibonacci ???

I am confused
Pls clear my doubts....

regards

 

[pchauhan2007]

hi radha first of all let me thank you for the stuff.

radha i am bit confused about your point no. 6 short sell @ s3 and point no. 7 buy @ r3
because as per my observation these are the levels where the prices reverses so it should be buy @ s3 and short sell @ r3 but when there is a reversal in the price.
pl. correct me if i am missing something. prakash

 

[radha55]

Hi Radha,

Yesterday at 10.25 - 10.30 the range was 2976-2986 (Nifty Future March)
and why R1 from normal and R2 from fibonacci ???

I am confused
Pls clear my doubts....

regards

Hi,

I got this value from nse intraday charts at the end of day.

Now R1 for normal and R2 for fibonacci is because,
if u read my first post we can take any values.
The price 2977 was between pivot and R1 for Normal values
and the price 2977 was between R1 and R2 for fibonacci values.

So if suppose i follow normal values, so for me the buy will above R1. So i buy above R1.

Suppose i follow fibonacci values, so for me the buy will be above R2. So i buy above R2.

Hope you understood.

You can follow any values.

I mean to say in my yesterdays post that target for both values(normal and fibonacci) were achieved.

 

[radha55]

Hi,

as you can see in the above image,

the pivot is at 2956.

At 10:25-10:30 am, the price of NIFTY Futures May Series is between 2927 - 2937.

This value is between the S1 and Pivot in case of both values(normal and fibonacci.)

So as per rule, we should buy above Pivot.

Lets say we buy at 2960.

0.75%=2982.2 (target achieved) 11:45 am.
1% = 2989.6 (target not achieved soon. However at the end of day this target was achieved, but before that market fell trigeering our stoploss.)

So at the end of day,

0.75% Target achieved successfully.
1% Target not achieved missed by 2-3 pts.

So day ends in 0.75% profit.

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

 

[radha55]

At 10:25-10:30 am

Price of Nifty Futures April series = 3030 - 3035

For Normal Values, this is between R1 and R2.

so buy above R2.

Lets say we place buy order for 3051 (trigerred at 1:50)
0.75% target=3073 (achived at 2:55)
1% target= 3081 (achieved at 3:00)
0.5% stoploss=3035 never got hit. (returned back from 3041)

For Fibonacci, this price is between R2 and R3.

so buy above R3.

Lets say we place buy order for 3048. (trigerred at 1:30)

0.75%=3070 (achieved at 2:50)
1%=3078 (achieved at 2:55)
0.5% stoploss = 3032 (never hit)

Day ends in 1 % profit.

Another successful day.

Those who want to know how this theory works refer to first post of this thread.

 

[radha55]

I m not getting time to post the image since last 3 days.

On 30th March, the theory gave 0.75% profit.
On 31st March, the theory reached only 0.5% profit. so stoploss of 0.5% hit.

Today, 1% target achieved.

It takes lot of time to copy image and upload, hence those who are interested can see the results by performing calculation.

The above result are for April Nifty Futures.

There is also one more trading system called on the site.
The system is Camarilla Pivot Based Trading. This system also gives good profit.

Today this system also worked.

I dont want to start a new thread on camarilla pivot trading as some one has already started here.

Please people do reply.

Those who want to know how this system works please read the first post of this thread.