Green up spread sheet instructions

[dflowe]

Hi, is there a write up for how this works??? I dont sem to be able to get it to work.I have the mybets sheet getting data but need to know what else to do, where is the time to greenup taken from? does the sheet apply the greenup bets etc etc......

Thanks Dave

[GaryRussell]

It doesn't do the green up automatically if that's what you were thinking. It just calculates the stake required and whether it should be a back or lay bet.

Column Y: This will contain BACK or LAY to indicate which bet should be placed to green up.

Column Z: This is the stake required.

Column AA: These are the odds that were used in the calculation therefore these odds should be used when submitting the green up bet.

Column AB: This column displays what your P&L will be if the green up bet is placed and matched.

I haven't given a blow by blow explanation because I am not aiming to teach VBA, it's meant as an example for users who already have an understanding of VBA and can work through the code and amend it to suit their requirements.

[dflowe]

Hi Garry,
I think I have my answer from what you have said and another link so thanks for the reply.....

Dave