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. AlgoGeek Algorithmic Trader. R&D in Financial Markets. Professional Coder.