nifty
New Member
Posts: 5
|
Post by nifty on Sept 13, 2020 2:34:54 GMT
Hi, Can somebody help me with some coding please. I would like to code that I would like to back a last start winner carrying a weight today between 54kg and 56kg or above 63kg. Thanks. Nifty
|
|
|
|
Post by Ipposnif on Sept 13, 2020 9:22:11 GMT
Hi,
what you asked for is possible, but I found just now a bug in the @weight variable that makes the thing a bit more tricky.
So first, you have to fix the bug yourself (it will be fixed for all the users in the next release):
From the program, open Tools -> Database Command
Copy/paste the following SQL in the top text area and press button "Execute"
update tbl_SysVariables set Funct='select @weight=case when (select [valuenum] from tbl_syscfg where codice=''weight_in_kilograms'')=0 then case when weight_unit=''pounds'' then [weight] else case when weight_unit=''kg'' then convert(int,[weight]/0.45359237) else 0 end end else case when weight_unit=''pounds'' then [weight]*0.45359237 else case when weight_unit=''kg'' then [weight] else 0 end end end from [tbl_Races_Horses] where ID_race=@id_race and ID_Horse=@id_horse' where Name='weight'
you should see in the bottom text area:
Execute completed successfully.
The bug is fixed.
Now the strategy:
You work with kilograms so you have to switch from pounds to kilograms from the program options.
The condition you have to insert in the "Trigger Condition" of the Bet is:
@form like '%1' and ((@weight between 54 and 56) or (@weight > 63))
This condition works only with races that provide both the form of the runner and its weight (GB, IE, US, ZA, etc..).
In the next post, I'm going to publish an example strategy that uses this condition.
|
|
|
|
Post by Ipposnif on Sept 13, 2020 9:57:41 GMT
 |
- Maximum 3 markets with open bets at the same time. Each market can have a maximum of three bets on three different runners.
- Bets are placed only on the HORSE RACING markets.
- Bets are placed in the timeframe that goes from 1 minute at the start to 1 minute after the programmed start of the race (the race has no more delay than 1 minute). Only if the market is not in-play (Pre).
- This is the core condition provided in the previous post.
- The best back price at 1 minute at the start is used. If the bet remains unmatched it will be used the reconciliation starting price provided by Betfair when the market is closed (or goes in-play).
- Every bet has a fixed size of 1.
- If the bet remains unmatched during the placement (the price moved in the meanwhile), every 5 seconds update the price to the new best BACK price.
|
Enjoy! |
|
nifty
New Member
Posts: 5
|
Post by nifty on Sept 14, 2020 2:21:23 GMT
Hi Administrator, thank you so much for the fix and coding and also for your program. The bug fix worked fine and I have coded in your wording. I will let you know how it goes.
Also, I just have another thought, I can start a new strategy thread if you wish.
I would like to know if there is a way to also code in market firmers? For example if a horse has met the last start winner and weight carried criteria and has also firmed say 5% or more from it's price as it was at 10 minutes to start time.
Thanks again for your help.
Regards
Nifty
|
|
nifty
New Member
Posts: 5
|
Post by nifty on Sept 16, 2020 6:03:23 GMT
Hi, after much experimentation the following coding seems to work, @form like '%1' and ((@weight between 54 and 56) or (@weight > 63)). I have found that it needs to be inserted under Runner Filters and SQL Assertion. I tried but couldn't get it to work under Trigger Condition. Regards Nifty
|
|
