Author Topic: How to create Format file, aqe file  (Read 2565 times)

shahadat65

  • Newbie
  • *
  • Posts: 4
    • View Profile
How to create Format file, aqe file
« on: February 11, 2016, 11:53:16 am »
1] I have a format file in note pad, How can I create dot format(.format) file with this.

2] I have a Excel file with fundamental data, How can I create dot aqe (.aqe) file with this.

I attach both file herewith.

Can anyone help me on this.

Peter5510

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: How to create Format file, aqe file
« Reply #1 on: December 18, 2017, 10:30:54 pm »
Change your file in the following order....
$FORMAT TICKER,BOOK_VALUE_PER_SHARE,.....
$SEPARATOR ,
$SKIPLINES 1
$NOQUOTES 1

Save this file and name it e.g. fundamental.format in the Amibroker/Formats folder.

The next thing you must do is to add the following line in import.types file.
Fundamental Information (*.*)|*.*|fundamental.format

In Amibroker, go to File -> Import ASCII... select the file to import and select the file types in the drop down menu. Click Open
.