Guardian profit/loss reports

[Derek27]

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.

[MemphisFlash]

Capture.PNG

might need a slight adjustment to your path directory

nice work.

[MemphisFlash]

did a little tidy up of your buttons
If you hold ALT when stretching your buttons it snaps to the grid.

Capture.PNG

[Derek27]

Cheers, I didn't know you could do that. I spent a bit of time wrestling with them and then just placed them in the centre.

[MemphisFlash]

Capture.PNG

your sheet working perfectly

[MemphisFlash]

added a couple of formulae to get strike rate

Capture.PNG

[Derek27]

Capture.PNG

added a couple of formulae to get strike rate

User interfaces have never been my strong point.

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]

i just enhanced what you already had.

[MemphisFlash]

now got a groovy chart added to it , lol

Capture.PNG

[MemphisFlash]

blank sheet ready for the day

Capture.PNG

[MemphisFlash]

Capture.PNG

Well Pimped up now