Excel Help Please

[thewald]

Hi

Two questions with regards to linking excel up with Gaurdian.

Once excel has fired a bet, how do you clear the cells in excel so that it can fire again on the same selection?

I want to use a command that fires a BACK or LAY with a fill or kill command, is the following what I need

BACK:1 FILL_KILL

Thanks in advance

Nick

[thewald]

*Guardian

[Wyndon]

Assuming you want a delay of 1 second the command is

BACK FILL_KILL:TRUE KILL_DELAY:1

Clearing the status cells is probably best done by a macro. If you search there are various threads that discuss how you can automate this.

[LinusP]

If you don't have experience in excel I strongly recommend in using the guardian automation.

[thewald]

Thank you very much for your help!

[thewald]

Just stumbled on a couple more questions, probably more maths based than Excel.

I have been using Poisson for a while now, but have only recently come across info on 'zero inflation'. Can anybody help on this and how I amend my excel poisson calculations to incorporate this?

Also regarding Poisson, I read in one of Peter' blogs about how many goals the market was expecting. I assume that this is a sort of 'reverse poisson' calculation. I can do it manually by adjusting the mean/expected goals until I get prices matching the markets. Is there a calculation I can do to get this expectancy or mean automatically from the Under/Over prices?

I have tried to find answers to both online but only find complex mathematical equations which I dont understand. Any help or direction appreciated

Thanks