All You Need For DayTrading

Update 6:

Trading Futures with Options Data

What is Open Interest?
Open Interest is the total number of outstanding contracts that are held by market participants at the end of the day.

It can also be defined as the total number of futures contracts or option contracts that have not yet been exercised (squared off), expired, or fulfilled by delivery.

Open interest applies primarily to the futures market. Open interest, or the total number of open contracts on a security, is often used to confirm trends and trend reversals for futures and options contracts.

Open interest measures the flow of money into the futures market. For each seller of a futures contract there must be a buyer of that contract. Thus a seller and a buyer combine to create only one contract.

Therefore, to determine the total open interest for any given market we need only to know the totals from one side or the other, buyers or sellers, not the sum of both.

The open interest position that is reported each day represents the increase or decrease in the number of contracts for that day, and it is shown as a positive or negative number.


How to calculate Open Interest?
Each trade completed on the exchange has an impact upon the level of open interest for that day.

For example, if both parties to the trade are initiating a new position ( one new buyer and one new seller), open interest will increase by one contract.

If both traders are closing an existing or old position ( one old buyer and one old seller) open interest will decline by one contract.

The third and final possibility is one old trader passing off his position to a new trader ( one old buyer sells to one new buyer). In this case the open interest will not change.



Benefits of monitoring open interest?
By monitoring the changes in the open interest figures at the end of each trading day, some conclusions about the day’s activity can be drawn.

Increasing open interest means that new money is flowing into the marketplace. The result will be that the present trend ( up, down or sideways) will continue.

Declining open interest means that the market is liquidating and implies that the prevailing price trend is coming to an end. A knowledge of open interest can prove useful toward the end of major market moves.

A leveling off of open interest following a sustained price advance is often an early warning of the end to an uptrending or bull market.



Open Interest - A confirming indicator?
An increase in open interest along with an increase in price is said to confirm an upward trend. Similarly, an increase in open interest along with a decrease in price confirms a downward trend. An increase or decrease in prices while open interest remains flat or declining may indicate a possible trend reversal.

The relationship between the prevailing price trend and open interest can be summarized by the following table.




Twist....?
Now the twist is that, we dont use futures data to trade futures but options data.
like, if lot of traders showing interest in buying calls then it interprets that market has tendency to rise in coming time and vice versa for puts
So i think its better to analyse options data to predict market trend of nifty futures
For this purpose, here an excel sheet which automatically downloads option data from NSE website and interprets data in easy form to trader.

Here's screenshot:


You can download this file from HERE

If you find it useful, then I will upload 2 more excel files in this series...

Update 6a:

Trading Futures with Options Data

IInd file in this series is...... the one developed by Nishant....
It also uses options data for buy sell signal in Nifty Fututres and BankNifty futures and signals are displayed in excel itself.

Here's the screeshot:




You can download the file from Here

Password to open file is: MyProfit@123!
After entering password, click "Read Only"

Update 6b:

Trading Futures with Options Data

Here comes IIIrd excel sheet of this series.
It analysis open interest data of nifty to greater extent and displays it in simple manner.

screenshot:





Download excel sheet from HERE

Update 7:

Free Data Export from NOW to MT4

(All credits to Ramdas for developing and Shivangi for revealing)

This version Gives you Ticker Window with RealTime chart 1min/5min/15Min updating with Quote from Ticker.
Ticker Quote feed source options Google / Yahoo / NSE-NOW
You can use this Ticker tool with MetaTrader- 4 which is connected to Broker with Demo/Real account or without any demo accout.
You need to Install MetaTrader on RamDisk to work with proper speed.

Instalation is in two steps.
Step 1) Create folder name MetaTrader RT on D Drive. e.g D:\MetaTrader RT
Download MetaTrader -4 from "http://www.metaquotes.net/en/metatrader4/trading_terminal"
Install full working MetaTrader 4 on D:\MetaTrader RT
Copy all files from zip file Ticker RT GYN V10.rar to respective location in MetaTrader 4 Folder.
Test all functions and operation.
Once it start working. Step 2

Step 2)
Create RamDisk of 50MB or 100MB
RamDisk is HardDisk created in RAM, RamDisk is used to increase file Read/Write speed.
"http://memory.dataram.com/products-and-services/software/ramdisk"
Copy complete folder from D:\MetaTrader RT to RAMDisk
Start using MetaTrader in RamDisk

Create folder name MetaTrader RT on D Drive. e.g D:\MetaTrader RT
Download MetaTrader -4 from "http://www.metaquotes.net/en/metatrader4/trading_terminal"
Install full working MetaTrader 4 on D:\MetaTrader RT
After installation complete, Restart MT4
login with Login 1234 , Password 1234 , Server default
Also select checkbox Save Account information

Copy all files from zip file Ticker RT GYN V10.rar to respective location in MetaTrader 4 Folder.

Copy Files to respective locations
\expert\Indicators\Ticker RT GYN V10.ex4
\expert\Indicators\Price Display V201.ex4

\expert\script\Ticker Update Charts GYN V10.ex4
\expert\script\Refresh Chart 3 Sec.ex4
\expert\script\Refresh Chart 1 Sec.ex4
\expert\script \F3_Symbols Load.ex4

\templates\Ticker RT GYN V10.tpl

\history\default\A1115.hst
\history\default\A1111.hst

\expert\files\NOWTicker.txt
\expert\files\TickerSymbol_G.txt
\expert\files\TickerSymbol_N.txt
\expert\files\TickerSymbol_Y.txt
\expert\files\TickerReaderNOW V10.xls

Explanations:
Ticker RT GYN V10 This is main Indicator.
It pulls data from Google/ Yahoo/ NOW and show you ticker panel and real time chart.
This indicator is to be placed on Only One chart A111,M5

Price Display V201 This is Indicator
It shows Price at corner in bold .

Ticker Update Charts GYN V10 This is Script for backfill of all chart.

Refresh Chart 3 Sec & Refresh Chart 1 Sec
These script need to be put on chart A111,M5 to start ticker
Refresh Chart 3 Sec is for 3 sec used for google and yahoo feed
Refresh Chart 1 Sec is for 1 sec used for NSE-NOW feed

F3_Symbols Load
This script creates Symbol names in Global Variable.
when you press F3 on any chart..Global Variable window will appear,
Global Variable is used to Add /Remove symbols in Ticker list.
As well as switching Ticker feed.


Step 1
Go to Menu -> Tools -> Options and make setings as shown in picture.
Open Offline chart A111, M5
Apply Template Ticker RT GYN V10.tpl on offline chart A111
and you will see window as shown in picture.
you will see ticker symbols listed in text file \expert\files\TickerSymbol_G.txt

Apply script Refresh Chart 3 Sec only on chart A111, M5
this script will show you refreshing quotes every 3 sec in Ticker window.

F3_Symbols: Using GlobalVariables to Add / Remove Symbols
When you press F3 you will get Pop up window name Global Variables.
Global variables used to Add / Remove stocks.

Press F3 , and in Global Variable window delete all Variables.
From script Run script F3_Symbols Load on any chart.
This will add symbols from TickerSymbol_G.txt to Global Variable
When you press F3 you will see 1st variable as A1TickerSource value as 1
A1TickerSource ..This variable will always listed at first in list.
A1TickerSource Value 1 = Google Feed
A1TickerSource Value 2 = Yahoo Feed
A1TickerSource Value 3 = NOW Feed

You will also see stock names and index name.
When you set value = 1 that stock is enabled in Ticker window
When you make value as 0 that stock get disable and removed from Ticker Window.
Once you set value as 0 and stock get removed from ticker window..you can delete that stock name in global variable.
Note: when Refresh Chart 3 Sec is running on chart A111 , when you add remove stock in GolbalVariable window that stock will get add remove from TickerWindow which you see on chart A111
Also when you change A1TickerSource Value as 1 / 2/ 3 Ticker feed will change.

Try Adding Removing some stock... Then we will see how to get Moving chart of stock apearing in Ticker Window

Creating Charts with backfill.

Open Offline chart A111, M1
Run Script Ticker Update Charts GYN V10 on chart A111, M1.
In Input field make seting as shown in picture.
This will create Charts M1,M5,M15, M30, H1, D1 of symbols listed in text file \expert\files\TickerSymbol_G.txt
After you get Alert "Done"
You can open chart in offline mode and it will Start moving with Quotes from Ticker.
Note: Only M1, M5 and M15 will move RealTime..all other timeframe charts will not move. those are created just for study.

Creating Charts with backfill for newly added single stock

Open Offline chart A111, M1
Run Script Ticker Update Charts GYN V10 on chart A111, M1.
In Input field make seting as shown in picture.
Note: first tue fields set as true.
In StockName put your stock name. and ok

This will create Charts M1,M5,M15, M30, H1, D1 of stock you mentioned in StockName
After you get Alert "Done"
You can open chart in offline mode and it will Start moving with Quotes from Ticker.
Note: Only M1, M5 and M15 will move RealTime..all other timeframe charts will not move. those are created just for study.

Step 2) Create RamDisk of 50MB or 100MB

If you want to use RamDisk for good speed and avoide HardDisk operations.
You have to use Ramdisk
You can also use instalation in foder D:\MetaTrader RT

RamDisk is HardDisk created in RAM, RamDisk is used to increase file Read/Write speed.
"http://memory.dataram.com/products-and-services/software/ramdisk"
Copy complete folder from D:\MetaTrader RT to RAMDisk
Start using MetaTrader in RamDisk
Keep instalation in foder D:\MetaTrader RT as a Backup in case required.

Manual for Ramdisk
"http://memory.dataram.com/__documents/file/Dataram_User_Manual_35.pdf"

If you want to use this ticker utility with demo accout of any broker... you can use it.
just copy all HST files from \History\default folder to broker \History\yourbrokerfolder
and login with your demo account.
to login to demo accout you need to copy yourbroker.srv file to config folder. so that you will able to login to MetaTrader which is installed in RamDisk.


Detailed installation procedure can be downloaded from HERE

Download needed files from HERE

Dear Ajeet,
Very nice....:clapping::clapping::thumb:

How could i get gap up or gap down opening stock list.

Update 8:

Free Realtime Data from Various sources to Amibroker
(credits to josh1 for developing)


Josh have been able to fetch realtime datafeed from NOW, ODIN, Trade Tiger, Google, Yahoo, to Excel 2007 and pull it into AmiBroker and Fcharts.

Click HERE to download file
Setup instructions are given in the folder itself.
Code is open. Users are free to change/copy/distribute it.
Backfill is semi-automatic. About 15 days to one month available depending upon your source.

Here's Video Tutorial for configuration

You might have to adjust Date & time in windows so here is the Procedure.

Click Here for Backfill procedure.

To backfill from data downloader, Watch this.

You might face any prob during installation, Post here all your Queries.

Dear Ajit

Thanks for posting the 2 XLsheets in # 12 & 13.

I hope that the two excel files based on macros, when run, will not clash among themselves or with other excel file (based on macros) that is already running. Have you ever run these 2 XL sheets side by side.

Further, I am using a real time data downloading software (DDS) for my charting purpose and I can not copy/paste any data or paragraph, in excel or word till the moment DDS is running. Otherwise it will paste only, the data DDS is copying and transferring to charting software.

Update 9:

Some Good Ebooks for DayTrading


101 Option trading Secrets


The Option Course with Exercise


Magic Breakout Strategy


Tom Demark Price Projection I


Tome demark price Projection II


Tom Demark Price Projection III


Trading Chart Patterns


Profit with Options


I have 10's of other ebooks, if you find above ebooks helpful then i will upload all I have !!!