Cymatic Trader Community

[marwanco]

Hello,
I have idea for a strategy, before start testing it I need constructive criticism from you.
I want to try a martingale system , doubling the money on every new horse reaching odds=2.0
According to my observation max 4 horse can reach odds=2 in one race.
So back the first at 2 x10$
Second at 2x20
Third at 2x40
Fourth at 2x80

The goal is to win the initial 10$ bet.

The problem I see:
1.i might not hit odds =2 all time, sometime it will be smaller, due to latency.
2."PLACED" in status field prevent to place a bet on same horse second time, in case the horse odds increases and then come back to 2 again,and there was another horse that hit 2 odds with doubled money,This is crucial.required a way to clear status.
3.if doubling the money not enough, tripling could be tried next.

thanks

[Gavin]

Hi Marwanco,

I have already written an article on why I believe Martingale should always be avoided, please see here:

Why to avoid Martingale

I'm not convinced that a limited Martingale is any better.

Kind regards,

Gavin

[marwanco]

Thank you Gavin for your reply,

What is the easiest way to clear a status cell?
Macro,vba, udf, or excel built in functions?
I whant to place a back bet more than once on same horse.
Thanks

[sjaak1943]

Private Sub Worksheet_Calculate()
Dim Working As Range
Set Working = Range("A1:BW26")
Dim X As Integer
Dim Y As Integer
Y = Range("BW5").Value


If Range("BB3").Value > 0 Then

For X = 8 To Y
If Range("BD" & X) = "PLACED" Then
Range("BD" & X).Value = ""
End If

Next X


End If


End Sub


BW5=H4+7 (last row with a runner)
BB3 tells if race is "In Play" or not.

[Gavin]

Hi Marwanco,

Yes VBA, I agree with Sjaak.

Just make sure that you don't cause an infinite number of bets to be sent, which can happen if you are repeatedly clearing the status cell.

Kind regards,

Gavin

[marwanco]

Many Thanks.