How to generate your own Profit/Loss graph and statistics

I’ve been asked to tell how I generate the graphs and statistics for my Triggers in Action reports (see an example here).

Here is a simple step-by-step guide on how to reproduce the same graph and stats.

1. Find the bank statement files you want to analyse. In MarketFeeder Pro, your statements are stored in the following folders:

Test account statements:

C:\Users\%username%\MarketFeeder Pro\profiles\%profile name%\logs\statement\test\

Real account statements:

C:\Users\%username%\MarketFeeder Pro\profiles\%profile name%\logs\statement\real\

You will see a number of files there, such as these:

2. Download this spreadsheet.

I use Excel, but you can get similar results if you open it in some Open Source alternative, such as Libre Office. Attention: this file contains macros: pieces of VBA code that I programmed to automatically populate some data required to build a nice-looking chart. If you do not trust me or my code, please do not use this file and just do it all manually or hire someone to do it for you.

Note: you will have to enable macros in this spreadsheet before you proceed!

3. Put your mouse onto cell A1. Select the Data tab -> From Text:

4. Choose the statement file you want to import. Normally, to build a continuous, historically accurate graph, you will start from the earliest statement file. Press "Import".

5. Choose “Delimited” and “Start import at row 2”, then press “Next”:

6. Choose “Comma” as your delimiter, then press “Finish”:

7. Press “OK” when asked where to put the data (in cell A1):

You will immediately see that your graph and stats below it have been populated with the new data:

8. Put your mouse in the nearest empty cell in the A column to import the next statement file:

Repeat steps 4 to 7 until you have imported all the statements.

Then check the updated graph and stats.

Enjoy!

If you have not heard of BetFair yet or do not have an account, register today and get £20 free. Use the link below:
New customers only, bet up to €/£20 on the Exchange and if your first bet loses, we’ll refund you €/£20 in Cash. Bet must be placed in first 7 days of account opening. T&Cs apply.
Gamble responsibly! Always be aware that betting is NOT risk-free. You must be 18+ years old before you try gambling, but even as an adult, withhold from spending money in an ill-judged manner. Our company does not encourage you to prefer gambling over other meaningful activities. If gambling is affecting your life or the lives of people close to you, please contact GamCare
 
© 2005-2019 WellDone Creative Software. All rights reserved. Terms and conditions.
BetFair® and the BetFair Logo are registered trade marks of The Sporting Exchange Limited. Gamble responsibly.