Recent Posts

Pages: « 1 2 3 4 5 6 7 8 9 10 »
81
Troubleshooting / Re: Need help - Write to a file
« Last post by joaofrancisco on 17 May 2024, 20:26 »
I already made it.. It´s the parameter [lay_matched]
82
Troubleshooting / Re: Need help - Write to a file
« Last post by joaofrancisco on 17 May 2024, 19:42 »
Thanks MarkV... 

It worked but that is only one thing that is not right. It doesn´t put the stake. I have the parameter [lay_sptotal] but it seems not working. Maybe it´s not the right parameter.


MarketName,SelectionName,SP,Stake
"17/05/2024","Horse Racing / IRE / Leopardstown 17th May / 18:40 Leopardstown 17th May - 1m4f Hcap - 1m4f Hcap","Rotolo",6.57,0.00
83
Triggered betting / Re: most_traded_price in-play only
« Last post by MarkV on 17 May 2024, 18:46 »
Hi
I don't think this would be possible to do because you would need to monitor traded volume for every price tick and then sort them lowest to highest. most_traded_price data is provided directly by Betfair.    
84
Triggered betting / Re: Write selected data to Excel sheet
« Last post by MarkV on 17 May 2024, 18:26 »
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
Hi bobh
Please can you confirm you definitely want to write this data directly from MFP to Excel using the connection link to Excel? The reason I ask is because the Excel link is known to be unreliable and consumes a lot of system resource. The preferred and efficient method is to write to a csv text file which can be opened in Excel. If you let me know which one you want to use I'll have a look at this.
85
Troubleshooting / Re: Need help - Write to a file
« Last post by MarkV on 17 May 2024, 18:11 »
Hi
Please try the attached trigger in test mode. The laying trigger is so I could test the trigger on a days markets. I have disabled it but you should put your laying trigger in the same place.

The trigger will write headers to the text file at the start of the day and will add entries to the file as each market goes in-play.
The name of the text file contains the date string.
86
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.
87
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.
88
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.
89
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.
Pages: « 1 2 3 4 5 6 7 8 9 10 »
Please note, BetFair is seems to be currently OFFLINE