AFL Testing Databases

Small databases, with a limited number of symbols and limited data, can be useful for solving complex problems or designing systems within AmiBroker. A small amount of data can be easier to use, for debugging code or proving strategies, than larger amounts. For AmiBroker users, Yahoo data is readily available for this purpose.

In this tutorial new users are shown a simple method to create small quality controlled databases that are suitable for testing basic AFL functions and procedures.

FORMULAS FEATURED: BarCount, BarIndex();

INCLUDING: creating, copying, naming, deleting and backing up databases; managing databases from AmiBrokers? File commands or Windows Explorer; database naming conventions, creating small databases using AmiQuote; manipulating data with Quote Editor; understanding errors reported by the Database Purify Tool, plotting AFL functions as a training aid and more …………….

Attached Files:

  • Click on the link to browse document files on line, or, Save As to download an editable version, complete with a document map (the document map will only be available to users who own a copy of Word).
  • To download .afl files to the desktop right click on the link  and Save Target As ‘filename’ at Program Files/AmiBroker/Formulas/Custom to access them as formulas in the AmiBroker Charts list.
  • 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

    5 Responses to “AFL Testing Databases”

    1. brian_z
      October 13th, 2007 | 7:27 am

      No2 in the Database Management series is something of a diversion from the main theme. It was intended for use with series 2 (pad & align, ATC and custom indexes) but that is receding in the rear view mirror at the moment. Since it has been sitting on my hard drive since May I decided I may as well post it.

    2. October 13th, 2007 | 2:03 pm


      Hi. In the doc you write:

      “Databases can also be opened from ‘File’ > ‘Open’ on the AmiBroker menu bar. Database folders can be copied, renamed and deleted from within this window.”

      But I have not be able to open a database that way. If I navigate to a database folder, highlight it, and click ‘Open’, the dialog navigates into that folder rather than opening the database.

      Am I missing something? (or perhaps the doc needs a correction …)

    3. October 13th, 2007 | 2:04 pm

      P.S. the experience described above was in Windows Vista, if that matters.

    4. October 13th, 2007 | 2:16 pm

      Later in the doc it comes out that that way to open a database via ‘File’ > ‘Open’ is to select the broker.workspace file. This is brought out in section 2.1.

      I would suggest that this information be introduced in section 1.2.3, for the sake of those who might be following along from scratch. Cheers!

    5. brian_z
      October 13th, 2007 | 11:54 pm

      Yes, it is my intention that those who are new to AB could use my posts as ‘workbooks’ to get them on their way (obviously those with an IT background will fly through them and zoom ahead).
      For that reason inclusion of the basics, and being correct with the detail, are important for that style of post so thanks for letting me know ‘how it reads’.
      It would be annoying to come to the first section and click away to find nothing happening so I will add a quick reference for now and maybe make some changes to the post later (I haven’t read this one for months so I might do a re-edit on it when I upload the associated post(s)).
      A few months down the track I will put out the ‘pad and align’ expose that runs off the database I created in this post (the database will be supplied).
      Thanks for your interest.