Annulleret

Excel and Gruss' Betting Assistant

Only those who are familiar with Gruss' Betting Assistant program need read any further.

I am looking a small bit of help with an Excel sheet that I have designed, as it doesn't do exactly what I need it to do.

## Deliverables

Using the Excel logging feature within Gruss' Betting Assistant I have a sheet that I use to place bets on under 2.5 goals in football matches - that is all that the sheet is used for - I never bet on over 2.5 goals.

?

The sheet is set up for any number of matches, as on a Saturday I may be looking to place bets on upto 12 matches.

(BTW the sheet will be sent to? any bidder who requests it)

?

What I do is load all the matches in one browser window in Betting Assistant and Log to excel.

?

Once the games are on the spreadsheet I? run a? macro - this effectively gets my sheet primed, all I then have to do is manually enter what I believe to be the true unders price of each game in? some cells.

?

The sheet is setup so that 10 minutes before kick off in each game a bet is fired providing that the odds that I am getting on unders are at least 5% greater than my perceived true odds.? It also either backs unders or lays overs depending on which price is better.? The stake is also worked out for me as it is Kelly based.

?

All that works absolutely fine and I don't need any of that changing.

?

So what do I want????

?

Well sometimes the stake I want to bet is more than there is currently available at the best price, and it is very important that I get all of my stake matched.

?

?

So my requirements are:

?

The initial bet to be fired the way it currently is, ie 10 mins pre game fire a bet at whichever is the better price (backing unders or laying overs) when my price threshold has been reached, at the calculated stake.

?

After that you are free to use whatever approach you want but it needs to do the following:

?

x minutes (currently 5) after the bet is placed if I have any unmatched bet I want to reduce my back price / increase my lay odds to the currently available price.? The stake that I need this second bet to be will be calculated using Kelly staking (my sheet already does that) BUT IT IS VITALLY IMPORTANT THAT YOU TAKE INTO ACCOUNT THE STAKE ALREADY MATCHED.

So say my inital bet is £200 at 1.9, the stake at 1.89 might be £190 but if I already got £75 matched at 2.0 then I want the new bet to be for £115.

?

The second bet to be placed needs to be at the best odds available, ie you must look at whether it is better at this stage to back unders or lay overs.

?

If the second bet then isn't fully matched after y minutes (say 7) then we go again.

?

And finally if the 3rd bet isn't fully matched after z minutes (say 9) then we just match my entire remaining stake at whatever price I can get.

?

Remember that the sheet needs to cater for? more than one match, so whatever way you structure the code each match on the sheet has to operate independently, ie some matches might have no bet due to price not being good enough, some matched might see my inital bet immediately matched in its entirety, some matches may need the odds altered as my bet is too big for the best price available etc.......

?

I think that is just about everything.

?

Anything you aren't clear in give me a shout.? If you can meet my requirements then let me know what sort of price you would charge.

Evner: PHP

Se mere: works well independently, works need excel, what to do when you get fired, what to do when fired, what to do if you get fired, what to do after being fired, say anything you want, looking for an account assistant, just got fired, i just got fired, i got fired, got fired, getting fired, get an assistant, free excel help, what is macro in excel, sort excel, Kelly, football excel project, football betting

Om arbejdsgiveren:
( 14 bedømmelser ) United Kingdom

Projekt ID: #3317049