How to record bots P&L?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
biggeeman
Posts: 12
Joined: Mon Mar 21, 2022 9:33 am

Hi folk,

New to automation.
How do i record the P&L of a greyhound bot i have made?
I have Linked to the excel sheet - but that changes every race and swipes previous race data.
Obviously the log is there which i would need to manually go through to see my back and lays.
Is there a way of stopping the excel sheet from deleting previous race data?

Ta, Paul
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

There's a Guardian automation file here which will store your P/L, if you needed it into Excel you could then just export the final value each day (or after each market closes)
viewtopic.php?f=56&t=25455
biggeeman
Posts: 12
Joined: Mon Mar 21, 2022 9:33 am

Dallas wrote:
Mon Dec 05, 2022 2:11 pm
There's a Guardian automation file here which will store your P/L, if you needed it into Excel you could then just export the final value each day (or after each market closes)
viewtopic.php?f=56&t=25455
Magic, thank you!
biggeeman
Posts: 12
Joined: Mon Mar 21, 2022 9:33 am

Dallas wrote:
Mon Dec 05, 2022 2:11 pm
There's a Guardian automation file here which will store your P/L, if you needed it into Excel you could then just export the final value each day (or after each market closes)
viewtopic.php?f=56&t=25455
Can you use 2 bots at the same time then?
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

biggeeman wrote:
Mon Dec 05, 2022 3:11 pm
Dallas wrote:
Mon Dec 05, 2022 2:11 pm
There's a Guardian automation file here which will store your P/L, if you needed it into Excel you could then just export the final value each day (or after each market closes)
viewtopic.php?f=56&t=25455
Can you use 2 bots at the same time then?
You could but if they were both running on the same market its isn't possible to distinguish which the P/L's belong to, unless they were straight betting or simple back and lay bots which could use different stakes
biggeeman
Posts: 12
Joined: Mon Mar 21, 2022 9:33 am

Ok, so I'm doing a simple lay the favorite on the dogs.
Using the P&L Bot from here, i have the following:

05/12/2022 17:21:42: [G_Auto 1] : £ 2.00 Lay bet placed on 4. Goldcash Dysart at 3.45. Fully matched at 3.45. Ref: 10227
05/12/2022 17:22:21: Guardian has detected that the market is suspended
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 1. Brennans Debbie: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 2. Yan Tan Tether: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 3. Brennans Darcy: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 4. Goldcash Dysart: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 5. Springview Pal: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 6. Unknown Express: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Store Value (Shared) for 3. Brennans Darcy: Market_Profit = 2
05/12/2022 17:24:52: [G_Auto 2] : Store Value (Shared) for Bet Angel: Total_Profit = 2 + -7.6 = -5.6

Why am i -5.6? when i layed Goldcash and Brennans Darcy won?? confused...
This has happened a lot over say 20 odd races.
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

biggeeman wrote:
Mon Dec 05, 2022 6:03 pm
Ok, so I'm doing a simple lay the favorite on the dogs.
Using the P&L Bot from here, i have the following:

05/12/2022 17:21:42: [G_Auto 1] : £ 2.00 Lay bet placed on 4. Goldcash Dysart at 3.45. Fully matched at 3.45. Ref: 10227
05/12/2022 17:22:21: Guardian has detected that the market is suspended
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 1. Brennans Debbie: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 2. Yan Tan Tether: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 3. Brennans Darcy: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 4. Goldcash Dysart: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 5. Springview Pal: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Automation Signal for 6. Unknown Express: triggered = 1
05/12/2022 17:24:52: [G_Auto 2] : Store Value (Shared) for 3. Brennans Darcy: Market_Profit = 2
05/12/2022 17:24:52: [G_Auto 2] : Store Value (Shared) for Bet Angel: Total_Profit = 2 + -7.6 = -5.6

Why am i -5.6? when i layed Goldcash and Brennans Darcy won?? confused...
This has happened a lot over say 20 odd races.
Your total profit before this market was -£7.60, after winning £2.00 your total profit now is -£5.60
biggeeman
Posts: 12
Joined: Mon Mar 21, 2022 9:33 am

Your total profit before this market was -£7.60, after winning £2.00 your total profit now is -£5.60
Thanks!

But i layed the favorite and another dog won - how is that a loss?
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

biggeeman wrote:
Mon Dec 05, 2022 6:19 pm
Your total profit before this market was -£7.60, after winning £2.00 your total profit now is -£5.60
Thanks!

But i layed the favorite and another dog won - how is that a loss?
Its not a loss, you won £2.00
biggeeman
Posts: 12
Joined: Mon Mar 21, 2022 9:33 am

Dallas wrote:
Mon Dec 05, 2022 6:21 pm
biggeeman wrote:
Mon Dec 05, 2022 6:19 pm
Your total profit before this market was -£7.60, after winning £2.00 your total profit now is -£5.60
Thanks!

But i layed the favorite and another dog won - how is that a loss?
Its not a loss, you won £2.00
Ah! is there some sort of virtual balance in practice mode i don't know about?
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

biggeeman wrote:
Mon Dec 05, 2022 6:33 pm
Dallas wrote:
Mon Dec 05, 2022 6:21 pm
biggeeman wrote:
Mon Dec 05, 2022 6:19 pm
Your total profit before this market was -£7.60, after winning £2.00 your total profit now is -£5.60
Thanks!

But i layed the favorite and another dog won - how is that a loss?
Its not a loss, you won £2.00
Ah! is there some sort of virtual balance in practice mode i don't know about?
There is no virtual balance

When you apply that rules file to your markets it starts at £0.00, and stores the P/L for each market and the total, so at some point since you applied it to your markets you'd lost £7.00

If you add the guardian custom columns you'll be able to see the P/L's for individual markets and the session total as shown in the top image of that post
biggeeman
Posts: 12
Joined: Mon Mar 21, 2022 9:33 am

Dallas wrote:
Mon Dec 05, 2022 6:40 pm
biggeeman wrote:
Mon Dec 05, 2022 6:33 pm
Dallas wrote:
Mon Dec 05, 2022 6:21 pm


Its not a loss, you won £2.00
Ah! is there some sort of virtual balance in practice mode i don't know about?
There is no virtual balance

When you apply that rules file to your markets it starts at £0.00, and stores the P/L for each market and the total, so at some point since you applied it to your markets you'd lost £7.00

If you add the guardian custom columns you'll be able to see the P/L's for individual markets and the session total as shown in the top image of that post
Right, magic, i see what's going on here!
Thanks for your input much appreciated!
Ive started a fresh slate for tonight - i will let it run and see what's what.
I did have way more winners than losers from looking at the log - so here's hoping!
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”