Data Formats

Warning

Updates are ready for review; srvo approval is still pending for template changes. Log the approval in the compliance change log before using these templates as final.

1 Data Formats Directory

This directory contains all data format specifications and templates for Ethical Capital Investment Collaborative’s portfolio management and investment decision systems.

2 Structure

2.1 Specifications

portfolio_data_format_specification.md - Comprehensive guide for all portfolio data formats
exclusion_data_format_specification.md - Format for exclusion screening data
firm_data_format_specification.md - Firm-level compliance and operational data formats

2.2 Templates

2.2.1 Core Investment Data

universe_data_template.csv - Master security screening database
exclusion_data_template.csv - Exclusion tracking template

2.2.2 Portfolio Management

growth_portfolio_template.csv - Portfolio composition and rebalancing
growth_stats_template.csv - Portfolio statistics summary
portfolio_weights_history_template.csv - Historical position weightings (rebalance dates)
performance_history_template.csv - Monthly performance metrics (month-end)

2.2.3 Investment Research

research_notes_template.csv - Research notes and questions tracking
tick_history_template.csv - TICK score change audit trail
workbench_activity_template.csv - Workbench session activity log

2.2.4 Reporting

performance_deck_template.csv - Comprehensive performance analytics
website_performance_template.csv - Strategy-level performance for website

2.2.5 Firm Compliance & Operations

client_master_template.csv - Client profile and relationship data
client_documentation_checklist_template.csv - Documentation compliance tracking
compliance_activity_log_template.csv - Compliance monitoring and supervision
regulatory_communications_template.csv - SEC and regulatory correspondence

2.3 Working Data Examples

Port 5.0 - Universe (2).csv - Example universe data
Port 5.0 - Growth.csv - Example portfolio composition
Port 5.0 - Growth Stats.csv - Example portfolio statistics
Port 5.0 - Growth Vertical History.csv - Example allocation history
Port 4.9 - Growth.csv - Previous version example
Deck - Sheet1.csv - Example performance deck

3 Key Concepts

3.1 TICK Score System

Range: -100 to 100
Minimum for portfolio inclusion: 10
Tracked historically with full audit trail

3.2 Timing Distinctions

Portfolio Weights: Set at rebalance (new moon)
Performance: Measured at month-end
These are separate timelines and tracked in separate files

3.3 Data Linkages

All data linked via Ticker as primary key
Research notes linked via Note_IDs
Workbench sessions linked via Session_IDs
Complete audit trail from analysis → decision → portfolio impact

4 Usage

Use templates as starting points for new data files
Follow specifications for field definitions and validation rules
Maintain linkages between related data files
Update monthly according to rebalance schedule

5 Integration

These formats are designed for: - Clean integration with Colab notebooks - Compatibility with Garden platform workbench - Compliance and audit requirements - Performance attribution analysis