Draw candle stick on Excel

Here in this Video I have shown that it is possible to draw candle stick charts on Excel

How to Calculate Beta of a stock?

Here in this video I have shown how to calculate a beta of the stock using excel and log return.

Click here to view the calculation

Technical Analysis on SBIN (State Bank of India)

I m looking SBI for a correction. The stocks is at its resistance and if the trend line gets broken the stock will drop at its support 1837. 

Strategy for Gold on FOCM meeting

Today all eyes are on FOCM meet to be held. Not only commodity and Gold but Forex and stock market will have implication of the meeting which is to be held today or tomorrow(Source: Business Standards). Anticipating strategies for gold, all eyes are on tapering of bonds by fed. Many experts believe that Fed will come up with taping of bond buying program. If it happens gold will loose value globally.

Technical

An open up candle followed by a bearish engulfing had given a clear indication of a possible bearish trend 28k &26K are the good supports as seen in technical charts. More clarity will be seen after fed's bond buying strategy.  

Gold; Where is it?

Gold has become a huge political issue. In spite of many artificial measures to stop import of gold, government has miserably failed. This eventually led to the domino effect in the entire Indian Financial Markets.

We are currently seeing Gold at upper level the RSI is giving a caution signal and we have 2 major resistances ahead. It’s a high time for gold, the trend-line which was broken by gold during the end of March and the upper level resistance @32,500.

We are seeing signals from gold of a possible correction. Which will start from the first week of next month or prior. 

If gold is able to give a breakout and sustain the breakout gold is again a screaming buy.

For previous article on gold; Click Here

BSE FMCG; Will it enter a bull run?

Jetairways; an Analysis

Most of the aviation stocks are at a downtrend, few hit badly. I am seeing Jet airways to be a potential stock. it is forming a falling wedge along with it we are seeing divergence. The stock has even given a per-mature breakout. The target are showen above in the figure. If the stocks fail to give a breakout the stock is expected to find support at 275 

Weekly analysis of Sensex: 29th April to 3rd March 2013

The market  will  looking sluggish this week the resistance of 19712 will be a major resistance for this week the market is expected to have  18624 as a support at lower side. we are seeing a negative divergence in in Sensex, this may drive to 18624.

 Am I bullish on Sensex?

No, I expect a consolidation. We are seeing a risk building out in Sensex, as per me this week is the week for profits booking. Most of the short term players may book profit this week.

How much consolidation is good for Sensex?

18510-18000 need to be the support below which market is not healthy to grab. If market manages to consolidate below 18000 levels we may see a free fall upto 17500/16900.

RIL: An Analysis for 25/4/13

After one cycle swing seen in reliance I am looking a reversal. The stock has a powerful resistance at 850. If it able to cross then we can see the stock going up to 920.

Indicators:  we are seeing a bullish divergence which is been building from long days. We see this divergence in MACD. We have even seen a good crossover as most of the stock has been in a bearish mode. It is been a hotspot for many of the investors.

Fib Levels:  As I had told above this stock may find resistance at 50%. If it manages to cross that level, it will reach to 920. Which will lead to 920 levels; the stock is looks potential and we may even see the stock moving more than 940 as the divergence is strong.

Moving Average: I have been looking for a long time. The stock is more sentimental towards 20 DMA. After confirmation of a breakout in 20 DMA this stock is found to be bullish.

A Falling Wedge in Sensex

We have seen market consolidating, these days. The cocktail of negative news have driven market near to 18000 levels. Before it reach 18000 we are seeing falling wedge pattern forming. 

A Falling Wedge

A Divergence Building up 

Simultaneously, we are seeing a Bullish Divergence forming in market. As we are seeing a gap filling have started up in Sensex. We may see a reversal @18000 level after filling up of gap; which will eventually lead to a bullish breakout in Falling wedge.

Important SAR

A Story of Turtles; History of Trend Following

Richard J. Dennis, a man who made a history in the world of trend following. Many of us use trend following in their investments & trading practice. But most of the people are not aware of this person and his contribution to Trend and Trend analysis.

Richard Dennis

It was the year of 1970’s when a 17 year old student of philosophy Richard J. Dennis; started this career as a floor trader at Chicago Mercantile Exchange. Soon after his education he returned to trading. He borrowed $1,600 from his family, which after spending $1,200 on a seat at the Mid-American Exchange left him $400 in trading capital. In 1970, his trading increased this to $3,000, which he described as "compared to $400 ... a real grubstake", and in 1973 his capital was over $100,000. He made a profit of $500,000 trading soybeans in 1974, and by the end of that year was a millionaire, just short of twenty-six years of age. Today he is well known as a commodity speculator once known as the "Prince of the Pit".

The story of turtles

Dennis believed that successful trading could be taught. So, along with William Eckhardt, a friend and fellow trader, Dennis recruited and trained 21 men and 2 women, in two groups, one from December 1983, and the other from December 1984. In January 1984, after the two-week training period was ended, Dennis gave each of the Turtles a trading account and had them trade the systems they had been taught . During this one-month trading period, they were allowed to trade a maximum of 12 contracts per market. After the trial-period ended, he gave the few of them who had successfully traded the system during the one-month trial, accounts ranging from $250,000 to $2 million of his own money to manage.

An advertisement by Richard Dennis

Selection of Turtles

 Dennis placed an ad in The Wall Street Journal and thousands applied to learn trading at the feet of widely acknowledged masters in the world of commodity trading.

In the selection process he asked basic question like

1.     The big money in trading is made when one can get long at lows after a big downtrend.

2.     It is not helpful to watch every quote in the markets one trades.

3.     Others' opinions of the market are good to follow.

4.     If one has $10,000 to risk, one ought to risk $2,500 on every trade.

5.     On initiation one should know precisely where to liquidate if a loss occurs.

Trading Strategy
Dennis trained this group, known as Turtles, for only two weeks introduction about a simple trend-following system, trading a range of commodities, currencies, and bond markets, buying when prices increased above their recent range, and selling when they fell below their recent range. They were taught to cut position size during losing periods and to pyramid aggressively—up to a third or a half of total exposure, although only 24% of total capital would be exposed at any one time. This type of trading system will generate losses in periods when the market is range-bound, often for months at a time, and profits during large market moves.

In "The Complete TurtleTrader: The Legend, the Lessons, the Results" (2007), author Michael Covel offers some insights into the specific rules:

• Look at prices rather than relying on information from television or newspaper commentators to make your trading decisions.
• Have some flexibility in setting the parameters for your buy and sell signals. Test different parameters for different markets to find out what works best from your personal perspective.
• Plan your exit as you plan your entry. Know when you will take profits and when you will cut losses.
• Use the average true range (ATR-an indicator) to calculate volatility and use this to vary your position size. Take larger positions in less volatile markets and lessen your exposure to the most volatile markets.
• Don't ever risk more than 2% of your account on a single trade.
• If you want to make big returns, you need to get comfortable with large drawdowns.

Outcome of Turtles
The story of how a group of non-traders learned to trade for big profits is one of the great stock market legends. Dennis earned more than $175 million in only five years. He also proved that, beginners can learn to trade successfully. Number of turtles (e.g. Jerry Parker of Chesapeake Capital, Liz Cheval of EMC, Paul Rabar of  Rabar Market Research) began and continued careers as successful commodity trading managers, using techniques similar, but not identical, to the Turtle System.

Support for Yes Bank

Bajaj Auto Ltd, A Analysis

After a corrective wave from 2223 the stock fell upto 12% causing a bullish divergence. MADC is below 0 line and making the stock more attractive and RSI is showing a strong bullishness. The stock have a potential to go upto 2220. 

State Bank of India, Analysis

"Haven't I told you?" ITC Reversal

I repeatedly wrote 2 articles regarding ITC Ltd seeing a possible reversal. I gave an exact support when a guy  asked  me a query, on my Blog. The stock was in a corrective phase where I saw a bullish divergence and predicted well before it happened.

• My article on ITC where I told it will go into a corrective Phase(Date:20/12/2012): Click Here
• My article on ITC where I spotted a reversal (Date:8/1/2013):Click Here
• My article on  ITC standing on my support(Date:7/1/2012):Click Here

ITC- Reversal

Yesterday at this time I wrote an article on wave analysis and and other factors in ITC. The wave seen in ITC Ltd is a Zig-Zag corrective wave along with it we are seeing a bullish divergence in this stocks. The stock have shown a reversal know.

Conclusion: can go with a good stop loss, it have a target of 10%.

Strategy: see for down-trend line, if it break today. Then bullish  

See yesterdays article on ITC: Click here

ITC, wave analysis

After seeing a bearish divergence the stock went to a correction we are currently seeing last wave correction . ITC have started showing a bullish divergence,  stock is having a support around 270

Tata Steel, Elliott Wave Analysis

It’s almost a year or more I have been observing that Tata Steel is more sentimental towards gaps theory. This phenomenon may be usual and may be seen in many stocks but we are seeing this "gap theory" again and again in tata steel.  Long ago I was speaking regarding "Magical support" of sensex. But Tata steel have too much of such SAR

The stock has started to correct and have a possible correction till around 417 and move in the bullish channel.

Elliot Wave Analysis

This is my 1^st EWT analysis. Currently we are seeing Tata steel correcting. It has just started corrective wave A and may have a support as mentioned above (around 417). 

Technical Analysis on IVRCL Ltd

On 3rd December I had had told my opinion on my page Experiments With Stocks, The stocks went up to  +9% and gave a bearish engulfing. the price is currently ruling around 42. I was away from this stocks but a sudden Harami drew my attention.

According to me the stock have a potential to go upto 47. If it show a reversal know. If not the stock have a  support at 39.

Rel cap

Good Morning,
                        Rel cap is showing a bullish divergence along with a breakout. The stock is also about to make a Bullish crossover on MACD.

Have a nice day :)