What is AmiBroker?

AmiBroker is a comprehensive trading software that provides a suite of tools for traders to analyze the market, develop and test trading strategies, and execute trades efficiently. It is designed to help traders find their edge in the market by offering an exploration tool that scans for opportunities and inefficiencies, a robust backtesting tool to test trading systems on historical data, and a portfolio-level backtesting tool for assessing the performance of multiple securities simultaneously.

The software includes advanced features such as a 3D optimization chart tool to identify the best parameter combinations, a batch processor for automating tasks, and an analysis tool that generates order lists and places orders directly from a trader's code. AmiBroker's user interface is customizable and supports multiple monitor setups, enhancing its versatility and usability.

AmiBroker is also equipped with a powerful formula language that allows traders to express their ideas concisely and quickly, with native support for processing arrays and matrices. A state-of-the-art code editor, complete with syntax highlighting, auto-complete, and in-line error reporting, assists in writing reliable and maintainable code. Additionally, AmiBroker integrates with the Windows scheduler and can run on Microsoft Windows, as well as on Apple Mac through virtualization software.

The software is available in three editions to cater to different trader needs, from end-of-day and swing traders to those requiring real-time data and advanced backtesting capabilities. AmiBroker licenses are perpetual and include two years of free upgrades, support, and maintenance. In terms of data handling, AmiBroker can manage data from almost any exchange in the world and comes with a sample DJIA components database, which can be updated using AmiQuote.

Exporting Data from AmiBroker to a CSV File

Using the Automatic Analysis Window

To export quotes to a CSV file through the Automatic Analysis window, you can use a specific formula. Start by opening the Automatic Analysis window, then paste the following formula into the formula window: Filter=1; AddColumn(O,"Open"); AddColumn(H,"High"); AddColumn(L,"Low"); AddColumn(C,"Close"); AddColumn(V,"Volume",1.0); AddColumn(OI,"Open Interest",1.0). After pasting, click on Tools -> Send to Auto-Analysis, select 'Apply to: All Stocks' and 'Range: All quotations'. Finally, click the 'Explore' button, followed by the 'Export' button, and specify the file name for your CSV.

Using File Functions

Alternatively, file functions can be used to export data to CSV files in fixed date (YYMMDD) and time (HHMMSS 24-hour format) formats. These CSV files can be used to import quotes into other programs, such as Metastock, using tools like Equis Downloader. This method is useful when you need to export quotes in a format that is compatible with other software.

Exporting and Importing Between Databases

AmiBroker also allows for exporting quotes from one database to ASCII files, which can be in CSV format. These exported files can then be imported into another database. The compatibility of date and time formats is crucial for successful import back into AmiBroker or other applications such as Metastock.

Seamlessly Integrate AmiBroker with Sourcetable

Incorporating AmiBroker data into your spreadsheets can now be more efficient and dynamic than ever with Sourcetable. By using Sourcetable to import AmiBroker data directly, you bypass the cumbersome process of exporting to CSV and then importing into another spreadsheet program. This streamlined approach harnesses the power of Sourcetable's capability to sync live data from a wide range of apps and databases effectively.

Sourcetable's ease of use comes from its ability to automatically pull in data from multiple sources, including AmiBroker. This functionality is pivotal for those who seek to maintain up-to-the-minute accuracy in their data analysis without the need for constant manual updates. The intuitive spreadsheet interface of Sourcetable allows users to query and manipulate their AmiBroker data with familiar tools, enhancing both automation and business intelligence capabilities.

Common Use Cases

• A

  
  Use case 1: Exporting basic quote data such as open, high, low, close, volume, and open interest for analysis outside AmiBroker
• A

  
  Use case 2: Creating a historical quotes database in CSV format for backup or transfer to another system
• A

  
  Use case 3: Utilizing file functions to automate the export process for regular reporting
• A

  
  Use case 4: Generating CSV files for quotes to share with clients or stakeholders who do not use AmiBroker

Frequently Asked Questions

What is the easiest method to export quotes to CSV in AmiBroker?

The easiest way to export quotes to CSV is to use the formula from the Automatic Analysis window with these lines: Filter=1; AddColumn(O,"Open"); AddColumn(H,"High"); AddColumn(L,"Low"); AddColumn(C,"Close"); AddColumn(V,"Volume",1.0); AddColumn(OI,"Open Interest",1.0).

Can AmiBroker export data directly to Metastock?

No, AmiBroker does not allow exporting directly to Metastock, but you can use Equis Downloader to import text files to Metastock.

How can I automatically export data to CSV in AmiBroker?

You can use a batch function to automatically export data to CSV. Advanced methods involve file functions such as fopen() to open a file, fputs() to save data, and fdelete() to delete old CSV files.

How can I remove the 00:00:00 timestamps from the CSV file?

To remove the 00:00:00 timestamps from the CSV file, you must use EOD data. You can confirm if EOD data is being used by checking if the 'EOD' column is 'True' when scrolling to the right in the quote list.

What steps does the tutorial recommend for exporting quotes to a CSV file?

The tutorial recommends using the formula from the Automatic Analysis window and employing the Explore and Export buttons to export the quotes. For exporting from another database, it suggests using a file function to export quotes to a text file.