Buy Trades

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.