Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

MC Tracker v1.0

19 sec read

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
 
 
[wp_ad_camp_5]

 

Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

Best Programming Languages for Traders & Investors to Learn…

Here is a list of programming languages that traders/investors may want to consider learning in the year 2023 to build their own trading indicators,...
Rajandran R
4 min read

Tijori Finance – Better Fundamental Data Analysis using Alternative…

Tijori Finance a sleek design portal to access in-depth data such as market share, revenue break-up, location exposure, operational metrics shareholding & financial on...
Rajandran R
1 min read

Tick Data Vendors and Quality of Tick Datafeeds

Last coupe of weeks we spend our energy in understanding the quality of the datafeeds(Indian & International vendors) for NSE Futures. Since data is...
Rajandran R
1 min read

21 Replies to “MC Tracker v1.0”

  1. 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

  2. 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

  3. 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

  4. Nifty to remain range bound once again for couple of days.No major upside is expected though

  5. Hey Raj, good stuff man need to learn indepth abt ur strategy……the next GURU bhai of stock mkt..regards,Artoftrading..

  6. Thanks Raj. Working just fine on Vista Ultimate, Office 2007.A note for others, you may need to permit file to use live content.

  7. Dear Raj, U have done a wonderful job. Congrats. Sometimes some fields like Trin today is not getting updated Y?

  8. 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.

  9. 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

  10. 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 [email protected]

  11. It would be great idea if the auto refresh 1 minute becomes a configurable parameters

  12. I am unable to get updated values of smart money and the rest. Can anybody send the latest file

  13. I am unable to get updated values of smart money and the rest. Can anybody send the latest file

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More