MC Tracker v1.0 is a simple MS Excel Based tool Which does
Live NSE Index Update (Auto Refresh Every 1min)
SMR Computations (EOD)
PCR Ratio(Live – Updates every 1 min)
Indian VIX (EOD)
Live Near Month Option Values( Updates every 1min)
+Delayed 5 EMA+TRIN+ RSI-2 Computations
+FNO Trading Statistics (EOD)
Compatible with : Windows 2000/XP/VISTA and works on OFFICE XP,2003/2007
Click here to download
Give your valuable feedback and Suggestions to improve the tool.
Regards,
Rajandran R
Zmarketcalls 
February 9, 2009 at 6:28 am |
please explain the meaning n implication of different indicators in the sheet at the bottom.eg if PCR is 1.22 n SMR ratio is 41 then what does that mean n indicate.thanksvivek
February 9, 2009 at 10:54 am |
Raj…………Excellent Job……..Just want to tell that Nifty value in 1st sheet is not updating automatically……i have also selected the option to enable macro to refresh automatically,,,,,,,,,,plz check………..wud request u to plz add the other imp emas like weekly 13 ema and 34 ema….similary 5 ema and 20 ema daily……..Br Gaurav
February 9, 2009 at 1:22 pm |
HERE ALSO TRY TO ADD SCO VALUE IT IS ALSO GOOD THING FOR NIFTY AND STOCK.
February 9, 2009 at 3:29 pm |
Hi Raj,Nifty is again trying to touch its weekly 13 EMA (2938)….so does that mean tommorrow a fall is expected with high probability…….as nifty has almost reached 2920Br Gaurav
February 9, 2009 at 8:14 pm |
Nifty to remain range bound once again for couple of days.No major upside is expected though
February 15, 2009 at 8:31 am |
India/China Index ratio added to the MC TrackerSpread Sheet Tool
February 15, 2009 at 12:19 pm |
Hey Raj, good stuff man need to learn indepth abt ur strategy……the next GURU bhai of stock mkt..regards,Artoftrading..
February 16, 2009 at 3:53 am |
hi raj,good job, really apperciate
February 16, 2009 at 9:15 am |
Thanks Raj. Working just fine on Vista Ultimate, Office 2007.A note for others, you may need to permit file to use live content.
February 16, 2009 at 11:11 am |
I am unable to open the excel showing some error.
March 4, 2009 at 3:21 pm |
Dear Raj, U have done a wonderful job. Congrats. Sometimes some fields like Trin today is not getting updated Y?
March 18, 2009 at 7:52 am |
please explain the meaning .PCR is SMR ratio is then what does that mean paresh
April 15, 2009 at 8:41 am |
HiIt is an excellent tracker!Right now it is displaying date as 25-Feb-2009although data is current.Also Nifty options sheets is displaying Strike price till 3100 only.
April 16, 2009 at 4:39 am |
siri have not updated the all charts what can i dochowdarykpcadvocate@gmail.com
April 18, 2009 at 6:20 am |
Dear Rajendran, I search VIX & SMR since last 6 months. My search end here. Now, I can guss market move with your help. Thank you
April 18, 2009 at 7:26 pm |
getting some error while updating data
April 19, 2009 at 5:03 pm |
allready download but getting some error like unable to open file because the server did not understand request or request unvalid so what should be done pl guid me on goldigandhi@yahoo.com
July 11, 2009 at 7:11 pm |
It would be great idea if the auto refresh 1 minute becomes a configurable parameters
July 23, 2009 at 2:37 pm |
I am unable to get updated values of smart money and the rest. Can anybody send the latest file