Traderji.com - Discussion forum for Stocks Commodities & Forex


Realtime Nifty Put Call Ratio calculator

Discuss Realtime Nifty Put Call Ratio calculator at the Technical Analysis within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hi, I am attaching an excel file that can calculate Nifty PCR in real time. ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > METHODS & STRATEGIES > Technical Analysis

Technical Analysis Discussion of all the principles involved in technical analysis.


Reply
 
Thread Tools
  #1  
Old 5th January 2009, 12:18 PM
Member
 
Join Date: Nov 2008
Posts: 205
Thanks: 328
Thanked 251 Times in 89 Posts
kiranb is a jewel in the roughkiranb is a jewel in the roughkiranb is a jewel in the rough
Default Realtime Nifty Put Call Ratio calculator

Hi,

I am attaching an excel file that can calculate Nifty PCR in real time.

Go get the latest PCR, go to "Nifty Options" sheet and click on "Data
\ Refresh Data" from menu.

Other scrips can be easily added too. Tell me what you think.

Update (Jan 30 2009):
- Auto updates every 3 mins
- Updated with Open Interest PCR
- Added Reliance




Last edited by kiranb; 9th June 2009 at 03:07 AM.
Reply With Quote
The Following 18 Users Say Thank You to kiranb For This Useful Post:
citrus (6th February 2010), darshanshukla (4th March 2010), diosys (6th January 2009), gauharjk (11th October 2010), gunavadhi (30th January 2009), leo_3455 (31st January 2009), madpab (19th February 2010), mfire (1st February 2009), mylaianand (7th February 2010), myvineet (5th January 2009), onkar_kelkar (25th November 2009), rajendrani (5th January 2009), rimikoolcute (26th March 2010), rosco (3rd January 2010), santoshkj (10th December 2009), sprintravi75 (3rd July 2010), terminator_123 (5th January 2009)
Sponsored Links
  #2  
Old 21st January 2009, 10:16 AM
Member
 
Join Date: May 2008
Posts: 25
Thanks: 0
Thanked 4 Times in 4 Posts
krishna79 is on a distinguished road
Default Re: Realtime Nifty Put Call Ratio calculator

Hi Kiran,

Well the excel sheet calculation is superb in other words fabulous.

Thank you for sharing the datasheet, i just want to ask once the settlement expiry like jan expired does the excel sheet replace with the new one.

secondly the PUT CALL RATIO is calculated on the current month.

hope we can share the knowledge togethere

Regards,
Krishna
Reply With Quote
  #3  
Old 21st January 2009, 01:06 PM
Member
 
Join Date: Jan 2006
Posts: 324
Thanks: 144
Thanked 127 Times in 68 Posts
knarendra will become famous soon enoughknarendra will become famous soon enough
Default Re: Realtime Nifty Put Call Ratio calculator

Hai kiran,
Thank U verymuch. But, Its also shows 2011 CE, PE . We need current month PCR to better trade. Pl. modift it.
Reply With Quote
  #4  
Old 23rd January 2009, 10:51 AM
Member
 
Join Date: Nov 2008
Posts: 205
Thanks: 328
Thanked 251 Times in 89 Posts
kiranb is a jewel in the roughkiranb is a jewel in the roughkiranb is a jewel in the rough
Default Re: Realtime Nifty Put Call Ratio calculator

Nagendra, Krishna,

Glad that you like it. Yes, it will automatically roll over to new contracts after the expiry. I am simply getting the data from http://www.nseindia.com/marketinfo/f...ut_Opt=Options

To my knowledge, PCR is not bound to current month. But I guess people could calculate the way they like it based on their experience etc. Please let me know if you see any definition or link that says that PCR is calculated only on current month.

But if you look keenly, number of trades in current month are way too high than future months, the the error it introduces will be very minor and can be ignored.

Kiran
Reply With Quote
  #5  
Old 23rd January 2009, 10:07 PM
Member
 
Join Date: Sep 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
aiya_ashok is on a distinguished road
Default Re: Realtime Nifty Put Call Ratio calculator

how i calculate nifty IMPLIED VOLATITY ( NIFTY IV ) OR any site which daily update day to day NIFTY IV
Reply With Quote
  #6  
Old 25th January 2009, 12:54 PM
Member
 
Join Date: Jan 2006
Posts: 101
Thanks: 0
Thanked 1 Time in 1 Post
saamy is on a distinguished road
Default Re: Realtime Nifty Put Call Ratio calculator

Is there any website from where I can get Historical Nifty PCR.
Reply With Quote
  #7  
Old 26th January 2009, 11:58 AM
Member
 
Join Date: Jan 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
samarthcapital is on a distinguished road
Thumbs up Re: Realtime Nifty Put Call Ratio calculator

Dear Friends,

Please find the attached excel file about online calculating PCR (on the basis of open interest) for the month of Jan 09. We will post the same file for Feb 09 after expiry.

Regards,

A. K. Mistry
Samarth Capital Markets
Mumbai
Reply With Quote
  #8  
Old 26th January 2009, 08:18 PM
Member
 
Join Date: Sep 2008
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
brahmayya is on a distinguished road
Default Re: Realtime Nifty Put Call Ratio calculator

Quote:
Originally Posted by aiya_ashok View Post
how i calculate nifty IMPLIED VOLATITY ( NIFTY IV ) OR any site which daily update day to day NIFTY IV
hi
this is brahmayya
you can visit this link
http://nse-india.com/marketinfo/char..._date=24012009
Reply With Quote
The Following User Says Thank You to brahmayya For This Useful Post:
rock007007 (5th November 2009)
  #9  
Old 27th January 2009, 03:09 PM
Member
 
Join Date: Jan 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
samarthcapital is on a distinguished road
Default Re: Realtime Nifty Put Call Ratio calculator

Dear pra,

By the utility which we have posted, u can can calculate the PCR on realtime basis and only for ongoing month contracts.

Regards,

A. K. Mistry
Reply With Quote
  #10  
Old 30th January 2009, 12:19 PM
Member
 
Join Date: Nov 2008
Posts: 205
Thanks: 328
Thanked 251 Times in 89 Posts
kiranb is a jewel in the roughkiranb is a jewel in the roughkiranb is a jewel in the rough
Default Re: Realtime Nifty Put Call Ratio calculator

I uploaded newer version of this excel file in the main post, with some updates.

samarthcapital, thanks for the nseindia link.

Kiran


Reply With Quote
Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +5.5. The time now is 05:45 AM.

Indemnity, Disclaimer & Disclosure Notice:
By visiting Traderji.com you automatically indicate that you agree to our Forum Rules, Indemnity, Disclaimer & Disclosure Notice and General Content Disclaimer Notice and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum/site.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. You are recommended to make appropriate enquiries and seek appropriate advise before sending money, incurring any expenses, acting on recommendations or entering into any commitment in relation to any advertisement published here. Traderji.com does not vouch for any claims made by the advertisers of products and services. Traderji.com will not be held liable for any consequences in the event such claims are not honoured by the advertisers. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of any information by anybody mentioned anywhere on this site.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy or legality of any information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. Although we constantly delete all irrelevant content and/or SPAM, if you should find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © www.Traderji.com 2001 - , All rights reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245