Author Topic: Formula for stake  (Read 571 times)

Tags:
  • All members
  • Posts: 82
Formula for stake
« on: 05 Jun 2019, 17:25 »
Hi
I am pulling selections in for a .txt file and it refreshed and imports them successfully, the problem I am having is that sometimes in my txt file the selections do not have a stake next to them (separated by a tab), what I need is an iferror statement which says if it cannot find a stake for imported_1 then just use the default_backa

I cannot for the life of me work out what needs to go into the liability stake part of the back sp block.

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: Formula for stake
« Reply #1 on: 12 Jun 2019, 09:05 »
Hello!

The solution is non-trivial because imported_1 will return an empty space (not a zero) if you leave it out in the text file.

So you need to insert this formula into the Amount field:

IF(imported_1+0 > 0.05, imported_1+0, default_backa)

The trick here is that is imported_1 is empty, the expression will be down to: 

IF(+0 > 0.05, +0, default_backa)

which is a perfectly valid trigger expression, and it will return default_backa.

On the other hand, if imported_1 has some value, e.g. 3.5, then 3.5 + 0 will still be 3.5, so this won't affect your staking plan.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

 

Please note, BetFair is seems to be currently OFFLINE