Tradebase Guide

The Tradebase provides you a view into your current positions, your trade history, and your P&L. The fundamental unit in the Tradebase is the "trade", as all positions are calculated as the sum of all trades in the same symbol. Trades can be created and edited using the Tradebase web interface, using the features defined below.

Trades

You have two options for entering trade data into the system:

1. Enter it manually through the "New Trade" under the "Trades" section
2. Trades are imported automatically on the appliance, or when the Tradebase Trade Recorder is setup

List Trades	List all the trades in the Tradebase, most recent first
New Trade	Use this to add a new trade (for example, off-line or phone trades)
List Unprarseable Messages	List of messages Trade Recorder couldn't parse

This screenshot of the trade detail view screen shows all of the data that can be stored in a trade record.

This screen represents a currency trade of 1 million EUR/USD. This trade was executed at a conversion rate of 1.4763 on November 7, 2007. The "Trade type" field indicates that this was a real trade, and not a placeholder for error correction or accounting. The "Strategy" field holds an arbitrary strategy name for the purposes of P&L reports. "Total Commission" represents the commission on the trade. The "Asset Type" field indicates that this is a currency trade. Finally the comment field may be used to store any text relating to the trade.

At the bottom of the shot is a summary of the cashflows involved in the transaction, in this case, the inflow of 1 million EUR and outflow of 1676300 USD.

Positions

All Positions	List all current positions
Positions as of	This option leads to a query page that allows you to examine the positions held "as of" a specific historical date.
Positions by Account	Provides a query page to list all the positions for a specific account.

Reports

Search for Trades	Click on this for a query page that will let you search for trades in a given date range, based on symbol and account.
Positions as of	This option leads to a query page that allows you to examine the positions held "as of" a specific historical date.
Positions by Account	Provides a query page to list all the positions for a specfic account.

P & L

P&L	Brings up a query page that allows you to run a P&L report for a given date range, and for a specific account.
List Marks for Sybmol	List all the marks for a particular symbol
List Marks on Date	List all the marks on a given date
New Mark	Enter a new mark
Import Marks	Allows bulk import of marks into Tradebase. You can either paste the marks in or specify a CSV file

The P&L calculations are done based on the positions in the Tradebase and on the marks for the corresponding securities. A P&L can be run between any two dates for which there exist marks. The following image shows a P&L report across all accounts, broken out by strategy and currency.

The account column shows the name of the account, in this case, a Currenex-based account for the fictional hedge fund, Minsk. The strategy column shows the value of the strategy field in the trades themselves, if any. Please see the section on trades, above, for more information. The P&L column shows the quantity of the P&L in the base currency of the individual trades (the currency is noted in the next column). The final column "USD P&L" shows the P&L as converted into the base currency of Tradebase, in this case, USD. This column requires additional currency marks, and missing marks will result in the placeholder "Create mark".

Currently, Tradebase is not integrated with any market data feed, so it is necessary to enter all the marks by hand through "New Mark" in the "P&L" section, or import them using a custom database script (example coming soon).

Once the marks are entered, you can run the P&L reports by dates for

• One account: gives you a P&L for a specific account, broken out by symbol
• All accounts: gives an aggregate P&L across all accounts, broken out by account

If the system is missing marks for some of the days required for P&L calculation you will be prompted on the next screen for the marks that need to be created:

P&L Methodology

The P&L is calculated in the following manner:

• Calculate the real cashflows for each transaction occurring within the date range, taking into account the commission, if any.
• For any positions that exist on the start or end dates, calculate a "synthetic" cash flow equal to the position quantity times the mark on that date, creating a cashflow equivalent to the opening or closing trade of that position. These synthetic cash flows are then added to the P&L to calculate the total.

You can use the marks importer tool to import CSV files into the system. It is a Java application that is setup to work with MySQL database, but the source code is included (and is also available online as well), so you can modify it to your needs.

DB Maintenance

List Accounts	List all the accounts in the system
New Account	Create a new account
List Equities	List all equities in the system
New Equity	Create a new equity
List Symbols	List all symbols
New Symbol	Create a new symbol
List Dividends	List all dividends
New Dividend	Add new dividend
List Currencies	List all currencies

Help

Documentation	Links to Tradebase documentation
Report a Bug	Links to bug reports in Marketcetera bug tracking system
About Marketcetera	Links to the Marketcetera company page
Server Diagnostics	Server Diagnostics
ORS Log	View of last 2000 lines of ORS log
Tradebase Log	View of last 2000 lines of Tradebase log