How to Feed .CSV Files on Amibroker

Here is a basic simple tutorial on how to feed your amibroker .csv files.

Before we proceed feeding your amibroker requires patients.

So if you dont have one don't proceed reading below.

1.1 step. Open your amibroker by clicking the shortcut icon on you desktop.

1.2 Click "File" on the amibroker environment just like on the picture below.

1.3 Click "Import Wizard" just like the image above.

1.4 Click "Picks files" a window is going to open locate the .csv file.

Note:(In my setup its located at Drive C:/folder, in your case you should locate the .csv file.

If you do not have a .csv file i will share mine on the end of this blog.)

1.5 click on the .CSV file, this indicates that this is the data that you want to feed in your amibroker.

In my example i clicked "stockQuotes_02012013"

See image below.

1.6 Click "Open"

1.7 Click "Next"

1.8 the window Define fields will appear after clicking Next.

Click "more columns" 5 more drop down box will appear. 

1.9 Click "YMD" drop down box.

YMD is the default setting change it to "MDY" just like the image below.

  

 2.0 under "column 8" click the drop down box and select OpenInt just like the picture above.

Note:(this OpenInt enable you to view the foreign buys)

But you will still need the formula for foreign buy which i will share below.

2.1 click "next" to view Additional Settings.

2.2 click "Add current settings to ASCII importer definitions" just like below.

2.3 click "finish" and your half done already.

Note:(You have successfully save formats and 1 .csv data on amiboker).

Note:(Amibroker requires a minimum of 3 .csv file to view a graphs.)

So you will feed more .csv file to amibroker using a shortcut steps.

3.0 on amibroker environment click "File".

3.1 click "Import ASCII".

Note:(We can use this procedure only if we have completed all the steps above.)

3.2 click on the .CSV file, this indicates that this is the data that you want to feed in amibroker.

In my example i clicked "stockQuotes_02222013"

See image below.

3.3 click "Open".

Example below.

Bofore no .csv was feed it looks like this.

After 4 .csv was feed see picture below.

basically you will just repeat steps 3.0 to 3.3 until you have feed all the .csv files that you want.

Congrats now you know how to feed daily quotes to amibroker!

If you don't know where to get .csv files you need to install PSEget.

Or you can download my .csv file from 2012 to the last trading day below is the link.

For 2012 with foreign bought and sell here is the link https://www.dropbox.com/s/h01zbf6fgqvdqvt/2012%20csv.zip

For 2013 until Feb 22 2013 with foreign transactions. https://www.dropbox.com/sh/zsl1202kdjhh6oy/zJZbQLq8D2

Formula for foreign buys is below.

http://amibroker101.blogspot.com/2013/02/how-to-add-foreign-bought-and-sell-on.html