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