Positions

Last modified

Positions tabbed worksheet

The Positions tabbed worksheet shows all of the open positions within the portfolio, grouped by symbol.

The Positions themselves are grouped into individual Trades, in a manner similar to the display on the Trades tabbed worksheet.

Click on the plus sign to expand a symbol's summary row. All of the trades for the selected symbol will display.

Each Trade can then be expanded to view its component Transactions, each in its own individual row.

The Positions worksheet allows users to view the currently open positions for each symbol.

Positions Summary Rows

A typical Positions Summary Row can have the following column headings:

The following explanation describe the display for each column in a Positions Summary Row.

Note - The column's content display, and order, can be customized using the Action menu's Configure View tool.

Symbol

Each Position group contains all open transactions in for a particular share, option, futures contract, index, etc..

The Symbol for the Position's security is displayed here.

Description

The Symbol's full name or description.

Exchange

The Exchange on which the positions have been entered.

Last Traded

This field applies to the Transaction Rows only, see below.

Qty

The total number of currently open positions for the Symbol.

Entry Price

Averaged Entry Price for all currently open positions.

Market Value

The current market value of all open positions.

Formula

Market Value = Current Total Quantity x Last Price

Last

The last market price retrieved from the server.

Comm

Total commissions paid for the current open positions for this symbol.

Total

This field applies to the Transaction Rows only, see below.

Profit/Loss

The sum of all the positions' Profits and Losses.

For details on calculating profit/loss, see the Trades Summary Rows discussion, below.

Profit(%)

The overall profit, expressed as a percentage, for all the positions currently open.

Profit (Points) [not shown in graphic]

The overall profit, expressed as points, for all the positions currently open.

% of Portfolio

The proportion of the entire portfolio that the positions in this symbol represent.

Trades Summary Rows

 A typical Trades Summary Row can have the following column headings:

The following explanation describe the display for each column in a Trades Summary Row.

Note - The column's content display, and order, can be customized using the Action menu's Configure View tool.

Symbol

Each Trade group is indicated by a folder and the trade's sequential number assigned by Your Software.

Description

A description of the trade.

Exchange

The Exchange on which the positions have been entered.

Last Traded

This field applies to the Transaction Rows only, see below.

Qty

The total number of currently open positions for the Trade.

Entry Price

Averaged Entry Price for all currently open positions for the Trade.

Market Value

The current market value of open positions in the Trade.

Formula

Market Value = Current Trade's Quantity x Last Price

Last

The last market price retrieved from the server.

Comm

Total commissions paid for the current Trade.

Total

This field applies to the Transaction Rows only, see below.

Profit/Loss

The sum of Profit or Loss for all the positions in the Trade.

Profit(%)

This field only applies to the Positions Summary Rows, see above.

Profit (Points [not shown in graphic]

This field only applies to the Positions Summary Rows, see above.

% of Portfolio

This field only applies to the Positions Summary Rows, see above.

Individual Transaction Rows

A typical Positions Summary Row can have the following column headings:

The following explanation describe the display for each column in a Positions Summary Row.

Note - The column's content display, and order, can be customized using the Action menu's Configure View tool.

Symbol

The first two words on each individual Transaction row describe the transaction's contract type.

Normal equities transactions usually will have two types of contract: Buy(Entry) and Sell(Exit).

However, Options and Futures can be either bought or sold, and the position can be entered or exited.

There are four types of Options and Futures contracts: Sell(Entry), Buy(Exit), Sell(Exit) or Buy(Entry).

Description

The Symbol's full name or description.

Exchange

The Exchange on which the positions have been entered.

Last Traded

The date that the transaction was filled.

Qty

The total number of positions acquired or sold in the transaction.

Entry Price

Averaged Entry Price for the positions involved in the transaction.

Market Value

The current market value of the transaction.

Formula

Market Value = Current Quantity x Last Price

Last

The last market price retrieved from the server.

Comm

Total commissions paid for the current transaction.

Total

The total cost or net proceeds of the transaction.

Formula

Total = (Quantity x Entry Price) +/- Commissions

Commissions will be added to the cost of purchases and subtracted from the proceeds of sale.

Profit/Loss

The Profit or Loss for the individual transaction.

The profit for a purchase is calculated as follows:

Formula

P/L = (Current Quantity x Last Price) - ((Quantity x Entry Price) + Commissions)

The profit for a sale is calculated as follows:

Formula

P/L = (Quantity Sold x Sale Price) - ((Quantity Sold x Entry Price) - Commissions)

Unrealized Gains

Unrealized gains, i.e. gains calculated using the Last Price rather than an actual Sale Price are indicated by an asterisk: *.

Profit(%)

This field only applies to the Positions Summary Rows, see above.

Profit (Points) [not shown in graphic]

This field only applies to the Positions Summary Rows, see above.

% of Portfolio

This field only applies to the Positions Summary Rows, see above.

Total Summary Row

The row at the bottom of the table is the Summary Row.

It contains total Quantity of securities held, total Market Value and total Profit/Loss figures.

Function Bar

The Positions worksheet shares the function bar with other worksheets on the Portfolio Details workpage.

For a detailed description of each tool, go to the Function Bar section of the Portfolio Details workpage's help topic.

Page statistics
1194 view(s) and 6 edit(s)
Social share
Share this page?

Tags

This page has no classifications.

Comments

You must to post a comment.

Attachments