Skip to main content

How to Import CSV data into amibroker

Tips : A Step by StepsText guide, A pictorial guide and a video guide has been attached with the post. To see right now go to last part of the post, clicking more.  
Now post : After database creation, importing CSV data is the 2nd major job Amibroker requires. But for new users of Amibroker, a trading system software, its not always an easy job. In Bangladesh most of the TA followers import data through Profita, as its more easier. Stockbangladesh.com gives csv data more faster, just after the market closes at 3pm, but it lacks sector data in csv files.  So its better




wait one hour, update Profita after 4PM, and import csv file to amibroker. But how? See the graph bellow.
Its very easy.  Just have a glance. It`s `Jalabat Taralang'.

Steps to follow :
  • Profita1: in Profita Click `Tools', then click `Export data to Amibroker'
  • P2: previous click opened Date selection option
  • P3: select your date. Selection of more than one day is possible. If you do it everyday, make two boxes same.
  • Amibroker!: From File menu click `Import Wizard'
  • A2: Click `Pick files'
  • A3: Go to ABData folder, located within Profita Soft Folder
  • A4.Select the you just have downloaded.
  • A5: Picks file window now will be opened, be sure that your selected file`s name is visible and Click `Next'
  • A6: Previous click will open a vital window.
  • A7. a) Select Date format DMY, and b) type `1' in Skip Line box. Then click `next'
  • A8. Click Finish. You you want to save all the settings you just have performed and want to import multiple files simultaneously with Import Ascci command, select the box `Add Current ...'. And finally click `Finish.' Thats all.

Video shot of this tutorial :
Labels:

Comments

  1. AnonymousAugust 14, 2010 at 11:13 AM

    Its a very nice effort. But the pic are not clear. Would u plz write in a text form. it may help many members like me.

    Thanks

    ashraf

    ReplyDelete
  2. Gaus Rahman PiashAugust 14, 2010 at 5:44 PM

    Ashraf Bro, Steps by Steps guide now in text also. Visit the post again. It has been updated.

    ReplyDelete
  3. Gaus Rahman PiashAugust 14, 2010 at 8:48 PM

    A video tutorial of data uploading technique from profita to ami has been uploaded. For View in full screen mode, Click on the button on right-bottom conrner of the video box.

    ReplyDelete
  4. SPWSOctober 20, 2010 at 5:29 PM

    Thanks for the tutorial! I have some trouble using this software.

    stock trading room

    ReplyDelete
  5. kalyanOctober 27, 2010 at 12:38 AM

    i just recently creat my data base(nse india).there r many readymade historical eod data available in net(zipped) or we can download historical data in ascii or csv format by eod downloader but problem is with importing this files in amibroker serially by import wizard is very tedious and time consuming. wud u suggest a way how to to import it bulk in a short time

    ReplyDelete

Post a Comment

Popular posts from this blog

4 Tips for using Midas in KPL, Code added

ATTENTION : KPL-Midas Code is at the last part of this post. Please copy and paste in your amibroker.) 4 Tips for using Midas in KPL: 1. put your price mark at the beginning of last major price break, bullish or bearish. 2. Right click on price chart, and open Peremeters 3. Change the settings of VWAP channel and ovserve in chart, whether it can create strong support /ressitance level. or not. 4. If you are satisfied with the setting, click OK. (of course, at the same time you can change the KPLs perimeter.) KPL Swing is a simple trend following mechanical trading system. It automates the entry and exit signal. This trading system is very simple and easy to use. It works across multiple time frames and does not require any in-depth knowledge of TA. In KPL System no targets are given as no one knows how high (or low) the stock price will reach. A trailing stoploss locks in the gains and removes emotions from trading. The MIDAS system of technical market analysis is based
9 comments
Read more

Trading System : Using KPL with MIDAS curve

Firsly, the KPL Swing is a simple trend following mechanical trading system. It automates the entry and exit signal. This trading system is very simple and easy to use. It works across multiple time frames and does not require any in-depth knowledge of TA. In KPL System no targets are given as no one knows how high (or low) the stock price will reach. A trailing stoploss locks in the gains and removes emotions from trading. Secondly, the the MIDAS System. The MIDAS system of technical market analysis is based on the concept of Volume Weighted Average Price (VWAP). VWAP calculations is being used widely worldwide. A standard VWAP calculation represents the total value of shares traded in a particular stock on a particula  day divided by the total volume of shares traded in that stock on that day. Here i`m giving a chart using bothe KPL and MIDAS (three lines) curves. As example, BERGER symbol (data updated at 4 Aug, 2010) has been used. In chart its visible that both KPL
3 comments
Read more