Guidance needed: VBA routine that deals with SUSPENDED issue

[Jonathan474]

Evening All

Has anyone come across this issue, and if you have, would you be happy to point me in the direction of a solution, please?

I have set up a nice little multiple-market spreadsheet that looks at up to 20 football markets using the Guardian-Excel function. I have added a new Overview tab into the workbook that brings together my activity in those 20 markets and reports a whole load of information including the current green-up status of my bets. So, if my current green-up losses are, say, 50% of my stake then the global command GREEN_ALL is issued against that particular market and the position is closed.

All well and good until the market is SUSPENDED. After the suspension is cleared the market can be, as you will be aware, all over the bloody place and often the green-up figure shoots under my kick-out stop-loss condition. Yesterday, Wigan's second goal confirmed my winning bet but I was greened-up for an immediate loss of 150% of my stake after the suspension condition was cleared. Today, Sampdoria's third goal did the same - once again, a winning bet was turned into a loss.

Now, there has to be a way of introducing a timer delay into this workbook using a VBA routine.

My thinking: Set a flag when the SUSPENDED indicator appears, set another flag - a HOLD flag - that prevents any GREEN_ALL commands being issued whilst the HOLD flag is set - and at the same time start a count down timer from, say, 45 seconds down to 0. Once the count down reaches 0 the HOLD flag is cleared and now GREEN_ALL commands can once again be issued. During these 45 seconds (or at whatever delay it needs to be set) the volatilty in the market should have disappeared and my winning bet will not have been settled out of the money.

Anyone come across this before? Did anyone find a solution. I'll look at this during the week ahead but didn't want to reinvent the wheel if it had already been solved. I can't see anything on this topic in the forum but subject headings can be ambiguous.

Anyway, now settling down to watch El Classico. Got a small position on this one.

Take care and thanks in advance to anyone who replies.

Kind regards
Jon

[LinusP]

I don't work football, but after a suspension I know there is a serious drop in liquidity and the spread becomes huge. I would add a simple if function based on the spread and liquidity for a 'green up' to occur.

[Jonathan474]

LinusP, Thank you. That is a much better idea. Keeps it simple.

I have spent the evening "watching" odds movements when goals are scored to see how a spread pattern behaves after a goal is scored and how quickly it returns to "normal".

I'll turn this behaviour into a better trading trigger...one that stops me being dumped out of a winning trade.

Thanks again.

Kind regards
Jon

[woodhousejj]

HI - Not sure if this helps - but I currently use Guardian for automation - just starting so have not progressed to Excel yet. The reason for my reply is that in the Guardian rules functionality I use a condition for my Green Up called "Time Unsuspended Condition" - where I specify the time to Green Up based on the time since the market was last unsuspended. I don't know Excel that well but I am assuming similar commands are available in Excel. Apologies if I have misunderstood your problem.
John

[Jonathan474]

Thanks John. I think you have stated exactly what I wanted to do originally - use a VBA routine to try to mimic a timer starting when the suspended condition is lifted and to only permit a trade to take place once a set period of time had then elapsed. I have looked at doing this with the Automation functionality but stopped in preference of using the Excel solution.

I have found various counters in VBA code which might be worth looking at but this evening I like the idea that has been suggested by LinusP for a HOLD flag that looks at the spread and the WoM conditions. I have come up with the states of those two conditions which give me that HOLD instruction after a suspension and am now testing to see if it works.

Thanks for the reply.

Kind regards
Jon