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
$SEPARATOR “, ”
Alternatively u can download the Cbloom format here
and save the file into the folder c:program filesAmibrokerformats path
Preparing the Amibroker Database
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
NSE Symbols includes Nifty, Bank Nifty, CNXIT, Mini Nifty, and more than
200 NSE Future Stocks
World Indices symbols includes Dow Jones.
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.