What is AmiBroker?

AmiBroker is a comprehensive trading platform that provides a robust set of tools for market analysis and trading system development. It is equipped with features such as exploration tools for scanning market opportunities, various backtesting capabilities, and the ability to define objective trading rules. AmiBroker caters to both novice and professional traders by offering a versatile environment for strategy development and execution.

The software is known for its advanced functionalities, including portfolio-level optimization, Walk-forward and Monte Carlo simulations for system validation, and customizable charting options. AmiBroker also supports auto-trading, allowing traders to execute trades directly from the platform. Its powerful formula language, AFL, enables users to express trading ideas quickly and efficiently, supported by a built-in debugger and code editor with syntax highlighting and auto-complete features.

AmiBroker comes in various editions to suit different user needs and offers a perpetual license model with 24 months of free upgrades and support. Additionally, the platform can be used on both Windows and Apple Mac devices through compatibility software, ensuring a broad user base. Overall, AmiBroker provides a flexible and powerful environment for traders looking to analyze the markets and develop their trading systems.

AmiBroker Plugins for Excel

Linking to DDE Sources

The AmiBroker Excel plugin facilitates the linking of AmiBroker to any DDE source, allowing the utilization of almost any DDE source with the Excel plugin. This feature enables users to stream data into AmiBroker for real-time analysis.

Streaming Symbol Limitations

While using the Excel plugin, users can stream up to 500 symbols simultaneously. The plugin is also versatile in supporting all base time intervals for these symbols.

Time Interval Support and Numerical Formats

The Excel plugin supports all base time intervals, ensuring that users can work with time series data according to their analysis needs. Additionally, it uses the regional settings numeric format by default, which ensures consistency with the user's local data format preferences.

Limitations of Excel Plugin

Despite its versatility, the Excel plugin does not support backfill, which is a limitation for users who require historical data for their analysis. In such cases, a dedicated plugin, which is both faster and offers more features, might be a better alternative.

Common Use Cases

• A

  
  Use case 1: Importing real-time quotes from a financial data vendor that does not offer a dedicated AmiBroker plugin
• A

  
  Use case 2: Displaying and analyzing streaming data for up to 500 symbols in real time within AmiBroker
• A

  
  Use case 3: Customizing the DDE server/topic/item settings to match specific data fields required for AmiBroker analysis
• A

  
  Use case 4: Utilizing the plugin on older operating systems like Windows XP and Windows 9x for compatibility with legacy systems

Frequently Asked Questions

How do I set up a DDE connection from Excel to AmiBroker using the AmiBroker Excel plugin?

To set up a DDE connection, configure a DDE datasource in AmiBroker's database settings and specify 'EXCEL' as the server. Detailed steps can be found on the AmiBroker website.

Can the AmiBroker Excel plugin be used to link a trading terminal to Excel?

Yes, the plugin can link a trading terminal to Excel. If experiencing issues, users can seek help on the forum where one user is willing to provide settings and assistance.

How can I import and access Excel data in AmiBroker?

Save your Excel files in CSV format and use the Import ASCII option in AmiBroker to import the data. Imported data is then accessible by direct reference within AmiBroker.

What should I do if I encounter problems displaying symbols from Excel in AmiBroker?

If you face issues connecting to live data, seek guidance on the next steps on the AmiBroker forum. Ensure that you have configured the DDE connection correctly.

Is the AmiBroker Excel plugin compatible with all versions of AmiBroker software?

The plugin is compatible with different versions of AmiBroker software, including AmiBroker 6.35.1 BETA as mentioned by a user on the forum.