Cymatic Trader Community

[brysa]

I have a staking plan that is reliant on the result of the previous race in Excel, is this possible?

[Gavin]

I think that you'd need to write some code in the Visual Basic Editor in Excel that stores the lowest price horse of each race, perhaps repeatedly getting this information throughout the race. The final value before the race ends, would thus almost certainly reveal the winner of the race. Then you'd have that information ready for your calculations on the next race.

Do you have the Excel skills to do this? If not please let me know.

Kind regards,

Gavin

[brysa]

I have some VBA code written with the help of ChatGTP. The staking plan is Labouchere and it has a few bugs in it but is close to working flawlessly. I haven't got the "pause until 30 seconds to the off" yet. I have been studying VBA for a long time, but I would say I am at the P plate level. Any help would be appreciated Gavin.

[Gavin]

Hi brysa,

I'm impressed that you've used ChatGPT to do some specific coding for you. I haven't even tried that option yet!

Doing any sort of programming in Excel, is something that Cymatic can potentially help with but I the costs are considerable because it typically requires me to oversea a sub-contractor to do the work, because I'm too busy to do projects on my own. I don't expect many users would want to pay the high cost of a programmer and a senior programmer overseeing things, with all the back and forth and revisions that can sometimes be required, which is why you don't see me promoting this service anywhere. However, we can look at that if you think you might want to invest in it.

Regarding the Labouchere staking plan, it sounds hazardous. I've written about the Martingale Technique and why to avoid it. The same concerns would apply to any similar staking plan that involve increasing stakes after each loss.

Kind regards,

Gavin

[brysa]

Thanks for your reply Gavin.
The Labouchere Staking Plan can be hazardous if not controlled properly. with Target and Stop Loss resetting.
This takes the emotions out of your betting.
I have done a semi-automatic application with some manual input with VBA and it is working as expected.
The draw down is small and the trend is going up
Thiis sample was over 20 days and it tends to mark time when it hits consecutive losses.
I will continue to monitor it.
After 100,000 Monte Carlo simulations there was a 0.001 chance of going bankrupt.
You will notice that the bank is 500 times the Basic stake
Here is an attachment to show what I mean.

[Gavin]

Hi Brysa,

Thanks for your message. Good luck with it!

Kind regards,

Gavin