Requests

[osknows]

I have a few weeks off in July and (sadly ) planned to get my C# skills into a bit more shape as I'm a little rusty. What would be really useful for me is if I had a specific project to work on....

Therfore, this is a request for such a project. If you can let me know on this thread a single useful tool/app I'll see what I can do.

All the best
Os

[xraymitch]

Hi,

I have always rated your coding examples highly so am not surprised to hear you are C# programer too.

I would like a clock that shows the time elapsed since the start of an event. It is something that Gary considered doing a year or so ago but has fallen by the wayside.

Many thanks,

Ray

[xraymitch]

Hi Os,

Not much activity here I see.

I guess my suggestion doesn't press the right buttons for you then !!

Ray

[xraymitch]

Okay, how about a simple one (I suspect for you).

I have spent over 100 hours on this and still can't get it right.

I can write VBA code but I am still very much a beginner.

I have reached the point where I am now depressed that everything I have tried has failed and have now finally this evening admitted defeat.

Rather than give you numerous examples of my code let me express in a nutshell what I want to do.

When certain conditions are met (don't worry about the conditions) a LAY bet is placed.

So far no problem.

Now that the lay bet is placed, at some point if condition are met (again don't worry about the conditions) I will want to make a Back bet but before I can do that I have to clear the bet reference.

Problem:

I can never CLEAR the bet reference so that I can have the BACK bet placed.

Example of what I want to achieve:

I Lay at 4 and the back odds are now higher than 4. So I want to place a BACK bet (don't worry about the stake amounts).

If you have the time please point me in the right direction as I have given up with everything I've tried

Thanks for any help you can offer.

Ray

[xraymitch]

Will try modifying my code so that it uses the additional column Y - offset betting references.

I can only assume my logic is wrong somewhere in my current code. Yet I have set up breakpoints in VBA and tested while not connected to BA and all works.

I also have Macros that have worked for months on end then suddenly stop working. Is it possible that they can become corrupt within Excel ?

Have you decided on your holiday project yet ?

Ray

[xraymitch]

yes that works for me but is not flexible enough. At least I have a starting point now.

Should have said earlier column Y offset bet matched flag.

Ray

[Steve Voltage]

Okay, how about a simple one (I suspect for you).

I have spent over 100 hours on this and still can't get it right.

I can write VBA code but I am still very much a beginner.

I have reached the point where I am now depressed that everything I have tried has failed and have now finally this evening admitted defeat.

Rather than give you numerous examples of my code let me express in a nutshell what I want to do.

When certain conditions are met (don't worry about the conditions) a LAY bet is placed.

So far no problem.

Now that the lay bet is placed, at some point if condition are met (again don't worry about the conditions) I will want to make a Back bet but before I can do that I have to clear the bet reference.

Problem:

I can never CLEAR the bet reference so that I can have the BACK bet placed.

Example of what I want to achieve:

I Lay at 4 and the back odds are now higher than 4. So I want to place a BACK bet (don't worry about the stake amounts).

If you have the time please point me in the right direction as I have given up with everything I've tried

Thanks for any help you can offer.

Ray

Why not use two separate sheets? one for lay and one for back?

[xraymitch]

Thanks for that Arnold - I will check it out.

Ray

[osknows]

Hi Os,

Not much activity here I see.

I guess my suggestion doesn't press the right buttons for you then !!

Ray

Sorry Ray, was not ignoring this. I've just been much more busy than expected and to top it all have had both a hard drive fail and my router blow up in the same week. Thankfully all is sorted now so will take a look at your suggestion.

Os

[danjuma]

Now that the lay bet is placed, at some point if condition are met (again don't worry about the conditions) I will want to make a Back bet but before I can do that I have to clear the bet reference.

Problem:

I can never CLEAR the bet reference so that I can have the BACK bet placed.

Example of what I want to achieve:

I Lay at 4 and the back odds are now higher than 4. So I want to place a BACK bet (don't worry about the stake amounts).

Hi xraymitch,

Not sure why you can't just use an excel formula, except If I have misunderstood what you are after or what you are after is more complex than I think.

What I do in one of my sheets is reference the MyBets sheet.

Say set a cell for example X1 to be equal to 1 if no bets placed yet. You write an excel formula to check either columns A or B in MyBets - =IF(COUNTA(MyBets!A2:A50)=0,0,1).
Then set another cell say X2 to be equal to 1 if there's a lay bet in MyBets and its fully matched by using formulae to check columns E and F in MyBets.

You can put a formula like this in the Trigger column (Q) - if(X1=1,"BACK",if(X2=1,"CLEAR","LAY"))

[danjuma]

Sorry, wrong way round

if(X1=1,"LAY",if(X2=1,"CLEAR","BACK"))

[jumpsfan]

hi osknows, does this mean you would be able to add things to gruss, or will everything be excel based?

[osknows]

It's not right to add things to gruss so it will be excel based.

[mak]

Ok then
I need a workbook that will win me say 50€ per / day

[U.F.O]

Okay, how about a simple one (I suspect for you).

I have spent over 100 hours on this and still can't get it right.

I can write VBA code but I am still very much a beginner.

I have reached the point where I am now depressed that everything I have tried has failed and have now finally this evening admitted defeat.

Rather than give you numerous examples of my code let me express in a nutshell what I want to do.

When certain conditions are met (don't worry about the conditions) a LAY bet is placed.

So far no problem.

Now that the lay bet is placed, at some point if condition are met (again don't worry about the conditions) I will want to make a Back bet but before I can do that I have to clear the bet reference.

Problem:

I can never CLEAR the bet reference so that I can have the BACK bet placed.

Example of what I want to achieve:

I Lay at 4 and the back odds are now higher than 4. So I want to place a BACK bet (don't worry about the stake amounts).

If you have the time please point me in the right direction as I have given up with everything I've tried

Thanks for any help you can offer.

Ray

You could do that easy with a few if statements and a few macros. it may be a bit crude for some but it would work , im a nuts and bolts sort of person but i useully get the job done