Sourcetable Integration

Export AmiBroker to CSV

Jump to


    Welcome to our comprehensive guide on exporting AmiBroker data to CSV filesā€”a crucial process for traders and analysts who wish to leverage the power of AmiBroker's advanced analytics in other applications like Excel. Exporting to a CSV file not only facilitates a seamless transition of data into a versatile spreadsheet format for further analysis and visualization but also simplifies sharing and backing up valuable insights. On this page, we'll delve into what AmiBroker is, the step-by-step process of exporting data to a CSV file, practical use cases for such exports, an innovative alternative to CSV exports for AmiBroker using Sourcetable, and a helpful Q&A section to address common queries about the export process.

    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.

    Sourcetable Integration

    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
      Sourcetable Integration
      Use case 1: Exporting basic quote data such as open, high, low, close, volume, and open interest for analysis outside AmiBroker
    • A
      Sourcetable Integration
      Use case 2: Creating a historical quotes database in CSV format for backup or transfer to another system
    • A
      Sourcetable Integration
      Use case 3: Utilizing file functions to automate the export process for regular reporting
    • A
      Sourcetable Integration
      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.


    Exporting quotes from AmiBroker to CSV is a streamlined process that leverages the Automatic Analysis window for quick and efficient data handling, suitable for both re-importing into AmiBroker or use in other applications. By following the simple steps of pasting the appropriate formula into the Formula Editor, sending it to the Automatic Analysis window, applying it to all stocks, and utilizing the Explore feature, users can easily export their data to a CSV file. While this method is effective, it's worth considering the advanced capabilities of Sourcetable, which allows for direct importation of data into a spreadsheet, bypassing the need for intermediate CSV files. To enhance your data management workflow and embrace seamless integration, sign up for Sourcetable to get started.

    Start working with Live Data

    Analyze data, automate reports and create live dashboards
    for all your business applications, without code. Get unlimited access free for 14 days.