Mosaic Research Report

Trade Performance Analysis

Closed-trade realized performance analysis of the uploaded trade log. Starting capital is fixed at $30,000; open trades are excluded from all main performance statistics.

Ending Equity
$38,814
Net P&L
$8,814
Total Return
29.38%
Closed Trades
149
Max Realized DD
-4.25%
Profit Factor
2.63
Sharpe
5.64
Sortino
5.26
Analysis period: 2025-09-23 to 2026-05-22Generated: 2026-05-23

Risk-Manager Dashboard

Closed-trade realized view only. The figures below use the $30,000 starting-capital denominator and exit-date aggregated P&L where appropriate.

Net Realized P&L$8,814Ending equity $38,814
Total Return29.38%against starting capital
Max Realized Drawdown-$1,274-4.25% of starting capital
Profit Factor2.63gross profit / gross loss
Win Rate81.21%121 wins / 27 losses
Average / Median Trade$59 / $50trade-level expectancy
Worst Trade-$1,33024.64% of gross losses
Worst 5-Trade Run-$1,439sequential closed-trade P&L
Worst 5 Losses65.87%of total gross losses
Sharpe / Sortino5.64 / 5.2673 exit-date observations
Time in Drawdown34.25%closed-trade observations
Reliability FlagRealized onlyno daily MTM or margin path
Read-through: the record is profitable and relatively broad-based, but loss concentration remains material. The largest five losses represent 65.87% of gross losses.
Risk limitation: Sharpe, Sortino, and drawdown are based on realized exits. They should not be read as full strategy volatility, margin stress, or intratrade drawdown statistics.

Executive Summary

The realized closed-trade record produced $8,814 of net P&L, lifting realized equity from $30,000 to $38,814, a 29.38% return against starting capital. The closed-trade win rate was 81.21%, profit factor was 2.63, and average trade P&L was $59 versus a median of $50.

The best trade was $1,125 and the worst trade was $-1,330. Maximum realized closed-trade drawdown was $-1,274, or -4.25% of the $30,000 starting capital. Time in drawdown was 43.62% by closed-trade observations and 33.47% by calendar days between the first and last closed trade.

Sharpe and Sortino, calculated from exit-date aggregated realized returns against starting capital and annualized with a 252-trading-day convention, were 5.64 and 5.26. These are not daily mark-to-market risk statistics. They summarize the realized closing stream only.

Interpretation: the result appears broad-based rather than purely dependent on a single outlier. The realized stream suggests stable positive realized expectancy with intermittent clusters of losses. The log is dominated by short strangles/straddles and VRP-labeled trades, so the realized record is consistent with short-volatility premium harvesting: frequent smaller winners, occasional larger losers, and a need for separate stress, margin, and peak adverse excursion analysis.

Data Cleaning and Column Mapping

The parser identified the trade-log header row and mapped columns directly from the workbook. Rows were retained only when Status was exactly closed after trimming and lower-casing. Closed rows with missing exit date or missing numeric P&L were excluded from realized analysis.

ItemDetected / Result
Header row detectedExcel row 2 / zero-based row 1
Entry date columnEntry
Exit date columnExit
P&L columnPnL
Status columnStatus
Ticker columnTicker
Strategy type columnStrategy type
Position/structure columnPostion
Rows excluded: non-closed or blank status9.00
Closed rows excluded: missing exit2.00
Closed rows excluded: missing P&L0.00
Closed rows excluded: future exit date after 2026-05-232.00
Malformed VRP values coerced to missing3.00
Estimated margin availability0 closed rows with usable values

Suspicious values: two closed rows had future exit dates after 2026-05-23 and were excluded; VRP probability contains non-numeric markers such as “x”; those were treated as missing for VRP diagnostics. Estimated margin is blank for the closed-trade set, so return on margin or return on capital at risk was not calculated.

Performance Statistics

Starting capital$30,000
Ending realized equity$38,814
Net P&L$8,814
Total return29.38%
Number of closed trades149
Winning trades121
Losing trades27
Flat trades1
Win rate81.21%
Loss rate18.12%
Average trade P&L$59
Median trade P&L$50
Std. dev. trade P&L$222
Average winner$117
Average loser$-200
Median winner$70
Median loser$-105
Largest winner$1,125
Largest loser$-1,330
Payoff ratio0.59
Profit factor2.63
Expectancy per trade$59
Best 5-trade run$2,398
Worst 5-trade run$-1,439
Top 5 winners / gross profit$0
Worst 5 losers / gross loss$1
Skewness-2.12
Excess kurtosis19.84
Sharpe ratio5.64
Sortino ratio5.26
Max realized drawdown $$-1,274
Max realized drawdown % of start-4.25%
Time in drawdown, trade obs.43.62%
Time in drawdown, calendar days33.47%
Longest drawdown duration26.00
Average drawdown duration10.00
Recovery factor6.92

Realized Equity Curve

2026-05-23T17:54:18.860199 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/

The equity curve is constructed as $30,000 plus cumulative closed-trade P&L by exit date. The curve does not include open-trade marks, intraday variation, or unrealized losses while trades were still open.

Cumulative P&L Curve

2026-05-23T17:54:18.960908 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/

Cumulative P&L is the same closed-trade stream before adding starting capital. Multiple trades closing on the same date are aggregated for date-level risk statistics.

Drawdown Analysis

2026-05-23T17:54:19.037116 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/
Maximum realized drawdown-1,274.00
Max realized drawdown % of start-4.25%
Drawdown start date2026-03-06
Drawdown trough date2026-03-10
Drawdown recovery date2026-04-01
Current drawdown statusIn drawdown
Number of drawdown episodes8
Average drawdown depth-0.01
Median drawdown depth-0.00

Definition. Trade-observation time in drawdown is the percentage of closed-trade equity observations below a prior realized equity high. Calendar-day time in drawdown forward-fills the realized equity curve across calendar days between the first and last closed trade.

This is a closed-trade realized drawdown view. For short-volatility positions, it may materially understate peak adverse excursion, intraday drawdown, margin stress, gap risk, and liquidation risk.

Return and P&L Distribution

2026-05-23T17:54:19.128768 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/
2026-05-23T17:54:19.203283 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/

Best 10 Trades

indexexit dateentry datetickerpositionstrategypnlholding days
129.002026-04-132026-03-09USOstrangleVRP 30 dte1,125.0035.00
8.002025-10-062025-09-22NUGTput spreadVRP485.0014.00
127.002026-04-132026-02-25NVDAstrangleearnings485.0047.00
121.002026-03-232026-03-12QQQstrangleVRP 30 dte465.0011.00
126.002026-04-022026-02-27VXXstraddleVRP 30 dte420.0034.00
11.002025-10-062025-09-29NUGTput spreadVRP 9dte355.007.00
116.002026-03-132026-02-02VXXstrangleVRP 30 dte350.0039.00
131.002026-04-132026-03-17VXXstrangleVRP 30 dte346.0027.00
139.002026-05-012026-04-28SMHstrangleVRP 9 dte310.003.00
123.002026-04-012026-03-19MESstrangleVRP 30 dte305.0013.00

Worst 10 Trades

indexexit dateentry datetickerpositionstrategypnlholding days
7.002025-10-062025-09-09NUGTstrangleVRP-1,330.0027.00
109.002026-03-062026-02-20USOstrangleVRP 30 dte-1,211.0014.00
135.002026-04-292026-04-22USOstrangleVRP 9 dte-356.007.00
134.002026-04-292026-03-23USOstrangleVRP 30 dte-346.0037.00
12.002025-10-072025-09-25XLVstrangleVRP 30dte-312.0012.00
49.002025-11-202025-11-10IBITstrangleVRP 30 dte-235.0010.00
130.002026-04-132026-03-16VXXstocksUnclassified-215.0028.00
112.002026-03-102026-02-12KREstrangleVRP 30 dte-145.0026.00
18.002025-10-162025-10-02GDXstrangleVRP 30 dte-140.0014.00
10.002025-10-062025-09-26ARKGstrangleVRP 9dte-130.0010.00

Outlier Analysis

The average closed-trade P&L was $59, versus a median of $50. The mean is above the median, indicating positive skew from several larger winners, despite the presence of a material left tail. The top five winners contributed 20.97% of gross profits; the worst five losers contributed 65.87% of gross losses. This is meaningful concentration, but not a one-trade result. The worst single trade represented 24.64% of total gross losses; the worst three trades represented 53.68%.

Rolling / Sequential Risk Analysis

2026-05-23T17:54:19.413553 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/
2026-05-23T17:54:19.505729 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/

The rolling series indicates whether expectancy is broadly persistent or concentrated into specific sequences. Because this is trade-indexed rather than time-indexed, clusters should be interpreted as realized trade sequences, not necessarily full market-regime intervals.

Strategy Breakdown

strategyTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
VRP 30 dte1188,501.0072.0453.0085.59%1,125.00-1,211.0013.2896.45%4.18$-1,236
earnings1485.00485.00485.00100.00%485.00485.0047.005.50%N/A$0
VRP 9dte3368.00122.67143.0066.67%355.00-130.009.334.18%3.83$0
VRP 9 dte13356.0027.3840.0076.92%310.00-356.005.234.04%1.75$-372
VRp 30 dte1-38.00-38.00-38.000.00%-38.00-38.0026.00-0.43%0.00$-38
VP 30 dte1-70.00-70.00-70.000.00%-70.00-70.0014.00-0.79%0.00$-70
Unclassified3-145.00-48.33-115.0033.33%185.00-215.0021.00-1.65%0.56$-145
VRP 30dte3-178.00-59.3331.0066.67%103.00-312.0010.33-2.02%0.43$-312
VRP6-465.00-77.5082.5066.67%485.00-1,330.0015.67-5.28%0.66$-885

Strategy labels are usable but not perfectly normalized; for example, variants such as “VRP 30 dte”, “VRP 30dte”, “VRP 9 dte”, and “VP 30 dte” are treated as separate labels in the raw grouping. Normalizing these into a strategy taxonomy would improve comparability.

Ticker / Underlying Breakdown

2026-05-23T17:54:19.276305 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/
tickerTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
VXX192,353.00123.84126.0084.21%420.00-215.0019.1626.70%7.65$-24
MES91,060.00117.78125.0088.89%305.00-130.008.6712.03%9.15$-130
SPY51,042.00208.40227.00100.00%245.00144.005.4011.82%N/A$0
QQQ2735.00367.50367.50100.00%465.00270.006.508.34%N/A$0
NVDA2665.00332.50332.50100.00%485.00180.0024.007.54%N/A$0
XLI7459.0065.5759.00100.00%90.0051.009.005.21%N/A$0
IWM3420.00140.00137.00100.00%180.00103.007.334.77%N/A$0
DIA4399.0099.75132.5075.00%174.00-40.0010.004.53%10.97$-40
SMH2390.00195.00195.00100.00%310.0080.002.004.42%N/A$0
EWY2345.00172.50172.50100.00%185.00160.0013.003.91%N/A$0
GLD2335.00167.50167.50100.00%220.00115.005.503.80%N/A$0
BOIL4261.0065.2555.50100.00%125.0025.009.252.96%N/A$0
DPST1255.00255.00255.00100.00%255.00255.0013.002.89%N/A$0
XBI2142.0071.0071.00100.00%85.0057.0026.001.61%N/A$0
SLV3138.0046.0025.0066.67%224.00-111.008.671.57%2.24$-111
ITB1133.00133.00133.00100.00%133.00133.0021.001.51%N/A$0
YINN1130.00130.00130.00100.00%130.00130.0013.001.47%N/A$0
SOXL1105.00105.00105.00100.00%105.00105.0014.001.19%N/A$0
ASTS190.0090.0090.00100.00%90.0090.004.001.02%N/A$0
KRE769.009.8636.0071.43%92.00-145.0019.570.78%1.38$-183
LABD167.0067.0067.00100.00%67.0067.0011.000.76%N/A$0
UCO165.0065.0065.00100.00%65.0065.0035.000.74%N/A$0
EFA356.0018.6721.00100.00%31.004.0011.000.64%N/A$0
DLTR150.0050.0050.00100.00%50.0050.0013.000.57%N/A$0
IBIT948.005.3336.0077.78%75.00-235.008.890.54%1.18$-235
XLF542.008.4015.0060.00%45.00-35.0020.000.48%1.93$0
NEE140.0040.0040.00100.00%40.0040.002.000.45%N/A$0
JETS138.0038.0038.00100.00%38.0038.007.000.43%N/A$0
UVXY135.0035.0035.00100.00%35.0035.0010.000.40%N/A$0
MRNA135.0035.0035.00100.00%35.0035.0013.000.40%N/A$0

Position / Structure Breakdown

positionTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
strangle1357,410.0054.8950.0082.96%1,125.00-1,330.0012.8984.07%2.51$-1,678
put spread2840.00420.00420.00100.00%485.00355.0010.509.53%N/A$0
straddle9709.0078.7867.0066.67%420.00-78.0012.678.04%5.76$-78
stocks3-145.00-48.33-115.0033.33%185.00-215.0021.00-1.65%0.56$-145

Position structure uses the workbook’s position labels. The column is labeled “Postion” in the workbook; no aggressive inference was applied beyond lower-casing and trimming labels.

Holding Period Analysis

Average holding period13.01
Median holding period11.00
Shortest holding period1.00
Longest holding period47.00
holding bucketTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
6–10 days432,379.0055.3340.0086.05%355.00-356.007.5626.99%3.65$-356
11–20 days592,338.0039.6345.0076.27%485.00-1,211.0013.4626.53%1.99$-1,211
2–5 days192,099.00110.4790.00100.00%310.0030.003.6323.81%N/A$0
21+ days241,694.0070.5861.0066.67%1,125.00-1,330.0031.0819.22%1.79$-1,330
0–1 days4304.0076.0052.50100.00%180.0019.001.003.45%N/A$0

Expiration / DTE Analysis

entry dte bucketTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
31–45 DTE995,290.0053.4351.0080.81%1,125.00-1,330.0013.6460.02%2.22$-1,651
15–30 DTE272,342.0086.7451.0085.19%485.00-356.009.3326.57%4.71$-356
46+ DTE6709.00118.1751.00100.00%485.0022.0026.838.04%N/A$0
8–14 DTE9527.0058.5644.0088.89%126.00-16.006.005.98%33.94$-16
0–7 DTE591.0018.2040.0060.00%75.00-55.0011.601.03%2.01$-15
Unknown3-145.00-48.33-115.0033.33%185.00-215.0021.00-1.65%0.56$-145

Expiration dates were parsed from YYYYMMDD-style values when available. Stock rows and rows with “-” expiration were excluded from DTE calculations. Entry DTE is based on expiration date minus entry date.

Volatility / VRP / Vega Diagnostics

VRP Probability Buckets

vrp bucketTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
nan142,942.00210.14130.0085.71%1,125.00-215.0017.9333.38%9.92$0
(52.999, 66.0]352,643.0075.5170.0082.86%420.00-356.0014.2029.99%3.97$-356
(66.0, 69.0]352,300.0065.7150.0077.14%350.00-145.0011.6326.09%5.72$-183
(69.0, 72.0]36841.0023.3634.0080.56%465.00-1,211.0012.149.54%1.46$-1,221
(72.0, 85.0]2988.003.0338.0082.76%305.00-1,330.0011.931.00%1.05$-1,330

Vega Exposure Buckets

vega bucketTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
(25.9, 129.0]354,563.00130.37120.0091.43%485.00-312.008.8951.77%10.47$-312
(0.999, 6.6]372,501.0067.5935.0081.08%420.00-130.0013.4628.38%6.83$-81
(6.6, 12.0]362,263.0062.8640.0083.33%485.00-235.0011.7525.68%7.13$-235
nan81,547.00193.38111.5075.00%1,125.00-215.0021.0017.55%5.69$0
(12.0, 25.9]33-2,060.00-62.4226.0069.70%255.00-1,330.0016.30-23.37%0.46$-2,315

VRP probability and vega exposure are available for many but not all closed trades. Non-numeric VRP markers were treated as missing. These diagnostics should be treated as conditional realized summaries, not causal evidence.

Trade Sizing and Risk Concentration

size bucketTradesNet PnLAvg PnLMedian PnLWin RateBestWorstAvg Holding DaysContributionProfit FactorMax Group DD $
(4.999, 100.0]1488,769.0059.2550.5081.08%1,125.00-1,330.0012.9399.49%2.62$-1,274
(100.0, 300.0]145.0045.0045.00100.00%45.0045.0024.000.51%N/A$0

Size is proxied as size × contract value because explicit risk capital and margin fields are unavailable. This is a rough exposure proxy, not capital at risk. It should not be used as a substitute for margin, buying power usage, or stress loss.

Loss Clustering and Tail Risk

The longest consecutive loss streak was 5 trades. The worst cumulative 3-trade loss was $-1,256; the worst 5-trade loss was $-1,439; the worst 10-trade loss was $-918. These are realized closed-trade figures, not peak adverse excursion.

Given the prevalence of short straddles/strangles, the realized loss profile is consistent with a short-volatility program: losses are less frequent than wins, but individual losing trades can be large relative to the median winner. The log is insufficient to estimate theoretical tail exposure or liquidation risk.

Calendar Analysis

The monthly view is based on exit dates and closed-trade realized P&L. It is useful for identifying calendar clustering, but monthly conclusions are preliminary because the sample spans less than one year and the P&L stream is lumpy.

Monthly Heatmap / Calendar Grid

MonthNet P&LTradesWin RateAvg P&LWorst TradeBest TradeMonthly Return
2025-09$6106100.00%$102$35$2552.03%
2025-10$7083683.33%$20-$1,330$4852.36%
2025-11$1,4972095.00%$75-$235$2704.99%
2025-12$4141872.22%$23-$111$1151.38%
2026-01$6925100.00%$138$19$2242.31%
2026-02$1,7852185.71%$85-$49$2275.95%
2026-03$991758.82%$6-$1,211$4650.33%
2026-04$2,2501369.23%$173-$356$1,1257.50%
2026-05$7591384.62%$58-$130$3102.53%

Gold cells indicate positive realized monthly P&L and red cells indicate negative realized monthly P&L. Cell intensity is scaled by absolute monthly P&L within this sample.

2026-05-24T16:46:26.572091 image/svg+xml Matplotlib v3.10.8, https://matplotlib.org/
monthTradesNet PnLWin RateAvg PnLMonthly Return
2025-096610.00100.00%101.672.03%
2025-1036708.0083.33%19.672.36%
2025-11201,497.0095.00%74.854.99%
2025-1218414.0072.22%23.001.38%
2026-015692.00100.00%138.402.31%
2026-02211,785.0085.71%85.005.95%
2026-031799.0058.82%5.820.33%
2026-04132,250.0069.23%173.087.50%
2026-0513759.0084.62%58.382.53%

The corrected month parsing allocates numeric YYYYMMDD-style exit dates to their proper 2026 months. March remains the weakest month, while April is the strongest realized month in the sample.

Risk Manager Notes

The realized record shows positive expectancy, strong net P&L, and a high win rate on closed trades. On a $30,000 starting capital base, the realized return is substantial, and the recovery factor is strong because the largest realized closed-trade drawdown is modest relative to ending profit.

The main qualification is scope. This is a closed-trade realization report, not a full pathwise risk report. It measures what happened at exits; it does not measure interim mark-to-market equity, peak adverse excursion, margin expansion, gap exposure, assignment risk, or liquidation pressure during open trades.

Within that limitation, the trade log is analytically useful. It suggests that the program had a favorable realized expectancy over the sample, with most months positive and losses concentrated in a relatively small number of trades rather than evenly distributed. That pattern is consistent with many premium-selling programs and should be monitored, not automatically treated as disqualifying.

Future reviews would be materially stronger with daily MTM equity, margin usage, Greeks, implied volatility at entry and exit, underlying price movement, and adjustment notes. Those fields would allow the realized record to be connected to actual exposure, stress, and sizing decisions.

Appendix: Assumptions, Definitions, and Exclusions

Assumptions

Metric Definitions

Data Exclusions and Warnings