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 ( )

187 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 (21 to 40 out of 396) - Latest Replies are put on Top | First | << Previous | Next >> | Last |

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

From : Ajeet Singh at 02:48 PM - Sep 15, 2015 ( )

Kindly elaborate more..... i didn't get you.

From : Girish Gupta at 02:34 PM - Sep 15, 2015 ( )

what about nifty charts formula!

From : Ajeet Singh at 02:11 PM - Sep 15, 2015 ( )

Pivot Calculator

(Online and very Handy)

Visit:  http://bit.ly/1ObSz3g

From : Ajeet Singh at 01:39 PM - Sep 15, 2015 ( )

BNF Trading Strategy


1. Go to I-charts site. Open eod banknifty future 1M chart.

2. Settings for chart: EMA: high,2 & EMA: low,2

3. How to get LONG or SHORT probable band range: 
Best BUY range for next day: (ema low,2 value)-100 to (ema low,2 value)+60
Best SELL range for next day: (ema high,2 value)+125 to (ema low,2value)-70

4. Entry price: Enter only if you see Bnf open price in our buy/ sell range. You can still entre if open price is trading little bit closer to band (10 to 25 pts) entre or wait to come price in range for better confirmation. If it is opened out of range or too far from both buy/sell range band avoid trade for that day.

5. Stop loss: after execution place 115 points SL 

6. Target: minimum 90 to 100 points from execution price (execution prices is near days open always (it may vary +-10 to 25 pts case to case) in most trading days target hits immediate after execution in first 10-20-30 minutes. 

Back tested result:

Total long trade 61 
Stop hits for 12 trades 
Success trades 49 

Total short trades 87
Stop hits for 33 trades 
Success trades 54


Courtesy: sspagro

From : Ajeet Singh at 09:52 AM - Sep 10, 2015 ( )

Daily FII Derivatives Data

Visit and Download Excel


After visiting the above link, click derivatives then click fii derivative statistics

Excel file with all data will be downloaded to your computer.



From : Ajeet Singh at 09:40 AM - Sep 10, 2015 ( )

Daily FII / DII Cash Data



From : Srinivas D at 09:36 PM - Sep 06, 2015 ( )

Ajeet sir,

Thank you for sharing such a valuable Excel utility.

From : Ajeet Singh at 09:57 AM - Sep 04, 2015 ( )

In same series as Nifty OAT....

Below file is for BANKNIFTY


Best Option Analysis Tool for BANKNIFTY


Excel Utility by Proffittaker

From : Ajeet Singh at 09:53 AM - Sep 04, 2015 ( )

 Shanmugam K

I am not the creator of this file.

It's developed by "Profittaker"

I have only shared with fellow traders here.

From : Shanmugam K at 08:34 AM - Sep 04, 2015 ( )

thank you for sharing nifty oat files sir,

please one,option pair

( buy side price = ce 20< price, 50>price / pe 70< price, 100>price

sell side price = ce 70<price , 100>price / pe 20<price, 50>price )

why you put this ratio sir,

From : Ajeet Singh at 07:37 PM - Sep 02, 2015 ( )

 Srinivas D

For Sept and so on......

Here goes the new version:


From : Srinivas D at 05:40 PM - Aug 31, 2015 ( )

Hello Ajeet sir,

Best Option Analysis Tool for NIFTY


is for Aug month expiry only , Kindly Update the excell for SEPTEMBER Expiry and re post please.

Thanks in advance.

From : Ajeet Singh at 08:15 AM - Aug 27, 2015 ( )

My previous resource for pair trading was deleted by moderator

though its basic source if free but as its directing to 3rd site, I think thats why got deleted.


Here goes the....


Best Option Analysis Tool for NIFTY


Excel Utility by PT

Login to participate in discussion.


Recently Discussed Posts of Ajeet Singh

Intraday Section >> Only Banks (44)

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

Mutual Funds >> Self Trading Mutual Fund (558)

Copywriting >> CNBC Stocks 20-20 (4)

Intraday Section >> NIFTY - Bounce & Beat (25)