1. The document is a stock portfolio tracker that provides information on stock holdings including quantity, market value, gains/losses, and cash balance.
2. It tracks performance today and totals for the portfolio, broken down by individual stocks and industries.
3. The second page allows the user to enter stock transactions over time including buys, sells, deposits, withdrawals, dividends, and provides calculations for various metrics.
1. The document is a stock portfolio tracker that provides information on stock holdings including quantity, market value, gains/losses, and cash balance.
2. It tracks performance today and totals for the portfolio, broken down by individual stocks and industries.
3. The second page allows the user to enter stock transactions over time including buys, sells, deposits, withdrawals, dividends, and provides calculations for various metrics.
1. The document is a stock portfolio tracker that provides information on stock holdings including quantity, market value, gains/losses, and cash balance.
2. It tracks performance today and totals for the portfolio, broken down by individual stocks and industries.
3. The second page allows the user to enter stock transactions over time including buys, sells, deposits, withdrawals, dividends, and provides calculations for various metrics.
1. The document is a stock portfolio tracker that provides information on stock holdings including quantity, market value, gains/losses, and cash balance.
2. It tracks performance today and totals for the portfolio, broken down by individual stocks and industries.
3. The second page allows the user to enter stock transactions over time including buys, sells, deposits, withdrawals, dividends, and provides calculations for various metrics.
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 18
STOCK PORTFOLIO TRACKER All stocks
#NAME? Stock Symbol Quantity
MARKET Market Performance Today
VALUE #NAME? #NAME? $16,220 #NAME? #NAME? #NAME? #NAME? TOTAL GAIN/LOSS Your Portfolio Performance Today $6,841 $0.00 Today's Gain/Loss #DIV/0! % Today's Gain/Loss CASH $4,826 Instrument Type
Total Result $16,219.9
6 Not Available $16,219.9 6 (empty)
Current Market Value (Stocks) by Industry
Time Offset -7 #NAME?
Today's % Today's Total % Total
Last Price Change % Change Current Value 52 Week Low 52 week range Gain/Loss Gain/Loss Gain/Loss Gain/Loss Purchase 52 Week High Purchase Amt Sold Qty Sold Amt Invested Amt Industry Instrument Type Qty Enter all your transactions Starting Cash $ 10,000.00
Low price on High price on Is the Price btwn Running cash
the txn date the txn date low & high? Total Txn Amt balance PRICE Low High Valid? AMOUNT Cash Balance $97.25 Not Available $486.25 $ 9,513.75 $100.21 Not Available $501.05 $ 9,012.70 $119.99 Not Available $839.93 $ 8,172.77 $21.98 Not Available $263.76 $ 7,909.01 1. Buy: When buying $161.76 Not Available $2,426.40 $ 5,482.61 Value $75.80 Not Available $758.00 $ 4,724.61 2. Sell: When selling a $36.25 Not Available $398.75 $ 4,325.86 Value $257.49 Not Available $2,574.90 $ 1,750.96 3. Cash Deposit: Whe $97.56 Not Available $487.80 $ 1,263.16 platform $81.52 Not Available $407.60 $ 1,670.76 4. Cash Withdrawal: W $106.25 Not Available $531.25 $ 1,139.51 account $162.55 Not Available $812.75 $ 1,952.26 5. Fees: When any fee $197.50 Not Available $1,382.50 $ 569.76 6. Dividend Payout: W $25.44 Not Available $50.88 $ 620.64 Balance $5,000.00 Valid $5,000.00 $ 5,620.64 7. Dividend Reinvestm $205.25 Valid $205.25 $ 5,825.89 & value.Quantity = Qu Current $1,000.00 Valid $1,000.00 $ 4,825.89 Reinvestment $131.50 Not Available $26.30 $ 4,825.89 Current Value = Curre Today’s Gain/Loss = C % Today’s Gain/Loss Total Gain/Loss = Cu Invested Amount = To stock % Total Gain/Loss = T Cash Available = Star Withdrawal – Fees + T Sell
Transaction Types . Buy: When buying a stock – Reduces Cash balance. Increases stock quantity & Value . Sell: When selling a stock - Increases Cash balance. Decreases stock quantity and Value . Cash Deposit: When adding Cash from external accounts into stock management latform . Cash Withdrawal: When taking Cash from Stock Management platform to external ccount . Fees: When any fees are applied which reduces money from your Cash balance . Dividend Payout: When Dividend is issued that increases money in your Cash alance . Dividend Reinvestment: When Dividend is issued as stocks. Increases stock quantity Calculations & value.Quantity = Quantity Bought – Quantity Sold + Quantity Dividend Current Reinvestment Current Value = Current Quantity * Last Price of Stock Today’s Gain/Loss = Current Value – (Previous Close * Current Quantity) % Today’s Gain/Loss = Today’s Gain/Loss / (Current Value - Today's Gain/Loss) Total Gain/Loss = Current Value – Invested Amount nvested Amount = Total Amount used to buy the stock – Total Amount used to sell the tock % Total Gain/Loss = Total Gain/Loss / Invested Amount Cash Available = Starting Cash Balance - Total Amount used to Buy Stock – Cash Withdrawal – Fees + Total Amount of Selling stock + Cash Deposit + Dividend Payout
