Realtime Nifty Put Call Ratio calculator

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

samarthcapital, thanks for the nseindia link.

Kiran

Dear kiran

Your 1st version was in right ,just add open interest column & calculate PCR by open interest in 1st version .Please, post this utility as per my requirement.
If you honour my request i will be greatful to you to use your utility otherwise i will dump it forever.

Thanks

Pra
 
#13
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

Kiranmayee

When will the March series be updated.
 
#14
Can u explain how can we read PCR, it if i m not wrong if the PCR is above .50 it means heavy selling in nifty and if its below .50 it means its positive. Also can u prepare a realtime NSE BSE advance decline calculator hope to hear soon thanks again for your efforts in the PCR calculator
 

pkamalesh

Well-Known Member
#16
Dear kiran

Please, post this utility as per my requirement.
If you honour my request i will be greatful to you to use your utility otherwise i will dump it forever.

Pra

No wonder we keep talking of people demanding free things and still showing authority....ridiculous
 

pkamalesh

Well-Known Member
#18
Dear Pkamalesh can u explain how can we read the PCR
LOL dude its not my calculater though....and i dont use this calculator...its simple to calculate pcr or atleast have an idea of where the pcr is goin...What ive learnt from one of my seniors alex is that we can take a days top traded(10) nifty puts and calls...and just go ahead and divided the OI in puts by the OI in calls..thats a basic idea of how u calculate...regarding kirans excel..sorry buddy no idea...
 
#20
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
:( Hey plZ can u tell me & how it works.....how u hav connected it to the share market
 

Similar threads