Hello I hope someone can help me I spreadbet and have a program that
triggers bets using excel I need a formula that will buy two shares but
only when they are priced below 2.

I have this so far but all it achieves is the buying of one bet when
two are under 2

IF(AND(AND(r_1_layp<2.0, r_2_layp<2.0), OR(lay_price<=r_1_layp,
lay_price<=r_2_layp)), 2, 0)

I hope someone can help me someone else helped me with the above but we
dont know how to get it to work!

thanks in advance


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220

Sorry, I am not understanding your terms

So if r_1_layp and r_2_layp is lower than 2, you buy two shares?

what about this lay_price thing? From your formula, you are basically
saying, that r_1_layp and r_2_layp must be lower than 2 AND layprice
must be either lower than r_1_layp or lower than r_2_layp...

can you clarify?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554220

Hi thanks for replying - yes what I want to do is buy two shares if
r_1_layp and
r_2_layp are under 2 but only if they are both under 2.

lay_price is the price of the share in real time. its the second part
of the formula that is confusing me!

again thanks for replying this has me tearing my hair out!


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220

Also the idea is to buy £2 worth when both shares are under 2


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220

Also the idea is to buy £2 worth when both shares are under 2


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220

sorry actually what I want to do is buy £2 worth of both when they are
under 2


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220

IF(AND(AND(r_1_layp<2.0, r_2_layp<2.0), 2, 0)

would this be the solution?


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220

Maybe it's a communication problem. I am still not understanding what
it is you require.

If r_1_layp *AND* r_2_layp is less than 2 then you want to show a 2,
else a 0?

if that is the cast, just do =IF(AND(r_1_layp<=2, r_2_layp<=2), 2, 0)

is there another condition you want? something to do with the layprice
being lower than or equal to r_1_layp *OR* lower than or equal to
r_2_layp?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554220

Thanks for being patient I am going to think through the best way to
explain it and will post it tomorrow basically the condition I want is
for there to be no bet unless both prices are less than 2 and the bets
on bothe must be placed when the price is under 2

r_1 is the first share
r_2 is the second share

and lay_Price is the actual price

please stick with me untill I can explain it better! thanks have a
good evening


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220

Thanks for being patient I am going to think through the best way to
explain it and will post it tomorrow basically the condition I want is
for there to be no bet unless both prices are less than 2 and the bets
on bothe must be placed when the price is under 2

r_1 is the first share
r_2 is the second share

and lay_Price is the actual price

please stick with me untill I can explain it better! thanks have a
good evening


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220