Guardian profit/loss reports

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
Derek27
Posts: 23618
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

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.
You do not have the required permissions to view the files attached to this post.
Last edited by Derek27 on Wed Mar 15, 2023 2:06 am, edited 1 time in total.
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.PNG

might need a slight adjustment to your path directory

nice work. :D :D :D
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2147
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. :o

Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23618
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

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. :)
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.PNG
your sheet working perfectly
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

added a couple of formulae to get strike rate
Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23618
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

MemphisFlash wrote:
Wed Mar 15, 2023 2:22 pm
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.
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

i just enhanced what you already had. :D
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

now got a groovy chart added to it , lol

Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

blank sheet ready for the day

Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.PNG
Well Pimped up now
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Bumpy ride so far today

Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
jamesedwards
Posts: 2299
Joined: Wed Nov 21, 2018 6:16 pm

MemphisFlash wrote:
Wed Mar 22, 2023 11:57 am
Capture.PNG

Well Pimped up now
Could you share this please?
User avatar
jamesedwards
Posts: 2299
Joined: Wed Nov 21, 2018 6:16 pm

Derek27 wrote:
Tue Mar 14, 2023 9:49 pm
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.
Nice! :mrgreen:
User avatar
Derek27
Posts: 23618
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

MemphisFlash wrote:
Wed Mar 22, 2023 5:08 pm
Bumpy ride so far today


Capture.PNG
Are you getting your stakes from the MatchedBetsReport files?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”