Trading Performance Analyzer (TrdPerfAna) - Custom Trading Imports

Importing from Interactive Broker (IB)

Login to the Acocunt Management of Interactive Broker (IB) and select your Account
click on "Run" button for the "YTD" Flex Query (see below how to create your "YTD" Flex Query):
This will open a new browser window and save automatically all confirmed transactions/trades since beginning the year into a CSV file:

Open the folder were the "YTD.csv" file was downloaded and right click on the "YTD.csv" file and select "PosAna" (Trading Performance Analyzer):

This will open the "Trading Performance Analyzer" showing the completed trades in the Equity Chart and now you can analyze your trading etc!

 

 
Creating your "YTD" Flex Query
Below we show you how create a "YTD" Flex Query - allowing you to save automatically all confirmed transactions/trades with one click!
Once you have created the "YTD" Flex Query you can directly just run the query  see above!
Go to the "Flex Queries" section: 
Reports -> Trade Confirmations -> Flex Queries

Since we do not have [yet] any Flex Queries you see - click on the "Create New Flex Query" button:

Adjust the basic Flex Query settings as shown below:



Select the ALL FIELDS fields under the "Fields Available" section:
a) Click on the first field "ClientAccountID":

b) Move the grey scroll  box to the end:

c) Hold down the SHIFT button and click on the last field "AllocatedTo" to select ALL FIELDS:

d) Click on the green selection arrow to include ALL FIELDS:
  
moving all fields to included:


e) Click on the "Save Query" button:


f) Now the "YTD" query is available - click on "Run" to save all confimed transactions/trades since the year beginning

 

Select the following fields are essential for correct processing and need to be selected in the "Fields Included" section:
Account ID
Symbol
Multiplier
Quantity
Trade Price
Proceeds
IB Commission
Cost Basis
Realized PL
Buy/Sell
Trade Date
Trade Time
 
 

 


Importing from your custom CSV File (CSV)

The "Trading Performance Analyzer (TrdPerfAna)" allows you also to import any custom trading records.
Just drag the CSV import file into PerfAna and select "Replace current File" or right click in Windows Explorer and select "Open with" and select the PerfAna icon.
You can then save the loaded CSV file as a native POSA file (File/Save As)
 
Short Format:  (Bold=Required Columns)  Sample1.csv.
Column Content Examples Description
1 Symbol @EC,HPJ The trading symbol up to 10 characters
2 EntryDate 12/10/2004 Date of the Entry (MM/DD/YYYY or YYYYMMDD)
3 EntryTime 12:04:00 Time of the Entry (HH:MM:SS) or (HH:MM) - of omitted 00:00:00
4 Exit Date 2/10/2004 Date of the Exit (MM/DD/YYYY or YYYYMMDD)
5 ExitTime 14:14:00 Time of the Exit (HH:MM:SS) or (HH:MM) - of omitted 00:00:00
6 Volume 100,-200 Number of Shares/Contracts Positive=Long Position, Negative=Short Position
7 EntryPrice 6.349 Price bought/shorted at the Entry
8 ExitPrice 1.3210 Price sold/covered /shorted at the Exit
9 Profit/Loss 125.00 Amount of the Profit/Loss
10 Commission 5.40 optional - Fee/Commission - Amount with a decimal dot
11 Label LE optional - Trading Label - identifying trade details

Symbol,EntryDate,EntryTime,ExitDate,ExitTime,Volume,EntryPrice,ExitPrice,Profit/Loss,
@EC,12/10/2004,12:04:00,12/10/2004,12:14:00,1,1.3200,1.3210,125.00

Long Format: (Bold=Required Columns)
Column Content Examples Description
1 PosNbr   skipped - Position Number
2 Equity   skipped - Equity
3 Symbol @EC,HPJ The trading symbol up to 10 characters
4 EntryDate 12/10/2004 Date of the Entry (MM/DD/YYYY or YYYYMMDD)
5 EntryTime 12:04:00 Time of the Entry (HH:MM:SS) or (HH:MM) - of omitted 00:00:00
6 Exit Date 2/10/2004 Date of the Exit (MM/DD/YYYY or YYYYMMDD)
7 ExitTime 14:14:00 Time of the Exit (HH:MM:SS) or (HH:MM) - of omitted 00:00:00
8 Volume 100,-200 Number of Shares/Contracts Positive=Long Position, Negative=Short Position
9 EntryPrice 6.349 Price bought/shorted at the Entry
10 ExitPrice 1.3210 Price sold/covered /shorted at the Exit
11 Profit/Loss 125.00 Amount of the Profit/Loss
12 Commission 5.40 optional - Fee/Commission - Amount with a decimal dot
13 Label LE optional - Trading Label - identifying trade details

Pos#,Equity,Symbol,EntryDate,EntryTime,ExitDate,ExitTime,Volume,EntryPrice,ExitPrice,Profit/Loss[,Fee,Label]
1,45.00,@EC,12/10/2004,12:04:00,12/10/2004,12:14:00,1,1.3210,1.3200,125.00, 5.40,LE,
(fields "Pos#,Equity," are skipped)

Copyright 1994-2015, Burkhard Eichberger, Professional Software Solutions
All Rights Reserved Worldwide.