Showing posts with label Trading Strategy. Show all posts
Showing posts with label Trading Strategy. Show all posts

Saturday, 28 January 2017

Basics of Technical Chart : Stock Trends, Moving Averages, RSI, MACD, Support and Resistance


Day trading in stocks is risky. However, if you have an eye for spotting market trends, you can make a neat pile in quick intra-day deals. There was a time not long ago when trading was a simple game of buying and selling stocks based on one's conviction. Now, technical analysis- a science of predicting future prices from historical price data-has given investors new tools. "Technical analysis increases the probability of your call being right," 
How it works
Technical analysis is done on the basis of historical price movement plotted on a two-dimensional chart. One reason it has become popular is that anybody can look at the chart and see how prices have moved.
For example, in the chart, Easy Reading, you can see open, high, low and closing prices of the National  Stock Exchange.
How to pick a stock
Good volume and volatility are a must to gain from trading. While volume should ideally be at least 500,000 shares, the stock should have a high beta, or volatility. This means if the index rises 1%, the stock should rise by more than 1%. Those who don't understand the concept should see to it that the difference between intra-day high and intra-day low prices of a stock is at least Rs 10.
Identifying the right stock and fixing a stop-loss level is a must, says Paul. One must stick to the stop-loss. Generally, stop-loss is fixed at 1.5-2%, which means the stock is sold if it falls 1.5-2% below the purchase price. Big traders generally fix stop-loss at about one-third of the expected profit. For example, if they expect a stock to rise 10% in three days, they set a stop-loss at a point the price falls by 3%.
Once you zero in on the stock, look at its volumes and price trends. Generally, higher volumes with higher price rise indicate an uptrend, but it should not be considered a thumb rule. Big volumes and large moves sometimes throw up big tops and bottoms, says Barrett. This means if both volumes and prices are increasing, it may be the last leg of the rally.
Stock Trends
Identifying trends is important. But how do you spot a trend? It's difficult, as the market never moves in a straight line. A stock will never fall continuously on a given day and rise on another. "Generally, higher highs and higher lows indicate an uptrend, whereas lower highs and lower lows mean a downtrend," .
"Look at the trend. Look at news related to the stock," . For example, if the rupee is falling against the US dollar, it's common knowledge that technology companies will gain.
Analysts and market experts take the help of various parameters to confirm if a stock is a trade pick. The most used are available in any technical analysis software. These include 200-day moving average, relative strength index, moving average convergence divergence or MACD, Fibonacci retracement and candle stick price chart. The terms may sound daunting, but software available nowadays makes technical analysis easy.
Moving Averages

One of the widely used tools is the 200-day moving average. You simply have to plot the 200-day moving average on the price chart. When the price of the stock rises above the moving average line, it's a buy signal, and when the price falls below the moving average line, it is a sell signal. One can also look the 50-day moving average or the 10-day moving average. Trading is a game of probability. So, you have to arrive at your own methods to decide which parameters suit you the best. In the graph, Moving Averages, you can see the Sensex movement compared to the 200-day moving average of the Sensex. The brown line is the moving average line. In February, the line went above the price bars and the Sensex started falling. When the 200-day moving average fell below the price bars in April, the markets started going up. In the graphic, the Sensex is below the moving average, indicating bearishness. But this is just one parameter.




Relative Strength Index (RSI)
RSI compares the magnitude of recent gains to recent losses to see if an asset is oversold or overbought. RSI is plotted on a scale of 0-100. Generally, if it is above 70, the stock is considered overbought and so one can look to sell it. Similarly, an RSI of less than 30 indicates the stock is oversold and can be bought. In the chart, Relative Strength Index, you can see that RSI was near 20 in October 2011, signaling that L&T's shares were oversold. It reversed from 20 and the stock moved up.


Moving average convergence divergence (MACD)
This is a very important tool used by technical experts. You just have to select the MACD and plot it on a chart. The MACD comprises two lines, fast and slow. The fast line is the difference between the 26-day exponential moving average and the 12 day-exponential moving average. The slow line, also called the signal line, is the nine-day moving average. So, the blue line in the chart, MACD, is the fast line and the brown line is the slow line. With technology, these calculations are automated and a graph gets plotted at the click on the mouse.
When the fast line crosses above the slow line, it's a buy signal, and when the slow line crosses the fast line, it's a sell signal. The chart shows that the MACD is the best way to predict the movement of a stock.
Fibonacci Retracement

Fibonacci retracement is based on the assumption that the markets retrace by a few predictable percentages, the best known of which are 38.2%, 50% and 61.8%. So, when the market retraces 38%, it will generate either a sell or a buy call depending on the trend.
You have to plot Fibonacci retracement from the peak price. The software will give the above mentioned retracement levels. When the price reaches the 38.2% level and bounces, it means the price of the stock at which the chart plots the 38.2% retracement is the support level and you can buy. However, if the price falls below the 38.2% level, you may look at the price at 50% retracement level as your next support. The chart, Fibonacci Retracement, shows how the 38.2% retracement is working well for the Ranbaxy stock.


Support and Resistance 
You may hear or read technical experts recommending support and resistance levels. But plotting support and resistance and finding it yourself is a simple job. As you know, prices move in a zig-zag fashion and form lows and highs. A support is plotted at the daily low price and resistance at the daily high price. For example, in the given chart, support of 4,700 for the Nifty and if the index falls below this, it may fall further to 4,300.  Resistance is plotted  at 5,177 levels. Take a look at how we can  manage to get support and resistance for the Nifty from the October 7 graph.

Wednesday, 25 January 2017

Intraday Trading Using Gann's Square of 9/Gann Calculator



How to use GANN Square Of 9 Calculator?

1. Our GANN Calculator is focused around the hypothesis of W. D. GANN’s Square Of 9. Gann depended vigorously on geometrical and numerical connections and made a few apparatuses to help with his work. Around these apparatuses are the GANN Square of Nine, GANN Square of 144, and the GANN Hexagon.


Moneygaze.com




2. The GANN Square of Nine, or GANN Square as we will allude to here, might be built in no less than two ways. The static Square has the number 1 at the focal point and the element Square has the memorable low of the time arrangement in the core. The Square is a framework of numbers that starts in the inside with the number 1. The number 2 is entered in the case to the left of the number 1. Climbing and around clockwise (some are built by moving anticlockwise to work reliably with astro diagrams), 1 is added to the past number and the ensuing number is entered in the case. This is rehashed in a winding around the inside.

3. The paramount parts of the GANN Square of 9 are the core, the Cardinal Cross made out of the vertical and even lines that cross at the center of the square, and the lines reaching out at 45 degrees, 135 degrees, 225 degrees, and 315 degrees that constitute the Fixed Cross. The Cardinal Cross and Fixed Cross are utilized to focus likely purposes of help and safety.


4. This gann square of 9 calculator is implied for trading just intraday.


5. Enter the LTP (last traded price) or WAP (weighed average price) of any stock/ index/ future at whatever time throughout the trade hours.


6. The perfect time is 15min – 1hr secondary selling opens.


7. On the off chance that you are unable to discover the WAP, you can additionally enter last traded price of the stock/ underlying.


8. In the wake of entering the value, click the calculate button.



9. You will get the buy and sell decisions.


10. Take after the decision you get to trade.


11. For more point by point contemplate on GANN Square Of 9, please click the button underneath to download the extraordinary digital book The Definitive Guide to Forecasting Using W.D. Gann’s Square of Nine by Patrick Mikula.

Tuesday, 24 January 2017

Top stocks & strategies of Successful Investors in India -Rakesh Jhunjhunwala,Vijay Kedia,Porinju Veliyath,Dolly Khanna

Rakesh Jhunjhunwala, Vijay Kedia, and Porinju Veliyath are few successful investors of the stock market. What makes them successful investors?  Where they invest their money? How successful investors make money from the stock market?  These are some common questions which we keep on hearing almost every day. Most of the time we don’t have answers to these questions. In this post, I will try answer these questions.

How to become a successful investors in the stock market?



Although the sure-shot formula for the success in the stock market is yet not discovered, here are strategies followed by successful stock market investors. These strategies will surely help you to become successful in the stock market.
1.Rakesh Jhunjhunwala
Buy Right and Hold Tight.  
Rakesh Jhunjhunwala is a well-known stock market investor. He is also known as warren buffet of India. One of the strategies followed by him is Buy right and Hold tight. He purchases fundamentally sound stocks and holds it for a longer duration. The buy and hold strategy is also used widely by value investors like warren buffet, peter lynch and Philip fisher. The long-term investment strategy gives tree benefits –
  • Historically it is seen that over a longer duration stock price appreciation is much higher.
  • You can get benefit of dividend year on year.
  • You can take advantage of stock split or bonus over a longer duration.
You should look at opportunity while investing in stock market.
The second investment strategy followed by Rakesh Jhunjhunwala is look for future business opportunity while investing in stock. RJ made a lot of money in stocks like Parj Industries because he has seen a future business opportunity of ethanol in India. This is most common investment philosophy of every successful investor.
2.Vijay Kedia
Invest in only best managed companies.
Vijay Kedia is a successful name in the stock market. Vijay Kedia investment strategy is to invest only in the best-managed companies. Good management in bad business is better than bad management in good business. If you invest your money in the best-managed company, you need not worry about market volatility.
Book Profit Periodically
Vijay Kedia believes in booking profit periodically. As per him when a stock has reached a target or when a stock looks overvalued you should book a profit. A balancing act on your portfolio always helps. You should not hesitate to cash in the gains.
3.Porinju Veliyath
Make strategy when to exit from stock
Porinju Veliyath is among value investor of India. He suggests making a strategy when to exit from the stock. As per him, timing is very important and skill related to that usually comes from experience. Porinju exited from Shreyas Shipping by booking profit at the level of Rs.700. After reaching all-time high stock price is now reduced to Rs.271
Remember – A successful investor is always right when it comes to buying and selling stocks. They know when to buy, what to buy and when to sell.
Buy High Quality lesser known stocks
You should identify and invest in high-quality lesser-known stocks. In order to identify such stocks, you need to do careful research. The entire portfolio of Porinju is full of less known stocks such as Gokaldas Exports or Nirvikara Paper Mills.
4.Dolly Khanna
Invest based on Facts
Dolly Khanna is known as a lady with Midas touch. She follows a strategy of investing in stock based on facts. She advises that you should never invest in stock based on speculation or insider information. You should invest in a company with strong balance sheet. In order to do that, you should learn to read annual reports and balance sheet of the companies.
Top Stocks of successful investors in India
After looking at investment philosophy of successful investors let’s take a look at where they invest their money. The top stocks holding of successful investors in India is given below.

You can defiantly make a money from the stock market because the stock market is the best place to make money.  The only thing you require is patience, discipline, and strategy in order to become a successful investor in the stock market.
Do you think above-mentioned strategies of successful investor will help you in getting success in the stock market?
Do you think top stocks of successful investors is worth for investment?
Do share your views in the comment section.

How to start Auto Trading in Zerodha Kite ?


I have prepared this post where you can get in-depth idea on how you can start auto trading or algo trading in Zerodha Pi platform.
Case 1: Auto Trading in Zerodha Pi – Directly writing expert advisor code on Pi platform
  1. Open Zerodha expert advisors page by clicking here.
  2. Run your Zerodha Pi.
  3. Create new expert advisor by clicking Artificial Intelligence –> Create new expert advisor.
  4. You can backtest your expert advisor or take it into live trading also.
  5. You can also use ready made expert advisors from Zerodha Expert Advisors page.
  6. By default retail traders can do semi automated trading. If you want fully automated trading need to provide NCFM / NISM certificate to Zerodha and approve your strategy from the exchange. Remember, approving your strategy may take at least one month.
  7. There can be some charges for semi automated and fully automated trading.
For detailed information on the charges and expert advisor you can write a mail to support@zerodha.com OR post your queries to Trading QNA site.

Auto Trading In Zerodha
Case 2: Auto Trading in Zerodha Pi – Using Pi Bridge

Using Zerodha Pi Bridge, Zerodha Pi can be connected to your favourite charting language like Amibroker, Ninja Trader OR even you can write your trading logic in your favourite programming language like C#, Python or Perl and fire your trades directly into Zerodha Pi. You can also utilise or code two way updates to and from Zerodha Pi. One way you can fire orders and on the other way you can get order updates, modify or delete orders or get your position updates.
Pi Bridge
For accessing Pi Bridge you need to login to your backoffice Q and activate it from the Pi section of Q. Remember there can be some charges for using Zerodha Pi Bridge. For detailed information on the charges of Pi Bridge you can write a mail to support@zerodha.com OR post your queries to Trading QNA site.

Monday, 16 January 2017

Risk Reward Ratio,Profitablity and Success Rate: Excel Sheet

I hope you have already read our article on Risk Reward Ratio. If not, please find it here.
Many of our readers have requested for the excel sheet to calculate the profitability based on Risk Reward Ratio. You can find the excel sheet as an attachment with this post. And yes, we have not kept any formulas hidden in the excel sheet

                             
The Excel sheet basically contain two worksheets outlined below:-
1) Risk Reward Ratio and Profitability:- This worksheet will calculate the profitability based on your risk-reward ratio. In this worksheet, you just have to enter the Risk and Reward values in column A and B respectively. We have kept Success Rate as 40 for all calculations, however this is editable and can be changed as per your strategy. Risk is the maximum amount you can lose in a trade(This might be equal to your stop loss value). While Reward is the Target Profit expected. Different strategies have different risk-reward ratio. Profit is calculated considering 100 trades, with Risk and Reward as input in designated columns.

We have already pre-filled excel sheet with some standard values, which can be edited as per requirement. Also, an Area graph is created based on the values in the table. Please see the below screen-shot.

2) Risk Reward Ratio vs Success Rate: This worksheet will calculate required Success Rate for the given Risk Reward Ratio, and vice versa. In this worksheet too, you  have to enter the Risk and Reward values in column A and B respectively. Success Rate is calculated for a break-even trade (no profit no loss).
We have already pre-filled excel sheet with some standard values, which can be edited as per requirement. Also, a line graph is created based on the values in the table. Please see the below screen-shot.

Please note that we haven’t considered brokerage or any other charges while formulating this excel sheet.
Download the Excel sheet here. Post your queries in the comment section below.

Moving Average Trading System in Excel Sheet

Probably Moving Average based trading systems are most popular among the traders across the globe. These trading systems work very well in Trending markets.

                         
Most of the beginners might not have subscription to any broker with continuous data feed. So here  we have provided semi-automated  Moving Average trading system in Excel. The only manual task would be to copy closing price for the security selected in this excel.

Strategy Overview

ParamterValue
Preferred TimeframeDaily
Indicators Used3 Days EMA, 5 Days EMA
Buy Condition3 Days EMA is above 5 Days EMA
Sell Condition3 Days EMA is below 5 Days EMA
Stop LossNo fixed target, Stop and reverse when excel gives opposite signal
TargetsNo fixed target, Stop and reverse when excel gives opposite signal

Excel Sheet
ParameterDescription
Worksheet NameMA Trading System
InputsDate (Column A)Calender Date
Close Price (Column B)Closing price  on specified Calender Date.
Faster EMA Period (Cell C2)Faster Exponential Moving Average. Default is 3.
Slower EMA Period (Cell D2)Slower Exponential Moving Average. Default is 5.
OutputsFaster EMA ValuesFaster EMA values based on period defined at input.
Slower EMA ValuesFaster EMA values based on period defined at input.
Crossover PriceThe exact price at which EMA crossover will take place.
SignalBuy/Sell signal based on conditions mentioned at strategy overview.

Screenshot

MA Trading System

Download Link

Fibonacci Levels Calculator: Excel Sheet

Fibonacci Levels is one of the most popular tools in the worlds of Technical Analysis. These levels are predictive in nature and helps to identify pullbacks or breakouts. People have been using it successfully since years especially in Forex market. Using Fibonacci retracements in your trading will not guarantee you overnight success. But if used in conjunction with other technical analysis indicators like RSI, MACD, moving averages, candlestick patterns, etc it can be very valuable. In this post, we have shared Fibonacci Levels Calculator Excel sheet. Please read through to understand how to use it.
Check out the other popular Excel sheets posted in this blog here.



What is Fibonacci Sequence?

The Fibonacci Sequence is a series of numbers where the each number in the sequence is the sum of previous two numbers. The first ten numbers in the Fibonacci Sequence are: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34. Fibonacci numbers also appear in many aspects of nature such as the arrangement of leaves on a stem and the branching of trees. Off lately, this sequence has gathered huge popularity in Financial markets too.
From the Fibonacci Sequence comes a series of ratios, and  these ratios are of special significance to traders as they predict possible reversal or breakout. The most important Fibonacci ratio is 61.8% – it is sometimes referred to as the “golden ratio” or “golden mean” and is accepted as the most “reliable” retracement ratio. The Golden Ratio is arrived at by dividing any number in the sequence by the number that immediately follows it. No matter which number you choose, the answer will always be very close to the mean average of 0.618, or 61.8%. For example:
  • 8 divided by 13 = 0.615 = 61.5%
  • 13 divided by 21 = 0.619 = 61.9%
  • 21 divided by 34 = 0.617 = 61.7%
The other two Fibonacci Ratios that forex traders use are 38.2% and 23.6%. These two ratios seem to have a lower level of success but are still included for analysis purposes.
The 38.2% ratio is derived by dividing any number in the sequence by the number found two places to the right. For example:
  • 8 divided by 21 = 0.380 = 38.0%
  • 144 divided by 377 = 0.381 = 38.1%
  • 6765 divided by 17,716 = 0.381 = 38.1%
In a similar fashion, the 23.6% ratio consists of any number in the sequence divided by the number that is three places to the right:
  • 5 divided by 21 = 0.238 = 23.8%
  • 34 divided by 144 = 0.236 = 23.6%
  • 6765 divided by 28,667 = 0.235 = 23.5%
In addition to these three ratios, most trading systems also show retracement levels at 50% and 100%.

How to use Fibonacci Levels?

Fibonacci Levels are broadly classified into two: Retracement levels and Extension levels. Retracement levels represent the percentage of Pullback or retrace before reversing into the original trend. While the Extension levels represent the price target. In general terms, the retracement levels give you an idea of where to put Stop Loss, while Extension levels help you identify the profit targets.
Here is the graphical representation of retracement:
retracements

After a stock makes a move to the upside (A), it can then retrace a part of that move (B), before moving on again in the desired direction (C). These retracements or pullbacks are what you as a swing trader want to watch for when initiating long or short positions.

Excel Sheet for Fibonacci Levels Calculator

ParameterDescription
Worksheet NameFibonacci Levels Calculator
InputsCell B5,B6,B20,B21
High and Low values of the selected Stock for Uptrend and Downtrend respectively. It can be weekly High and Low for Swing Trading, or Hourly High and Low for Intraday Trading.
OutputsCells E5:H16Retracement and Extension levels for Uptrend
Cells E20:H31Retracement and Extension levels for Downtrend

Screenshot


Fibonacci Levels

Download Link

Please download the Excel sheet from the below link. Let us know in the comments section if you have any queries.

Nifty Option Greeks Calculator: Live Excel Sheet

People who practice Options trading know very well how important ‘Option Greeks’ are. As per Investopedia, Trading options without an understanding of the Greeks – the essential risk measures and profit/loss guideposts in options strategies – is synonymous to flying a plane without the ability to read instruments. Option Greeks, denoted by certain Greek alphabets, are the parameters which determine how Option price varies with the change in external factors like Time, Volatility and underlying Stock Price. These Greeks are calculated based on the Black and Scholes options pricing model, which was first published by Fisher Black and Myron Scholes (hence the name Black & Scholes) in 1973. In this post, we’ll go through a Nifty Option Greeks Calculator which updates real-time and calculate Greek values for all the strike prices of Nifty Put and Call options.

                                

Options Greeks definition

option-greek

Image Source: http://optionspedia.blogspot.in/2012/10/option-greeks.html
  1. Delta – Measures the exposure of option price to movement of underlying stock price
  2. Gamma – Measures the exposure of the option delta to the movement of the underlying stock price
  3. Theta – Measures the exposure of the option price to the passage of time
  4. Vega – Measures the exposure of the option price to changes in volatility of the underlying
  5. Rho– Measures the exposure of the option price to changes in interest rate

Nifty Option Greeks Calculator: Excel Sheet overview

ParameterDescription
Worksheet NameGreeks
InputsExpiry Date (Cell E3)Expiration date of current Nifty Option series. Generally it is the last Thursday of the month.
Risk free interest rate (Cell E6)This is risk free rate prevailing in the economy. Use the RBI 91 day Treasury bill rate for this purpose. You can get the rate from the RBI website, RBI has made it available on their landing page here.
Dividend Yield (Cell E8)This is the dividend per share expected in the stock, provided the stock goes ex dividend within the expiry period.
OutputsCells B11:R31Option Greeks values for each strike price.

Nifty Option Greeks Calculator: Screenshot

Nifty Option Greeks Calculator
How to use this Excel Sheet
Below are the simple steps to use Nifty Option Greeks Calculator excel sheet. There is very little manual intervention required for this.
Step 1: Download the Excel file from the end of this post.
Step 2: Open this Excel file and make sure you are connected to internet. Please accept if it asks to enable Macros and Data connections.
Step 3: Input the required fields, Expiry Date, Risk free interest rate and Dividend yield.
Step 4: The Greek values would automatically get updated. The sheet refreshes every five minutes.

Download link for Nifty Option Greeks Calculator

Please see the below link to download Nifty Option Greeks Calculator excel sheet. Mostly everything is self explanatory, but please let us know if you have any queries. Also, send us your feedback on how to improve this sheet.

Options Max Pain Calculator: Excel Sheet

Max Pain theory in Options Trading is probably one of the newest bust most popular strategies for Options trading. This theory is backed upon the fact that about 95% of option buyers lose money. We have personally traded based on max pain and the success ratio is pretty cool. This article intends to explain max pain theory of options and how to profit from it. Also, we would go through Options max pain calculator excel sheet which can be downloaded from the end of this post.

Max Pain Theory: Definition and Usage

The idea behind Max Pain theory is the fact that Option writers tend to manipulate the expiry price of stock, index or commodity so that they benefit the most out of their positions. Although there is no authentic proof that how they manipulate the prices, yet this theory is widely accepted. As 95% of the options expire worthless and options is a zero sum game, this theory seems very realistic and logical. By definition, Max Pain is the strike price where if the underlying settles on expiry will cause maximum loss or maximum pain to the option buyers. Guess who would benefit from their loss? Yes, its Option sellers. Most of these Option Sellers are large investors / institutions or hedge funds that will hedge their positions and have the ability to manipulate the stock price to suit their open Options position.
There are enormous ways in which you can benefit from Option pain. Basically, max pain tells you the approximate level at which the contract is going to expire. If you know know this level, you can simply write Call options slightly above this level and pocket the premiums on expiry. Similarly, you can write Put options below this level. If you are a conservative option trader you can employ different hedging strategies like Bull Spreads or Bear Spreads.

Options Max Pain Calculator

Max pain is calculated using the Open Interest of options. The calculation is fairly simple and is summarized below:
  1. List down the different strikes of the option chain along with their open interests.
  2. For each strike, calculate the profit/loss incurred to the option writers if the underlying expires at that level. This calculation should sum up the profit/loss for put as well as call option at that strike price.
  3. The strike price at the the loss is minimum is termed as Max Pain strike price.

Automated Excel sheet for Max Pain calculation

We have created Options max pain calculator excel sheet which does all the background calculations and shows the Max Pain strike price. This excel sheet is automated and you need not to manually enter any data into the sheet. Currently this excel sheet supports both Nifty and Banknifty from NSE. When you open the sheet it would throw some warnings which can be safely ignored. The sheet would refresh every 5 minutes.
Below are few screenshots:
Options Max Pain Calculator

Options Max Pain Calculator Chart

Download link for Options Max Pain Calculator

Please see the below link to download Options max pain calculator excel sheet. Mostly everything is self explanatory, but please let us know if you have any queries. Also, send us your feedback on how to improve this sheet.