excel.. want to place conditional sp bet

[obratzov]

Hi, I'm very new to excel. I have been playing away for a few hours.

Basically what i want to do is something like the conditional bets in the normal software.

The conditional bets I want to place are something like this. I want to fire in a bet only when the last price matched has fallen to say 50% of the sp. or on the contrary lay samething only when it goes 100% above the sp.

i got this far and would like to know if i am barking up the wrong tree while trying to use gruss and excel.

in my limited wanderings on the net , I decided that I should place a formula in the trigger cell...

so i have been trying stuff like.. =IF((Y5+1)/2<o5, "BACK-IP")

then in the odds cell... y2/2.

I realise that manually , I can just put in the prices dependant on the last price matched using the normal conditional function on gruss. I would prefer just to set up the bets at anytime in advance. This way the price that I am backing at or laying at will be dependant directly on the bf sp. Doing this manually means doing it close enough to the off time so that im not guessing.

I would prefer to automate this process using excel and gruss.

I'm sorry if im being naive in thinking that entering formulas in the cells will work. Theres not alot out there for non excel beginners on this sort of subject.

Sorry also if this is on the forum and I havent found it.

cheers

[obratzov]

found what i was looking for under this

http://gruss-software.co.uk/forum/viewtopic.php?t=7422