- Home
- Skills
- Trading & Investing
- Trade P&L Attribution & Performance Decomposer
Works with the AI Agents you already use
Trade P&L Attribution & Performance Decomposer
Decompose trading P&L by strategy, instrument, and cost to identify recurring performance drivers and profit drags.
$29.99
Trade P&L Attribution & Performance Decomposer
Example session with this skill installed
Analyze my attached CSV ledger for Q3. Identify the main cost drivers, reconcile the net P&L against my $4,500 target, and show which strategies are actually profitable after fees.
- Read your context and instructions
- Compiled the trade p&l attribution
I have analyzed 412 transactions from your Q3 ledger. Data normalization is complete, with all timestamps adjusted to UTC. Reconciled net P&L is $4,312.40, showing a -$187.60 variance from your statement target, likely due to unmapped borrow fees on short positions.
Performance Attribution Summary
| Dimension | Gross P&L | Total Costs | Net P&L | Win Rate | Expectancy |
|---|---|---|---|---|---|
| Strategy: Mean Reversion | $6,200.00 | $1,850.50 | $4,349.50 | 62% | $145.20 |
| Strategy: Breakout | $2,100.00 | $2,400.00 | ($300.00) | 38% | ($22.10) |
| Instrument: NVDA | $4,800.00 | $920.00 | $3,880.00 | 55% | $210.00 |
| Instrument: SPY | $1,200.00 | $1,150.00 | $50.00 | 48% | $2.50 |
Cost Analysis
The primary profit drag is the
Breakout Strategy, where transaction costs (commissions + slippage) represent 114% of gross profits. Explicit brokerage fees total $2,140.00, while estimated slippage against arrival price accounts for $1,210.90. Long positions in high-volatility regimes show a 3x higher cost-per-fill than limit orders during mid-session.
Recurring Drivers
Concentration Risk (High Severity): 72% of net P&L is derived from 4 trades in NVDA. Excluding these, the portfolio is net negative for the quarter.
2.
Session Decay (Medium Severity): Trades entered during the first 30 minutes of the NY session show a negative expectancy of -$45.00 due to wide spreads.
Next steps
- Review the
Findings Registerfor a breakdown of unmapped borrow fees. - Audit the execution logic for the Breakout strategy to reduce market impact.
- Filter future reports by "Exclude Top 5 Trades" to assess baseline strategy health.
Connects securely to your tools. The creator never sees your data.
About this skill
Trading performance often feels like a black box where gross gains are eroded by invisible fees, slippage, and poor strategy attribution. This skill acts as a senior trading performance analyst to decompose your transaction data and identify exactly where your P&L originates.
What it does
- P&L decomposition breaks down gross and net results by instrument, strategy, direction, and holding period.
- Cost attribution isolates brokerage fees, exchange charges, taxes, funding costs, and measurable slippage.
- Data reconciliation validates source records against account totals to ensure reporting accuracy.
- Driver identification flags recurring profit sources and loss clusters using evidence-based patterns.
- Robustness testing calculates how much your performance depends on top outliers or specific market regimes.
How it works
- Data normalization where you provide trade ledgers or broker statements for cleaning and timezone alignment.
- P&L definition to establish consistent realized, unrealized, and net-of-cost conventions.
- Multi-dimensional analysis to group performance by instrument, strategy tags, and time buckets.
- Findings generation producing a prioritized register of cost drags, concentration risks, and execution gaps.
Frameworks & tools
This skill processes CSV, Excel, or JSON trade exports. It handles multi-currency transactions, partial fills, and complex multi-leg instrument data.
Why this beats prompting it yourself
Generic prompts often double-count fees or fail to reconcile trade-level data with account totals, leading to false conclusions. This skill enforces rigorous accounting principles, ensures denominators are valid for normalized metrics, and distinguishes between repeatable skill and one-off outliers.
Use cases
- Execution audit to see if high turnover or commissions are consuming your gross edge.
- Strategy comparison to attribute P&L across multiple setups or sub-accounts accurately.
- Risk concentration to determine if 90% of profits rely on a single instrument or session.
- Post-trade journaling to reconcile daily fills into structured performance reports.
Known limitations
Requires specific fields like timestamps and prices for holding-period analysis. Cannot infer strategy labels if not provided in the source data. Does not place trades or predict future returns.
Requires price and timestamp data for link analysis. Cannot infer missing strategy tags. Does not calculate slippage without benchmark prices. Results are historical, not predictive.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 17 days ago
Permissions
No special permissions declared or detected