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

Views: 69026

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

From : Ajeet Singh at 10:56 AM - May 31, 2017 ( )

Firefox users, can install


From : Ajeet Singh at 09:48 AM - May 31, 2017 ( )

For All those who are tired of manually refreshing....
Mudraa again and again....
for new post updates...
Here's automatic solution....
Kindly add below extension to your chrome browser
and choose any time of refresh (in secs)


From : Aravind Prabhu at 06:21 AM - Feb 28, 2017 ( )

Another doubt ji,

Identification of pin bar pattern are good in what time frame 15 min or Daily. Is it possible with 5 min?

From : Aravind Prabhu at 06:14 AM - Feb 28, 2017 ( )

Ajeet Ji,

It will be helpful if you post a scanner AFL that scans every minute with alerts either by OI or Volume or Uptrend and Downtrend. Can you? Thank you.

From : Rajendra Soni at 05:52 PM - Feb 26, 2017 ( )

Nice oNe.....................

From : Ajeet Singh at 02:23 PM - Feb 25, 2017 ( )

Below is the extract from some of my learnings...
"How I trade Pin Bars" to earn daily from stock market...


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

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

1 to 20 out of 396

Login to participate in discussion.


Recently Discussed Posts of Ajeet Singh

Intraday Section >> Only Banks (33)

Mutual Funds >> Self Trading Mutual Fund (557)

Copywriting >> CNBC Stocks 20-20 (4)

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

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