Help with missing bets and odd behaviour please

[edt123]

Hi thanks for the help previously.
I ran into trouble yesterday and at least one of these issues is a bot worrying. Maybe somebody can explain??
I started betting my excel sheet with real money on saturday and had a great day and the sheet worked nicely.

Sunday : Problem 1 laid a field in Plumpton- dutch sstyle but using my own excel algos Max loss was £37 (not max liability as shown in BA dutching)
Submitted all bets, they were picked up . wathce dhte race- lost 37 -as I thought. oh no the only bet placed was the one the invalud that limped in and cost je 90+ where the other 10 o som bets wet to I can not trace. betfair has no record, there is nothong my bet results mybets etc.
Is there a log for the api or betfair api that can be examined? Not knowing what happened is the worst thing.


Also: I chnaged markets and instantly the sysem bet in the next market. I did nothing to make this happen.
in the BA sheet the remains of bets form the previosu market may have been left behind and somehow misinterpreted. I had to back these runners to get out of the situation



Then: I sumitted my triggered bets. no respose from BA. visited betfair and no record of the bets existed there. This was near the off.
After 30 seconds or so. I decided this ahs not been sent and hit the button again. While wtching the race, I noticed a second lot of bets turn up in betfair and now I was double betted.

To prevent this repeating, I have started on ciding something to check status before rebetting and cancel previous bets. There many problems with this however:
1. When I palce trigger bets and there are cancelled bets already in the sheet I have to place my bets over them or how else will I identify the seleection.
BA seems to keep replacing this junk in the sheet though. Its hard to be confident
2. In a 6 runner race I ended up wit 8 or 10 rows of bet responses below the last runner on the sheet. These entries don do anything to idnetify which selection they refer to so what is the point in them being there and how can i use them

Can anyone gove me a cat iron way to check that my bets have been matched or cancel and resubmit? Incidentally I added tow oints (not ticks) to the lay odds to get matched and still ended up with this mess.

Lost most of Saturdays gains with these problems but most of al I lost confidence to bet with it.
any suggestions at all please?

[Captain Sensible]

BA has a transaction log of all betting activity just go to Account->View Transaction Log . It can also be saved to PC by default I think .
Betfair also have a log of all bets placed , just log in your account and navigate to https://myaccount.betfair.com/activity/bettinghistory you can then see all bets matched, lapsed voided etc as your bets may have been unmatched for whatever reason.

When you log your excel sheet to BA you have various options about clearing old bet references etc , it'd be worth you reading the manual on those settings so you're aware of what they do or don't do. A reference in the bet reference column will stop BA from placing further bets but if you clear that on the market change but still leave any formulas up they will get resubmitted.


"2. In a 6 runner race I ended up wit 8 or 10 rows of bet responses below the last runner on the sheet. These entries don do anything to idnetify which selection they refer to so what is the point in them being there and how can i use them"

I've no idea what this eans to be honest , if you wrote the sheet surely you'd know what those bet responses are? If you didn't write the sheet it'd probably be best to ask the person who did or at least stick up some idea of what data is showing.

[edt123]

Thanks for your time.
I have attached a picture of the kind of scenario I see in the sheet BA producces.
I cant make sense of it. I have spent some time on the manual and it doesnt answer all the questions.
I need a way to send a bet and then wait for a response and react to that depending on error, unmatched , canceled etc.
How can people trade market movement if it tales 3 or minutes to know what happened to your bet? that makes no snese at all.
I was lead to beleive scalpers were using this system
Trying to intepret the stuff on this sheet seems the only option to me to find out what's going on so I need to understand it. CVurrently, unless a bet is matched and has a bet id (and asusming I had an api to look it up with) I dont know what runner a bet response belongs to.
The thing I was questioning is that as per the attachement, these responses leak below the row of runners, so how can this be useful?
is it intended?

I think I already mentioned that I checked on betfiar and there ws no record of the lsot bets.
Neither did they turn up in results that is why I asked. it is rare that something like this can dissapear entirely.
I have been wrirng distributed apps since 1995 and I never saw one that jsut threw stuff over a wall and hoed for the best.
Since it was costly, I need to know it can't happen again.
when I log into betfair through BA are my crednetial and my transactions encrypted?

[edt123]

the file didnt seem to upload last time

[merlmagic]

It's been a while since I used triggered betting but have you linked more than 1 market to the same excel sheet. I can't remember and I'm not risking trying it out but I think would potentially cause your errors if the bets were placed in the wrong market. My understanding is that cancelled/void bets do not get recorded by betfair.

[Captain Sensible]

You can view Cancelled, lapsed and voided bets in the Bettinghstory page just select whichever options you want to view.

I'm guessing that must be some sheet you've coded yourself as I don't think BA sends details like Matched/Unmatched via the normal excel interface, don't think I've seen it. The mybets sheet just shows as F or U so I'm guessing those matched unmatched are coming from your coding? Are you using the COM?

[mak]

what is your recresh rate? q2 cell..?

[edt123]

Refresh rate is 1
Only one sheet one race is linked to BA
Yes BA place results of your bet in the sheet on the location where you placed the trigger bet.if you delete this it repwrites it a second.
On Sunday, I deftely found a new race had this rubbish left over from the previous race.

Is nobody available who can take any responsibility for thsi system. I need to cut my losses if this a dead duck?

[Captain Sensible]

I think you need to re-read the manual regarding excel linking, if a bet reference is in a column BA will gather the status of that bet reference, are you clearing bet details when you switch markets?

What boxes do you have ticked for the Log Current Prices screen?

Untitled.png

[edt123]

Not sure I understand that reply or what it is intended to say:
I use a sheet1 to receive data form BA.
This is all linked to DDE and I have little control over it.

The manual says to place the trigger, odds and stake in given columns when I want to bet. This I do.
Sometimes nothing happens as I described to you about Sunday- what was your respoonse to that, or was there one? I dont understand.
Sometimes it returns more responses than there were bets. ??

If I resubmit a bet, it will respond to this too. Now I have n runners on the sheet and n plus m responses.
That is a huge problem because the onlu way i can identify what runner the response refers to is by the row in which the runner has been placed. that too is how BA knows which runner I was betting on. Do you disagree with this?

In Sunday, as previously described, I saw data in these betting columns when I had just refreshed a race and I also found bets had been submitted to BF without my intervention. I dont know if the bet data had been carried forward/left in place from the previous race, or some other malfunction placed the data there.
After that I tried manually deleting the datain columnd R to Y(I start on B1) instantly, BA replaced it on the next refresh. this tells me that I have no control over this.

I asked you how I can make a bet and then wait for a response to see what happened to it. Is there any answer to this query?
I have red the manual and while I am not Einstein, I dont think I have missed the solution. can anyone offer hrlp?

To repat the question form previously, is this software supported at all?
Do I have to trawl the pubs of Brum to get an answer- its only 20 miles away :-}

[edt123]

Not sure I understand that reply or what it is intended to say:
I use a sheet1 to receive data form BA.
This is all linked to DDE and I have little control over it.

The manual says to place the trigger, odds and stake in given columns when I want to bet. This I do.
Sometimes nothing happens as I described to you about Sunday- what was your respoonse to that, or was there one? I dont understand.
Sometimes it returns more responses than there were bets. ??

If I resubmit a bet, it will respond to this too. Now I have n runners on the sheet and n plus m responses.
That is a huge problem because the onlu way i can identify what runner the response refers to is by the row in which the runner has been placed. that too is how BA knows which runner I was betting on. Do you disagree with this?

In Sunday, as previously described, I saw data in these betting columns when I had just refreshed a race and I also found bets had been submitted to BF without my intervention. I dont know if the bet data had been carried forward/left in place from the previous race, or some other malfunction placed the data there.
After that I tried manually deleting the datain columnd R to Y(I start on B1) instantly, BA replaced it on the next refresh. this tells me that I have no control over this.

I asked you how I can make a bet and then wait for a response to see what happened to it. Is there any answer to this query?
I have red the manual and while I am not Einstein, I dont think I have missed the solution. can anyone offer hrlp?

To repat the question form previously, is this software supported at all?
Do I have to trawl the pubs of Brum to get an answer- its only 20 miles away :-}

[MarkRussell]

Hi,

To answer your question about support, if you need specific support you are best contacting us by email using admin@gruss-software.co.uk
We will do our best to answer any queries as quickly as possible.
The Forum is a useful resource for users to interact with each other and help each other and make suggestions on features etc
We do also reply on the Forum but not on every single post that is made.

With regards to Excel triggered betting; the idea is that you connect to the Excel sheet and once connected the software will read the trigger cells on every refresh of the data and act accordingly.
If the Bet Reference column is blank and the trigger cells are populated then the software will action the trigger if it is a BACK or LAY trigger.
Once the trigger has been actioned the bet reference column is then populated with the bet reference that comes back from Betfair or you might get an error message if the bet request failed (this is the response to the trigger)
This then prevents further bets being sent until the bet reference column is cleared.
When you first connect to the Excel sheet there are options which you can choose to tick or not that tell Betting Assistant what to do with the Bet Reference column when a new market is selected both manually or using one of the auto select options.
So if you have chosen to clear the bet references and leave the trigger columns populated then as soon as new market is selected the software will read your trigger and place a bet on the new market.
If you don't want that to happen then don't tick the option to clear the bet references.

Regards,
Mark

[edt123]

Thanks for the response Mark. This was not available through any other source I could find and there is no test mode, but I solved it in the end by trial and error - at some cost I miht add.
I find I have to stop the DDE or stop events in order to do anything with excel. otherwise I have a very nice excel solution now.
Thanks