Closing out bets before the Off

[johnnic]

As I understand it, given that I operate Betfair from an Australian account, I am unable to apply a stop loss to any bet that I trigger from Excel should that stop be triggered in play. It will not be placed.

That being the case, I see no alternative other than to close all my positions prior to the off.

Is this possible in the Excel interface? Can I write an instruction which says that any bets that remain open, say, five minutes before the off are to be closed out at the current back or lay price?

John

[GaryRussell]

There are no specific functions in BA to do this, but you should be able to achieve this with a bit of effort. I have provided an example spreadsheet that performs the green up calculations. See http://www.gruss-software.co.uk/forum/v ... php?t=4659

See http://www.gruss-software.co.uk/forum/v ... php?t=4886 for an example of calculating seconds before off. See cell S1.

[johnnic]

Thanks Gary, I could see how this could work.

What I don't understand is, where on the spreadsheet are the formulas held that determine the Green Up Bet (column Y), the Stake (column Z), etc?

John

[GaryRussell]

It's my old favourite: VBA code. Press alt-f11 to display the code editor. The code is in sheet1 and module1.