The free version of APIX.XL™ includes a Microsoft Excel template demonstrating the rich user experiences enabled by API-Excel integration.
The RFPB Template file is an Excel application that reconciles a client’s position data against data from a prime broker and displays any breaks as well as data availability. The RFPB Template sources data from an API that is included with APIX.XL™.
The breaks reported in the template roll up to the Entity level and can be drilled down to the Account, Position, and Security level. The template also displays any margin calls and call requirements. In addition, it reconciles current-day and prior-day data from the broker, displays a summary of differences in margins and market values, and lists the top-10 margin differences.
The following guide provides an overview of the RFPB Template.
When the RFPB Template is first opened, the user may be prompted to enable editing.
The template itself will be empty. To call data, click the Refresh button located in the upper right hand of the dashboard.
Explanation of Breaks
Break Report: Out of 141 total positions, there are 7 position breaks across 6 accounts and 4 entities. There is a total of 59 accounts and 7 entities.
Data Availability: Out of 141 total positions, data for 5 positions is missing from the broker data set and 136 positions are available. The 5 missing data items are across 5 accounts and 4 entities.
The Entities Tab
Click on the ENTITIES tile on the dashboard to populate the dashboard with Entity-level data.
The Entities tab displays a data summary rolled up to the Entity level. The column to the right of Credit Cash is red for Entities with underlying breaks, and the number in this column indicates the number of accounts within the Entity that have breaks.
Clicking on an Entity will open up the Accounts tab in the workbook and allow the user to view Accounts under the entity.
Clicking on any summary tile on the right-hand side of the dashboard (Breaks, Data Issues, Margin Calls) will filter the data to display only items related to the tile. For example, if the Breaks tile is clicked, the data table will only display the entities that have breaks.
Filters can be cleared and predefined filters can be applied by making a selection from the Filters dropdown on the left-hand side of the dashboard. Similarly, various predefined sorting can be applied by making a selection from the Sort by dropdown on the left-hand side of the dashboard.
The Accounts Tab
The Accounts tab lists all accounts for the selected Entity. Accounts with underlying breaks are highlighted in red. Clicking on an Account allows the user to view underlying Positions.
The Positions Tab
The Positions tab lists all securities for the selected Account. Securities with underlying breaks are highlighted in red. Clicking on a Security ID allows the user to view details for the security in the Position Drilldown tab.
The Position Drilldown Tab
The Position Drilldown tab lists values for client and broker files for the selected security. Fields values that do not match are highlighted in red.