Track profit by turnover

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
tryingtotrade
Posts: 96
Joined: Sun Oct 15, 2023 11:34 pm

Would it be possible to track profit/loss in markets by turnover of a market?
I suspect am doing worser generally in lower liquidity markets, it would be helpful to sort a profit/loss statement that only lists horse racing markets below 100k matched, between 100-200k, above 200k etc.
How would be the best way to go about it? I dont think turnover information is given on the profit/loss statement? Would anyone be able to help with it? Thank you
User avatar
jamesedwards
Posts: 6102
Joined: Wed Nov 21, 2018 6:16 pm

Record your market P&L alongside the traded volume and look for any correlation once you have a decent data sample. I would do this by sorting market volume from low to high, then plotting cumulative P&L against these to see if there are any trends in the curve.

Be aware that traded volume and liquidity are not necessarily the same thing.
tryingtotrade
Posts: 96
Joined: Sun Oct 15, 2023 11:34 pm

You mean manually record? I have automation with every race.
There is not a good way to retrospectively analyse via the profit loss data?
User avatar
jamesedwards
Posts: 6102
Joined: Wed Nov 21, 2018 6:16 pm

tryingtotrade wrote:
Sat Aug 08, 2026 11:49 pm
You mean manually record? I have automation with every race.
There is not a good way to retrospectively analyse via the profit loss data?
You can either export SVs to excel as you go, or, probably simpler, to just export your guardian list of markets each day after trading.
tryingtotrade
Posts: 96
Joined: Sun Oct 15, 2023 11:34 pm

SVs?
But then still need to match it with all the market profit loss over a few months? Don’t know how to do that
User avatar
jamesedwards
Posts: 6102
Joined: Wed Nov 21, 2018 6:16 pm

tryingtotrade wrote:
Mon Aug 10, 2026 10:20 pm
SVs?
But then still need to match it with all the market profit loss over a few months? Don’t know how to do that
SV is a stored value. You can create a rulefile that stores your P&L per market by creating a stored value here. viewtopic.php?t=25455

Then add the stored value to your Guardian screen like this:
z309.jpg

Then at the end of the day export the data from Guardian into a spreadsheet (right click on any market and select 'export the contents of this market list') where you can build a slogger of all your results and compare market volume to your P&L once you have sufficient data.
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”