Overview of Day
Definition: Day represents the specific day extracted from a Datetime field, providing daily granularity for analysis. Formatted as a two-digit number (01-31).
Importance: Analyzing trades at the daily level helps traders recognize patterns, measure daily performance, and identify market trends. Understanding day-based metrics can improve trade execution timing and enhance risk management strategies.
Tips: Use daily trade data to compare performance trends across different days. Identify high-activity days for better strategy adjustments. Ensure consistent formatting to align with reporting standards. Correlate day-based data with broader market conditions to enhance decision-making.
Transaction-Level Scope of Day
Definition: Transaction-Level Day extracts the day of the transaction, aiding in day-based tracking and reporting.
Formula: The day is derived from the full Datetime value, isolating only the day component.
Example: A transaction recorded on 2025-02-10 at any time will have a Day value of 10.
Application: Helps traders analyze transaction patterns on specific days, identifying high or low trading activity dates.
Trade-Level Scope of Day
Definition: Trade-Level Day aggregates transaction-level days, offering a view of key dates within the trade.
Formula: The trade date is determined based on all associated transaction timestamps.
Example: A trade consisting of transactions executed on different days might use the first or last transaction’s day as its trade day.
Application: Useful for tracking trade durations and analyzing the impact of trade timing on performance.
Portfolio-Level Scope of Day
Definition: Portfolio-Level Day consolidates trade-level days, providing portfolio-wide insights into daily activity.
Formula: The portfolio-wide day analysis considers aggregated trade days across all trades in the portfolio.
Example: If a portfolio's most frequent trading activity occurs on the 15th of each month, this can be used to identify key trading periods.
Application: Helps traders monitor portfolio-wide performance trends on a daily basis, optimizing execution strategies based on historical day-based activity.
