Recent Posts

1

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.

2

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.

3

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.

4

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.

5

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.

6

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.

7

Triggered betting / Let luck be your guide, enter and win today!

« Last post by Kevin Smith on 16 May 2024, 17:55 »

We're giving away prizes all the time, so keep entering!

8

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??

9

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  

10

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?