Cannot remove ERROR status in Excel

[hordalan]

Hi

I am developing an automated spreadsheet using the Bet Angel template charting spreadsheet.

I have tested it offline and everything is working as expected but as soon as I connect to a live market the Status is set to ERROR and I cannot remove it. When I clear the cell it is immediately populated again with the ERROR status.

Any help would be appreciated.


Regards
Alan

[TheTub]

This would seem to imply that you have made an error somewhere!

And with the detail you have provided I can't really make any further comment.

It would be handy to know what formulas you use for the stake, price and instruction.

[staker72]

Hi
As previous reply difficult to say without more date but heres s suggestion.

Check all the rules, odds and stake cells in the bet angel sheet. If you are just recoring data these should be clear. If they look clear try using delete as Excel reads space as a character and would cause an error. If you are trying to outs odds etc. into ells to play check foramts. Usually number format 2 decimals work but so many slight differences between versions of Excel that not certain. If you are doing calculations in teh cell try doing it in another page and just refer to that cell in the bet angel sheet. All I can say is keep playing with formats etc.

Regards

[hordalan]

Thanks Tub & Staker72
I had checked formats and spaces as per some previous posts and I believe I have ironed out all the bugs.

The fundamental problem is as soon as I use a conditional IF statement in the Bet Rules section of the Bet Angel tab I get the error.

This is the formula I am using:-

=IF(Dashboard!E52="BACK","BACK OFFSET:1 FILL_KILL:TRUE KILL_DELAY:60 STOP:3 TRAILING_STOP:TRUE",IF(Dashboard!E52="LAY","LAY OFFSET:1 FILL_KILL:TRUE KILL_DELAY:60 STOP:3 TRAILING_STOP:TRUE"," "))

But even with a simple formula e.g.
=IF(G9=4,"BACK"," ") as soon as I connect the ERROR message is displayed and cannot be removed.

I have tested my formula by typing it in without the IF & conditions statement and it works ok.

Is this one I should report to Bet Angel direct?
If I could access the macro's I may be able to suss out but they are password protected in my copy of the spreadsheet.

Regards
Alan

[PeterLe]

Hi Alan,
A couple of questions:-

What do you have in the Stake Cell?
What do you have in the Odds cell?
...and where is the ERROR shown (In O6 or O9 ?)

Thanks
Peter

[hordalan]

Hi Peter

I have a fixed value (2) in the Stake cell while I am testing.
I have another If statement in the Odds cell:
=IF(Dashboard!E52="BACK",Dashboard!C44,IF(Dashboard!E52="LAY",Dashboard!C45," "))

This is just picking up the odds I want to use. I think I have tried a simple =G9 or =H9 as well.

ERROR is shown in O9

Regards
Alan

[TheTub]

Hi,

The error appears because of the space in your statement.

Remove the space between the final quotes:

=IF(Dashboard!E52="BACK",Dashboard!C44,IF(Dashboard!E52="LAY",Dashboard!C45,""))

TT

[hordalan]

Thanks Tub

That's sorted it, a bit of a DOH! moment there.
I should have realised I need a blank or the actual odds in this cell not a space.

Cheers
Alan

[rinconpaul]

Hi, I wouldn't feel so bad, if I have a "do!!" moment over this, if someone can help me. Similar story, I have this formula in cells L9 down:

"=IF(AND(F$4=0,C$2>5000,G9>0,'Price Order'!V9="LAY"),"LAY","")

It's basically waiting for countdown timer to reach 0, confirms that Back Price not zero and that there's $5000 in pool min AND a "LAY" signal from another worksheet. Any assistance appreciated,
Thanks

[rinconpaul]

I ended up sussing out the problem. In my attached worksheet, if there were any error messages in calculations, usually due to an early market and no volume traded, the error was passed through. So I re wrote the formulas to always show a blank cell if error.