My Trade Analyzer Trade Station
Contents
1. hot button that will allow you to collapse the data while posting your coding If your Analyzer does not fit into the width of your monitors for example the 19 size or the setting of monitor resolution you can go to View then Zoom then Custom Zoom and set for 92 This should set your layout for full view If not you can adjust your zoom appropriately Please read the following instructions first to fully grasp how to use this system prior to creating your first workbook A better understanding of its proper use will save you a lot of time and minimize errors Do not try to think for the program Get in a habit of maintaining a sequence of steps of using the Hot Buttons and let the program do the work for you There are hidden features in each of these buttons There are five basic parts to this analyzer Template This is the main data analyzer designed to allow you to redefine and input your style of trading according to your plan You can actually go into the sheet and change parameters to fit your individual types of Setups that you take the Timeframe you take your trades on Source of your trades the Time of day you took your trades and the types of errors you commonly make Totals This sheet automatically accumulates your daily results while keeping track of your performance on a daily weekly monthly and annual basis It also calculates which day of the week you perform your best or your2. onto your desktop take a moment and think about how you trade now or may trade in the future If you have several broker accounts where you trade futures and maybe stocks or ETF s in the IB Universal account you may want to copy My Trade Analyzer onto your desktop and rename it so you can analyze the different instruments you trade most people have different trading styles for trading different instruments Or if you are using a simulated account you may want to set up a copy to track how your simulated trading is doing Creating a copy of your program on your desktop See back of manual for the procedures you can make as many copies of the program as you wish Never rename the saved ORIGINAL SHEETS as these must be Kept as is for My Trade Analyzer to function properly Step 1 Setup your Template with User Definitions The Templates are designed to allow you to modify or change most of the coding to fit your style of trading For example in your style of trading let s say you do not take Break out or break down plays but you do take 123 Continuation plays or Gap plays You can go to the descriptions white cells of the Setup type timeframe source and time of day section and modify to suit your needs and even change the code You can also change the description of errors on all but error codes 1 2 and 7 those have linked formulas to them All other error codes in the Demon section can be changed t
3. the Step 6 prior to using the Post all button It will give you a message if you forget or type in your code on the wrong line Step 6 Column R Win Loss Scratch Break Even Stop Out Go to Column R and look in Column your P amp L determine whether your trade was a Win Loss Scratch Break Even or a Stop Out If the P amp L is greater than your scratch amount place a W in the cell If greater than your Scratch amount and a loss then place an L If a win but less than your scratch amount place an X If a loss but less than your scratch amount place an X If you were stopped out of the trade then place an SO If a Break Even 0 00 then place a BE Space down to our next trade exit and repeat the process Once done continue to Step 7 Step 7 Click on the Hot Button Post All Data At this point My Trade Analyzer calculates and posts your Today s Results in row 9 and automatically inserts that information on to your Totals Summary It also posts the data to your P amp L BA and Sharpe ratio line charts Now you will notice My Trade Analyzer updating automatically Tip If you would like to go back and see a previous day s results simply click in cell A9 the date select the date you would like to review from the drop down menu and it will repopulate the results for that date You will notice your Batting Average BA and Sharpe Ratio has calculated for the day And w
4. you will see a 2nd copy of the program file Select one of the copies Right click and rename Right click again create a shortcut and drag the new file onto your desktop Then go to the other copy Right click and re name the other file Right click again create a shortcut and drag the new file onto your desktop This will keep your original intact in your main My Trade Analyzer folder Now you have two copies of the program on your desktop and the saved original Now check to make sure the renamed copies appear on your desktop for easy identification You ve read the Instructions It s time to put My Trade Analyzer to work 8 Analyze what you are doing right and what you are doing wrong Overcome your Demons Copyright 2008 2009 My Trade Analyzer All rights reserved This program is protected by copyrighted laws of the United States any copying or reproduction via CD DVD format or reproduction via email or any other means is strictly prohibited without the prior written consent of the author The author disclaims all liability for any and all claims howsoever arising and makes no express or implied warranties or claim that to follow any of the advice in this program will result in any form of pecuniary gain or loss The advice given or results obtained is intended in good faith but no implication of liability is inferred IB User Manual 2 6 docx Revised 07 28 09
5. Aw Interactive Brokers User Manual MyTradeAnalyzer Introduction My Trade Analyzer was primarily designed to monitor and analyze your actual trades executed each day You can copy your actual trades taken daily from your IB Trader Platform on the IB website export to an Excel worksheet and paste directly into this program thus saving time and minimizing input errors This program does not need to distinguish between trades of different instruments it can calculate for Stocks ETF s Futures and Emini s This analyzer was designed using Microsoft s 2007 Excel Edition with file format xlsm If you have the previous Excel 2003 version My Trade Analyzer is available in xls format Please make sure you select the proper format when you download the analyzer Do not try to convert from 2003 to 2007 or vice versa Microsoft Excel has some inherent compatibility issues that could make the program function improperly Remember This is a macro enabled file If you are using Excel 2007 you must save it as a Macro Enabled Workbook If you are using Excel 2003 save it as an Excel 97 2003 Workbook Due to the vast amount of information My Trade Analyzer creates for you the ideal set up would be a four monitor system stacked which would allow full view access to your worksheet If you are using a one monitor or two monitor system side by side scrolling will be required however we have created a Toggle View
6. ew Year on the Totals Sheet select the next year and press OK This will create a copy of Totals of the present year and also creates a new Totals Sheet for your next year Click Save now click Save As and save your workbook as IB 2009 Stocks or IB Futures Go back to your present workbook and delete all your monthly sheets that you created for last year Tip you can keep your Totals for 2009 if you would like to compare last years trading with the upcoming year s trading Re evaluate and make any End of Year corrections to your Template Sheet and save the file You should be ready to start the New Year off Fresh Creating a copy of your program You can create as many copies of the program for as many accounts you may have However keep in mind My Trade Analyzer is specifically designed for the broker you downloaded t will not work for any other broker Please contact sales mytradeanalyzer com to obtain a second broker license Once you have downloaded the program Go to My Trade Analyzer Folder on your Desktop double click Then you should see the program file with a params files and uninstall file Right click on the program file and select Copy then right click and Paste Now you will see a copy of the program file If you want to analyze different instruments then create another copy so go back and repeat Right click on the program file And select Copy then right click and Paste Now
7. heir goal for the Sharpe 1 6 or better The Totals Summary sheet keeps a cumulative summary as you progress through your weeks months and even makes an annual summary It also allows you to select which month you would like to print Tip you may have to adjust your printer scaling to accommodate a full print function If any of the criteria starts to vary you become aware of issues arising in that particular area and what you need to do to address it My Trade Analyzer calls attention to how you are doing on your longs vs shorts My Trade Analyzer examines how you are doing on your setups which ones make you money and which ones don t My Trade Analyzer prompts you on how you are doing in your management styles and what needs to be addressed My Trade Analyzer cautions you on which timeframes source and time of day you are not making money and guides you on which timeframes source and time of day you are My Trade Analyzer posts the Total Commissions and fees in Column P daily keeps a running total of your expenses cell Z5 as well as automatically calculates your Commission s percentage against your P amp L Level 1 and Level 2 End of Year Creating Next Year s Totals Sheet Due to the fact each year does not maintain the same day of the week date relationship we have created a function that will automatically recalculate next years Totals Sheet After the last trading day for the year click the Hot Button N
8. hile Adding up the commission cost for your trades the Commission s percentage of your daily P amp L has calculated Note Take a quick glance at your BA and Sharpe for the day Most traders strive for a BA above 60 and a Sharpe above 1 5 If you can maintain that then you re making money There appears to be a lot of steps up to this point but after a few days you will be getting this far in less than 5 minutes Level 1 Users You have now completed your daily trade analysis You have also created a cumulating daily weekly monthly and annual summary report and graphs of the trend of your P amp L Batting Average and Sharpe Ratio Level 1 Users Go To End of Year Page 8 Level 2 Users Chart Analysis Tip This is where have a specific platform workspace set up which call Print Chart with a full view full workspace chart selected with my normal timeframes in which take trades with the necessary Moving Averages volume and any other indicators normally use also have Open Order Lines enabled for quick reference to the trades took that day scroll the chart over to put the first trade of the day to the far right of my chart This keeps me from looking at the future action after taking the trade to keep from determining any bias as to why I took that trade and managed in that way So now can toggle between my chart and My Trade Analyzer and post the appropriate codes And obviously cha
9. imited and then semicolon as the delimiter Once you have finished with this conversion dialog your trade information will be in Excel format Report from Trader Workstation Although you can go back seven days in this screen you cannot get the columns that the Trade Analyzer needs for days other than current day To get the appropriate columns for previous days you just have to approach it a different way So IT IS IMPORTANT IF YOU WISH TO USE THIS METHOD TO EXPORT YOUR CURRENT DAY S TRADES TO A TXT FILE BEFORE YOU CLOSE DOWN FOR THE DAY The information will then just sit out there waiting for you to post into My Trade Analyzer If you forget to do this then from the Trader Workstation choose View Statements from the menu This will connect you to the website choose Daily Activity and Summary Double click on the Trades section of this report to open up your trades for the particular date specified This will provide a report that you can copy and paste in pieces into an Excel worksheet In addition you will have to manually type in BOT and SLD in the appropriate spots as this field is not provided by reports generated in this manner This method takes much longer and is subject to more user errors So you are strongly encouraged to export the Day s Trades under the method suggested above from the Trades screen of your IB Workstation before the End of the Day Setting up your Program Once you have downloaded your program
10. nge the chart for the symbol am analyzing Step 8 Column S Setup Go to Column S review your chart for that trade to determine the Setup Post the code space over and repeat the process Column T Type of trade you managed Go to Column T review your chart for that trade to determine the management style Post the code space over and repeat the process Column U Timeframe Go to Column U review your chart for that trade to determine the timeframe Post the code space over and repeat the process Column V Source Go to Column V define whether it was your call a newsletter chat room recommendation and who called the trade Post the code space over and repeat the process Column W Time of Day Go to Column W define the time of day you took the trade Post the code At this point you can now see a great deal of information from this coding You will see your number of wins and losses dollar amount and average wins and losses your Batting Average and Sharpe ratio for that specific code You will also have what time of day the timeframe and management criteria of your wins and losses as well as your Batting Average and Sharpe of your Longs vs Shorts Basically the when where and how you make your money Trade Errors and Demons There are four rows where you can evaluate your trade and determine what mistakes you are consistently making The Demons Any more than two to three errors and you might think about pape
11. o suit your needs and as often as you wish Also in cell U4 account size you can set the value of your account Remember next month to change accordingly as your account value will vary from month to month In Col D Rows 16 amp 17 we have default values set there Define your values and change accordingly In cells A11 and A12 you can change your brokers name as well as the commission costs they charge you Most brokers have varying rates based on the size of your account and your volume of shares contracts you trade Now you are ready to save your changes and create a new monthly worksheet Step 2 To Create a New Months Worksheet Simply right click on your saved Template select Move or Copy highlight Template check Create a Copy and click OK This will create a new Template 2 sheet Right click on this tab select Rename and rename your new sheet the appropriate new month Now We Are Ready to Start Posting Level 1 and Level 2 Users Step 3 Copy Report Once you have your days trades in the Excel format Highlight your entire days trades and click on Sort A Z then select the first row to sort by And click OK Now your trades will be sorted alphabetically and collected together Highlight your trades again and use CTRL C to copy then open up your trade analyzer Go to EOD Trades Tab in upper left cell A7 click on it And then use CTRL V to paste the trades Because IB re
12. ous columns that you can have in the report Use the Select and Move Up and Move Down buttons on the right to make sure you have the following columns checked only these columns and they must be in this order Underlying Action Quantity Price Time Commission and Realized P amp L Then check OK If the Trades window does not update immediately with any changes you made you may have to close the Trades window x out in upper right corner and reopen with the Trades button on the 2 main Trader Workstation screen If the Realized P amp L column is not available as one of your choices from the main Trader Workstation screen choose Configure Feature Selector Real Time Activity Monitoring P amp L Columns to enable this feature Once your Trades window shows the day s trades with the columns above go to File Export Today s Reports Select Custom Columns and make sure the same columns as above are selected and in the same order usually allow the filename and path to stay the same as the default Click Ok and a message will pop up telling you the file has been exported In Excel to open the file choose all files in the type and in your IBJTS folder you should find the day s trades If you have allowed the default name to remain in the previous step the file will be named trades 20090601 txt if the date of the trades was June 1 2009 When the text import wizard pops up choose del
13. ports your trades in GMT there is a GMT Converter Time Zone built into the analyzer to allow you to set up the analyzer for your time zone This will allow the time of your trades to be posted in your local time Step 4 Consolidate and Post Now click on the Consolidate and Post Hot button It will ask you which sheet you want to post to Select your monthly sheet you are working on and click OK You will now see your trades on the monthly sheet You will also notice the trades have filtered out your partial fills at the same trade price Note If you get behind and decide to generate a report for multiple days make sure at this point you manually go in and insert a blank row between each of the trade dates Otherwise the program will consider all the days of trading as one day Step 5 Process Day s Trade Click on any cell within your days trade range to tell the analyzer which trades you want to analyze Click on the Hot Button Process Day s Trade If you get a default This date is not in the date range Click OK It is looking to see that you have not duplicated same trade dates My Trade Analyzer will determine whether it is a Long or a Short trade and insert the yellow coding cells for you Tip When coding the Yellow cells you must put your coding on the same row as your P amp L which is the same row as your Long or Short You will notice a warning message pop up reminding you to fill in
14. r trading Here is where the chart analysis really tells you important information and summarizes which are your most crucial demons and to what degree they are affecting your trading In the first row Row Y it is of the greatest importance to place the appropriate code that caused the major error in the trade to ultimately fail The other three rows of errors can be changed as you see fit The reason for this is the SDollar total and average loss on these trade errors is determined from this Row Y error code Although you may have also made other errors in this trade it does total the number of errors you are making and calculates the percentage of the errors made Your greatest percentage in the Demon column is the biggest demon You need to get under control Interpreting Your Cumulative Trading Worksheet Now let s evaluate your trades and see what it tells you Tip As you accumulate more trades for the month valuable information starts to pop out at you The upper section for your total Wins vs Losses calculates your Batting Average and Sharpe ratio for each type of trade Obviously you want to keep the highest Batting Average on your wins and the Lowest Batting Averages as possible on your Losses Scratches and Stop Outs Your objective is to keep less than 10 on each of your losses which affords you no more than 30 Batting Average on your losses Again most traders strive to keep their win Batting Average above 70 and t
15. worst Daily Trade Log This sheet is linked to the Template sheet so when you redefine your trading style and change the parameters it will automatically update This sheet is ideal to use as a cheat sheet that you can print out and keep on your desk to jot down the what when where and why you took that trade while in the moment You will find it makes for easier and faster coding at the end of the day Monthly Sheet You create this sheet each month and this is where you actually copy and paste your trade information Once you have redefined your Template and saved it you merely copy your template onto a new sheet and rename the sheet for the month you are working with P amp L BA Sharpe This sheet graphs and maintains your progress in these three areas and calculates an 8 period SMA of your trend Now Let s Get Started Due to Interactive Brokers limited reporting for static real time trades information you will need to customize your report in the Trader Workstation to fit the input requirements of this analyzer Setting up your IB Custom Report On your main IB Traders Workstation screen there is a button near the top called Trades Select this The Show Trades line should be checked for the current day of the week you are working on this method APPEARS like it allows you to go back seven calendar days see note below Go to Settings Layout and you will see a box of vari
Download Pdf Manuals
Related Search