Guardian profit/loss reports

Discussion regarding the spreadsheet functionality of Bet Angel.
User avatar
MemphisFlash
Posts: 2127
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

my calculations were wrong, but yes it is your sheet with tweaks and charts
User avatar
MemphisFlash
Posts: 2127
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

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

Another bouncy ride, but profit is profit

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

combined 2 day chart and stats

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

And Ready for Tonight

Capture.PNG
You do not have the required permissions to view the files attached to this post.
arch4672
Posts: 51
Joined: Sat Feb 20, 2021 8:40 pm

MemphisFlash wrote:
Thu Mar 23, 2023 10:25 pm
Another bouncy ride, but profit is profit


Capture.PNG
Would it be a less bumpy ride if you didn't use a loss recovery system and just used a constant stake for each bet?
ismailkho
Posts: 1
Joined: Sat Mar 25, 2023 5:59 am

Are you getting your stakes from the MatchedBetsReport files?
User avatar
MemphisFlash
Posts: 2127
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

so far today, 91 races
Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

What are these pl charts supposed to be showing?
User avatar
Derek27
Posts: 23477
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

ShaunWhite wrote:
Sat Mar 25, 2023 2:27 pm
What are these pl charts supposed to be showing?
I've never been into charts but if I did one it would have to be long-term. One day's P/L is only worthy of a single figure.
User avatar
Derek27
Posts: 23477
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

In your VBA editor, select Tools > References to get the dialog box below. Make sure that the 5 references in the graphic are selected and try again. Let me know if it doesn't work.

Screenshot 2023-09-14 191805.png
You do not have the required permissions to view the files attached to this post.
jtrader
Posts: 100
Joined: Thu Feb 09, 2017 11:35 am

I've received that message error and I couldn't manage that

Екранна снимка (813).png
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23477
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

jtrader wrote:
Mon Mar 18, 2024 12:19 pm
I've received that message error and I couldn't manage that


Екранна снимка (813).png
If you find the CreateReport subroutine and remove the On Error line I've marked in red, it won't solve the problem but the code will break wherever the error is occurring. If you post a screenshot of that I may be able to figure out what's wrong.

Screenshot 2024-03-18 155733.png
You do not have the required permissions to view the files attached to this post.
jtrader
Posts: 100
Joined: Thu Feb 09, 2017 11:35 am

Thanks,Derek27!

That's message when I've removed that row in code


Екранна снимка (814).png
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23477
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

jtrader wrote:
Mon Mar 18, 2024 7:06 pm
Thanks,Derek27!

That's message when I've removed that row in code



Екранна снимка (814).png
Sorry, can you press the "Debug" button and show me a screenshot of the highlighted code where it failed.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”