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