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


Permalink 05:22:00 pm, by Dana Comolli Email , 143 words   English (US)
Categories: Accounting, Backoffice, Reporting, Compliance

One Click NFA Performance Capsule

Producing the required NFA Performance Capsule for each of your programs can be a time consuming and error-prone task, especially for advisors with large numbers of accounts or ones with high-turnover.

You must update your disclosure document with this information each month any month where there are material program changes during the month.  In addition, the capsule also contains monthly returns values presented in a table with years across the top and months in the rows.  The specifics of the capsule are contained in the NFA’s CTA disclosure document guide.

TheBooks provides a function that produces the NFA Performance Capsule in the required format for any program defined to the system.  Once produced, you can copy the report and paste it into programs like Microsoft Word to update your disclosure document or other marketing materials.

A sample of the function is shown below:

NFA Performance Capsul


What's new in TheBooks version 3.3.0

TheBooks version 3.3.0 is now in production in several customers so we thought we would share some of the new capabilities we have added:

  • The largest change in this release is the support for time zones.  This change affects most areas of the system, but provides the greatest impact in the Data Manager for users of sub-daily bar data.  The time zone support is historical in nature which mean TheBooks now maintains a database of all time zones historically, allowing the automatic recognition of daylight saving time changes around the world.
  • The ability to produce pro forma performance tables for any account or group of accounts.  This allows the actual performance of a program to be re-stated using a standard management and incentive fee schedule.
  • The ability to produce the NFA Performance Capsule and put it on the clipboard for pasting into Microsoft Word and other tools.
  • Support for the Omega function allowing advisors to provide additional risk/return information to the clients and potential clients.
  • Order history and traceability reporting has been significantly enhanced.  All changes to an order (properties, fills, order detail lines, status) are recorded and displayed in the History tab of the order’s properties.
  • Broker statements that come as multiple data files can now be automatically combined into a single file for processing by reconciliation, reducing the reconciliation effort required for these types of statements.
  • The Historic Margin to Equity chart now supports trading size as well as total equity as divisor.
  • Contacts now have a reporting currency allowing automatic restatement of results to the currency of the reciever of a report.
  • Several new reports, including an Instrument Snapshot report that returns Today, MTD, YTD income and returns for markets/sectors and variants of the 13 column performance reports that have advisor fees taking out of the calculations.
  • Support for NDF currencies.

This version is being rolled out to the customer base and is what is installed for new customers.

For more information or to see a demo, contact us via email at or call 847-234-4969.


Permalink 10:57:00 am, by Linda, 586 words   English (US)
Categories: Reporting

Creating Custom Reports in TheBooks

Have you ever run a report in TheBooks, and think to yourself, “This report would be perfect if I could just add this one additional column.” We’ve been listening! The latest version of TheBooks now lets you use TheBooks data with Microsoft SQL Server Report Builder to create and customize reports. You can integrate these reports into TheBooks Performance Reports interface. You can make the reports private, usable only by the person adding the report, or public, shared across your organization. You can add your custom logo and your company information, and format the report so that it is indistinguishable from any other reports generated by TheBooks. As with TheBooks standard reports, you can send these custom reports out in any format supported by TheBooks, and to any contacts you have defined within TheBooks.

Creating the Report

To create your custom report, you must first install the Microsoft SQL Report Builder application on your computer. To begin creating a report, open Report Builder and select the Table or Matrix icon.

Report Builder Table or Matrix Icon

You will select TheBooks as your data source, and then begin to design your query. You will select the entity you want to include in your report, and then the fields you want to include from within that entity.

Report Builder Design a Query

Adding fields to your report is as simple as dragging them into the Drag and drop column fields section of the screen. You can also define computed fields to return information that is not available in an entity field. For example, to add net profit to our report, we would drag Change in OTE, Realized Gains, Charged Trading Commissions, and APS Adjustments into the formula bar, and then apply the appropriate operators.

Report Builder Define Formula

You can arrange the fields into rows and columns, and decide if you want to perform any functions, such as total or average a particular field. The Report Builder allows you to add parameters so that you can select a specific set of data to be returned in your report. In addition, you can add filters at the data source, so that only the data that matches our parameters is returned. This allows the report to run more efficiently.

Integrating Your Report into TheBooks

Once you are satisfied with your results in Report Builder, you can then integrate your new report into TheBooks Reports interface. Go to Reports and select the Manage Custom Reports option. You will add the report to TheBooks from this screen, enter the Report Name, a Description of the report, and determine the Visibility, that is, whether it is a public or private report.

TheBooks Manage Custom Reports

Your report now appears on the Performance Reports screen, under the Custom Reports tab. You can now select your Options, which have been determined by the parameters you created in Report Builder, and generate this report from within TheBooks.

TheBooks Custom Reports Tab

The Finished Report

This is a sample of an Instrument Returns by Month report that was created in Report Builder, and integrated into TheBooks. Parameters were defined to specify an account, an account group, and a specific time period. Net profit was calculated for each market grouped by month and totaled by sector. The company logo and company information were added to the header and footer of the report.

TheBooks Sample Custom Report


I have shown how easy it is to produce custom reports from within Report Builder using the data produced by TheBooks. Creating the reports and integrating them with TheBooks Reports does not require any programming experience as all the necessary capabilities are provided by Report Builder and TheBooks.

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

May 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 31
The official blog for users and others interested in TheBooks®


XML Feeds

powered by b2evolution free blog software