Equity Trades and Holdings

Trades include purchases and sales of equity securities.

Short sells aren't supported.

Buy / Purchase

To add a purchase use the Equity Trades page. A trade has the following attributes: portfolio, account, security (added via symbol), trade date, units and amount.

The amount is debited from the account when a trade is added.

If there isn't sufficient balance to cover the trade the addition will be rejected.

There is an option Do not verify or modify account balance on the Buy form. This can be used to circumvent the check. This should be only used in very specific situations where you may not be tracking the account balance, such as an employee ESOP plan.

Edit a Buy

The edit icon against a trade allows you to update a buy trade (sales cannot be edited).

This should only be used in specific scenarios such as when you have a systematic investment plan but do not want to track every trade. You could just have one trade and keep updating the amount (cost) and units to reflect the latest.

Move Trades

You can move trades across portfolios. To do so select one of more trades in the trades listing and click the move button.

When you select a trade any related trades (buys / sells) will be selected as well. Related trade share a lot.

Sale

You can only sell what you hold. To sell a security go to the Equity Holdings page. This page lists all lots you currently hold. Select one or more lots and click sell. You can sell fewer units than what you hold for each lot.

Sells result in credit of the amount to the holding account.

You cannot edit a sale; if you make a mistake delete the sale from the Equity Trades page and add a new one with the correct information.

Equity Holdings

The equity holdings page shows the lots you currently hold.

A lot corresponds to each purchase you made. For example, if you execute 3 trades of 10, 20 and 30 units of AAPL you will hold 60 units of AAPL but there will be 3 separate purchase trades or 3 lots. Lots are often used for tax lot accounting.

Trades Bulk Load

You can bulk load trades to an account. This feature is available under Data Management tab of account details page.

To upload, create a file with one purchase / (purchase + sale) per line with the following details. Use the comma , character as the delimiter.

Buy Only

<portfolio>,<symbol>,<trade-date>,<units>,<amount>

Buy + Sell

<portfolio>,<symbol>,<buy-date>,<units>,<buy-amount>,<sell-date>,<sell-units>,<sell-amount>
  • All fields are mandatory.

  • Dates must be in YYYYMMDD format.

Last updated