Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

How to Import NSE and MCX Intraday Data from CBloomNews to Amibroker

1 min read

This post deals with Importing NSE and MCX Intraday Data download from CBloomNews and importing the same into amibroker.
[wp_ad_camp_5]

 
Assume that you want to import MCX Gold 1 minute data into your Amibroker. Now the following steps need to be perform to import your data into amibroker

Extracting the CSV File
1. Goto www.cbloomnews.net
2. Go to the symbol(in our case it is MGLD- MCX Gold) you want and select the required timeframe(1 min)
3. After Selecting the timeframe 1min chart for MCX Gold will be drawn in CbloomNews
4. Now Go to settings tab above the charting image and Select Export Data as CSV

5. Save the CSV file into your local disk.

Prepraing Amibroker Format File
1.Open Notepad and save the below format type into c:program filesAmibrokerformatsCbloom.format

# Format definition file generated automatically
# by AmiBroker’s ASCII Import Wizard
$FORMAT Date_DMY, Time, Open, High, Low, Close, Volume
$SKIPLINES 1
$SEPARATOR “, ”
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

Alternatively u can download the Cbloom format here
and save the file into the folder c:program filesAmibrokerformats path

Preparing the Amibroker Database
1)Open Amibroker
2)Goto File-> New -> Database
3)Database Settings dialog box Opens. Type the Database name in the Database Folder path as shown below
4)Select Base time interval as Tick and Number of Bars should be greater than 10000 and Press OK button

5)Goto File -> Import ASCII
6)Select the CSV file and also select the File Type as CBloom from the drop down menu as shown in the below image.

7)Finally the MCX Gold Intraday Data appears on the chart. As CbloomNews supports the following symbols

MCX Symbols includes Gold, Silver, Copper, Lead, Zinc, Nickel..etc.
NCDEX Symbols includes agricultural commodities, Crude, potato,
Currency Symbols includes USDINR, EURINR, GBPINR, JPYINR forex cross
currency pairs.
NSE Symbols includes Nifty, Bank Nifty, CNXIT, Mini Nifty, and more than
200 NSE Future Stocks
World Indices symbols includes Dow Jones.

MCX Gold Intraday Chart 24 September

The same symbols can be imported into your amibroker database by just downloading the CSV file and then using the import ASCII functionality to import into amibroker database.

Getting a Hourly chart

1)As the 1min bars are not enough to plot the houly chart. So select the hourly timeframe in MCX Gold symbol(CbloomNews) and Makesure the hourly charts are plotted in CBloomNews.
2)Now Go to settings tab above the charting image and Select Export Data as CSV
3)Save the CSV file into your local disk.
4)Open Amibroker ->Goto File -> Import ASCII
6)Select the CSV file and also select the File Type as CBloom from the drop down menu. This will plot the hourly chart on the Amibroker. This can be
used for further shorter timeframe analysis and the same procedure is applicable to plot any sort of timeframe. Also Make sure that you have selected the hourly chart timeframe in the Amibroker.

The only disadvantage is importing all the symbols from CbloomNews to Amibroker is a tedious task and a timeconsuming activity. Its only applicable for those who want to analyse only few MCX/NSE symbols or their favorite stocks/commodities at that instant for shorter term purpose . Otherwise Maintaining a Database on daily basis is a hectic task.

Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

[Live Coding Webinar] Build Your First Trading Bridge for…

In this course, you will be learning to build your own trading bridge using Python. This 60-minute session is perfect for traders, Python enthusiasts,...
Rajandran R
1 min read

[Webinar] Understanding and Mitigating Curve Fitting in System Trading

"Understanding and Mitigating Curve Fitting in System Trading"! This dynamic session aims to equip novice to intermediate traders, quantitative analysts, and financial engineers with...
Rajandran R
1 min read

P-Signal Strategy Long Only Strategy – Amibroker AFL Code

This tutorial provides an overview of the P-Signal reversal strategy, a quantitative trading strategy that utilizes statistical parameters and error functions to generate probabilistic...
Rajandran R
2 min read

15 Replies to “How to Import NSE and MCX Intraday Data from…”

  1. Slight missing thing

    After creating Cbloom.format and saving the file into the folder c:\program files\Amibroker\formats\ path

    One need to add following line in the import.type file in the same folder

    CBloom (*.*)|*.*|CBloom.format

    so that when you import .csv file it will allow you to select “CBloom Format”

  2. hi,

    i get real time feed in excel. how to export it to fcharts? is there a free plugin available for the same?

    help appreciated.

  3. @Parag

    Whenever you want to analyse you have to use import ASCII. Since cbloomnews is realtime you can update your charts to study the market during the market hours

  4. Could you please give steps for nse quotes. I got registered but could not add nse data, finally is the data live or eod, and is backfill possible for live intraday data?
    Thanks

  5. Hi Rajandran, very useful article. Recently time is not showing correctly in cbloomnews.net. How can we correct time when importing data to Amibroker

  6. dear sir,
    i am a trader of mcx .
    i lost much money in mcx.
    can u tell me how to generate mcx calls.
    is there any coaching institute who can guide me to technically analysis mcx calls.
    pls help me.

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More