Ticker,Name,Shares,AvgPrice,CurrentPrice,MarketValue,Weight,UnrealizedPL,PLPercent
AAPL,Apple Inc,50,150,170,=C2*E2,=F2/$F$7,=(E2-D2)C2,=(E2/D2)-1
MSFT,Microsoft Corp,20,300,330,=C3E3,=F3/$F$7,=(E3-D3)C3,=(E3/D3)-1
AMZN,Amazon.com Inc,10,120,150,=C4E4,=F4/$F$7,=(E4-D4)C4,=(E4/D4)-1
SPY,SPDR S&P 500 ETF,15,420,460,=C5E5,=F5/$F$7,=(E5-D5)C5,=(E5/D5)-1
TSLA,Tesla Inc,5,200,170,=C6E6,=F6/$F$7,=(E6-D6)*C6,=(E6/D6)-1
TOTAL, , , , ,=SUM(F2:F6), ,=SUM(G2:G6),
Ticker,Name,Shares,AvgPrice,CurrentPrice,MarketValue,Weight,UnrealizedPL,PLPercent
AAPL,Apple Inc,50,150,170,=C2*E2,=F2/$F$7,=(E2-D2)C2,=(E2/D2)-1
MSFT,Microsoft Corp,20,300,330,=C3E3,=F3/$F$7,=(E3-D3)C3,=(E3/D3)-1
AMZN,Amazon.com Inc,10,120,150,=C4E4,=F4/$F$7,=(E4-D4)C4,=(E4/D4)-1
SPY,SPDR S&P 500 ETF,15,420,460,=C5E5,=F5/$F$7,=(E5-D5)C5,=(E5/D5)-1
TSLA,Tesla Inc,5,200,170,=C6E6,=F6/$F$7,=(E6-D6)*C6,=(E6/D6)-1
TOTAL, , , , ,=SUM(F2:F6), ,=SUM(G2:G6),