Custom Columns - Sort in Order of Favouritism

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
Radio Rod
Posts: 29
Joined: Sun Aug 15, 2021 10:16 pm

In many races, mostly dogs but sometimes horses, the 1st Betfair row is not the favourite. I have written some automation that Fixes the order of favouritism before the off based on back odds and then places a Back Bet on the favourite (Position 1 sorted in order of favouritism).

I'm creating a Guardian layout with a custom column to show the name of the selection, rather like the "Fav Form" example in the Customize Guardian Columns and Market List Layout thread viewtopic.php?t=22648

Unlike in the example, Sorted in Order of Favouritism does not appear in my Selection drop down menu. I can only choose the selection by Betfair order, Back Price, Lay Price, Last Traded Price, Starting Price, Volume, Nomination or Rank (see attached image). What am I missing please? How do I get Sorted in Order of Favouritism to appear in the drop down?
You do not have the required permissions to view the files attached to this post.
User avatar
Dallas
Posts: 23596
Joined: Sun Aug 09, 2015 10:57 pm

By position is order of favouritism

But without checking I think 'Fixing the order of favouritism' is only applicable to the automation rules so using the above may keep changing as the prices move

The other way would be to run a 'Update custom ranking' rule and select 'ascending' order on the parameters tab
Make sure to only have it trigger once at the same time as your 'Fix Order' rule does

Then select the custom rank option the custom column editor and set it to 1
Radio Rod
Posts: 29
Joined: Sun Aug 15, 2021 10:16 pm

By Position is only order of favouritism for that parameter, they may all be different favourites!

I noticed that your thread for selecting a runner had the attached file which shows the selection to be in position 1 in order of favouritism, I don't see this option in my Guardian drop down box.

I'll investigate custom ranking further as I think this relates to fixing the order.
You do not have the required permissions to view the files attached to this post.
User avatar
Dallas
Posts: 23596
Joined: Sun Aug 09, 2015 10:57 pm

That screenshot was from an older version which used your main favouritism sort order so it was somewhat restricted
Whereas now you can set how the favouritism sort order is done for each custom column, independent from your main settings and each other
User avatar
MemphisFlash
Posts: 2337
Joined: Fri May 16, 2014 10:12 pm

you mean like this
Capture.PNG
You do not have the required permissions to view the files attached to this post.
Radio Rod
Posts: 29
Joined: Sun Aug 15, 2021 10:16 pm

That looks good Memphis, but I want to see it as a list of event results in Guardian, with the Event, Event Time, my Selection, my Selection's Result, Event P/L

e.g.

Casino (AUS) 08:25 Flashman Winner £1.50
Casino (AUS) 08:46 Lucky Jim Loser -£0.50
Radio Rod
Posts: 29
Joined: Sun Aug 15, 2021 10:16 pm

Phew! Done it :D
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2337
Joined: Fri May 16, 2014 10:12 pm

how did you do it?

mine looks like this
Capture.PNG
You do not have the required permissions to view the files attached to this post.
Radio Rod
Posts: 29
Joined: Sun Aug 15, 2021 10:16 pm

1. As Sort in Order of Favouritism is no longer supported Custom Columns I have removed the Fix the Order rule and replaced it with "Update Custom Ranking (Ascending) by Back Odds" in my automation. All references to my selection are now by Ranking (rank 1 in Custom Ranking 1).

2. I save a Stored Value for the selection's win status and then check to see if this is a Winner or Loser. If it's a winner then I use the Profit & Loss of a selection for the Market Profit, if it's a loser then I multiply the total stake by -1 and use that as the Market Profit.

3. My automation then works out the value of stake for the next race dependent on a couple of selection criteria and the P/L. Essentially this is a Back the Favourite progression system with a stop loss reset after 6 successive losses. I am currently using the Place market as there is a very high strike rate so the progression does not have to be too aggressive to return a profit. I can change the progression between all of the well known ones; Martingale, Fibonnaci, etc dependent on what best suits the market. More of a gamble than a trade, but relatively safe. I've done a progression system for Laying too, but the numbers get scary very quickly!

Rod
User avatar
Dallas
Posts: 23596
Joined: Sun Aug 09, 2015 10:57 pm

Radio Rod wrote:
Thu Jul 18, 2024 3:53 pm
1. As Sort in Order of Favouritism is no longer supported Custom Columns I have removed the Fix the Order rule and replaced it with "Update Custom Ranking (Ascending) by Back Odds" in my automation. All references to my selection are now by Ranking (rank 1 in Custom Ranking 1).
It is still supported - you've got the 'Sort order of favouritism' option selected in your original image
Custom Column.jpg

As I said above originally your main favouritism sort order was automatically used across all custom columns
Whereas now you can set how the favouritism sort order is done for each custom column using any of the options highlighted above, so it is now independent from your main settings and each other custom column
You do not have the required permissions to view the files attached to this post.
Radio Rod
Posts: 29
Joined: Sun Aug 15, 2021 10:16 pm

Slight misunderstanding here Dallas.

In Automation Rules you can apply the rule to a selection by order of favouritism. This is what my image of the Automation Rules Editor shows.

Sort by Favouritism is not in the Custom Column box in v1.61, that is what my image of Custom Columns shows.

Sort by Favouritism was shown as an option in your thread "Creating Your Own Guardian Custom Columns" using v1.56 from 16 Jan 2021. That is what my image of "Columns in profile" shows.

You've highlighted Position Sorted by Back Price, but this is not the same as Sorted by Favouritism as the Back Price for all the runners may have changed from when the Order was Fixed and another selection now has a shorter back price.

Your suggestion of using Update Custom Ranking instead of fixing the order by favouritism has worked for me, so all's good in the end.
User avatar
Dallas
Posts: 23596
Joined: Sun Aug 09, 2015 10:57 pm

Radio Rod wrote:
Thu Jul 18, 2024 5:43 pm
Slight misunderstanding here Dallas.

In Automation Rules you can apply the rule to a selection by order of favouritism. This is what my image of the Automation Rules Editor shows.

Sort by Favouritism is not in the Custom Column box in v1.61, that is what my image of Custom Columns shows.

Sort by Favouritism was shown as an option in your thread "Creating Your Own Guardian Custom Columns" using v1.56 from 16 Jan 2021. That is what my image of "Columns in profile" shows.

You've highlighted Position Sorted by Back Price, but this is not the same as Sorted by Favouritism as the Back Price for all the runners may have changed from when the Order was Fixed and another selection now has a shorter back price.

Your suggestion of using Update Custom Ranking instead of fixing the order by favouritism has worked for me, so all's good in the end.
As stated earlier 'Sort by favourite in the rules editor' and 'sort by position' both mean and do the same thing - its just a difference in wording

By default the 'Order of Favouritism' in your rules editor uses the 'back price' to define the favouritism order, but this can be changed in your main settings area to lay price, LTP, actual SP, and even traded volume
https://www.betangel.com/user-guide/bas ... tings.html

In the Custom column editor you can now specify how you want the favouritism sorted for that individual custom column - rather than using whatever your main settings are using

So you could have two custom columns one sorting the order favouritism by back price at 5 mins to post, the other sorting the order of favouritism by actual SP


My earlier comment about fixing the order was in regards to not knowing (without testing) if the custom column would pick this up or if it was only the other rules within that file that would apply to
But I knew the custom ranking would do this providing it was only triggered once

Glad you've got it working though but hope that clears up the confusion with regards to the custom column having the same options as the rules editor does
Radio Rod
Posts: 29
Joined: Sun Aug 15, 2021 10:16 pm

Thanks Dallas, and sorry to be such a pain, I was confused by the whole thing! Sorted now.

This bit is really useful as I wondered how it was done if you were sorting by Back Odds ...

"By default the 'Order of Favouritism' in your rules editor uses the 'back price' to define the favouritism order, but this can be changed in your main settings area to lay price, LTP, actual SP, and even traded volume"

Thanks for your time and patience.
Post Reply

Return to “Bet Angel - Automation”