Recent Posts

Pages: 1 2 3 4 5 6 7 8 9 10
1
Triggered betting / Re: Selections p/l after event is settled
« Last post by MarkV on 17 May 2024, 16:04 »
Hi
Not tested this but if you are backing in win markets, the selection who's lay price is 1.01 is the potential winner, all other selections with back bets are potential losers.

so 2 triggers:

1st trigger as above, first matching selection, condition: selections lay price is equal to 1.01

2nd trigger sets a user variable individually per selection value: -back_matched
all matching selections
conditions:
trigger 1st trigger number of runs in the market is greater than 0
and selections back matched is greater than 0
and selections back price is equal or greater than greater than 1.01

this records the winners profit and assumes the liability for the others as a loss 

I don't think this is watertight because a lay price of 1.01 can still be overturned, or the market could be reopened after suspension etc. and also it does not take into account commission on the winning bets.
2
Triggered betting / Re: Selections p/l after event is settled
« Last post by djmotion on 17 May 2024, 03:08 »
Another option could be to set up a virtual bankroll for each runner and have conditions to only trigger if that runner reaches 1.01 lay price then it can take market_settled_pl and also only add to the virtual bank if the new amount would be higher than the old amount. Then again, the other runners would affect p/l so would need to add the bets back on anyways.
3
Triggered betting / Re: Selections p/l after event is settled
« Last post by djmotion on 17 May 2024, 03:04 »
Hi
I thought it would be a good idea but looking closer it wont work because a selection's p/l can be affected by other selections with bets. I will give this some more thought and post here if I come up with something.
 Could I not work out the p/l on the runner by taking the tradeout_pl and then adding the other bets. so if my variables are bet_1, bet_2, bet_3, bet_4 in relation to each fave then if the runner I'm taking the p/l for is the 3rd fave. Could I not do tradeout_pl on the 3rd fave + bet_1 + bet_2 + bet_4 which will give me the p/l for the 3rd fave.
So if the 3rd fave wins and the market is finished and the profit on the 3rd fave is £10. My bets for 1st, 2nd, and 4th fave are all £1 then if I were to just take tradeout_pl, it should equal £7 but if I add all them bets back on, I should get £10.
4
Triggered betting / Re: Selections p/l after event is settled
« Last post by MarkV on 16 May 2024, 18:20 »
Hi
I thought it would be a good idea but looking closer it wont work because a selection's p/l can be affected by other selections with bets. I will give this some more thought and post here if I come up with something.
6
Triggered betting / Re: Selections p/l after event is settled
« Last post by djmotion on 16 May 2024, 14:01 »
Hi
selection p/l is not available in settled markets, but here is something you can play with which will capture p/l just before market is settled:

in the settings make sure show p/l net of exchange commission is unticked

set a user variable with value: tradeout_pl individually per selection
once per market
market status: in-play or suspended
conditions:
at least one selections lay price is equal to 1.01
and markets race status is finished

you can change or add conditions as to when you best want to record the p/l's but the user variable should show each selections p/l after the market has been settled  
Hey, thanks for the reply. So if I set this up on the first 4 runners. Effectively, it would take the current p/l for the runner if the lay odds are 1.01 when the market is finished meaning the runner has secured victory so then I can use this to calculate my running total p/l for each selection? So I can do that for calculations after a win. For losses, would I set up the same trigger but have conditions for market is finished and tradeout_pl for selection is < 0??
7
Triggered betting / Re: Selections p/l after event is settled
« Last post by MarkV on 16 May 2024, 11:10 »
Hi
selection p/l is not available in settled markets, but here is something you can play with which will capture p/l just before market is settled:

in the settings make sure show p/l net of exchange commission is unticked

set a user variable with value: tradeout_pl individually per selection
once per market
market status: in-play or suspended
conditions:
at least one selections lay price is equal to 1.01
and markets race status is finished

you can change or add conditions as to when you best want to record the p/l's but the user variable should show each selections p/l after the market has been settled  
8
Triggered betting / most_traded_price in-play only
« Last post by soylolo on 15 May 2024, 23:48 »
If i'm not mistaken, most_traded_price is overall (pre and post off)

Is there a way to make most_traded_price reset at inplay starts? So it only counts inplay information

If not, what would be the formula to custom make it?
9
Triggered betting / Re: Write selected data to Excel sheet
« Last post by bobh on 15 May 2024, 13:42 »
Hello,
I have just noticed this topic and the replies, where a solution was offered by writing to a CSV file.

Can I ask if a solution could be provided for writing to an Excel spreadsheet with the details across the page, not down?

There is a sample trigger provided (in Features/Triggers/Excel) for horse racing for feeding prices into Excel, but I am having trouble working out what needs to be altered in the "Initialise sheet" and or/ "Initialise the variables" to feed the details across the page rather than down.

I am interested in doing this for soccer games with an example below:

Match Details  Home Team  MO Back Price   Away Team   MO Back Price  MO Draw Price  Winner (when known).

EPL etc           Liverpool         $1.80           Tottenham         $2.50             $4.00            Home

Is this possible?

Thanks in advance,

bobh


 
Pages: 1 2 3 4 5 6 7 8 9 10
Please note, BetFair is seems to be currently OFFLINE