Recent Posts

Pages: « 1 2 3 4 5 6 7 8 9 10 »
41
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.
42
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.
43
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.
45
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??
46
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  
47
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?
48
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


 
50
Troubleshooting / Re: Need help - Write to a file
« Last post by joaofrancisco on 14 May 2024, 12:52 »
Sorry, I click to post by mistake.... I missed to put my files for you, to see what is wrong.

Example:

Date                 MarketName                                                                                SelectionName     SP        Stake
5/14/2024      Horse Racing / GB / Wolverhampton 29th Apr/ 17:30 6f Nov Stks       Marry The Night   5.00     10.00
Pages: « 1 2 3 4 5 6 7 8 9 10 »
Please note, BetFair is seems to be currently OFFLINE