Excel Genius Required !!!!!!!!

[wayneindevon]

Hi, I have a plan but have no idea if it can be done which is where you excel gurus come in.
What i want to do is autotrade to very specific requirements but i have no spreadsheet experience at all. please tell me if this can be done and if anyone wants to take the job on we can negotiate later???
Heres what i want to happen in basic steps.

1.Begining of the day select maybee 10 races (Guardian?)
2.When race is 60 secs from off check prices and if favourite is above 2.0 but below 3.76 place lay bet for a % of bank (eg Bank £100 bet 2%)
If not then dont bet.
3.After race re-calculate bank
4.next race do same but adjust stake if previous horse won (ie horse won @ 3.0 -£6.00 bank now £94)so that new stake will recover loss at given odds .If no loss then bank will be £102 so next stake will be £2.04 etc etc
you get the idea....
If you think this can be done please let me know or if you need more info
Cheers
Wayne
ps a big ask i know!!

[Jimmy]

Hi wayneindevon,


I am pretty sure it can be done with excel, but unfortunately I dont know how. I have had to purchase a seperate bot to do that in the past, which also stops the bot if a target profit or loss is reached. It can also lay or back multiple favourites etc. it even has a Simulation mode. It was about £75.

But if someone has a excel sheet already done and is willing to share it, that would be great.

Many Thanks

Jimmy

[gutuami]

here is a sample of 1000 favs with their SP prices between 2 and 3.76. Test your idea, but I guess that it is a bad one.

[toptrader]

can be done quite easily using Guardian excel feature and a bit of code to check the account balance to see if you'd lost on the previous race, or hit your daily profit target.

I can't see the strategy being a good one, but you have to start somewhere

How much would you pay for the code?

[wayneindevon]

Hi All Thanks for your replies. Also thanks for the list of 1000 favourites which indeed shows a loss. However my master plan is a bit more complicated as i want to autotrade using a specific staking plan. It is quite complicated but here goes....
1. i will only use the plan on national hunt meetings
2 lay favourites between 1.75 & 3.75
3.the staking plan is as follows

the start bank is £200 and the Percent to Bet for Intial Stake is 1%. This makes the initial stake £2.
- If Bet Wins do multiply initial stake by -20%. This will only occur if the last stake is not already the initial stake.
- If Bet Loses do multiply initial stake by 100%. This will always apply. There is no stoploss in this staking plan.

So for instance you can see that if our first bet loses then the next stake is
£2 + (100% * £2) = £4

If the bet loses again we would have
£4 + (100% * £2) = £6 and so on.

If the next bet wins we would have
£6 + (-20% * £2) = £5.80 and so on.

Would be interested to see if this could be done and if anyone thinks they could adjust Bet-Angel-Autotrade-V2 to do this tell me the cost and we may have a deal. Also with the autotrade sheet i cant work out how to trigger a single bet, any ideas???
If anyone can run the 1000 favourites through this i would be interested to see the results, however i think most of these races were flat races so wouldnt use them in my plan...
Thanks for your time
Wayne

[BeatTheHouse]

Read a book on Excel or watching a couple of youtube videos. It will save you some money that you can put towards your strategy What you want to do is relatively easy to set up, but might take a little time to do.

[iangrant230]

I want to lay with a fixed liability and am currently going through old results to see what the profit and loss are like but does anybody know a formula to convert your liability to the stake?

[Jukebox]

I want to lay with a fixed liability and am currently going through old results to see what the profit and loss are like but does anybody know a formula to convert your liability to the stake?

Divide your intended liability by the odds minus one.
EG
If you intend a Lay liability of £10 and the odds are 6 then divide £10 by 5 = £2 stake

[wearthefoxhat]

Hi All Thanks for your replies. Also thanks for the list of 1000 favourites which indeed shows a loss. However my master plan is a bit more complicated as i want to autotrade using a specific staking plan. It is quite complicated but here goes....
1. i will only use the plan on national hunt meetings
2 lay favourites between 1.75 & 3.75
3.the staking plan is as follows

the start bank is £200 and the Percent to Bet for Intial Stake is 1%. This makes the initial stake £2.
- If Bet Wins do multiply initial stake by -20%. This will only occur if the last stake is not already the initial stake.
- If Bet Loses do multiply initial stake by 100%. This will always apply. There is no stoploss in this staking plan.

So for instance you can see that if our first bet loses then the next stake is
£2 + (100% * £2) = £4

If the bet loses again we would have
£4 + (100% * £2) = £6 and so on.

If the next bet wins we would have
£6 + (-20% * £2) = £5.80 and so on.

Would be interested to see if this could be done and if anyone thinks they could adjust Bet-Angel-Autotrade-V2 to do this tell me the cost and we may have a deal. Also with the autotrade sheet i cant work out how to trigger a single bet, any ideas???
If anyone can run the 1000 favourites through this i would be interested to see the results, however i think most of these races were flat races so wouldnt use them in my plan...
Thanks for your time
Wayne

This reminds me a little of the Little Acorns Lay system and their Fibonacci retrieval staking.

Of course the main difference is that the favourite gets laid at odds-on if the price of the other market leaders are within a certain range.

With laying odds-on, it is more low liability staking, if you include odds-against, then of course it gets higher.

As you say excel should be able to do something when linked to B.Angel.

[Wolf1877]

A complication with your requirement is that events may overlap and hence the previous result would not be known in time.

For example you might select 2 NH meetings with races starting at 14:00 with say a 15 minute gap between events and with a £100 opening bank. Settlement of the bets can easily overlap due to combinations of delayed starts, long races, stewards enquiries and photo finishes etc. If the 2 NH meetings happen to offset by a 20 minute/10 minute cap then the likelyhood of overlapping events is far higher as race starts delayed 5 minutes are pretty common and NH races of 5 minutes or more are also pretty common.

Example:
14:00 race at Newbury is a 3 mile chase triggers a £2 lay bet at @ 3.00 at 13:59. Race starts 10 minutes late at 14:10 and takes 7 minutes with a stewards enquiry taking a further 3 minutes. In this scenario a lay bet placed at 13:59 would not be settled until after 14:20

14:15 race at Stratford triggers a lay bet at @ 3.25 at 14:14. Problem is previous event has not finished by 14:14 and therefore it is not possible to determine if the "bank" for the 14:15 race is £96 or £102 (less comnmission) at 14:14

Other than that complication then you could simplify it by just using the balance in cell C6 at 1 minute before scheduled time regardless of if previous bet has settled. i.e. assume a loss from previous event if not settled.
Alternatively you could skip placing any bets on the 14:15 because the previous event has not been settled by 14:14.