State Machine Spreadsheet

[CallumPerry]

I agree! I really do appreciate all the (free) advice that you are kindly sharing. I have already learned a lot in my short time as a member and it's all because of people on this forum being so helpful!

I have created the first draft of the template which I am about to share in a new thread so it's easy for the wandering lurker of this forum to find.

Case "B"

Call BackOne
Worksheets("Bet Angel").Range("J32").Value = "C"

Case "C"

etc etc.......

I tried simplifying the code to something like above but for some reason it wouldn’t recognise it so for now, I just wanted to get the spreadsheet out for other members to enjoy and test, I have made quite a lengthy bit of code for the template. The bottom line is that it works and should generally run pretty darn fast so i'm happy to share now and take your advice on board to improve things in my own time.

One more question…
When closing a trade what is the difference between L9 = “LAY” stake = £2 and L9 = “Close_Trade” and stake = £2? When would you ever use the individual command option Close_Trade over just laying?

Callum