Backing Rollover

[humanoid769]

Hi

Is there anybody who knows if this is possible to do in excel and BetAngel

I have been looking at how to build and Accumulator automation file, I thought I may have been able to use signals but UI think I must be missing something… I wish to be able to do something like this

Sunday.. Race 1 Stake 5.00 Back Place It wins @ 1.5 return 5.00 +2.50 = 7.50
Monday.. Race 2 Stake 7.50 Back Place It wins @ 2.00 return 7.50 + 7.50 = 15.00
Monday.. Race 3 Stake 15 Back Place It Wins @ 1.5 return 15 + 7.50 = 22.50
Tuesday.. Race 4 Stake 22.50 Back Place and keep repeating.

So pretty much I would like to be able to pass the return amount to be able to be used in the next bet… I assume this is something I should do via excel? Is this something that can be achieved

Thanks
Tony

[Jukebox]

Races for Tuesday aren't usually available on Sunday

[Euler]

Y, I can see a similar issue. Markets generally only go up the night before and you also have the issue with reduction factors and withdrawals. Quite tricky to trap all situations.

[CallumPerry]

If Monday's races are hours apart then it should be easy enough. You could write a bit of code that says
"At 5 minutes out (or whenever) write my balance to a free cell". Then on the next sheet I'd have an IF statement saying "If my balance is bigger than what it was in the previous race then proceed to increase the stake".

It's important the matches are over and the bets have been settled. If you tried this with greyhounds for example which run every few minutes, you could be screwed over by your previous funds not been processed as win/loss yet.

You're going to need to do some simple VBA to write the value of the balance to a cell at a specific time and then an if statement to trigger the next bet. Your stake would be £5 + the difference between your starting bank and your current bank.

Basically, yes - it can be done but if you're going to be doing accas which span days, wouldn't it just be easier to type your stake into a sheet when you turn your machine on in the morning?

[CallumPerry]

Ahhh + while I was typing ^^^^^ withdrawals, markets not loading, suspended or being abandoned half way through the acca etc etc you could probably brainstorm another several precautions you'd have to take, each one would need a solution in your code/formulae.

[humanoid769]

Thank you some food for thought

[Xeres]

I think I have done something similar in Excel before when I was testing out some logic before I coded it up.

The result of the previous race would change my stake for the next race depending on my starting bank and opening bank. The starting bank would reset depending on a condition and I did all this with formulas.

Happy to share if or help you put one together if it sounds similar to what you need.

[humanoid769]

Xeres that sounds pretty close to what I want to do... I would love to see what you have done

I am trying to increase the next stake by what was won


Thanks
Tont

[Xeres]

Xeres that sounds pretty close to what I want to do... I would love to see what you have done

I am trying to increase the next stake by what was won


Thanks
Tont

Here is the file, I've left in my data so you can see how it works.

Basically the idea was to recovery any stakes that I had lost from previous races, so if you enter a 1 or 0 in the result column it will change the amount needed to be recovered on the next race and alter the stakes based on the current price. I ignored betfair commission in excel and I just adjusted for that in my actual software.
Columns N->P keep track of the balance before and after the race in order to reset the amount needed to be recovered.

If you have any questions on it or want any help let me know. This strategy actually worked fine but I couldn't stomach the high stakes needed after a series of losses to make it work.

[humanoid769]

Xeres that sounds pretty close to what I want to do... I would love to see what you have done

I am trying to increase the next stake by what was won


Thanks
Tont

Here is the file, I've left in my data so you can see how it works.

Basically the idea was to recovery any stakes that I had lost from previous races, so if you enter a 1 or 0 in the result column it will change the amount needed to be recovered on the next race and alter the stakes based on the current price. I ignored betfair commission in excel and I just adjusted for that in my actual software.
Columns N->P keep track of the balance before and after the race in order to reset the amount needed to be recovered.

If you have any questions on it or want any help let me know. This strategy actually worked fine but I couldn't stomach the high stakes needed after a series of losses to make it work.

Thankyou Xeres I will take a look

Tony