Microsoft Access - Project Profile for the Commission Settlement System

Ask us a question on-line
or get our email address on scr.im

Access Programmers has a mission to help people improve productivity through the effective use of technology.

 

 

Microsoft Certified Partner

  

Commission Settlement System Case Study

Customer Profile

Sector: Financial Services
Industry: Securities Brokers & Traders

The League Corporation, a proprietary trading firm, deals in interest rate, agricultural, equity index and metals, energy and other futures contracts.

Business Situation

The firm required a solution to reconcile and settle trading commissions on a daily basis. These commissions are based on daily trading activity and are computed at the end of each day. The firm uses a sliding scale to compute commissions and allocate funds to traders and their managers with the remaining allocated to the brokerage house.

Solution

Commission Settlement System

The Access Programmers team was selected to develop a customized solution for The League Corporation. The Commission Settlement System allows the import of daily transactions from the Trade Settlement System and reconciles commission payments. Users can also generate a variety of trading summary reports.

  

Executive Summary

Company

The League Corporation, based in Chicago, Illinois, has been a member of the CBOT since 1973.

Solution Description

The Access Database application enables the import of transactions on a daily basis to compute commission payments.

Benefits

Efficient Analysis

The back office can efficiently generate detail reporting for an individual trader or statistical details against all traders.

Risk Management

Managers can now track traders against individual threshold parameters. For instance, each trader can be configured for a maximum loss limit.

Software and Services

  • Microsoft Windows XP
  • Microsoft Access 2003
  • Windows 2003 Server