How to add manual trades to Stocklog+

008: Trade Details (Part 1)



See 007: Manually Adding Trades for a refresh on the trade column header.

0: Parent ID: The unique ID for this trade, it never changes and can not be modified
1: Child ID: Used to move a row under another, making it a child of the parent. You can have multiple children (rows) under one parent, and children can also be parents by having children (rows) under them. Once you move the row, the CID will revert back to it's Parent ID. You can return the child back to a top-level parent by deleting the CID.
2: CloseDate: The only way to close a trade. This will cause the summary tables to properly update. You can still modify fields even after the trade is 'closed'.
3: Floating Summary Bars:
  1. Balance: Initially your starting balance and then modified based on your trades
  2. Act ROI: Account ROI is the Return On Investment based on overall activity in your account
  3. Avg ROI: Average ROI is calculated based on the CLOSED positions
  4. Realized: Represents the actual profit or loss from CLOSED positions
  5. Unrealized: Potential/paper profit or loss from OPEN positions. Represents the current theoretical value IF all positions were closed at current prices
  6. Fees: Total of all fees collected
  7. Gross: Profit generated from the buying and selling of securities before deducting expenses such as taxes, commissions, brokerage fees, and other trading-related costs
  8. Net: Represents the total of both realized and unrealized P&L
  9. Winners/Losers: Number of positions that you closed and gained or lost money
  10. Open: Number of open positions
  11. ADH: Average Days Held represents the average holding period across all closed trades
  12. PF: Profit Factor represents the ratio of total gross profits to total gross losses across all closed trades; a single number that describes the overall profitability of your trading strategy
  1. Interpretation:
  2. PF > 1.0: The strategy is profitable (gross profit > gross loss)
  3. PF = 1.0: Break-even (gross profit = gross loss)
  4. PF < 1.0: The strategy is losing money (gross profit < gross loss)
  5. Key Points:
  6. Higher is better: A higher profit factor indicates a more profitable strategy.
  7. Risk assessment: Helps assess risk-adjusted returns.
  8. Comparison tool: Useful for comparing different strategies or time periods.
  9. Example:
  10. If gross profit = $15,000 and gross loss = $5,000:
  11. Profit factor = 15,000 / 5,000 = 3.0
  12. This means you make $3 for every $1 lost.
  1. LHT: Longest Held Trade referenced by the Parent ID
  2. MPT: Most Profitable Trade referenced by the Parent ID
  3. LPT: Least Profitable Trade referenced by the Parent ID

Alert
SHARES & CONTRACTS are either bought (positive number) OR sold (negative number). Price/Premium is always positive.
Alert
Closing the trade (#2 above) will stop Stocklog+ from updating the ClosePPS/Quote Price. ClosePPS is only updated for Stocks & Crypto

Notes
DTE (Days to Expiration) & NetAmount columns are auto-calculated fields and can't be modified directly

EDITING ROWS: You can edit a rows column data by double-clicking in the cell, it will turn orange as an indicator. Either tab or enter will insert the data. If the data is not the correct type it will revert back to the original data. Some edits will not cause Stocklog+ to immediately update, just keep going and you will eventually see the change - remember, it's lazy! If you want to refresh immediately, just choose the account again from the account drop-down list.



    • Related Articles

    • 010: Trade Details (Part 3)

      See 008: Trade Details (Part 1) for the start of this series Using the existing previous trades in Trade Details (007-009), we add the following on 2024-12-05: -1 2024-07-03 TSLA CSP @290 (Sell Cash Secured Put) - Expires Worthless 100 2024-08-01 ...

    • 009: Trade Details (Part 2)

      Understanding the trade: Your broker views everything in units or shares of 'something' and with that unit/share, you have an action: BUY: You traded your money for a unit/share of 'something' = positive units in & negative money out SELL: You traded ...

    • 006: Add Accounts

      Right-Click in the account list area and choose New/Mod Account: 0: Account Name: Descriptive name of your choice 1: Account Number: Use the account number assigned by your broker, this number can not be changed once submitted 2: Starting Balance: ...

    • 007: Manually Adding Trades

      Stocklog+ by default looks at most items as your broker does: Dates are always YYYY-MM-DD format Each buy or sell is considered a unique single transaction and treated as such. Simple example: When you buy a security, the broker may allow you to sell ...

    • 014: Data Import (Part 2)

      See Data Import (Part 1) for header details Below are header samples with a few lines of the raw (Account field was added) .csv file to give you guidance. Each header used here worked at the time of document creation. Try using the headers below as a ...