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

Modified AFL for Fibonacci Trading

With this post I would like to offer a modified Fibonacci AFL (download link available @ comment area, just below of this post). But first of all some thoughts on Fibonacci. Each person has personal tolerance level for risk and also has a level of greed. In losing trade we close the trade and stop the pain. This is our risk/pain tolerance point. Similarly, in a winning trade, at a point our profit seems in such a level that we become worried, and lock in our profits. This is our greed tolerance level. This level very from person to person. Meanwhile a chart using modified Fibonacci AFL: If we take a crowd of traders, say 50,000, we can say that they have a risk/greed tolerance value. Same technique can be applied for a different group of 50,000 traders. It means every group of traders have an average risk/greed tolerance value.As most traders are human, we can say that average risk/greed tolerance level for any large group would be more or less same. Thus short-term traders, and long-t...
5 comments
Read more

KPL Swing trading system

When Stock`s Price increases everyday, the stock holder becomes worried. Of course he should be worried, and before the scripts start falling he should lock his profit. But who knows when it would start falling? Nobody (but smart money sometimes knows). So we need indicators like RSI, OBV, or stochastic. The problem is, even with weak RSI, OVB, or horizontally straight stochastic a script may go up further. So taking profit in fear of falling some times becomes cause of pain, or less profit. So I would prefer a system like KPL swing to give me an exit signal first. Then I would exit. I would wait and see how much a bullish share can grow. See the Graph of Squiretextile, (data uptodated) Tips :  1. At very bottom is main chart (KPL with, adx) to follow, two others are supporting. 2. Thursday the stock opend bellow its previus day`s closing, but closed above it. Which indicates weekness. 3. Yet there is no fall signal (down arrow) and no ADX (price bar in deep green) appeared. So I w...
4 comments
Read more