![]() Add Buy Trade Click on "Buy" to display the Add Buy Trade form. Then proceed to complete the required fields on the form, when complete click on "Add Trade" and the details will be copied to the "Buy Trades" worksheet. ![]() After the trade is added a new entry will be displayed on the "Buy Trades" worksheet. In the entry you may see that company and other details are not found. This is resolve by running "Update Prices" or "Security Check", either of these will look for the details of all listed trades on Yahoo finance. Once found those details are then displayed for those trades. ![]() The following message box will be displayed after the entry is included to the worksheet. This allows you to immediately update the prices and security details for the trade that has been entered. ![]() Fields on Buy Trades WorksheetThe following is a listing of all fields on the Buy Trades worksheet. ![]() Trade Date: date on which the security was traded Security Code: security code for the trade; the exchange suffix is automatically included on "Add" 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 Contract No/Reference: reference number, contract number for the trade Purchase Price: purchase price for the trade Buy Cost: calculated buy cost for the trade NOT including brokerage Brokerage: brokerage for the trade Total Purchase Costs: total purchase costs including buy cost and brokerage Stop Loss: price at which a warning will be displayed in the open position worksheet to sell Take Profit: price at which a warning will be displayed to take a profit and sell Create Date: the date the trade was first created Update Date: the date the trade was update using "Modify Trade" Buy Trade Reference: a unique reference used to match buy trades against sold trades Position Status: indicator if the trade is "Open", "Sold" or "Partial" for trades not fully sold. |
2. Trading >