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

[gstar1975]

You can take whatever information from the full market name given by Betfair (how it appears in the 'Markets' column) that you want

In the example it only takes the last part. How do I get the full race type description like Nov Hcap Hrd which has 3 parts. Some descriptions have 1, 2 or 3 parts.


How to get the Race Type grade into a custom column 001.jpg

You'll need to use a Set/Modify Stored Value' rule and store a value as text
https://www.betangel.com/user-guide/sto ... _text.html

From there you can store the market name and have a lot more options over which parts you want.
Once you've done that you just need the custom column to look for the stored value name you gave it

I've had play with this before and this is the bit I am trying to achieve but can't get it to work. I know how to store the market name but after that I have no clue what to do. Do I need another rule?

[jamesedwards]

In the example it only takes the last part. How do I get the full race type description like Nov Hcap Hrd which has 3 parts. Some descriptions have 1, 2 or 3 parts.


How to get the Race Type grade into a custom column 001.jpg

You'll need to use a Set/Modify Stored Value' rule and store a value as text
https://www.betangel.com/user-guide/sto ... _text.html

From there you can store the market name and have a lot more options over which parts you want.
Once you've done that you just need the custom column to look for the stored value name you gave it

I've had play with this before and this is the bit I am trying to achieve but can't get it to work. I know how to store the market name but after that I have no clue what to do. Do I need another rule?

Which bit of the market name do you want?

This gets you the whole thing stored as a stored value called "market name" stored at market level.

You can truncate as you wish using the options in the stored values tab.

test 10.baf

[jamesedwards]

How can I get the Race Type eg Hcap, Hcap Chs, Nov Hcap Chs into a custom column on Guardian. I need it so I can sort the list to race type so I can easily select and assign the automation files.


How to get the Race Type grade into a custom column.jpg

Depending on your set-up, you might well find it easier to have all your different rules in one single rulesfile, then use text conditions so only the relevant bits of the rule trigger on the relevant races.

z173.jpg

[gstar1975]

You'll need to use a Set/Modify Stored Value' rule and store a value as text
https://www.betangel.com/user-guide/sto ... _text.html

From there you can store the market name and have a lot more options over which parts you want.
Once you've done that you just need the custom column to look for the stored value name you gave it

I've had play with this before and this is the bit I am trying to achieve but can't get it to work. I know how to store the market name but after that I have no clue what to do. Do I need another rule?

Which bit of the market name do you want?

This gets you the whole thing stored as a stored value called "market name" stored at market level.

You can truncate as you wish using the options in the stored values tab.

test 10.baf

Everything after the distance on horse races. So it could be just Hcap or Nov Hcap or Nov Hcap Chs.

[jamesedwards]

I've had play with this before and this is the bit I am trying to achieve but can't get it to work. I know how to store the market name but after that I have no clue what to do. Do I need another rule?

Which bit of the market name do you want?

This gets you the whole thing stored as a stored value called "market name" stored at market level.

You can truncate as you wish using the options in the stored values tab.

test 10.baf

Everything after the distance on horse races. So it could be just Hcap or Nov Hcap or Nov Hcap Chs.

Here you go.

Couldn't figure out how to truncate it using a single rule, (it might be possible, I don't know this area very well).

But here's a workaround that does it using three lines. Creates a stored value called "market name" which contains only the info you require.

test 10.baf

[Medicalshirt]

Just modify this list and add them yourself.

https://www.youtube.com/watch?v=8wJb6r2Ov80

Okay, many thanks.

[gstar1975]

Which bit of the market name do you want?

This gets you the whole thing stored as a stored value called "market name" stored at market level.

You can truncate as you wish using the options in the stored values tab.

test 10.baf

Everything after the distance on horse races. So it could be just Hcap or Nov Hcap or Nov Hcap Chs.

Here you go.

Couldn't figure out how to truncate it using a single rule, (it might be possible, I don't know this area very well).

But here's a workaround that does it using three lines. Creates a stored value called "market name" which contains only the info you require.


test 10.baf

Thanks James. I'll take a look tomorrow.

[gstar1975]

Which bit of the market name do you want?

This gets you the whole thing stored as a stored value called "market name" stored at market level.

You can truncate as you wish using the options in the stored values tab.

test 10.baf

Everything after the distance on horse races. So it could be just Hcap or Nov Hcap or Nov Hcap Chs.

Here you go.

Couldn't figure out how to truncate it using a single rule, (it might be possible, I don't know this area very well).

But here's a workaround that does it using three lines. Creates a stored value called "market name" which contains only the info you require.


test 10.baf

This is the outcome. Also you didn't have shared boxed ticked. I appreciate any further input. Great start!

How to get the Race Type grade into a custom column 002.jpg

[jamesedwards]

Everything after the distance on horse races. So it could be just Hcap or Nov Hcap or Nov Hcap Chs.

Here you go.

Couldn't figure out how to truncate it using a single rule, (it might be possible, I don't know this area very well).

But here's a workaround that does it using three lines. Creates a stored value called "market name" which contains only the info you require.


test 10.baf

This is the outcome. Also you didn't have shared boxed ticked. I appreciate any further input. Great start!


How to get the Race Type grade into a custom column 002.jpg

Works fine for me.

z174.jpg

Perhaps you're not looking up the correct SV in your custom column?

z175.jpg

[gstar1975]

Here you go.

Couldn't figure out how to truncate it using a single rule, (it might be possible, I don't know this area very well).

But here's a workaround that does it using three lines. Creates a stored value called "market name" which contains only the info you require.


test 10.baf

This is the outcome. Also you didn't have shared boxed ticked. I appreciate any further input. Great start!


How to get the Race Type grade into a custom column 002.jpg

Works fine for me.


z174.jpg



Perhaps you're not looking up the correct SV in your custom column?


z175.jpg

Tried it again without any changes and it worked. So not sure what happened. Thanks James.

[gstar1975]

How can I get the Track name with 2 parts? Like Down Royal?

How to get the Track Name with 2 parts.jpg

[jamesedwards]

How can I get the Track name with 2 parts? Like Down Royal?


How to get the Track Name with 2 parts.jpg

Do the reverse of what I did before. Make an SV = the first two words of the market name, and if any numerical value remains then make the SV = only the first name.

But do you need to? The only other "down" is Downpatrick but that is all one word, so "down" will always = Down Royal.

[SpikeyBob]

Can you not just use Venue Name?

This is from v1 of my Horse Racing Data Capture Automation :

VenueSV.jpg

... and how it looks in the recorded file (for Market Details):

VenueSV2.jpg

I'm assuming this will work in the columns as well, but not tried it.