Display Winning Horse, Jockey, Trainer Names with P&L's - Guardian Market List Layout

Get all your markets loaded at once into a fully customisable layout
Post Reply
User avatar
Dallas
Posts: 23543
Joined: Sun Aug 09, 2015 10:57 pm

DanTheMan1 wrote:
Sun Feb 25, 2024 9:10 am
Morning, is there any way of storing the owner of the horse as a stored value? I noticed that the Betfair has OWNER_NAME and was wondering if I could create a text stored value with this information maybe with a text comparison condition? Any help yes or no would be great.
Thanks
There isn't a Stored value to store the owners name (only trainer and jockey names), but if its available on the API then it could easily be added in a future update.

In the mean time you'd need to retrieve it via excel from your own source then import it into Bet Angel as a Stored Value
DanTheMan1
Posts: 65
Joined: Sun Feb 28, 2021 11:12 am

Thanks Dallas
User avatar
gstar1975
Posts: 776
Joined: Thu Nov 24, 2011 11:59 am

I have a list of markets that include both Horses and Dogs. I would like to have P&L for the market for these but I cannot use the Greyhound Information rules file together with the files for the horses. I am having trouble using the bits that i need to work from each of the files needed.

Can anyone help please?
eatyourgreens
Posts: 282
Joined: Sun Feb 18, 2018 12:53 am

hi,
just a thought, could you combine your horse and dog files and add a "text comparison" condition?
ie, for the dogs, market name does contain "gh" and for horses does not contain "gh"

horsey rules will then only fire on horses, and doggy only fire on doggies :)
User avatar
gstar1975
Posts: 776
Joined: Thu Nov 24, 2011 11:59 am

eatyourgreens wrote:
Thu Jun 26, 2025 3:36 pm
hi,
just a thought, could you combine your horse and dog files and add a "text comparison" condition?
ie, for the dogs, market name does contain "gh" and for horses does not contain "gh"

horsey rules will then only fire on horses, and doggy only fire on doggies :)
I understand what you are saying about using the text comparison condition but what is the relevance of the "gh"? yes it means Greyhound but how does the rule know the market contains "gh" all markets do not say Greyhound in them, they show Track Date Time Distance.
eatyourgreens
Posts: 282
Joined: Sun Feb 18, 2018 12:53 am

hmmm,
yea, i could have sworn greys had "gh" in the title. I have used a tactic like this b4, maybe I used a "race distance" condition, I will have a think!
User avatar
jamesedwards
Posts: 4101
Joined: Wed Nov 21, 2018 6:16 pm

Race distances can very occasionally clash.

Use the jockey name of any selection. A horse race will return a jockey name. A dog will return a null value.
User avatar
gstar1975
Posts: 776
Joined: Thu Nov 24, 2011 11:59 am

eatyourgreens wrote:
Thu Jun 26, 2025 3:54 pm
hmmm,
yea, i could have sworn greys had "gh" in the title. I have used a tactic like this b4, maybe I used a "race distance" condition, I will have a think!
Could I use the race distance less than 5f for Greyhounds and greater than or equal to 5f or greater than 943m which is the longest Greyhound race in the UK?
User avatar
gstar1975
Posts: 776
Joined: Thu Nov 24, 2011 11:59 am

jamesedwards wrote:
Thu Jun 26, 2025 4:04 pm
Race distances can very occasionally clash.

Use the jockey name of any selection. A horse race will return a jockey name. A dog will return a null value.
Great idea thank you James. But my problem is when I select the custom columns option to display the profit/loss for the selection there is only no option to select the winner of the market so I select the the market but my rules file only has the selection as Every Selection. My profit and or loss for each runner is not the same as I am not hedging, the profit and loss will be slightly different for each runner. So i need to point the rules file to the winner of the market. But the custom columns doesnt allow you to. I have tried all the selections and it only shows the P/L when i select the selection and by row index betfair order but it will only show the P/L for the runner I select not the winner. Its either all P/L for runner 1 or 2 etc or nothing works.

See file attached
Profit Loss Horses & Dogs with Total Staked and Daily Profit.baf
Profit Loss Horses and Dogs.jpg
Profit Loss Horses and Dogs Auto File.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
gstar1975
Posts: 776
Joined: Thu Nov 24, 2011 11:59 am

Profit Loss Horses and Dogs Auto File 001.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
jamesedwards
Posts: 4101
Joined: Wed Nov 21, 2018 6:16 pm

What exactly is it that you're trying to do?
User avatar
jamesedwards
Posts: 4101
Joined: Wed Nov 21, 2018 6:16 pm

Not sure what you are trying to do, but if you're trying to show your market P&L based on the winning selection then your winnerprofitloss SV needs to be stored at market level.

Mine is called Market_Profit.
z160.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
gstar1975
Posts: 776
Joined: Thu Nov 24, 2011 11:59 am

jamesedwards wrote:
Thu Jun 26, 2025 7:04 pm
What exactly is it that you're trying to do?
I want to have the Profit and or Loss for the winner for each market in a custom column and then have the Daily P/L in another column. Also I wouldnt mind having the Daily total for the Total Staked.

Profit Loss Horses and Dogs 002.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
gstar1975
Posts: 776
Joined: Thu Nov 24, 2011 11:59 am

jamesedwards wrote:
Thu Jun 26, 2025 7:08 pm
Not sure what you are trying to do, but if you're trying to show your market P&L based on the winning selection then your winnerprofitloss SV needs to be stored at market level.

Mine is called Market_Profit.

z160.jpg
How do I make sure its stored at market level?
User avatar
jamesedwards
Posts: 4101
Joined: Wed Nov 21, 2018 6:16 pm

gstar1975 wrote:
Thu Jun 26, 2025 7:42 pm
jamesedwards wrote:
Thu Jun 26, 2025 7:08 pm
Not sure what you are trying to do, but if you're trying to show your market P&L based on the winning selection then your winnerprofitloss SV needs to be stored at market level.

Mine is called Market_Profit.

z160.jpg
How do I make sure its stored at market level?
Change this to "the market"
z161.jpg
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Guardian market list layouts”