Updated Example Custom Settings Sheet V2.xlsData_For_Offthelip2.xlsWolf Dream.docx

Hi gents,

Please find attached:
1) An updated version of the custom settings sheet (I have turned bold the new information that I have added since my last reply, I think this is the final version of this sheet with everything you requested SamT).
2) The spreadsheet with the altered code as requested by you Offthelip, I just tried to extend it with that bit you also typed up SamT but I’m afraid I just missed the last race of the evening! I tried just pasting it underneath the first part like so: 

Private Sub SaveRecording()
    Worksheets.Add Before:=Sheets("Bet Angel")
    ActiveSheet.Range("A1:C" & CStr(RecordingLength)) = Recording
   
    Static DataTable As Range
    Set DataTable = Range("C45:L46")
    Dim Recording(1 To RecordingLength) As Variant
    If Target.Cells(1).Address <> "$B$45" Then Exit Sub
    Recording(i) = DataTable.Value
 
End Sub
But it resulted in the following:
Compile error:
Duplicate declaration in current scope

I didn’t have time debug it and work out the, I’m assuming, painfully obvious error I have made constructing this little add-on so before I reattempt it tomorrow, any idea what needs to be altered? I am travelling to London first thing in the morning so may struggle to capture any markets tomorrow but I shall try my best if either/both of you instruct me to collate any more information. Again, I shall try and reply in the late evening (work has been a pain this week) but I will be in London until Sunday. As of Monday I will continue to give this my absolute, undivided attention once more.

Furthermore, I have been thinking. I assume the system works automatically as soon as it detects movement on the main sheet which is fantastic as this can easily be controlled by the restrict refresh function the BA app supplies; it also means it can start at any time not just 10 minutes before market start but when I choose. To hedge all my profits, I shall also use the GREEN_ALL function BA supplies so can the system stop placing orders once the market countdown has reached 15 seconds or less, that is to say when BACountdownToStart (F4) is <= 00:00:15, Then (No new orders), If (0rders are still open) then Close_Trade within 5 seconds. Also, if the market suddenly creates a bounce I may miss an opportunity and in a fully automated system consequently some money. As previously mentioned you join a queue of money so sometimes the market can move faster than you can get an order made...

Now this is something I need to look into further but a simplistic quick fix I’d like to include now please would be as follows:
IF (BAFirstBack1) is (two ticks – need to work out a formula for this to obviously this won't be included immediately) away from (trigger price) AND (Order) has not been filled, THEN fill (What’s left of order) at (New price). I will look into this next. Also, I’d just like to clarify a couple of other things at this stage please. The system won’t get confused if there are blank columns or ‘0’s’ (Less than three brands) will it? Also, it shouldn’t get confused if I have multiple markets running simultaneously or at slower update speeds i.e. pre match football markets (5 at a time equals 1 second updates instead of 200m/s updates), I’m just trying to get to grips with the strengths and limitations of this system and where I can experiment with it once it’s up and running.

And finally, one last final tangent if either of you are interested. I had a really intense dream the other night that I wrote down because it fascinated me. I have copy and pasted it into a word document which is also attached to this comment if either of you are fascinated in the psychology of dreams or simply what is going on in my strange little head.

Cheers lads,
Goodnight.

CPerry.