Is there a way to know the result of previous race

Questions about integrating Excel and Cymatic, programming, formulae, etc

Is there a way to know the result of previous race

Postby brysa » Thu Jun 27, 2024 9:32 am

I have a staking plan that is reliant on the result of the previous race in Excel, is this possible?
brysa
 
Posts: 5
Joined: Sat Jul 20, 2019 12:13 pm

Re: Is there a way to know the result of previous race

Postby Gavin » Fri Jun 28, 2024 8:00 am

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
User avatar
Gavin
Site Admin
 
Posts: 3863
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Is there a way to know the result of previous race

Postby brysa » Sun Jun 30, 2024 2:05 am

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.
brysa
 
Posts: 5
Joined: Sat Jul 20, 2019 12:13 pm

Re: Is there a way to know the result of previous race

Postby Gavin » Mon Jul 01, 2024 4:50 pm

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
User avatar
Gavin
Site Admin
 
Posts: 3863
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Is there a way to know the result of previous race

Postby brysa » Tue Jul 02, 2024 4:30 am

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.
You do not have the required permissions to view the files attached to this post.
brysa
 
Posts: 5
Joined: Sat Jul 20, 2019 12:13 pm

Re: Is there a way to know the result of previous race

Postby Gavin » Tue Aug 20, 2024 12:35 am

Hi Brysa,

Thanks for your message. Good luck with it!

Kind regards,

Gavin
User avatar
Gavin
Site Admin
 
Posts: 3863
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom


Return to Excel - Help / Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron