Post by timosar on Aug 30, 2020 6:24:32 GMT
Hi Fabrizio!
Thanks for the great software!
I have bit of a problem with this 3.0 version.
My SQL skills are very limited, but with help of Google and studying Ipposnif I have learned to do some modifications of my own.
In version 2.4 I used the custom selection criteria a lot.
In dbo.tbl_Races_Horses I created my own columns, for example "Drift" where horse gets a computed value based on a odd movements and I want to lay the horse with the highest value.
So in strategy I used the custom selection criteria and I modified the function dbo.fun_tbl_Horse_Selection accordingly:
if @prop='favourite_by_custom_desc'
begin
insert into @r
select id_horse from (select ROW_NUMBER() OVER(ORDER BY Drift desc) AS Row, id_horse from tbl_Races_Horses
where ID_Race=@id_race and [status]<>'REMOVED' and ISNULL(quotabf,0)>0) dvtbl where ROW = 1
This doesn't seem to work anymore in 3.0 version, I made the same changes, but strategy picks up wrong horses. That Custom is not available in a list anymore so I made the change in some other criteria, but no success.
Other change I found useful:
The price three or two hours before race is quite useless in horse and greyhound races. Horse races especially often have minute or two delay between the race time and actual start.
In that time the odds can vary significantly and especially in trading, much more useful info is what the price is at the race time and one minute after race time(if not in-play already)
In stored procedure dbo.sp_parse_listMarketBook I changed the lines:
QuotaBF180=case when datediff(minute,@cdate,racedatetime) <=0 and quotabf180 is null then lastPriceTraded else QuotaBF180 end,
QuotaBF120=case when datediff(minute,@cdate,racedatetime) <=-1 and QuotaBF120 is null then lastPriceTraded else QuotaBF120 end
So variable @price_180 becomes kind of a "@price_0", price at the race start time
and @price_120 becomes "@price_-1" price one minute after race start time.
Regards
Timo
Thanks for the great software!
I have bit of a problem with this 3.0 version.
My SQL skills are very limited, but with help of Google and studying Ipposnif I have learned to do some modifications of my own.
In version 2.4 I used the custom selection criteria a lot.
In dbo.tbl_Races_Horses I created my own columns, for example "Drift" where horse gets a computed value based on a odd movements and I want to lay the horse with the highest value.
So in strategy I used the custom selection criteria and I modified the function dbo.fun_tbl_Horse_Selection accordingly:
if @prop='favourite_by_custom_desc'
begin
insert into @r
select id_horse from (select ROW_NUMBER() OVER(ORDER BY Drift desc) AS Row, id_horse from tbl_Races_Horses
where ID_Race=@id_race and [status]<>'REMOVED' and ISNULL(quotabf,0)>0) dvtbl where ROW = 1
This doesn't seem to work anymore in 3.0 version, I made the same changes, but strategy picks up wrong horses. That Custom is not available in a list anymore so I made the change in some other criteria, but no success.
Other change I found useful:
The price three or two hours before race is quite useless in horse and greyhound races. Horse races especially often have minute or two delay between the race time and actual start.
In that time the odds can vary significantly and especially in trading, much more useful info is what the price is at the race time and one minute after race time(if not in-play already)
In stored procedure dbo.sp_parse_listMarketBook I changed the lines:
QuotaBF180=case when datediff(minute,@cdate,racedatetime) <=0 and quotabf180 is null then lastPriceTraded else QuotaBF180 end,
QuotaBF120=case when datediff(minute,@cdate,racedatetime) <=-1 and QuotaBF120 is null then lastPriceTraded else QuotaBF120 end
So variable @price_180 becomes kind of a "@price_0", price at the race start time
and @price_120 becomes "@price_-1" price one minute after race start time.
Regards
Timo