When you first start using Share Trade Tracker no buy trades will exist in the Buy Trades worksheet. There are two ways to record your buy trades either through the "Buy" or "Upload Trades" option on the Share Trade Tracker menu. In this help article we will cover the "Buy" option which is used to enter buy trades one at time into the Buy Trades worksheet. For the upload of multiple buy trades refer to Upload Trades
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 Worksheet
The 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.