I've written a VBA module that scans the profit and loss CSVs that Guardian creates and produces a report listing. To use it, make sure macros are enabled, press the Browse button and locate your MarketReports folder. By default it will be in:
<System Volume>\Users\<Username>\AppData\Roaming\Bet Angel\Bet Angel Professional
Save the workbook.
Select your desired date range, either from the dropdown menu or enter your custom start and end dates.
Press the Create Report button.
You can toggle-sort the columns by pressing the title buttons at the top of each column.
I don't trade place markets but I placed a few bets in practice mode and it seems to work fine on place markets.
Guardian profit/loss reports
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
might need a slight adjustment to your path directory
nice work.



You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
did a little tidy up of your buttons
If you hold ALT when stretching your buttons it snaps to the grid.
If you hold ALT when stretching your buttons it snaps to the grid.

You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
your sheet working perfectly
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
added a couple of formulae to get strike rate
You do not have the required permissions to view the files attached to this post.
User interfaces have never been my strong point.MemphisFlash wrote: ↑Wed Mar 15, 2023 2:22 pmCapture.PNG
added a couple of formulae to get strike rate

I only created it for small-stake automation testing but it might be worth my while making sure all my manual markets are in Guardian to get a complete daily report, then getting the markets copied into my accounting database. Manual updating is getting tiresome as the number of markets go up.
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i just enhanced what you already had. 

- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
now got a groovy chart added to it , lol
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
blank sheet ready for the day
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Well Pimped up now
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2079
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Bumpy ride so far today
You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 1881
- Joined: Wed Nov 21, 2018 6:16 pm
Could you share this please?
- jamesedwards
- Posts: 1881
- Joined: Wed Nov 21, 2018 6:16 pm
Nice!Derek27 wrote: ↑Tue Mar 14, 2023 9:49 pmI've written a VBA module that scans the profit and loss CSVs that Guardian creates and produces a report listing. To use it, make sure macros are enabled, press the Browse button and locate your MarketReports folder. By default it will be in:
<System Volume>\Users\<Username>\AppData\Roaming\Bet Angel\Bet Angel Professional
Save the workbook.
Select your desired date range, either from the dropdown menu or enter your custom start and end dates.
Press the Create Report button.
You can toggle-sort the columns by pressing the title buttons at the top of each column.
I don't trade place markets but I placed a few bets in practice mode and it seems to work fine on place markets.

Are you getting your stakes from the MatchedBetsReport files?