|
Account Statement |
  
|
|
Account Statement |
|
The purpose of the Account Statement report is to review all transactions, open positions and an account summary for the selected time period.
Report Interface
Configuring the Report:
Report Period
The following are the options for the report period:
Day
(End of previous trading day until the present moment)
Week
(End of previous trading week until the present moment)
Month
(End of previous trading month until the present moment)
Quarter
(End of previous quarter until the present moment)
Year
(End of previous calendar year until the present moment)
Since open
(From the moment of account creation until the present moment)
Previous month
(Previous calendar month)
User defined
This section allows you to define the start and end points of the report period. This is the most flexible option, allowing you to define the report period with great precision (to the second). The From and Till fields must be filled out in mm/dd/yyyy hh:mi:ss format.
Note: The report is generated in either GMT or EST time format, depending on the value of the rule Use GMT.
Account(s)
In this section, you can either select "All Accounts" to run the report for all your account(s), or select an individual account if you have more than one.
Checkboxes
| • | Simple form: The Account Statement report can be displayed in a simple or detailed form (uncheck the “simple form” checkbox to see the detailed report). In the simple form, the report’s Account Transactions section will only show position closings. Please note that if the simple form is selected, the Markup box becomes grayed out. Likewise, if the Markup box is checked, the Simple form box becomes grayed out. |
| • | Markup: Check this box to display markups in the body of the report. |
Pagination
This report can be set to display a certain number of rows per page: 20,40,60,80, “by Rule”, or “No Pagination”. "By Rule" refers to a pagination value set by the system administrator.
Report Body
The Account Statement report consists of four main sections:
| 1. | Basic report/account information in the header |
| 2. | “Account Transactions” |
| 3. | “Open/Floating Positions” |
| 4. | Report summary/footer information |
Basic report/account header information
This section displays the following information:
| • | Company logo |
| • | Time/date of report generation |
| • | Account ID |
| • | Customer name |
| • | Customer address |
| • | Base Currency |
| • | Report period |
| • | Report "From" and "Till" dates |
| • | Trader Login |
Account Transactions
This section chronologically lists all account transactions for the selected time period.
Note: The Simple form of the report only displays position closings.
Column descriptions
Date/time
Date and time of the transaction
Type
Transaction type
AJ |
Adjustment |
DP |
Deposit |
WD |
Withdrawal |
OP |
Open Trade |
CP |
Closed Trade |
PR |
Overnight Rollover fee |
Ticket
Ticket number. A ticket number is the number assigned by the system to a trade.
When a partial closing of a position took place, the Ticket column will display 2 ticket numbers connected by an arrow. For example, XXX1=>XXX2. This means that ticket XXX2 was partially closed by order XXX1.
Instrument
Instrument name.
Lot
Number of lots in the transaction.
Note: If your system is configured for trading in amounts instead of lots, then the name of this column will be Amount. The values in this column will be base currency amounts.
B/S
Buy/Sell. Shows in which direction (buy or sell) the position was opened
Open Date/Time
Date and time the position was opened
Open
The rate at which the position was opened.
In a CP record, this field will display the opening price in green italics. (for reference only)
In a PR record, this field will display the opening price in green italics. (for reference only)
Close
The rate at which the position was closed.
In an OP record for a position that is currently open, this field will be empty.
In an OP record for a position that has subsequently been closed, this field will display the closing price in green italics. (for reference only)
In a PR record, this field will display the closing price in green italics. (for reference only)
D/W/Adj
Deposit/Withdrawal/Adjustment. This column displays any deposits, withdrawals, or adjustments made on the account.
| G$P/L |
Gross profit/loss realized at the time of position closing. The gross profit/loss is simply the result of the difference between the buy/sell prices (in system base currency). It does not factor in any commissions, transaction fees, or overnight rollover rates.
Commission (where applicable)
The commission is a service charge on an account for opening a new position applied per lot and measured in system base currency. The commission charge is subtracted from the account balance at the time of the transaction. On some systems, an additional overnight commission may apply for positions that remain open overnight. Overnight commission applies per lot and is equal to the regular commission set on the on the account. The number of days that a position remained opened has no bearing on the overnight commission charge.
Note: Some entries in the Commission column may appear in green italics. (This is only true for closing positions transactions.) Entries in green italics are meant for reference only and are not included in totals. These entries show all commissions that were applied to the position or part of the position that was being closed.
Trans fee (where applicable)
Transaction fee. The transaction fee is a charge per lot applied on an account for opening a new position (measured in system base currency). The transaction fee is subtracted from the account balance at the time of the transaction.
Note: Some entries in the Transaction Fee column may appear in green italics. (This is only true for closing positions transactions.) Entries in green italics are meant for reference only and are not included in totals. These entries show all transaction fees that were applied to the position or part of the position that was being closed.
NFA Fee (where applicable)
The NFA fee is charged per lot at the opening of a new position. It works the same way as a commission or a transaction fee: it is applied per lot and measured in system base currency. The NFA fee is subtracted from the account balance at the time of the transaction.
| Overnight Rollover Fee |
Overnight rollover fee (measured in system base currency).
Note: Some entries in the Overnight Rollover Fee column may appear in green italics. (This is only true for closing positions transactions.) Entries in green italics are meant for reference only and are not included in totals. These entries show all overnight rollover fees that were applied to the position or part of the position that was being closed.
| N$P/L |
The net profit/loss of the position, measured in system base currency.
Net P/L = Gross P/L - Commission - Transaction Fee +/- Overnight Rollover Fee
Balance
Account balance after the transaction. The balance figure in any transaction record is the resultant balance after the completion of that transaction.
| Equity |
Account equity after the transaction. Equity = Balance +/- Floating P/L from Open Positions. The equity figure in any transaction record is the resultant equity after the completion of that transaction.
Used Margin
Used margin on the account after the transaction. The used margin figure in any transaction record is the resultant used margin after the completion of that transaction.
User
The initiator of transaction. If the initiator is the trader, then the trader's login ID will be displayed. Other possible values for this field are 'DEALER', 'ADMIN', and 'System'.
Reason
This column displays the cause or reason for the transaction.
CO/CREATE_ORDR |
Order created |
HEDGE_TRADE |
Position was hedged |
CT |
Close trade |
AR |
Autoreject |
MC |
Margin Call |
L |
Limit Order |
S |
Stop Order |
ME |
Minimal Equity |
E |
Entry Order |
Markup columns (these columns appear if the Markup check box is selected in the report interface)
OM Pts/$
Position Opening Markup, in pips and system base currency
The open markup modifies the rate at which the position opens for the trader. (Markups do not alter the rates presented to the trader.) The markup setting is a positive number of pips and markups are always charged so as to worsen the trader's rate (i.e. to increase the buy price or decrease the sell price).
The OM Pts/$ column is divided into 2 parts. The left part shows the total value of the markup in pips (The markup setting multiplied by the number of lots in the position; always a positive value). The right part shows the total value of the markup in system base currency (The total value of the markup in pips multiplied by the pip value of the instrument; always a negative value).
CM Pts/$
Position Closing Markup, in pips and system base currency.
The close markup modifies the rate at which the position closes for the trader. (Markups do not alter the rates presented to the trader.) The markup setting is a positive number of pips and markups are always charged so as to worsen the trader's rate (i.e. to increase the buy price or decrease the sell price).
The CM Pts/$ column is divided into 2 parts. The left part shows the total value of the markup in pips (The markup setting multiplied by the number of lots in the position; always a positive value). The right part shows the total value of the markup in system base currency (The total value of the markup in pips multiplied by the pip value of the instrument; always a negative value).
Open/Floating Positions
This section lists all open/floating positions as of the end of the report period.
Column descriptions (Unless otherwise noted, the columns in this section correspond directly to the columns in the Account Transactions section.)
Current
The current trader's rate (as of the end of the report period). This excludes the closing markup.
| G$P/L |
The unrealized gross profit/loss at the end of the report period. The gross profit/loss is simply the result of the difference between the buy/sell prices (in system base currency). It does not factor in any commissions, transaction fees, or overnight rollover rates.
| N$P/L |
The unrealized net profit/loss of the position, measured in system base currency.
Net P/L = Gross P/L - Commission - Transaction Fee +/- Overnight Rollover Fee
Report Summary/Footer Information
This section shows summarized info for the report period.
Description
Beginning balance
Balance at the beginning of the report period
| Total Gross $P/L from settled trades |
Total gross profit or loss on all positions closed within the report period
Commission
Sum of all commissions charged within the report period.
Transaction fee
Sum of all transaction fees charged within the report period
| Overnight Rollover Fee |
Sum of all overnight rollover fees applied to all open positions within the report period
Deposit
Total sum of account deposits within the report period
Withdrawal
Total sum of account withdrawals within the report period
Adjustment
Total sum of account adjustments within the report period
Net D/W/A
Sum of deposits, withdrawals, and adjustments within the report period
Ending balance
Balance at the report’s closing time
| Total gross $P/L from open positions |
Total floating gross profit or loss on all open positions at the report’s closing time.
Equity
Equity at the report’s closing time.
Used margin
Used margin at the report’s closing time.
Usable margin
Usable margin at the report’s closing time.
Footer
The footer is optional text appearing at the bottom of the report. It is configured by the system administrator. The footer appears at the bottom of each page of the report. If the No Pagination option is selected, the footer appears only once, at the bottom of the report. In the Account Statement report by email, the footer appears only once, at the end of the email.
ACCOUNT STATEMENT BY EMAIL:
An Account Statement can be sent to traders via email. Contact your system administrator for more information on this option.
Exporting the Report
The Account Statement report can be exported into Microsoft Excel. Right-click on the report body, and select Export to Microsoft Excel.