Step by step guide to import pi chart data to amibroker

This post will explain step by step procedure to import pi chart data to amibroker.
1.Login to pi
2.Add required symbol to market watch
3. Right click on the symbol and select chart (shift + c)
4. Select periodicity, interval and days as required
(keep Periodicity as minute and interval as 1)
(If you select high number of days, Pi may take more time to load and may go unresponsive)
5. Once the chart is loaded, right click on the chart
Select    Save Chart –> Save Chart Data to Excel
6. Once exported, it will automatically open the csv file. Close that csv file.
Now, go to ‘C:\Zerodha\Pi\Exported’  folder.
Right click on the csv file and select open with and choose notepad
7. Next is the tricky part, we need to split date column into date and time with comma separated.
We are going to do this using simple find and replace function.
There is a space between date and time, we will find that space and replace it with comma.
Press Ctrl + H to open find and replace window.
In find what field – enter Space Button Once
In replace with field – enter,
Press Replace All Button
8. Save and close the text file
9. Now open AmiBroker.
Go to File –> Import Wizard.
10. In Import Wizard dialog, click pick files button and navigate to ‘C:\Zerodha\Pi\Exported’ folder and select the csv file or files.
1. Press next to configure import details.
Select all options as shown in the below figure.
Column1 – DMY
Column2 – Time
Column3 – Open
Column4 – High
Column5 – Low
Column6 – Close
Column7 – Volume
Separator – comma (,)
Skip first – 1 lines
Check – log errors
Check – automatically add new symbols.
12. Press next to save our import settings, so that we no need to go through the import wizard again
when we import csv files next time.
Check – add current settings to ASCII importer definitions
Description – PiImport
Format file – PiImport.format
Press Finish Button.
As soon as you press finish button, your data will be nicely imported into AmiBroker. And also, your import
settings are saved. By default, AmiBroker will use the file name as ticker if the ticker name is not available in
the csv file. That’s great.
13. Since we saved the import settings in the format file, we can use that directly to import csv files instead of going through import wizard again. Below is the example. Note before importing the csv file; ensure that you split the date and time column as mentioned above.
Go to File –> Import ASCII
Select the file or files to import and
Files of type – PiImport (*)
Press open. Now all the files selected will be imported to AmiBroker.
For any queries further you can drop message in below comment box.
Admin

Admin

I'm managing everything here...

8 Comments

Leave a Reply

Your email address will not be published.