Now2Ami - realtime datafeed to AmiBroker from the NOW terminal

This utility extracts intraday quotes from the market watch of NOW terminals in real time, and datafeeds the price quotes / volume (or OHLCV) to AmiBroker. The NSE NOW terminal provides live quotes for Equities, F&O, and currency scrips of National Stock Exchange, India.

Now2Ami can also backfill M1 (1 minute) stock prices for the current day, and for the last 15 to 20 days using Nest Plus.

The program aims to fill the need for those desiring better graphing and analysis abilities than available in NOW or Nest Plus, and preferring the use of AFL scripting features in AmiBroker. While graphs update real time, the stored database can optionally be aggregated to 1 minute OHLC intervals (to keep database size smaller) or fed as 'tick' data (more correctly, snapshot data) suitable for volume or range bars.

This data feeder is suitable for those who are looking for live updates of NSE stock quotes based on what is available in your trading terminal, and not on what is stored and retrieved from a server. An alternate feeder for NSE realtime quotes (and MCX as well) is Nest2Ami.

Versions

Version 0.84 (May 2013) adds

ability to backfill in parallel with capture.
symbol translation in Settings to enable automatic renaming of symbols. For example, the symbol for current month NIFTY would be NIFTY_1 if using the Symbol_N renaming option.
Earlier versions had implemented

adjustments to work with NOW 1.8.x.
Nest Plus backfill that provides historical quotes for a larger number of days.
ability to (optionally) capture tick / snapshot data.
selectable column capture such as Open Interest, ATP, or TBQ / TSQ.
Hardware / Software / OS requirements

Works with various versions of NOW (version 1.6.0 or 1.7 or 1.8 is assumed). AmiBroker version 5.2 or later is assumed (the free version does not save data). A subscription to Nest Starter Pack version 1.3 or 1.4 or 1.5 (earlier free upto Mar 2013, and now extended) is required for Plus backfill

Requires a minimum of XP SP3 (XP SP2 is no longer supported, and users will have to upgrade). Uses .Net Runtime 3.5 with SP1. Available from this link on the Microsoft website. It has not been tested on 64-bit machines (though users have reported successful usage).

Notes

The version you use may have limitations, e.g. number of symbols that can be captured, or expiry date of software.
May require administrator permission to run successfully.
Read the help file for more information.

Now2Ami Download:  Download links will only be available by request. 

By request only. Write, with some details about yourself, , and your broker, to Now2Ami@91-33.com
Website : http://91-33.com/download/Now2Ami.html

Read More »

Nest2Ami - real time data feed from Nest Trader to AmiBroker

The Nest2Ami utility extracts live real time quotes from the market watch of Nest Trader clients (also Zerodha Trader), and outputs the intraday data to AmiBroker. This is aimed at commodity traders, using the MCX exchange, who prefer the stock charting of Ami over the one inbuilt into Nest (or Nest Plus)

While most brokers offer Nest Trader only for MCX, Zerodha Trader, or ZT as it is generally referred to, has extended to a unified trading platform for NSE, BSE (not currently supported by the utility), MCX, and MCXSX. So, besides an MCX real time data source, it is a source for NSE market quotes as well.

The captured quotes comprises last traded price & volume at a configurable interval down to 1 second. Output to AmiBroker may be tick data (actually snapshot) data, or may be aggregated to 1 minute bar intervals.

Backfill is available in two varieties -- the internal backfill from Nest / Zerodha Trader, and the plugin data from Nest Plus. While the number of days of available data seems to be in a state of flux, it may be assumed that the current day backfill is from internal data, and Nest Plus provides longer term (7 to 20 days) backfill. The backfill is always 1 minute OHLCV, tick quotes are not available.

{ For the specific case of ZT and MCX, the internal backfill has too much data without filtering ability, and MCX backfill should use Plus irrespective of one or multiple days. For example, Gold or Copper prices may be available for as much as 40 days in ZT. This does not apply to MCX current day backfill from most other brokers. }

Versions

The current version 0.88 beta (May 2013) adds:

ability to backfill without stopping data capture.
availability of auto symbol translation in Settings. For example, RELIANCE-EQ will become RELIANCE, or NIFTY13MAYFUT may be NIFTY_1.
Earlier versions had added:

Support for MCXSX
Fixes to some issues with Nest versions after 3.10.57.97
Selectable column capture such as Open Interest, ATP, or TBQ / TSQ.

Hardware / Software / OS requirements

Assumed configuration for Zerodha / Nest Trader version 3.10 or later. AmiBroker version should be 5.2 and later. A subscription to Nest Starter Pack version 1.3 or higher (currently free) is required for Plus backfill

Requires a minimum of XP SP3. Uses .Net Runtime 3.5 with SP1. Available from this link on the Microsoft website. It has not been tested on 64-bit machines (though users have reported successful usage).

Notes

The version you use may have limitations, e.g. number of symbols that can be captured, or expiry date of software.

May require administrator permission to run successfully.

More information in the help file.

Please do not confuse this utility with Nest2Ami Professional from aamaadmisoftware.

Nest2Ami Download:  Download links will only be available by request. 

By request only. Write, with some details about yourself, , and your broker, to Nest2Ami@91-33.com

Website : http://91-33.com/download/Nest2Ami.html

Read More »

Here is a very simple solution to get Realtime Tick Charts in Amibroker using Metatrader DDE Server.

Software Requirements :

Amibroker , Metatrader 4

Steps to Get Realtime Tick Charts in Amibroker

1)Open Metatrader 4

2)Goto Tools->Options->Server and Check Enable DDE Server option this will enable Metatrader to export it quotes in realtime format to another software (DDE listener)

3)Now OpenAmibroker

4)Goto File->New->Database

5)Enter the Database Name and click on the CREATE button. This will create a new database.

6)Set the BASE TIME INTERVAL to tick and press ok.

7)In Amibroker goto File->Database Settings.

8)Select Data Source as DDE Universal Plugin.

9)Now Click on configure and now do the DDE Configuration settings as shown below.

10)After the DDE Configuration Settings. you will see a yellow WAIT signal at the bottom of the status bar in amibroker.

11)In Amibroker goto Symbol->New and type the New symbol as same as in metatrader for ex : EURUSD

12)Now you will notice that yellow WAIT signal status changed to green CONN status.

13) Tick charts will be coming to amibroker in realtime from MT4 DDE Server.

Tested in : Windows 8

The main drawback of this Universal DDE plugin is it doesn't supports backfill. 

Read More »

ODIN2AMIFree for Personal Use Only - Convert data from Odin terminal to Amibroker. No backfill.

Features
-Feeds NSE Cash,Futures , Commodities data to NinjaTrader or AmiBroker from DietOdin.
-Data updates every seconds in amibroker
-Continuous contracts for NSE F&O scripts.
-Free Software

Configuration

1. Download Software And Install It In Your Pc
2. Now Login In Your Odin Terminal And Open Any Marketwatch
3. Now Right click on Marketwatch and Click on Column Profile
4. Add This All- Symbol, Ser/Exp,LTP,Volume,Open,High,Low,Prv.Close,StrikePrice,OptionType
5. And Save Column Profile
6. Now Open OdinToAmiFree and Select your Terminal. And Click Find Watchlist.
7. Now you Need To Double Click Marketwatch When they will be avail in ODINTOAMIFREE.
8. Done

Download Odin2AmiFree Version

Read More »

Getbhavcopy is a FREE data downloader for NSE (National Stock Exchange) and BSE (Bombay Stock Exchange).

It downloads daily EOD (End Of Day) data as well as historical data (past EOD data) for equities and indices. The data is directly downloaded from NSE and BSE servers and is 100% authentic. The downloaded data can be directly imported into all leading technical analysis software like Metastock and Amibroker.

Installing Getbhavcopy

• Installing and downloading NSE and BSE Bhavcopy data using Getbhavcopy
• Getbhavcopy Options Tab settings
• Importing EOD stock data downloaded using Getbhavcopy into Metastock
• Importing EOD stock data downloaded using Getbhavcopy into Amibroker
• Adjusting Metastock data for Splits and Bonus
• Adjusting Metastock data for Symbol changes

Requirements of  GetBhavCopy

Getbhavcopy requiresMicrosoft .NET framework 3.5 to be installed on your machine. Please download and install it first.

Download

Download latest stable versions from following mirrors: Mirror 1: Download Getbhavcopy from 4Shared.com

1. Startup issues that were happening since past few days
2. 501 not implemented error for VIX data download
3. 501 not implemented error for Open Interest data downloadfor NSE Equities.

Getbhavcopy downloads following data from NSE and BSE servers:

NSE data downloaded	BSE data downloaded
NSE Equity Bhavcopy	BSE Equity Bhavcopy
NSE Equity Open Interest
NSE Indices data downloaded	BSE Indices data downloaded
NSENIFTY	SENSEX
NIFTYJUNIOR	MIDCAP
BANKNIFTY	SMLCAP
NSE100	BSE-100
NSEMIDCAP	BSE-200
NSEIT	BSE-500
NSE500	AUTO
NSEDEFTY	BANKEX
	CONSDURBL
	CAPGOODS
	FMGC
	HLTHCARE
	IT
	METAL
	OILGAS
	POWER
	PSU
	REALTY
	TECK
	DOL30
	DOL100
	DOL200

Additional Downloads

• I have consolidated Metastock historical NSE data updated till 13-Dec-2008 with Split and Bonus adjustments. It can be downloaded from NSE and BSE historical data in Metastock format.In case you want the same data in ASCII format then you can download it from NSE and BSE historical data in ASCII format.
• I have consolidated Metastock historical BSE data updated till 30-Dec-2008. Links are available in NSE and BSE historical EOD data in Metastock format. In case you want the same data in ASCII format then you can download it from NSE and BSE historical data in ASCII format.
• NSE and BSE bhavcopy data downloaded using Getbhavcopy can be used with Amirboker. Get Amibroker from the  Official Amibroker vendor in India
• NSE and BSE bhavcopy data downloaded using Getbhavcopy  can be used with Metastock. You can  download Metastock from Equis

Disclaimer

This software and documentation are distributed without any warranties as to performance or merchantability or any other warranties whether expressed or implied.
While I have thoroughly tested Getbhavcopy for correctness, there could be a possible bug which I am not aware of. I do not take any responsibility for any circumstances due to an incorrect technical decision made by you on the basis of the data.

Read More »

Hakija, is an opensource(free with source code available) NSE End of Day Data Downloader written in Python. No other installations like .NET framework, Java anything else is required.
It downloads daily EOD (End Of Day) data as well as historical data (past EOD data) for the NSE EQ series and also the main indices (‘NSENIFTY’,'NIFTYJUNIOR’,'BANKNIFTY’,'NSEMIDCAP’, ‘NSEIT’,'NSE100′,’NSE500′,’MIDCAP50′ and ‘VIX’).

If you choose to download only the bhavcopy data or just a few of the indices, the other can be downloaded later without any need to redownload the previous data. The data is directly downloaded from the NSE servers and can be directly imported into MetaStock or AmiBroker as ASCII format.

The data is downloaded in the same directory as the program itself.
It can be downloaded for free from

Download Hakija – Mirror1
Download Hakija – Mirror2
Download – Hakija Source Code

Read More »

This is licensed under GNU GPL V3. It’s free for life product. Current beta is on windows. We will launch it on Linux and Mac soon.

Formats

1. std csv
2. Fcharts
3. Amibroker
4. Ninja Trader
5. Advanceget
6. Metastock

Data

1. NSE market cap report
2. NSE Equity Derivatives Participant wise Open Interest report
3. NSE Equity Derivatives Participant wise Trading Volumes report
4. NSE bulk deals report
5. NSE block deals report
6. NSE Market Activity Report
7. NSE combined report
8. NSE Equity Derivatives FII derivatives statistics report
9. NSE board meeting & corporate annoucements
10. NSE Gainer & Loser of day
11. NSE Price Hit new all time High or LOW
12. NSE Price band hit High/Low
13. NSE corporate actions
14. BSE bulk data report
15. BSE block deal data report

Data

1. NSE cash market bhavcopy with open int.
2. NSE INDEX and VIX
3. NSE Equity Futures
4. NSE Equity Options
5. NSE ETF bhavocpy
6. NSE SME bhavcopy
7. NSE Forex Options
8. NSE Forex Futures
9. MCX Commodity bhavcopy
10. National Spot Exchange bhavcopy
11. MCX SX Commodity Index eod
12. MCX SX Commodity Index spot eod
13. NCDEX Futures
14. BSE Equity Index
15. BSE Cash market bhavcopy with open int.
16. Yahoo Fundamental

Extra features

1. Smart downloader with auto update from last download date.
2. Application Auto update
3. NSE Trading holidays support
4. Google calender support
5. Weekend support in built

We will enable ms format file and Yahoo, Google IEOD, EOD soon.

Please file bugs here

https://github.com/webshub/Shubha_Downloader/issues

Download Now

Read More »

Firstcharting launches Realtime Data Plugin for Amibroker in trial mode. Now with this data plugin you can access NSE(Cash,Futures), MCX Futures, MCX-SX Futures, NCDEX Futures, International Forex Cross Currencies realtime charts in Amibroker with Zero Data Delay.

Steps to Integrate the Firstcharting Datafeed in your Amibroker Software

1. Download the FirstchartingData Dll Plugin

2. Save the file in the amibroker plugin folder i,e c:program filesamibrokerplugin folder

3. Download Microsoft Visual C++ 2008 RedistributablePackage (x86) and install it in your machine.

4. Now Open Amibroker -> File Menu ->New->Database . And fill the instruction as shown below.

5. Choose Firstcharting-Data Plugin from the datasource list and make sure that Base Time Interval is

1minute

  

  

6.Now click on Configure button and click on connect

7.And click on the required exchange symbols which downloads the Symbol list from the firstcharting server 

8.Now Click Close on the Configuration Dialog. Now you will see a green Connected/Normal Button indicating that you had established connectivity with firstcharting server as shown below

8.Now goto the charts and select the required symbols and start your favorite charts in realtime tick by tick with zero delay.

Features

1)Zero Data Delay

2)Auto Backfill Supported

3)Light Weight Plugin

4)Easy Installation Onetime Setup

Current Limitations

Tested OK with 32 bit XP ,Windows 7, Windows 8, Vista machines. Testing not yet done with 64bit machines

Current Trial Version Doesnt Supports proxy. So if you are behind a proxy probably you could not able to connect

Read More »

First Process

Export intraday and EOD data to TXT files
One file for each stock
In the first line insert the directory you want to save them to, make sure the
directory exists
Select your charts to export with the “Apply to” filter in AA window
Select the timeframe period you want to save as using the AA “Settings”
Press Scan button

AFL :

/*

Export intraday and EOD data to TXT files

*/

fh = fopen( "c:\\SaveData\\"+Name()+".txt", "w");

if( fh )

{

   fputs( "Ticker,Date,Time,Open,High,Low,Close,Volume \n", fh );

   y = Year();

   m = Month();

   d = Day();

   r = Hour();

   e = Minute();

   n = Second();

   index = BarCount - 420;

   if(index > 0)

   {

    for( i = index; i < BarCount; i++ )

    {

      fputs( Name() + "," , fh );

      ds = StrFormat("%02.0f-%02.0f-%02.0f,",

                     y[ i ], m[ i ], d[ i ] );

      fputs( ds, fh );

      

      ts = StrFormat("%02.0f:%02.0f:%02.0f,",

                     r[ i ],e[ i ],n[ i ] );

      fputs( ts, fh );

      qs = StrFormat("%.4f,%.4f,%.4f,%.4f,%.0f\n",

                     O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] );

      fputs( qs, fh );

    }

   }

   else {

    for( i = 0; i < BarCount; i++ )

    {

      fputs( Name() + "," , fh );

      ds = StrFormat("%02.0f-%02.0f-%02.0f,",

                     y[ i ], m[ i ], d[ i ] );

      fputs( ds, fh );

      

      ts = StrFormat("%02.0f:%02.0f:%02.0f,",

                     r[ i ],e[ i ],n[ i ] );

      fputs( ts, fh );

      qs = StrFormat("%.4f,%.4f,%.4f,%.4f,%.0f\n",

                     O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] );

      fputs( qs, fh );

    }

   }

   fclose( fh );

}

Buy = 0;

Second Process

fmkdir( "C:\\SaveData" );
Buy = ( (DateNum() >= 1121220) AND (DateNum() <= 1121231) ); // data exported from 20/12/2012 to 31/12/2012

//if we want to export data for a single Day, we modify the Second line like this
//Buy = ( (DateNum() == 1070129));

for( i = 0; i < BarCount; i++ )
if( Buy[i] )
{
//fh = fopen( "C:\\SaveData\\intraday.csv", "a");//if we want to export all data in a single file//
fh = fopen( "C:\\SaveData\\"+Name()+".csv", "a");// if we want to export data in an individual file//
if( fh )
{
y = Year();
m = Month();
d = Day();
r = Hour();
e = Minute();
s= Second();

for( i = 0; i < BarCount; i++ )
if( Buy[i] )

{
fputs( Name() + "," , fh );
ds = StrFormat("%02.0f/%02.0f/%02.0f%02,",
y[ i ], m[ i ], d[ i ] );
fputs( ds, fh );

ts = StrFormat("%02.0f:%02.0f,%02.0f",
r[ i ],e[ i ]),s[i];
fputs( ts, fh );

qs = StrFormat("%.2f,%.2f,%.2f,%.2f,%.0f,%.2f\n",
O[ i ],H[ i ],L[ i ],C[ i ],V[ i ] ),OI[i];
fputs( qs, fh );
}
fclose( fh );
}
}

/*Export Data from Amibroker to ASCII files

Here there is a formula available to export data from Amibroker to ASCII files. With the formula we can export data for a specified period from Amibroker database.

How to export:

Scan with the formula in Automatic Analyser (AA) in Amibroker.
The formula will create a folder in C drive named 'Savedata' and will collecte the data in separate text files for each symbol.

Periodicity:

WE can export the data for different periodicity 1min, 5min, 10min or daily etc. as we required. To configure that go to AA > settings > General > Periodicity and set periodicity. Thus we can get data for 5min, 10min, 1 Hour, daily etc.

Select Date Range:

To set the date range, we have to edit the formula.
Open AA > pick (the formula file) > edit.
In the second line we can see:

Buy = ( (DateNum() >= 1061225) AND (DateNum() <= 1070110) );

First DateNum is the start date and second DateNum is end date.
The current settings will export data from 20061225(=10612205, so 2006 =106) to 20070110.
Just like that, we can select another date range. Instead of 2006, should give 106 and for 2007, give 107 etc. Month and date are same. Save the formula and scan it.
It will export and save the data in C:\Savedata folder.
If you want to export for an another date range, that will also be added to the corresponding files just after the current data.*/ 

Read More »