Pages: << 1 2 3 4 5 6 7 8 9 >>


Permalink 03:36:46 pm, by Dana Comolli Email , 491 words   English (US)
Categories: Reconciliation, Accounting, Futures Trading

APS was supposed to make things easier

When the Clearing Corporation developed the Average Price System (APS) approach to handling mixed fills, its purpose was to make it easier for traders to allocate their trades across multiple accounts. Unfortunately, policy changes at some FCMs have changed all that.


The Clearing Corporation developed the APS system in June of 1992 as a way of making the execution process more efficient. Then in 1994, they introduced APS “Plus Five,” creating a consistent, industry-wide standard for calculating and processing average price trades for clearing and bookkeeping systems.

This method involves rounding the weighted average fill price to the nearest tradable price (up on a buy and down on a sell.)  Each account is filled at that rounded price and then given an “APS Adjustment” in the form of a cash credit to make up for the slightly worse than average price each account receives.

This has been the norm for APSed orders until late 2009 when some brokers started clearing the trades at the numerical average price and dispensing with the APS adjustment. This provides the clearing firm one primary benefit, no need to provide cash adjustments.

The issue for Traders

The result of this change is a situation that rivals the complexity the APS system was designed to solve.

Where once every account got filled at the same price, now accounts get filled based on where they clear.  If a block trade includes accounts that clear at brokers that pick up the trade at the rounded (APS) price and accounts that clear at brokers that pick up the trade at the numerical average price, accounts get different fill prices even though the trade was APSed.

When reporting give-up’s and trade recaps, this difference based on where an account clears must be taken into account. Reconciliation is equally impacted since these changes affect trade confirmations, positions, and cash balances.  OTE and realized gains for two accounts that trade identically are now a function of where they clear.

How TheBooks can Help

TheBooks includes the ability to indicate that a clearing broker either does or does not pick up APS trades at the rounded price with APS adjustments. When block trades are APSed, those accounts that clear at FCMs that pick up the rounded price get filled at the rounded price and are given a cash adjustments, those accounts that clear at FCMs that pick up the trade at the numerical average get filled at that price without cash adjustments.

Counter-party notifications, allocation files, and other trade-related notifications automatically incorporate the appropriate price formats. Reconciliation understands these changes and the precision used by each broker for numerical average prices can be configured to work around any variances that exist in FCM back office systems.

Of course, since TheBooks incorporates multiple price allocation methods for fairly and consistently allocating multiple fill prices accross the accounts that make up a block trade, perhaps the easiest approach is to dispense with the APSing of trades altogether.


Permalink 02:04:48 pm, by Dana Comolli Email , 762 words   English (US)
Categories: Accounting, Futures Trading

FIX Drop copy in TheBooks

Imagine walking up to a trading screen (any broker or vendor’s trading screen), entering a trade and when the trade is filled, having the fills automatically show up in TheBooks. That is what FIX Drop copy in TheBooks provides.

FIX stands for Financial Information eXchange (FIX) Protocol and is a messaging standard developed specifically for the real-time electronic exchange of securities transactions and is supported by most trading partners. TheBooks supports both versions 4.2 or 4.4 of the protocol and several vendor-specific variations of these versions.

Let’s examine one application of this capability and how it can streamline the operation of a CTA or hedge fund with managed accounts:

Our hypothetical advisor has both discretionary and systematic trading components in their programs and have a fund as well as several managed accounts. They execute trades through multiple platforms through multiple brokers and have clearing relationships with three separate firms. They trade most or the major liquid global futures markets as well as some options and equities.

Each trading partner requires trade allocation information to be transmitted to them via an sFTP file transfer in their own specific format as soon as the trade has been filed. Each of the claring firms require an end of day file with trades they should expect from the various executing parties, and several 3rd party administrators as well as investors also require a daily recap of trades done in their accounts either sent via email or sFTP.

System Configuration
The diagram below provides a high-level view of how the advisor is configured to communicate with the firm’s various trading partners:

The FIX interfaces are implemented as point-to-point, always up connections over VPNs. The sFTP and email connections use the internet and are used as needed.

Trading Operations
Discretionary traders trade through multiple platforms such as TT’s X_TRADER and Goldman Sac’s Redi+. System-generated trades are placed into the market through the programming interface of a popular trading platform.

As trading occurs, fills, regardless of source, are automatically routed to TheBooks via the FIX connections. Fills for each ticket are consolidated into trades within TheBooks and are booked to what is known as a holding account.

This is done because as orders are worked, the ticket number for a trade typically changes as the limit is moved. This is a function of the execution platform, but the behavior is pretty standard across platforms. The result is that multiple tickets could really be part of a single trade. By having the trades booked to a holding account, the advisor can select multiple tickets that are to allocated to a block of accounts as a single trade.

For platforms that do not generate new ticket numbers as the trade is worked, TheBooks could be configured to automatically assign the trades to a pre-selected block of accounts.

Post Trade Allocation
After a logical trade has been completed, the trader or back office personnel select the ticket(s) which make up the logical trade and associate them with the group of accounts which are to be allocated to the trade. As an option, the trade can be associated with one or more strategy (or system) to allow tracking of virtual positions and performance by strategy.

Contract quantities are automatically assigned based on the each account’s relative trading size and once saved, quantities and fill prices are allocated to the accounts.

If the advisor wanted to work up trades in advance of execution (using TheBooks ability to combine trades from multiple systems/strategies, for example), the assignment of the ticket to the block of accounts can also be done by simply selecting an existing trade rather than specifying a group of accounts. In that case, the fills from the tickets are “pushed” into the existing trade.

Counter-Party Notification
Once the block order has been allocated, TheBooks automatically sends allocation information to those 3rd parties configured to receive it. In the case of the executing broker, this is typically done immediately. In the case of clearing brokers, administrators, and investors, this data is typically sent at the end of the day.

In all cases, the advisor is able to configure the format of the file, including symbology to be used and the transmission method (email, FTP, sFTP, etc) and whether the information is to be sent at trade completion, at end of day, or both.

By using TheBooks FIX drop copy interfaces in conjunction with its order management capabilities, this advisor easily implemented a diverse portfolio of trading strategies and execution platforms across multiple managed accounts with a minimum of manual effort.


Permalink 09:02:03 am, by Dana Comolli Email , 431 words   English (US)
Categories: Reconciliation, Accounting, Futures Trading

Painless reconciliation

Any CTA with managed accounts knows that one of the most time-consuming aspects of the job is reconciling your books and records with those of your clearing brokers. This becomes an especially arduous task when you have clearing relationships with multiple brokers. It seems that no two brokers have the same statement format, use the same symbology, or adhere to a consistent price convention.

What makes things even more frustrating is that most of the effort is spent reviewing trades that are correct in order to locate the ones that are wrong.

TheBooks reconciler automates this process and presents you with the trades, positions, and balances that do not agree, eliminating the tedious process of manually locating discrepancies.

Statements, not data files

TheBooks reconciler reads human-readable statements, not data files. This allows you and the software to use the same source when reviewing the information provided by your brokers.

In addition, TheBooks automatically organizes, encrypts, and compresses your statements and saves them within its database providing a single point for backup. It also includes facilities for exporting your statements onto disk in an organized fashion allowing you easily prepare for audits.

A three step approach to data extraction

TheBooks reconciler goes through three phases in preparing the data on a broker’s statement for use in the reconciliation process. These steps are outlined below:

The third step, validation, is what converts the data from the various standards that exist on broker statements into the standard you have defined in TheBooks. This step uses what are known as statement symbols to translate and, if required, re-value symbols and prices and is based on the settings you configure. In this way, TheBooks performs standards-independent data transactions from the broker statements into the format you desire.

Only the issues

When you ask the reconciler to look for differences, it only shows you the trades (or positions, or balances) that are different. You then spend your time resolving the issues; rather than looking for the issues. In addition, TheBooks reconciler maintains a list of open trade breaks and includes them on any break sheet you send to your broker.

As missed or extra trades are corrected on your statements, they are automatically removed from the list of open breaks. Price corrections are also detected and reported.

Sample confirm breaksheet


TheBooks reconciler’s ability to read the same statements you read, convert the symbology and price conventions to your standard, and to present you with only the issues, makes it an invaluable tool for the CTA with managed accounts.

For more information, see TheBooks Reconciliation at

<< 1 2 3 4 5 6 7 8 9 >>

September 2020
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        
The official blog for users and others interested in TheBooks®


XML Feeds

powered by b2evolution free blog software