Tables in the Segregated Database
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
Updated almost 2 years ago