P/L Attribution

P/L Attribution

Where the return over the selected range came from: first split into long, short, positioning and timing, then down to each position, showing what it made, how much of the portfolio it took, and how it did against the same money in SPY.

  • Portfolio
  • SPY

Drag across the chart to focus on a period; click to pin a month

Cumulative Return
505.72%SPY: 230.07%
Annualized Return
21.76%SPY: 13.94%
Months Ahead of SPY
60.36%67 of 111 months
Date
2017-09-25 to 2026-11-19
0%200%400%201820192020202120222023202420252026Sold all index ETFs; 100% hand-picked stocks since-10%0%10%

Summary

Long total

P/L

$730,133

Contribution
354.54
Excess vs SPY
110.14
Avg. weight
99.10%
Short total

P/L

$365,091

Contribution
147.96
Excess vs SPY
148.04
Avg. weight
-2.90%
Other

P/L

$10,443

Contribution
3.22
Excess vs SPY
3.22
Positioning and timing
Excess vs SPY
-23.97
Compounding
Excess vs SPY
38.23
Total

P/L

$1,105,666

Contribution
505.72
Excess vs SPY
275.65
Avg. weight
96.20%

Positions

LongGOOGL

P/L

$317,811

Contribution
132.33
Excess vs SPY
71.55
Return vs SPY (held)
157.82
Avg. weight
10.35%
LongVOO

P/L

$109,283

Contribution
49.74
Excess vs SPY
0.30
Return vs SPY (held)
2.25
Avg. weight
19.31%
ShortTMC

P/L

$88,586

Contribution
35.85
Excess vs SPY
36.06
Return vs SPY (held)
91.51
Avg. weight
-0.40%
LongVTI

P/L

$79,478

Contribution
17.52
Excess vs SPY
-1.49
Return vs SPY (held)
-1.90
Avg. weight
16.18%
LongTSM

P/L

$75,051

Contribution
30.46
Excess vs SPY
19.45
Return vs SPY (held)
-12.91
Avg. weight
2.51%
ShortQBTS

P/L

$74,303

Contribution
30.11
Excess vs SPY
31.33
Return vs SPY (held)
87.70
Avg. weight
-0.44%
ShortSPCX

P/L

$67,303

Contribution
27.40
Excess vs SPY
22.07
Return vs SPY (held)
21.09
Avg. weight
-0.61%
ShortASST

P/L

$61,863

Contribution
24.92
Excess vs SPY
20.61
Return vs SPY (held)
-16.29
Avg. weight
-0.10%
LongNVDA

P/L

$46,931

Contribution
23.84
Excess vs SPY
10.21
Return vs SPY (held)
909.84
Avg. weight
3.71%
LongAMD

P/L

$45,692

Contribution
18.77
Excess vs SPY
12.22
Return vs SPY (held)
32.03
Avg. weight
1.60%
LongHIMS

P/L

$24,473

Contribution
10.97
Excess vs SPY
10.26
Return vs SPY (held)
60.19
Avg. weight
0.37%
ShortPLUG

P/L

$23,442

Contribution
9.65
Excess vs SPY
11.89
Return vs SPY (held)
48.20
Avg. weight
-0.28%
LongVGT

P/L

$22,633

Contribution
18.38
Excess vs SPY
6.59
Return vs SPY (held)
183.90
Avg. weight
6.07%
LongAAPL

P/L

$21,840

Contribution
22.67
Excess vs SPY
12.46
Return vs SPY (held)
415.32
Avg. weight
7.30%
LongJPM

P/L

$19,669

Contribution
13.61
Excess vs SPY
5.63
Return vs SPY (held)
81.96
Avg. weight
3.46%
ShortFRMI

P/L

$15,140

Contribution
6.18
Excess vs SPY
6.44
Return vs SPY (held)
59.16
Avg. weight
-0.08%
LongBAC

P/L

$14,864

Contribution
8.19
Excess vs SPY
2.85
Return vs SPY (held)
23.99
Avg. weight
0.89%
ShortPCT

P/L

$12,955

Contribution
5.26
Excess vs SPY
5.94
Return vs SPY (held)
77.98
Avg. weight
-0.10%
LongTSLA

P/L

$12,508

Contribution
6.14
Excess vs SPY
5.42
Return vs SPY (held)
109.04
Avg. weight
0.11%
LongSATA

P/L

$12,371

Contribution
5.04
Excess vs SPY
1.59
Return vs SPY (held)
0.16
Avg. weight
0.26%
ShortTSLA

P/L

$11,212

Contribution
4.34
Excess vs SPY
6.85
Return vs SPY (held)
-18.18
Avg. weight
-0.66%
LongMSFT

P/L

$10,859

Contribution
11.60
Excess vs SPY
4.64
Return vs SPY (held)
326.31
Avg. weight
3.08%
LongSTRC

P/L

$7,736

Contribution
3.14
Excess vs SPY
2.45
Return vs SPY (held)
10.56
Avg. weight
0.04%
ShortQUBT

P/L

$6,460

Contribution
2.67
Excess vs SPY
3.15
Return vs SPY (held)
48.21
Avg. weight
-0.07%
LongAMZN

P/L

$6,289

Contribution
9.53
Excess vs SPY
4.79
Return vs SPY (held)
197.94
Avg. weight
2.77%
LongVXUS

P/L

$4,265

Contribution
1.48
Excess vs SPY
-2.99
Return vs SPY (held)
-33.56
Avg. weight
2.28%
LongITOT

P/L

$2,460

Contribution
6.85
Excess vs SPY
-0.60
Return vs SPY (held)
-2.35
Avg. weight
4.09%
ShortEVTL

P/L

$2,283

Contribution
0.93
Excess vs SPY
0.93
Return vs SPY (held)
79.14
Avg. weight
0.00%
LongHCI

P/L

$2,033

Contribution
1.00
Excess vs SPY
0.41
Return vs SPY (held)
8.48
Avg. weight
0.12%
ShortWMT

P/L

$1,765

Contribution
0.73
Excess vs SPY
1.91
Return vs SPY (held)
11.61
Avg. weight
-0.09%
LongLNTH

P/L

$1,689

Contribution
0.86
Excess vs SPY
0.15
Return vs SPY (held)
5.30
Avg. weight
0.13%
LongIBKR

P/L

$1,390

Contribution
0.85
Excess vs SPY
0.72
Return vs SPY (held)
14.98
Avg. weight
0.03%
LongIUSG

P/L

$1,187

Contribution
2.41
Excess vs SPY
0.40
Return vs SPY (held)
6.34
Avg. weight
0.92%
LongNTES

P/L

$845

Contribution
0.42
Excess vs SPY
0.10
Return vs SPY (held)
2.44
Avg. weight
0.03%
LongKSPI

P/L

$789

Contribution
-0.05
Excess vs SPY
-12.99
Return vs SPY (held)
-34.96
Avg. weight
3.06%
LongPACB

P/L

$604

Contribution
0.63
Excess vs SPY
0.29
Return vs SPY (held)
43.58
Avg. weight
0.28%
LongGM

P/L

$556

Contribution
1.85
Excess vs SPY
1.61
Return vs SPY (held)
6.43
Avg. weight
0.08%
LongTMO

P/L

$417

Contribution
0.86
Excess vs SPY
0.66
Return vs SPY (held)
12.94
Avg. weight
0.31%
LongT

P/L

$370

Contribution
0.21
Excess vs SPY
-0.09
Return vs SPY (held)
-3.72
Avg. weight
0.04%
ShortCOST

P/L

$241

Contribution
0.10
Excess vs SPY
0.79
Return vs SPY (held)
19.16
Avg. weight
-0.05%
LongILMN

P/L

$171

Contribution
0.20
Excess vs SPY
-1.24
Return vs SPY (held)
-45.55
Avg. weight
0.55%
LongTTWO

P/L

$144

Contribution
0.06
Excess vs SPY
0.06
LongBN

P/L

$129

Contribution
0.06
Excess vs SPY
-0.07
Return vs SPY (held)
-3.67
Avg. weight
0.03%
LongGRAL

P/L

$78

Contribution
0.04
Excess vs SPY
0.04
Return vs SPY (held)
-0.67
Avg. weight
0.00%
LongSBUX

P/L

$68

Contribution
0.23
Excess vs SPY
0.15
Return vs SPY (held)
2.75
Avg. weight
0.02%
LongBND

P/L

$50

Contribution
0.04
Excess vs SPY
0.14
Return vs SPY (held)
0.35
Avg. weight
0.04%
LongIVV

P/L

$45

Contribution
0.14
Excess vs SPY
0.01
Return vs SPY (held)
-0.09
Avg. weight
0.06%
LongBRK.B

P/L

$37

Contribution
0.12
Excess vs SPY
0.07
Return vs SPY (held)
0.12
Avg. weight
0.03%
LongSPXL

P/L

$37

Contribution
0.12
Excess vs SPY
0.07
Return vs SPY (held)
0.72
Avg. weight
0.00%
LongINTC

P/L

$27

Contribution
0.01
Excess vs SPY
0.01
Return vs SPY (held)
22.81
Avg. weight
0.00%
LongMGK

P/L

$17

Contribution
0.06
Excess vs SPY
0.02
Return vs SPY (held)
0.57
Avg. weight
0.01%
LongVUG

P/L

$14

Contribution
0.05
Excess vs SPY
0.02
Return vs SPY (held)
0.48
Avg. weight
0.01%
LongSIRI

P/L

$6

Contribution
0.04
Excess vs SPY
0.04
Return vs SPY (held)
-1.30
Avg. weight
0.00%
LongPLUG

P/L

$4

Contribution
0.00
Excess vs SPY
0.00
Return vs SPY (held)
0.73
Avg. weight
0.00%
LongVWO

P/L

-$2

Contribution
-0.02
Excess vs SPY
-0.04
Return vs SPY (held)
-1.29
Avg. weight
0.00%
LongWBD

P/L

-$14

Contribution
-0.05
Excess vs SPY
-0.07
Return vs SPY (held)
-1.83
Avg. weight
0.00%
LongAAP

P/L

-$21

Contribution
-0.07
Excess vs SPY
-0.07
Return vs SPY (held)
-6.07
Avg. weight
0.00%
LongBBWI

P/L

-$40

Contribution
-0.13
Excess vs SPY
-0.13
Return vs SPY (held)
-1.78
Avg. weight
0.00%
LongNKE

P/L

-$41

Contribution
-0.14
Excess vs SPY
-0.21
Return vs SPY (held)
-3.20
Avg. weight
0.02%
LongCVS

P/L

-$112

Contribution
-0.37
Excess vs SPY
-0.43
Return vs SPY (held)
-9.37
Avg. weight
0.01%
LongVHT

P/L

-$163

Contribution
-0.19
Excess vs SPY
0.04
Return vs SPY (held)
3.46
Avg. weight
0.01%
ShortAAPL

P/L

-$463

Contribution
-0.19
Excess vs SPY
0.07
Return vs SPY (held)
1.36
Avg. weight
-0.02%
LongVEA

P/L

-$581

Contribution
0.15
Excess vs SPY
-2.40
Return vs SPY (held)
-26.75
Avg. weight
1.89%
LongIEMG

P/L

-$664

Contribution
-0.70
Excess vs SPY
-3.20
Return vs SPY (held)
-27.53
Avg. weight
1.77%
LongMGM

P/L

-$1,048

Contribution
-0.47
Excess vs SPY
-0.78
Return vs SPY (held)
-14.41
Avg. weight
0.06%
LongMETA

P/L

-$1,398

Contribution
-0.52
Excess vs SPY
-2.44
Return vs SPY (held)
-12.43
Avg. weight
0.63%
LongPHM

P/L

-$1,996

Contribution
-0.94
Excess vs SPY
-2.04
Return vs SPY (held)
-19.86
Avg. weight
0.22%
LongBNGO

P/L

-$2,031

Contribution
-3.26
Excess vs SPY
-3.61
Return vs SPY (held)
-78.78
Avg. weight
0.18%
LongRDDT

P/L

-$2,801

Contribution
-1.15
Excess vs SPY
-1.76
Return vs SPY (held)
-69.28
Avg. weight
0.11%
LongPDD

P/L

-$5,219

Contribution
-1.68
Excess vs SPY
-2.16
Return vs SPY (held)
2.28
Avg. weight
0.89%
LongGOOG

P/L

-$6,586

Contribution
-2.66
Excess vs SPY
1.65
Return vs SPY (held)
3.13
Avg. weight
0.06%
LongTCEHY

P/L

-$7,153

Contribution
0.34
Excess vs SPY
-0.20
Return vs SPY (held)
-53.99
Avg. weight
2.37%
LongMELI

P/L

-$26,602

Contribution
-10.71
Excess vs SPY
-13.23
Return vs SPY (held)
-48.19
Avg. weight
0.57%
LongBTC

P/L

-$58,313

Contribution
-23.36
Excess vs SPY
-14.70
Return vs SPY (held)
0.85
Avg. weight
0.19%
View the full tables
SummaryP/LContribution (pts)Excess vs SPY (pts)Return vs SPY (held, pts)Avg. weight
Long total$730,133354.54110.1499.10%
Short total$365,091147.96148.04-2.90%
Other$10,4433.223.22
Positioning and timing-23.97
Compounding38.23
Total$1,105,666505.72275.6596.20%
Side
LongGOOGL$317,811132.3371.55157.8210.35%
LongVOO$109,28349.740.302.2519.31%
ShortTMC$88,58635.8536.0691.51-0.40%
LongVTI$79,47817.52-1.49-1.9016.18%
LongTSM$75,05130.4619.45-12.912.51%
ShortQBTS$74,30330.1131.3387.70-0.44%
ShortSPCX$67,30327.4022.0721.09-0.61%
ShortASST$61,86324.9220.61-16.29-0.10%
LongNVDA$46,93123.8410.21909.843.71%
LongAMD$45,69218.7712.2232.031.60%
LongHIMS$24,47310.9710.2660.190.37%
ShortPLUG$23,4429.6511.8948.20-0.28%
LongVGT$22,63318.386.59183.906.07%
LongAAPL$21,84022.6712.46415.327.30%
LongJPM$19,66913.615.6381.963.46%
ShortFRMI$15,1406.186.4459.16-0.08%
LongBAC$14,8648.192.8523.990.89%
ShortPCT$12,9555.265.9477.98-0.10%
LongTSLA$12,5086.145.42109.040.11%
LongSATA$12,3715.041.590.160.26%
ShortTSLA$11,2124.346.85-18.18-0.66%
LongMSFT$10,85911.604.64326.313.08%
LongSTRC$7,7363.142.4510.560.04%
ShortQUBT$6,4602.673.1548.21-0.07%
LongAMZN$6,2899.534.79197.942.77%
LongVXUS$4,2651.48-2.99-33.562.28%
LongITOT$2,4606.85-0.60-2.354.09%
ShortEVTL$2,2830.930.9379.140.00%
LongHCI$2,0331.000.418.480.12%
ShortWMT$1,7650.731.9111.61-0.09%
LongLNTH$1,6890.860.155.300.13%
LongIBKR$1,3900.850.7214.980.03%
LongIUSG$1,1872.410.406.340.92%
LongNTES$8450.420.102.440.03%
LongKSPI$789-0.05-12.99-34.963.06%
LongPACB$6040.630.2943.580.28%
LongGM$5561.851.616.430.08%
LongTMO$4170.860.6612.940.31%
LongT$3700.21-0.09-3.720.04%
ShortCOST$2410.100.7919.16-0.05%
LongILMN$1710.20-1.24-45.550.55%
LongTTWO$1440.060.06
LongBN$1290.06-0.07-3.670.03%
LongGRAL$780.040.04-0.670.00%
LongSBUX$680.230.152.750.02%
LongBND$500.040.140.350.04%
LongIVV$450.140.01-0.090.06%
LongBRK.B$370.120.070.120.03%
LongSPXL$370.120.070.720.00%
LongINTC$270.010.0122.810.00%
LongMGK$170.060.020.570.01%
LongVUG$140.050.020.480.01%
LongSIRI$60.040.04-1.300.00%
LongPLUG$40.000.000.730.00%
LongVWO-$2-0.02-0.04-1.290.00%
LongWBD-$14-0.05-0.07-1.830.00%
LongAAP-$21-0.07-0.07-6.070.00%
LongBBWI-$40-0.13-0.13-1.780.00%
LongNKE-$41-0.14-0.21-3.200.02%
LongCVS-$112-0.37-0.43-9.370.01%
LongVHT-$163-0.190.043.460.01%
ShortAAPL-$463-0.190.071.36-0.02%
LongVEA-$5810.15-2.40-26.751.89%
LongIEMG-$664-0.70-3.20-27.531.77%
LongMGM-$1,048-0.47-0.78-14.410.06%
LongMETA-$1,398-0.52-2.44-12.430.63%
LongPHM-$1,996-0.94-2.04-19.860.22%
LongBNGO-$2,031-3.26-3.61-78.780.18%
LongRDDT-$2,801-1.15-1.76-69.280.11%
LongPDD-$5,219-1.68-2.162.280.89%
LongGOOG-$6,586-2.661.653.130.06%
LongTCEHY-$7,1530.34-0.20-53.992.37%
LongMELI-$26,602-10.71-13.23-48.190.57%
LongBTC-$58,313-23.36-14.700.850.19%
Notes
  • P/L is the closing exposure less the opening exposure, plus the cash from every trade in between (sales and shorts in, purchases and covers out), plus the dividends while it was held. Realized and unrealized gains both count, after commissions. Each row is one position: each month's P/L goes to the long or the short row by the side held that month, so a ticker that switched sides within the range has two rows.
  • Exposures come from month-end holdings at that day's close, and the last span runs to the latest valuation, so a range starts and ends on those dates.
  • Contribution is the percentage points the position added to the range's return. Each month uses its opening value plus weighted net contributions and is scaled by the growth before it in the range, so the positions and Other add up to the chart's return exactly.
  • Excess is the points the position added beyond the same dollars in SPY. Each position gets an SPY mirror: each month it opens at the position's opening exposure, and on the day of each of the position's trades it buys or sells the same dollars at SPY's close, dividends reinvested. Excess is the position's contribution less its mirror's. A short is set against the same dollars short SPY, so shorting a stock that rises less than the market still counts as excess. Buying at a high or selling at a low costs the mirror as much, so it stays out of the position's excess and lands in the summary's Positioning and timing.
  • Return vs SPY leaves size aside and asks only how the stock did: its return over the days it was held, dividends included, less SPY's over the same days. Buying and selling along the way does not change it; the price runs from one known price to the next (the month-end closes and each fill), and days without the position do not count. A short turns it round, SPY's return less the stock's, so a gain on either side is above zero: shorting a stock that fell 40% while SPY rose 5% is 45 points. Excess is that gap scaled by the position's size, in points of the portfolio, so a small position can have a tiny excess and a large return vs SPY. The summary has none, since adding them up would weigh them by size again.
  • P/L and contribution can have opposite signs, and that is expected: the same dollars count for more points when the portfolio is smaller. A $1,000 gain on a $100K portfolio is +1 point; a $2,000 loss on a $500K portfolio is โˆ’0.4 points. Together that is โˆ’$1,000 of P/L but +0.6 points of contribution.
  • Average weights rebuild each ticker's shares day by day from the trade log, changing on each trade's date; its price is the close at each month-end and the fill on each trade's date, drawn in a straight line between, as is the portfolio's value between month-ends. Average weight is taken over every day of the range, days without the position counting as zero and shorts negative: how much of the portfolio was on it over the span. So the long rows add up to the Long total and the short rows to the Short total, the range's average long and short exposure. A position held for only part of the range shows a smaller weight the longer the range. The shares the trade log adds up to are checked against every month-end's holdings.
  • The summary above splits the Total into long, short and Other: the Total's contribution is the chart's return for the range, its average weight is the net exposure, long plus short, and its excess is the return less SPY's, the gap to SPY on the chart. The excess column takes two more rows. Positioning and timing is how far the portfolio with every position swapped for SPY, all else as it was, fell short of SPY itself: from being less than fully invested or leveraged, and from when money went in and came out. Compounding is the part already ahead of SPY riding SPY's later moves; the further the portfolio pulls ahead, the larger it gets. Long, short, Other, positioning and timing, and compounding add up to the Total exactly. Pick the Total, the Long total or the Short total in it to list those positions in the table below; the Total, every position, is picked to begin with. Other has no positions to list. Click a header in the positions table to sort by it, and again to reverse it. On a phone, the All, Long and Short switch and the sort menu above the positions do the same.
  • Dividends count on the ex-date, for the shares held the day before, at the amount actually received: net of foreign tax withheld at source, before U.S. income tax. A short pays them, and so does a synthetic short, which is booked at the stock price just as a stock short is. So every row is a total return, on the same basis as the chart's SPY, dividends included.
  • Other is the part of the gain the trades and dividends do not explain: cash and margin interest, single-leg options, borrow fees and fractional shares. Synthetic shorts are booked at the stock price when opened; after their dividends, the small gap left to the real option P/L (the interest and spread priced into the options) lands here too.