iCharts Discussions :: View topic - Nifty PCR, Option Pain, Option OI Data Sheet

iCharts Discussions

FAQ

Memberlist

Usergroups

Profile

Nifty PCR, Option Pain, Option OI Data Sheet
Goto page Previous 1, 2, 3 Next

iCharts Discussions Forum Index -> Market Direction

View previous topic :: View next topic

Author

Nifty PCR, Option Pain, Option OI Data Sheet

twist

Joined: 12 Feb 2010
Posts: 333

Post: #16 Posted: Fri Oct 25, 2013 9:48 pm Post subject:

chalo finally tumhara barso purana sapna to build your own oi pcr sheet is completed j/k kahan ho bhai everything fit fat na?

sherbaaz
Yellow Belt

Joined: 27 May 2009
Posts: 543

Post: #17 Posted: Fri Oct 25, 2013 9:53 pm Post subject:

hi jdpt, yeh excel sheet badiya si lug rehi hai. but sub bouncer hai kuch hum jaise chingu mingu traders kay liye vyakayha ker dijiye badi krupa hogi aapki. regds,

jaimaalaxmi
White Belt

Joined: 19 Jan 2012
Posts: 7

Post: #18 Posted: Fri Oct 25, 2013 11:11 pm Post subject: jml

kahaa ho sir,,,very thing f9 na,,

jdpt
Yellow Belt

Joined: 25 Jun 2012
Posts: 806

Post: #19

Posted: Fri Oct 25, 2013 11:18 pm Post subject:

twist wrote:

chalo finally tumhara barso purana sapna to build your own oi pcr sheet is completed Laughing

j/k kahan ho bhai everything fit fat na? Very Happy

I need nuclear Very Happy

and it's chhota mota sutli bomb

idhar sab "kushal"karigar"mangal"daku.com hai twisty aap aur baki pirates of SBians kaise hain ?

jdpt
Yellow Belt

Joined: 25 Jun 2012
Posts: 806

Post: #20

Posted: Fri Oct 25, 2013 11:41 pm Post subject:

sherbaaz wrote:

hi jdpt,

yeh excel sheet badiya si lug rehi hai. but sub bouncer hai kuch hum jaise chingu mingu traders kay liye vyakayha ker dijiye badi krupa hogi aapki. Very Happy

regds,

sher hi, how are you sir ? missing your 2b or not 2b calls Very Happy

aap changu mangu trader ho to hum jaiso ko log kahenge nangu pangu trader Mr. Green

sher bhai sari vyakhya naam anusar hi hai, change in put call ration ,option pain strike price wise & any change in open interest ye batati hai ye sheet, higest OI+strike batati hai nifty ke kis option strike pe highest open interest hai, waise hi (+) kisi strike me hui highest open interest addition aur (-) kisi strike pe with strike price kitne OI ghate hain iski jankari deta hai, waise to aapko sabhi pahle se hi pata hoga bas mere sath kidding Laughing

Regards

Last edited by jdpt on Mon Nov 04, 2013 8:27 pm; edited 1 time in total

jdpt
Yellow Belt

Joined: 25 Jun 2012
Posts: 806

Post: #21

Posted: Fri Oct 25, 2013 11:51 pm Post subject: Re: jml

jaimaalaxmi wrote:

kahaa ho sir,,,very thing f9 na,,

jml hello, yeah everything is alright dear, roaming with family Very Happy

what about you and your client ptji ?? I hope you bought a new kb with volume keys Wink

regards

twist

Joined: 12 Feb 2010
Posts: 333

Post: #22

Posted: Sat Oct 26, 2013 3:16 am Post subject:

jdpt wrote:

twist wrote:

chalo finally tumhara barso purana sapna to build your own oi pcr sheet is completed Laughing

j/k kahan ho bhai everything fit fat na? Very Happy

I need nuclear Very Happy

and it's chhota mota sutli bomb

idhar sab "kushal"karigar"mangal"daku.com hai twisty aap aur baki pirates of SBians kaise hain ?

nuclear

sahi hai bhai lage raho.... main aur sbians ek dum jhakasss Very Happy

Andre
White Belt

Joined: 06 Jun 2012
Posts: 220

Post: #23 Posted: Sat Oct 26, 2013 12:00 pm Post subject:

JDPT.... Hi Jd....please help us in analyzing this sheet....i mean how did it help us in decision making. what does it signify by 1st strike and 2nd strike...All in all....help us in making sense of this sheet..... Thanks .....

jdpt
Yellow Belt

Joined: 25 Jun 2012
Posts: 806

Post: #24

Posted: Sat Oct 26, 2013 3:04 pm Post subject:

Andre wrote:

JDPT....
Hi Jd....please help us in analyzing this sheet....i mean how did it help us in decision making. what does it signify by 1st strike and 2nd strike...All in all....help us in making sense of this sheet.....

Thanks .....

Hello Andre,
Your 1st query: This sheet is nothing but a calculator for getting realtime data about Nifty Put Call Ratio, Option Pain & changes in Open Interest, to understand those things do some Google about PCR,Open Interest and Option pain then you will be able to do your own analysis with this data. It will help you to get some idea about market direction.

About your 2nd query: 1st and 2nd strike is for getting current option pain, ie. you want to know option pain between option stike 5000 to 6000 then just put you 1st value in below 1st strike cell then put 2nd value in below 2nd strike cell, in this case you have to put 5000 in 1st strike and 6000 in 2nd strike and a result will appear as current option pain. You can also give a value in both cells by just clicking filter arrows: Please refer to snapshot >
Hope this will make some sense..

Regards

Last edited by jdpt on Mon Oct 20, 2014 9:04 am; edited 1 time in total

jdpt
Yellow Belt

Joined: 25 Jun 2012
Posts: 806

Post: #25

Posted: Sat Oct 26, 2013 11:04 pm Post subject:

jdpt wrote:

Andre wrote:

Hello Andre,
Your 1st query: This sheet is nothing but a calculator for getting realtime data about Nifty Put Call Ratio, Option Pain & changes in Open Interest, to understand those things do some Google about PCR,Open Interest and Option pain then you will be able to do your own analyses with this data. It will help you to get some idea about market direction.

About your 2nd query: 1st and 2nd strike is for getting current option pain, ie. you want to know option pain between option stike 5000 to 6000 then just put you 1st value in below 1st strike cell then put 2nd value in below 2nd strike cell, in this case you have to put 5000 in 1st strike and 6000 in 2nd strike and a result will appear as current option pain. You can also give a value in both cells by just clicking filter arrows: Please refer to snapshot >
Hope this will make some sense..

Regards

Here are some articles regarding you queries :

Open Interest
http://www.tradingpicks.com/open_interest.htm

Put Call Ratio
http://www.optiontradingpedia.com/put_call_ratio.htm

Option Pain
http://www.tradingpicks.com/open_interest.htm

Regards

pkholla
Black Belt

Joined: 04 Nov 2010
Posts: 2890

Post: #26

Posted: Sun Oct 27, 2013 9:01 am Post subject:

jdpt wrote:

here is the updated version of data sheet with Option Pain or Max Pain:Regards JDPT

JDPT: Quite a few of us are happy with 2003 Office .xls excel or .doc word. Can you please take a minute, save as, old version, save, post the file as XLS ??? Thank you in advance, Prakash Holla
I tried to open with Google Docs, it says that file is PW protected?

jdpt
Yellow Belt

Joined: 25 Jun 2012
Posts: 806

Post: #27

Posted: Sun Oct 27, 2013 9:45 am Post subject:

pkholla wrote:

jdpt wrote:

here is the updated version of data sheet with Option Pain or Max Pain:Regards JDPT

JDPT: Quite a few of us are happy with 2003 Office .xls excel or .doc word. Can you please take a minute, save as, old version, save, post the file as XLS ??? Thank you in advance, Prakash Holla

No problem prakash, here is your file:

Regards

indb
White Belt

Joined: 27 Aug 2012
Posts: 41

Post: #28 Posted: Sun Oct 27, 2013 10:43 am Post subject:

hi jd how are you kahan ho bhai sb mai dikhai nahi diye?

jdpt
Yellow Belt

Joined: 25 Jun 2012
Posts: 806

Post: #29

Posted: Sun Oct 27, 2013 5:22 pm Post subject:

indb wrote:

hi jd how are you kahan ho bhai sb mai dikhai nahi diye?

Absolutely fine indb, Thanks. Chhutti pe hoon will try to come back soon, how about you sir ?

regards

pkholla
Black Belt

Joined: 04 Nov 2010
Posts: 2890

Post: #30

Posted: Sun Oct 27, 2013 10:03 pm Post subject:

jdpt wrote:

No problem prakash, here is your file:Regards

JDPT: Thanks for file and prompt reply. Prakash Holla

Display posts from previous:

	iCharts Discussions Forum Index -> Market Direction	All times are GMT + 5.5 Hours Goto page Previous 1, 2, 3 Next
Page 2 of 3

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

@	MEMBER OF PROJECT HONEY POT Spam Harvester Protection Network provided by Unspam