Taking bets In-play & keeping them in play with suspensions

[conorm]

Hi I was wondering if anyone could help me with regards to market suspensions and taking bets in-play on excel.

I have written a formula but in horses for example if I set it up before the race and leave it, when the market gets suspended and then goes In-lay it returns an ERROR an the bet status column on excel and obviously once this happens no further bets can be placed as the error status effectively voids that line of code until you manually delete the ERROR status. Is there anyway to stop this happening and leave that column blank until it actually makes the bet?

[conorm]

Also one other question, but how can you use excel to record data to plot charts and analyse at a later date?

Is there away of printing certain values in a cell every 10 seconds or something similar to this?

Thanks, Conor

[nimrodel1]

Hi Connor,

With regard to your first ERROR post I was getting this though not in relation to in-play. I got around by placing my rule function within an IFERROR command so say if originally we had if(H9>0, "LAY", "") I now had IFERROR(if(H9>0, "LAY", ""), "")

As I said I used it in a different context but it did get rid of that annoying Error message.

[ODPaul82]

hi conorm,

Regarding the recording of prices for plotting and reviewing back (i.e. replay the market) I'm producing a demo spreadsheet which does this as we speak.

Regards
Paul.