Home >> Learning Section

Ajeet Singh
View Profile

Best Collection of AFL's and Excel softwares

From : Ajeet Singh at 10:01 AM - Aug 22, 2012 ( )

Total Views: 66251

186 345 Bookmark

Hi friends

today i landed on collection of afl's and excel softwares by shivangi which is updated on weekly basis by her. its worth to visit


From: Ajeet Singh at 04:50 PM - Aug 23, 2012( )

Below is the link for getting intraday trend of NSE stocks


From: Ajeet Singh at 09:55 AM - Aug 24, 2012( )

Automatic ATR Calculator 

(on daily basis)

It calculates atr on daily basis and download data from *

Link:  http://www.mediafire.com/?w741c0wei82wffv

From: Ajeet Singh at 08:52 AM - Aug 25, 2012( )

Another Daily ATR sheet but manually feeded.




From: Ajeet Singh at 09:59 AM - Aug 27, 2012( )

Bank Nifty Options Calculator in Excel download from here:


From: Ajeet Singh at 08:40 AM - Sep 05, 2012( )

Bank Nifty Option Strategies Pdf


From: Ajeet Singh at 08:41 AM - Sep 05, 2012( )

Brokerage Calculator in Excel


From: Ajeet Singh at 08:42 AM - Sep 05, 2012( )

Derivatives Digest in PDF


From: Ajeet Singh at 09:43 AM - Sep 05, 2012( )

Bazaar trend exe


From: Ajeet Singh at 11:27 AM - Sep 09, 2012( )

Amibroker 5.30 by khushi


From: Ajeet Singh at 11:28 AM - Sep 09, 2012( )

Amibroker 5.50.rar


From: Ajeet Singh at 11:05 AM - Sep 12, 2012( )

Brokerage Calculator.xls


From: Ajeet Singh at 11:13 AM - Sep 12, 2012( )

Elliot Wave calculator in Excel


From: Ajeet Singh at 09:53 AM - Sep 18, 2012( )

E Magic Robot.exe


From: Ajeet Singh at 09:51 AM - Sep 21, 2012( )

Fabonacci Calculator xls


From: Ajeet Singh at 10:40 AM - Oct 30, 2012( )

Free Trading Software


From: Ajeet Singh at 09:17 AM - Oct 31, 2012( )

Free Charting Software


From: Ajeet Singh at 09:20 PM - Nov 19, 2012( )

Live MCX rates on computer n mobile


From: Ajeet Singh at 08:35 AM - Nov 25, 2012( )

Gann Wheel in Excel


From: Ajeet Singh at 09:47 AM - Dec 12, 2012( )

Real time Commodity Charts with Buy/Sell

Gold: http://www.marketcalls.in/mcx-gold

Copper: http://www.marketcalls.in/mcx-copper

Silver: http://www.marketcalls.in/mcx-silver

Nifty: http://www.marketcalls.in/livecharts/nifty-futures

BankNifty: http://www.marketcalls.in/livecharts/bank-nifty

IciciBank: http://www.marketcalls.in/livecharts/icici-bank

TataSteel: http://www.marketcalls.in/livecharts/tata-steel

From: Ajeet Singh at 09:07 AM - Dec 19, 2012( )

Gann Calculator in Excel


From: Ajeet Singh at 10:17 AM - Dec 22, 2012( )

Gartley Bullish n Bearish (in excel)


From: Ajeet Singh at 08:43 PM - Dec 22, 2012( )

From Now Onwards, Links will be given under Messages Section (Normal Postings)

In Reply to above Message (1 to 20 out of 390) - Latest Replies are put on Top | First | << Previous | Next >> | Last |

From : Ajeet Singh at 06:15 PM - Feb 03, 2017 ( )

Below is the extract from some of my learnings...
Earn daily from stock market....


you just need a technical software with live data....

From : R Praveen at 06:29 PM - Jan 29, 2017 ( )

Thanx ajeet ji for your kind support with novice traders like us....

Eagerly waiting for your AFL's to be uploaded and one of my all time favourite pair trading strategy Excels as well.

From : Ajeet Singh at 03:23 PM - Jan 29, 2017 ( )

@ Praveen

I will defiantely upload AFL's
Actually I lost some of my data, written on DVD's
I will try to reupload, mediafire links !!!

From : R Praveen at 07:31 AM - Jan 29, 2017 ( )






From : Ashish Patel at 04:22 PM - Jan 28, 2017 ( )

Thanks for sharing ajeet ji...........

kindly share your level calculator also..........

From : Ajeet Singh at 04:01 PM - Jan 28, 2017 ( )

Free Intraday Data from Google to Amibroker


From : Ajeet Singh at 08:06 PM - Apr 30, 2016 ( )

Forthcoming Results Display (Auto-updated)

Visit:  http://bit.do/companyresults

From : Ajeet Singh at 09:17 AM - Feb 26, 2016 ( )

Daily Support and Resistances (of any stock)

Visit:  bit.do/sonu01

You can add any stock, just post name of scrip here.

From : Ajeet Singh at 08:35 PM - Sep 25, 2015 ( )

The 3 Duck's Trading System

The system is fairly straight forward and easy to use. Like a lot of trading systems it will be more productive when prices are moving in one direction and not stuck in a tight trading range. Of course this system has losing trade and losing runs, but with proper money management and good discipline I'm sure this system will keep you out of bad trades and give you a great chance to make profits in the Fx market. One of the nice things about this system is it will quickly tell you if prices are in an up or down swing phase and stop you from guessing! It will also allow you to decide to be a bull or a bear and trade in the direction of that trend. There are 3 charts involved in this system: a 4hr chart, a 1hr chart and a 5min chart. There is 1 indicator, a 60 period simple moving average (60 sma) plotted on each chart. There you go, its that simple.


How it works:

Step 1 - First Duck
The first thing we need to do is look at our largest time-frame (4hr chart) and see if current prices are above or below the 60 sma. From this chart we can see that current price is below the 60 sma. This tells us that we maybe looking to sell.

Step 2 - Second Duck
The second thing we need to do is drop down to our 1hr chart. We need to see the current price below the 60 sma on this chart also, this gives us confirmation.
Important: If the current price was to be above the 60 sma on this chart we could not move on to step 3.

Step 3 - Third Duck
From step 1 and 2, current prices need to be below their 60 sma's on each chart. We are now on the 5 min chart and we are looking to sell when price crosses below the 60 sma. For extra confirmation we should let prices break the last low on the 5 min chart. This would mean that prices will be below their 60 sma on all 3 time-frames, therefore all 3 Ducks are lined up in the same direction.

Stop-Losses: This is where you can make this system your own. If you are a short term trader you may want to put your stop-loss above the highs on the 5 min or the 1 hr chart. If you are more of a positional trader you may wish to put your stop-loss above a high on the 4 hr chart. You could also use a fixed stop-loss, maybe 25-30 pips or more from entry. It all depends what type of a trader you are, so you decide! Another "trick" that may help you preserve capital, If you do sell and prices get back above the 5 min 60 sma by 10 pips (not a good sign) you may want to cut your losses short before your stop-loss. But if you are a longer term trader this may not be a big deal for you.

Targets: Same again, depends what type of a trader you are but target can be support or resistance levels.

Note: This system was developed for Forex but works good for all types of markets. 

Courtesy: Capt. Curency

From : Ajeet Singh at 08:23 PM - Sep 25, 2015 ( )

A Very Simple Intraday Breakout Strategy


1. Draw upper and lower lines on first hour bar. If the next candle does not break upper and lower lines of first hour bar, then cancle those lines, draw the same lines for second hour bar. Continue the sequence likewise.


2. On seeing breakout of these lines, switch down the timeframe to 5 minutes and see that a complete 5 min candle forms outside the hourly channel drawn as in point 1 above. Once that happens get into the trade. Long for above breakout. Short for below breakout.


3. There are two ways to ride it.


A) Scalping. Book profit upon seeing it. Stop loss is the low of the five min candle on which trade is triggered.


B) Day trading. Book 50% upon seeing profit. Keep stop loss at the other side of channel. Trail the SL apropriately.

Courtesy: Veluri

From : Ajeet Singh at 12:28 PM - Sep 23, 2015 ( )

What happen to Nifty December 2015 Contracts ( Call n Put ) after changing lot size to 75, currently Lot size is 50 ?

So if you are holding 50 Nifty Dec CE/PE or any multiple of 50 (current lot size of Nifty for long dated options is 50 and not 25 like everyone thinks) after the end of this expiry on 24th Sept, the new lotsize of Dec will be 75. What this means now is that you will not be able to exit the 50 Nifty CE/PE that you hold after this thursday. 

So for example

1. If you hold 50 Nifty Dec calls after this expiry. You will not be able to convert this into a multiple of 75, and hence u will not be able to sell and will be forced to hold the position till Dec expiry. 

2. If you hold 100 Nifty Dec calls (2 lots) after this expiry, you will be able to sell only 1 lot of 75, and u will be forced to hold the remaining 25 till Dec expiry. 

So, if you want to continue to hold this position into next month, ensure that you are holding an option position which is a multiple of 75 (new lot size). So if you have 50 Nifty, buy another 100 to make it 150 (multiple of 75). Or just square off all positions and take a fresh position after the Sep expiry. 

Remember that you have to get this done before the end of September expiry on Thu, 24th Sep 2015.

courtesy: DPK

From : Ajeet Singh at 12:45 PM - Sep 21, 2015 ( )

ATR based Day Trading Strategy

1. Select any highly liquid stocks. Atleast 3 stocks.
2. Let the first half an hour candle close so that initial hiccups are over.
3. Take the close of first half an hour candle.
4. Visually scan ATR(14) for the last 4 months. Take the average of highest ATR and lowest ATR. Not a big work if you have amibroker. Just drag ATR indicator and visually scan it by scrolling. No need to have very specific numbers. Just a rouch idea.
5. Calculate 25% of this average ATR. 
6. Place buy order at CLOSE + 25% OF AVERAGE ATR and sell order at CLOSE - 25% of average ATR.
7. place stop loss at close after the buy/sell order is filled.
8. Profit Target is ENTRY + 25% OF AVERAGE ATR in case of BUY and ENTRY - 25% OF AVERAGE ATR IN CASE OF SHORT. No greed.
9. If stop loss hit and book losses.
10. Cancel all orders.
11. Start afresh from step 3 by doubling the order size.
12. If second time stop loss hit, close the terminal for the day

Here is the AFL for Amibroker Users if you have not it already.
periods = Param( "Periods", 15, 1, 200, 1 );
Plot( ATR(periods), _DEFAULT_NAME(), ParamColor( "Color", colorCycle ), ParamStyle("Style") );

Money Management.

1. This strategy is based on volatility. Since the price can move in any direction, expect stop loss hits. So, we should have a proper money management in order to succeed in this strategy.

2. If one has an account of Rs.50,000/-. Consider 1/4th of it. That is Rs.12,500/-. Spread it into three shares ie Rs.4,100/- roughly for each scrip. 
Use 4 times leverage. ie 16,400 for each scrip.

3. Divide Rs.16,400/- by scrip value. Ex Unitech Rs.71. Just rough calculations. Rs.16,400 divided by 71 comes to 230 shares. So, your buy order will be for 230 shares and sell order for 230 shares. 
Another example. Axis Bank Price 1240. Rs.16,400 divided by 1240 comes to 13 shares. So, buy order will be 13 shares and sell order for 13 shares.

Courtesy: Veluri

From : Ajeet Singh at 09:08 PM - Sep 20, 2015 ( )

30 min Breakout Strategy

This method can be very risky but it can also produce some very large profits. The best time to begin using this method is after it has had 3/5 losses in a row.

The 30-minute breakout method will help you get the edge on day trading, but it will require the following:

1.Maximum discipline and attention to rules.
3.At least Rs.50,000 in starting capital for trading the full-sized Nifty contract
4.The ability to accept at least seven consecutive losing trades.
5.The ability to sit at the computer all day.
6.The discipline to ride profits until the end of the trading day.
7.The eventual ability to trade multiple positions.


The 30-minute breakout method (30MBO) uses the price high and price low of the first 30 minutes of each trading day as the setup. 

Finding the setup is very simple. All you have to do is to make note of the high and low price for the first 30 minutes of the trading session; this can only be determined after the first half-hour is over.

A buy trigger occurs when and if any subsequent 30-minute price bar ends above the high of the first 30-minute price bar. A sell trigger occurs when any subsequent 30-minute price bar ends below the low of the first
30-minute price bar.

A trigger can only occur at the end of a bar, not during a bar. 

A trigger can occur at the end of any 30-minute bar up to the last hour of trading.


Follow-through for this method is very simple, but you must be consistent and highly disciplined in order to employ the follow-through method profitably.

Here are the rules:

1.As soon as a trade has triggered, your stop-loss becomes the opposite side of the trade. In other words, if a buy is triggered first, then the stop is a 30-minute ending price below the low of the first 30-minute ending bar and vice versa for a short.

2.When a trade is triggered, the first profit target is the range (high/low) of the first 30-minute bar.

3.If you have multiple contracts, then take profit on part of your position at the first profit target and place a stop at breakeven.

4.If and when the trade achieves twice the range of the first 30 minutes place a stop at the first profit target. If you have multiple positions, take profit on another portion of your position and place a stop at the first
profit target.

5.Exit MOC (market on close) on all positions not stopped out.

6.If you get a buy first and are stopped out, then reverse to a sell and vice versa.

7.Only take one reverse trade per day. In other words, if the second trade loses money then there are no additional trades for the day.

8.Always exit at the end of the day.

The rules are clear and concise. Practice and the ability to ride large swings both in your favor and against you are of paramount importance if you want to be successful with this method.

Paper trade initially for a week or so on your favourite stocks/futures. Adjust the profit targets as per the volatility of stock/futures.

Happy Trading

Courtesy: Veluri

From : Girish Gupta at 11:51 AM - Sep 18, 2015 ( )

Thanks so much

From : Ajeet Singh at 11:34 AM - Sep 18, 2015 ( )

The Four Week Rule
A Simple One That Gives You Huge Profits Potential
(Based on Richard Dochanian's Theory)

Here is a simple forex trading system that is easy to understand and apply and has influenced some of the top traders of all time. Don't be fooled by its simplicity it works. Let's look at it.

The 4 week rule is one of the simplest technical analysis systems of all time and it may not be trendy or flavor of the month, with a lot of forex traders who think complicated is better - but don't think that because its simple it doesn't work - it does.

Richard Donchian was a true legend and one of the most influential trend followers of all time he spoke and wrote profusely on the subject of trading and has influenced some of the greatest names in trading including trading legend Richard Dennis.

The four week rule has proved to be an effective building block on which many successful trading systems are based.

It's based on the following assumptions about market behavior:

1. The strongest trending moves start from new market highs NOT market lows.

Those people who think buy low sell high is a great way to make money are wrong. If you don't buy breakouts from new highs, you will miss some of the best trends - period.

2. A trend in motion is more likely to continue than reverse.

We all know this is a basic building block of technical analysis and there is no better trend than one that is making new highs

3. A four week cycle is the dominant cycle in trading.

This can vary at times of course but the four week cycle is highly effective.

The original rules were used for trading commodities and can be summarized by:

Cover short positions and buy long whenever the price exceeds the highs of the previous 4 calendar weeks.

Liquidate long positions and sell short whenever the price falls below the lows of the previous 4 calendar weeks.

The original system being devised for commodities was designed to use a stop and reverse so the trader was always in the market with a position.

In a non trading market it can get whipsawed a solution to this problem is to enter on the 4 week rule (the breakout), and to exit on a shorter time period such as 1 or 2 weeks. With this system, a four week "breakout" would be needed to initiate a new position, but a one or two week signal in the opposite direction would mean liquidation of the position.

The trader then remains out of the market until the next new four week breakout is registered.

Why It Works

This system is based on sound technical principles with signals that are mechanical and clear-cut. It is trend-following so a trader is virtually guaranteed to be on the right side of every trend.

It also follows the often quoted trading wisdom - "let profits run, while cutting losses short". Another advantage is fewer trades, which means less time being spent looking at the market and finally you don't even need a computer!

People often say technology helps - but for many traders its a hindrance they think being clever will make them money, well consider this 95% of traders lost 100 years ago and the its the same ratio before yet computers today are more powerful than the one mission control used to land man on the moon!

Don't be fooled by simplicity it can be very profitable.

Being a trend-following system, it is not going to catch market tops and bottoms ( but how many systems do that though?) however, the 4 week rule works as well as any other trend-following system but with the benefit of incredible simplicity.

The Proof

You might be saying that won't work - well go and try it on a strong trending currency market like the euro, Canadian dollar or Australian dollar and back test it and in a number of strong trending markets and you will see it does.

Don't be led to believe that if its simple it won't work - all the best forex trading systems are simple.

You don't get paid for being clever you get paid for being right - Period.

Today, traders always like to trade something different or obscure but if you want a simple system, by a trading legend, that's hard to beat - try Richard Donchian 4 week rule It's been part of some of the true great traders box of tools and should be in yours to.

Courtesy: rkarnani

From : Ajeet Singh at 11:23 AM - Sep 17, 2015 ( )

 Girish Gupta

In late months of last year, I used GLS but then I discontinued use of MT4

Don't know, whether they are giving free demo currently or not.

For configuration you refer below help file.


From : Girish Gupta at 10:39 AM - Sep 17, 2015 ( )


from which side i can install MT4 free chart software for nifty!

From : Ajeet Singh at 08:43 AM - Sep 17, 2015 ( )

Staurt's Advanced Strategy

For  IntraDay Trading

Consider High, Low and Close of Today.
Arrive at the range of the day ie High - Low.
Calculate 25% of the range.
Now, Add this 25% figure to the close of today.
This gives us buy order for tommorrow.
Now, deduct this 25% figure from the close of today.
This gives us sell order for tommorrow.
Simply buy above todays close Sell below todays
close at the arrived prices.
Fix 25% of todays range as Profit Targets.
Place Stop Loss some points away from opposite order.
Donot forget to place the orders before market opens.

Courtesy: Staurt

1 to 20 out of 390

Login to participate in discussion.


Recently Discussed Posts of Ajeet Singh

Intraday Section >> Trading Futures For Future (Part-2) (195)

Mutual Funds >> Self Trading Mutual Fund (407)

Intraday Section >> Trading Futures For Future (108)

Learning Section >> Best Collection of AFL's and Excel softwares (398)

Commodity Calls >> Golden Gold (123)