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
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 |
2. Trading >