BA Bot to change stake size relative to odds

[JAMESGLYNN67]

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

[ShaunWhite]

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

The syntax on that excel forumua is wrong.
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.