Record a Transaction

Last updated:

Recording Transactions

From any worksheet in the Portfolio Details work page users can record transactions entering or exiting a trade.

Open the Action menu, or right mouse click on any page to open the pop-up menu.

The first command on either menu will always be Buy/Sell.

Roll the cursor over the Buy/Sell command to view its submenu:


The sub-menu contains a number of commands to open Enter Transaction dialogs for five different types of security: Equities, Forex, Futures, Options and Warrants.

The Enter Transaction dialog for each type is quite similar, the main differences being that some fields are enabled for some types and disabled for others.

This help topic will use the Equities Enter Transaction dialog as its example, the fields that are different for the other types of transactions will be noted.

Enter Transaction

Single left-mouse click a command in the submenu to open the Edit Transaction dialog in its collapsed view:


Click the Details>> button to expand the dialog, see below.

Security Details

The symbol of the selected security, together with the exchange that it is traded on and its description will be displayed in the first three text boxes.

Click the Select button to retrieve the options chain for the security. Once an option is selected, its symbol and other details will populate the Enter Transaction dialog.

Transaction Details

Type and Entry/Exit

From the Type field, choose whether you want to buy or sell the selected security.

The Entry/Exit field shows whether this trade is designed as an entry strategy, or an exit strategy.


The current date is automatically entered in the Date field, however this may be changed either by .typing in a new date in the dd/mm/yyyy format, or by using the drop-down date-selector calendar.

Quantity / Contracts

If you are trading shares, enter the number of shares you want to trade in the Quantity field. The Contracts field is disabled for share purchases. If you are trading futures or options, enter the number of contracts that you wish to trade in the Contracts field and the quantity will be calculated automatically (for example in the US there are 100 stocks in an exchange traded option, in Australia there are 1,000).


The current market price of the instrument is automatically entered into the Price field. This can be changed to reflect the actual amount paid.


If you are trading options or futures, you can also complete the Margin fields, either by entering a percentage or an actual amount.


Total is the total cost of purchase or proceeds of sale.


Click on the Details>> button to drop down additional fields of settings for the transaction.


Broker Details


Select the broker from the Broker drop-down menu. The list includes brokers that you have previously defined using the Broker Accounts feature.

If you have set a broker as the Default broker, it will initially populate this field.

After selecting a broker, the Brokerage will be calculated using the formula that you added when the Broker was defined.

For more information on defining Brokers, go to the Broker Accounts help topic.



If no brokers have been defined, or if a special brokerage applies to the transaction, click on the selector button in the Brokerage text box to open the Brokerage dialog box:

Enter the amount of the Commission and/or Fees.

The name of the tax (e.g. Sales Tax, VAT, GST, etc.) and the amount at which it is levied, is controlled by the Local Tax Name/Rates settings on the General tabbed page of the Application Settings.

Select Calculate Local Tax to calculate the tax and add it to the Total.

Click OK and the brokerage Total is displayed in the Enter Transaction window.


If you wish to record the reason for entering or exiting the trade, record this in the Reason field - this will allow you to look back at your trades and benefit from your experiences.

Show As

Finally, you can choose whether it is a filled or unfilled order. A filled order means it has been confirmed by your broker, an unfilled order means that you have placed the order and are awaiting confirmation.

For more information, go to the Portfolio Details Orders worksheet's help topic.

Symbol Information

This system supplied information provides up-to-date market data.

Last Price

The Last Price displays the most recent price downloaded from the server, together with the date of that price.


The multiplier shows how many underlying securities one Options contract applies to.

Normally this is 100 Options per Contract in US and 1000 options per contract in other markets. Frequently however, the multiplier will be slightly higher or lower because of various adjustments.

For Equities, Futures, Forex, etc. this will always be N/A.

Point Size

This reflects how the price is quoted and displayed.

For equities by default it is 0.01 to 0.01, or dollar for dollar.

For Futures the ratio is much greater, for example:


The user can alter the point size, click on the text box button to open the Point Information dialog box.


Trade Allocation

On the bottom right of the Edit Transaction dialog, is an area headed Allocate to. This allows you to allocate a transaction to a trade.

Trade Grouping Explained

Grouping a number of transactions together as a trade lets you record and analyze the performance of trading strategies. These transactions are then linked to each other and their overall performance is tracked. Trades are based on a single underlying security - for example, a trade may contain a number of options for AOL or a number of stock trades for General Electric. However, you could not create a trade that includes stocks from both AOL and General Electric.

There are three options, with the default being for New Trade.

Alternatively, click the Existing Trade button. This will generate a list of all existing trades that include the selected security. Highlight the trade from the list that the new transaction is related to and click on Select to add the current transaction to that trade.

Once you have entered all of the details in the Edit Transaction window, click on OK to close the window.

For more information, go to the Portfolio Details Trades worksheet's help topic.

  1. Back to top