Author Topic: price with conditions, conditional prices  (Read 8928 times)

Tags:
  • Guest
price with conditions, conditional prices
« on: 09 Apr 2013, 11:56 »
I need help to translate/enter prices with conditions into the trigger-price-field (I often use conditional-prices):

1) if price is between a and b, then place amount x, otherwise place amount y

2) (for placing a lay bet:) r_ticks(back_price,1), but dont place a price under 1.20 and over 5.0

thx.

  • Moderator
  • Posts: 3631
*
Re: price with conditions, conditional prices
« Reply #1 on: 09 Apr 2013, 12:42 »
I need help to translate/enter prices with conditions into the trigger-price-field (I often use conditional-prices):

1) if price is between a and b, then place amount x, otherwise place amount y
Price:
IF(AND(back_price>=a, back_price<=b),x ,y)




2) (for placing a lay bet:) r_ticks(back_price,1), but dont place a price under 1.20 and over 5.0
Lay
Price: r_ticks(back_price,1)
Condition:
and selection’s back price is between 1.19 and 4.90


thx.
Hi - see above
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: price with conditions, conditional prices
« Reply #2 on: 09 Apr 2013, 12:47 »
hi
IF(AND(lay_price>=a,lay_price<=b),x,y)
IF(AND(back_price>=a,back_price<=b),x,y)
you will have to fill a,b,x and y yourself.
IF(AND(lay_price>=1.20,lay_price<=5),r_ticks(back_price,1),0)
but with this one you are better to use the condition
and selections lay price is between 1.20 and 5.00
then put your r_ticks(back_price,1) in the price box


mcbee

we replied at the same time ;D
and mark i noticed you missed a , out in your forumla :o
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Guest
Re: price with conditions, conditional prices
« Reply #3 on: 09 Apr 2013, 12:53 »
thx to both of you, as always very fast. much appreciated.

1) ok, easy, as in excel. tried it once and didnt work, but surely with yours it will work.

2) I thought the solutions you gave.
but when the lay-price respevtice the r_ticks(back_price,1) ist over 5, lets say 8, I want YES a placed bet but at maximum 5, so I am in the queue at price 5 with my lay bet. is that possible?

  • Moderator
  • Posts: 3631
*
Re: price with conditions, conditional prices
« Reply #4 on: 09 Apr 2013, 12:56 »

and mark i noticed you missed a , out in your forumla :o

I have put it in now ;)
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: price with conditions, conditional prices
« Reply #5 on: 09 Apr 2013, 13:07 »
hi
this will place a lay bet at 5 if above 5
IF(AND(lay_price>=1.20,lay_price<=5),r_ticks(back_price,1),5)
BUT you must have a condition
and selections lay price is equal or greater than 1.20


mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Guest
Re: price with conditions, conditional prices
« Reply #6 on: 09 Apr 2013, 13:12 »
fine fine, I have found the same solution by myself after the previous posts and was to ask if it would do the job at the same time as you wrote it..
thanks again to all.

  • Guest
Re: price with conditions, conditional prices
« Reply #7 on: 09 Apr 2013, 15:19 »
I am confused:
when we are talking about back price or lay price, does it mean from a market-MAKER-sight or market-TAKER-sight?

  • Guest
Re: price with conditions, conditional prices
« Reply #8 on: 09 Apr 2013, 15:37 »
answer from the formulae builder:

back_price = best back price offered.

  • Guest
Re: price with conditions, conditional prices
« Reply #9 on: 17 Apr 2013, 08:52 »
hi mcbee and all,

I am using the formula you gave me, see above, for the price of a lay bet:
IF(AND(back_price>=1.89,back_price<=3.05),r_ticks(back_price,1),3.1)

and I am using this formula from the forum for the amount:
5/((IF(AND(back_price>=1.89,back_price<=3.05),r_ticks(back_price,1),3.1))-1)
its simple: 5/price-1 as I want to risk 5 euro.

now yesterday mfp placed 2 strange lay-bets (but many correct ones):
1) price: 2,58 amount: 2,38, so liability 3,76
2) price: 2,30 amount:4,63 (!), so liability 6,02

could you explain why mfp did so?
and how I could avoid it?

thx.

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: price with conditions, conditional prices
« Reply #10 on: 17 Apr 2013, 09:57 »
hi
are you running live or test mode

mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Guest
Re: price with conditions, conditional prices
« Reply #11 on: 17 Apr 2013, 10:03 »
hi mcbee,
it was live.

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: price with conditions, conditional prices
« Reply #12 on: 17 Apr 2013, 10:16 »
hi
can you check your program logs to see what price the bot sent out to betfair

the first one, the price could have changed by the time it was matched.
but the second one would mean that betfair matched at a higher price and that is not normal.

mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Guest
Re: price with conditions, conditional prices
« Reply #13 on: 17 Apr 2013, 10:31 »
sh...t:
in my settings it was set "clear log records older than 1 day". so I dont have the log.

I remember that this occured already 1-2 times before. so I am sure that in the next days, especially on saturday, I will have again this strange behaviour. than I will have program record (but no trigger record).

is there no possibility to put for the amount a formula where there is no reference to back_price but a reference directly to the price-setting of the trigger (at the left side, "price") ? or directly putting in the liability?

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: price with conditions, conditional prices
« Reply #14 on: 17 Apr 2013, 10:55 »
hi
the formula that you have calculates the amount and price as it is at the split sec and sent out to betfair.


mcbee

Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

 

Please note, BetFair is seems to be currently OFFLINE