Example Database

Easy access to free Yahoo data, using AmiBrokers companion down-loader AmiQuote, is a huge bonus for AmiBroker users.

In this tutorial, the first in a series of Users’ Knowledge Base articles on Yahoo data management, new users are introduced to some basic concepts utilizing mainly GUI methods. Walk through examples, using the Dow Jones Industrial Average database installed with AmiBroker, and apply simple customized formulas written in AFL (AmiBroker Formula Language).

FORMULAS FEATURED: BeginValue(); LastValue; DateNum(); BarCount; Status(); FullName(); IsIndex(); GroupID(); MarketID(); SectorID() and IndustryID().

INCLUDING: database location, backup and naming; ticker lists (.tls files); company information pages; symbol addition and deletion; updating quotes; writing and saving formulas in Formula Editor; running Explorations and viewing the results list; data quality checking using the Database Purify Tool; adding favorites to the Web Research list; setting the default and scrolling Yahoo pages in the AmiBroker browser; deleting quotes in Quote Editor; rearranging the Workspace layout using the Docking sticker; Ticker Toolbar searching and more …………….

Attached Files:

  • exampledatabase.doc (1178 KB) (Word 2002 document)
  • x-categories.afl (262 bytes)
  • x-database.afl (226 bytes)
  • 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 (1 votes, average: 4.00 out of 5)

One Response to “Example Database”

  1. brian_z
    September 7th, 2007 | 4:21 am

    Version 5.00 candidate release http://www.amibroker.com/devlog/2007/09/04/amibroker-500-release-candidate-1/

    Q. I didn’t notice the recommendation that “Existing users should use the UPGRADE version only, to keep their existing data untouched”. I installed using the FULL version. My database went back to May. Now that I missed this what can I do ?

    A. That is rather impossible as the database shipped with 5.00 is updated up to August 31.

    Full (not upgrade) version installs the demo end-of-day DJIA database into
    “Data” folder. If your default database was in that folder it will only overwrite those 30
    stocks from DJIA and nothing else and it will be updated up to August 31.

    If your database is in different folder – you can simply open it using
    File->Open Database

    Best regards,
    Tomasz Janeczko

    AmiBrokerYahooGroup message #114768 – AmiBrokerYahooGroup – AmiBroker 5.00 Release Candidate 1

    Authors comment – v5.00 release makes the setup used in this example redundant however the tutorial will be retained as is. The methods used are still relevant and future articles will build on the theme.