AIAnalyst Logo

Formula Help

The algorithm generated by AIAnalyst for each Order is made available on the report in three different ways:


This format aims to be easily readable by non-programmers.

Market data is numbered starting from 1 for the first and most recent candle. As an example, if your latest market data is 04/16/13, open2 is the Open value from 04/15/13.

The correct way to read the Formula is to start by solving the innermost parentheses, and then solving the ones enclosing them, successively, until the outermost parenthesis is solved.

Example Formula: ((high2 - close4) + 0.1120)

Using the same example dates (last candle is 04/16/13) this formula can be solve by:

  1. Subtract the close value from 04/13/13 from the open value from 04/315/13.

  2. Add 0.1120 to this value.

  3. final value > 0: buy; final value < 0: sell; final value = 0: hold.

C Code

This format can be pasted directly to your C code.

The candles array is zero-based, with the first element (position 0) having the most recent candle

Excel Formula

Just like the C Code, the Excel Formula can be pasted directly to your spreadsheet

Market data used by the Excel Formula should have the following arrangement:

Example Formula: =CHOOSE(SIGN((C3 - E5) + 0.112)+2,"DOWN","N\A","UP")

This is how the example formula can be directly pasted in an Excel spreadsheet, revealing the result for this data set: