How to plot a histogram on Excel? (Part 2) using Returns

How to calculate a Moving Average? EMA

Daily commentary: 12 12 2014

Market was flat for the last trading day of the week. Nifty and Sensex ended negative. Today NSE benchmark Nifty closed -0.81% low and BSE Sensex with -0.91%. Traders remained cautious ahead of IIP and retail inflation data to be released later in the day. BSE oil and gas index hit 7 months low.  Today’s fall is the biggest fall since July.

The movers of the day are Ultratech Cement , Maruti, Lupin, Ambuju Cement and Sun Pharma . And the top losers of the day are GAIL, Tata Steel, CAIRN, ONGC and SSLT.

The entire Broad Index ended up red. With Midcap and small cap poorly hit. CNX pharma was up by +0.23%. India Vix was up by +7.67%. Wherein Crude oil fell below $63/Barrel

Asian markets closed mixed. Japan's Nikkei finished 0.66% higher, Hong Kong's Hang Seng was down 0.27%, and China's Shanghai Composite was up 0.43% at the end of the day. US futures are also sinking.  China's industrial output grew by a less-than-expected 7.2% in November from a year ago, but retail sales rose 11.7%, beating forecasts.

As there was a weakness seen in stocks and US dollar; gold were up by 3% putting it us the biggest rise in last 6 months in global markets. The entire precious metals even silver and platinum are showing some rise.

Daily Commentary: 10/12/2014

After 3 day continues fall today Market closed marginally higher. Nifty was volatile with +0.18% and

Sensex also closed higher yet out of 30 scripts only 13 were on positive note. Meanwhile, ONGC, SBI,

Tata motors were the limelight stocks for the day.


Traders are still cautious over market as there was not directional cue from today. Market breadth on the

BSE remains healthy 1,587 shares advancing and 1,176 shares declining. Foreign Portfolio Investors sold

a net worth Rs 221.52 crore on Tuesday as per provisional data. India VIX was negative by -2.02%

The Top Movers of the day are SBIN, Jindal Steel, ONGC, PNB and Bank of Baroda. Top losers of the

day are NMDC, BHEL, HUL, GAIL and Tech M.


As Chinese consumer inflation was reported to be 5 year low Chinese market +3% higher to yesterday.

Weak crude oil price and pull-down in US Market affected Japanese market due to which Nikkei was low

by -2%


 However, BSE Capital Goods, IT and FMCG are losing sheen and are down between  -0.4 to -1%. Yet,

Midcap and small cap closed higher and stool as outstanding index for the day. Meanwhile, Government

is thinking to conclude coal linkage rationalization an and swapping agreement for terenal project wich

will save 6000 crores . This is going to benefit power projects of companies including Adani Power,

Indiabulls Power and NTPC, among others.

Market Commentary:12/9/2014

Major Indian Index Nifty and Sensex opened negative and after two failed attempts to stay positive Nifty Slipped -1.16% and Sensex slipped -1.15%. Both the Indices gave conformation of 20DMA negative breakout which happened yesterday. Indian Market ended up its 8 week low.

Today all the major Indices were negative; India VIX was up by 2.36%. The major losers in stock are SSTL, ONGC, Tata Power, Tata Steel and the top gainers are M&M, Dr. Reddy, Sun Pharma and HCL Tech  

Most of all Asian Markets are in negative in which Chinese market fell over 5% creating a major fall since 2009. Meanwhile Brent Crude oil hit its 5 year low at USD 66/Barrel.   

Technical Analyst predicts 100DMA can be the next support for Nifty and Sensex. Indian stock market is likely to consolidate further this week. Traders say weak global cues and rise in current account deficit (CAD) is the major reason for today’s fall.

Video Resume Sangamesh K S

Statistics in Excel: Mean, Median, Mode, Range, Standard Deviation and V...