Tables in the Segregated Database

Background

Canopy Analytics creates a separate database for each client. Users can connect to this database in multiple ways. This database has many tables, of which the following tables are the most important

• Single Line Transactions: Contains fully populated details on each transaction in your account
• Consolidated Holdings: Snapshot of the closing positions in your account as of the end of each day.
• Strategy Definitions: Defines the various calculations that have been configured in your account
• Strategy Records: Results of any calculations (as defined in Strategy Definitions above) are stored here