Hi
I'm trying to vary my stakes relative to the best market price as well.
I'm looking at stored values to calculate my stake to be 10% of the best market price, 3 seconds before start.
I've been trying this out on excel but cant get it to action. I have my staking formula in the stake column N9= If(F4<=0.00003472,N9=G9/10,"").
How do I replicate this as a stored value in guardian?
Can you help me out please?
Cheeers
BA Bot to change stake size relative to odds
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
The syntax on that excel forumua is wrong.JAMESGLYNN67 wrote: ↑Thu Apr 08, 2021 8:15 pmHi
I'm trying to vary my stakes relative to the best market price as well.
I'm looking at stored values to calculate my stake to be 10% of the best market price, 3 seconds before start.
I've been trying this out on excel but cant get it to action. I have my staking formula in the stake column N9= If(F4<=0.00003472,N9=G9/10,"").
How do I replicate this as a stored value in guardian?
Can you help me out please?
Cheeers
Enter =If(F4<=0.00003472,G9/10,0) into cell N9.
But that makes N9 zero unless N4 is less than or equal to that very small number.
You might want to put this in N9 instead
=Iferror(g9/10,0)
That will make N9 contain g9/10 unless there's an error (such a divide by zero) in which case it'll be 0.