APL |
Regulatory Composite Performance Reporting |
Regulatory Composite Performance Reporting
The new function FACOMPOSITE provides monthly FA composite performance data in a .CSV file, as well as a one-time historical file for all FA composites since inception. The function will prompt for the report type:
- If monthly there will be two rows per composite in the report
- if since inception there will be multiple rows per composite, depending on inception
The following new fields have been added (M = monthly, I = inception):
- Composite ID (CompID) M & I: This is the (maximum) 6-byte composite code (e.g., MK015)
- Gross Monthly Return (GrossM) M & I: The function has a prompt for an as-of date. This will be the one-month return for the month ending on or before the as-of date. For example, if the as-of date is June 7, 2022, then the one-month return will be for April 30, 2022, through May 31, 2022
- Net Monthly Return (NetM) M & I
- Gross Quarterly Return (GrossQ) M & I: This is the return to the calendar quarter ending on or before the as-of date. For example, if the as-of date is June 7, 2022, the quarterly return will be for December 31, 2021, through March 31, 2022
- Net Quarterly Return (NetQ) M & I
- Number Of Accounts (NoAccts) M & I
- Assets Under Management (AUM) M: Assets under Management at the end of the Period
- Composite Inception Date (InceptDT) M: This is the INCEPT date in the report
File Layout
Header Record
Field |
Mandatory |
Description |
|---|---|---|
Client acronym |
Yes |
This is the directory-level acronym for which the report is being run. |
Report name |
Yes |
For example, FA Composite Report or Inception FA Composite Report. |
Monthly vs Since Inception |
Yes |
Either MONTHLY or SINCE INCEPTION depending on the response to the monthly vs since inception prompt. |
As-of date |
Yes |
The derived month end date, not necessarily the date entered at the as-of date prompt. |
Run date and time |
Yes |
For example, 06/08/22 11:52 A.M.) |
List of field names in the detail section |
Yes |
The field names can be “code words.” It is not necessary to include the full field name. For example, AUM can be used for Assets under management. |
Detail Record
Field |
Mandatory |
Description |
|---|---|---|
Composite ID |
Yes |
This is the (maximum) 6-byte composite code (e.g., MK015) |
Start date |
Yes |
|
End date |
Yes |
|
Gross return |
Yes |
Formatting should not include commas. |
Net return |
Yes |
Formatting should not include commas. |
Number of accounts |
Yes |
Formatting should not include commas. |
Asset under management |
No, included in monthly report only |
Formatting should not include commas. |
Inception date |
No, included in monthly report only |
|
Trailer Record
Field |
Mandatory |
Comments |
|---|---|---|
Record type |
Yes |
Hardcoded to TRAILER |
Record count |
Yes |
Only detail records are counted. Formatting should not include commas. |
Examples
Monthly
WHT,FA COMPOSITE REPORT,MONTHLY,20220430,06/08/22 11:52 A.M.,ID,START,END,GROSS,NET,ACCTS,AUM,INCEPT MK015 ,20220331,20220430, 1.230000, 1.300000, 345, 13212432.55,20000101 MK015 ,20211231,20220331, -10.730000, -10.140000, 369, 11365789.56,20000101 MK1481,20220331,20220430, 4.375000, 4.552000, 1848, 278228842.45,20181101 MK1481,20211231,20220331, -8.375000, -8.552000, 1823, 254324656.77,20181101 TRAILER,4
Since Inception
WHT,FA COMPOSITE REPORT,SINCE INCEPTION,20220430,06/08/22 11:52 A.M.,ID,START,END,GROSS,NET,ACCTS MK1481,20181031,20181130, 0.123000, 0.120000, 742 MK1481,20181130,20181231, 1.123000, 1.120000, 727 MK1481,20181231,20190131, 1.333000, 1.231000, 735 MK1481,20190131,20190228, 2.333000, 2.231000, 747 MK1481,20190228,20190331, 4.653000, 4.442000, 785 MK1481,20181231,20190331, 8.876000, 8.672000, 793 ... MK1481,20220331,20220430, 4.375000, 4.552000, 1848 MK1481,20211231,20220331, -8.375000, -8.552000, 1823 TRAILER,967