Back to Category Page
Tables in the Segregated Database
5 articles under this sub-category. Click here to check them out.
October 30, 2021
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