Open Positions

Once a Buy Trade is created a corresponding entry will also be included to the Open Positions worksheet. This worksheet maintains a list of all Open Positions. As you add Sell Trades the Open Positions are updated to reduce or remove them from the worksheet. The Stop Loss / Take Profit warnings are displayed on this worksheet for you review.

Fields on Open Positions Worksheet

The following is a listing of all fields on the Open Positions worksheet.

Purchase Date: date on which the security was purchased

Security Code: security code for the trade

Exchange: the exchange that the security was traded on, the familiar name is shown

Company: this field is matched to the company details found on Yahoo

Portfolio: this is the portfolio selected for the trade

Instrument: this is the type of trade either a "Share" or "CFD"

Quantity: total quantity for the trade; this will shown the remaining quantity

Purchase Price: purchase price for the trade

Buy Cost: this is the cost for the trade excluding brokerage, quantity * purchase price

Buy Brokerage: the brokerage for the trade

Total Purchase Costs: total purchase costs including buy cost and brokerage

Current Market Price: this is the price retrieved from Yahoo Finance

Daily Move: this is the movement in the price from the previous day to market open

Market Value: total value of the current position using Market Price and Quantity

Gross Profit/Loss: this is the difference between the Market Value and Buy Cost excluding brokerage

Net Profit/Loss: this is the difference between the Market Value and Total Purchase Costs

% Gain/Loss: this is the % difference between the Total Purchase Costs and current Market Value

Days Held: calculates the number of days that the position has been held

Stop Loss/Take Profit: a warning for any breach to the settings for Stop Loss/Take Profit, the options are

  • Position OK - no action required price is within the Stop Loss/Take Profit

  • Stop Loss Breach - the market price has gone below the Stop Loss and trade should be sold

  • Take Profit Breach - the market price has risen above the Take Profit and should be sold

Maximum Price: the maximum price returned by Update Prices for a open position. It will be set only when the price exceeds the current maximum price and is taken from the high price for a given day. If needed the Maximum Price can be manually set using the Modify Trade function on the ribbon.

Maximum Price Date: the date on which the maximum price was last set

% Floating Stop Loss: this calculation compares the maximum price to the current market price and if the loss calculated is greater than the Floating Stop Loss % then it will highlight that % in a darker blue then other loss %. The Floating Stop Loss % is set a a default level across Share Trade Tracker by a value in the Configuration settings.

Buy Trade Reference: a unique reference used to match against the existing buy trades

Position Status: indicator if the trade is "Open", "Sold" or "Partial" for trades not fully sold