One click trading - free program coming soon

[GaryRussell]

Originally posted by: LayItYouMug
Oops. There was indeed a problem with LAYFIELD. I have now fixed it. Version 0.98q.

[GaryRussell]

Originally posted by: Down the drain
Thanks LayItYouMug
I was beging to think my excel programming was naff

the offical betfair in running delay is 1 sec,

If found no difference between your program and using the betfair site direct.

just glad i didn't back all at 1000 for £5

[GaryRussell]

Originally posted by: LayItYouMug
Sorry about that. It showed the message that you were backing the fields, but thankfully it was never going to happen due to a bug.

[GaryRussell]

Originally posted by: thunderfoot
What is the latest version that I should be using .... currently using "pre-release version 0.98p".

I've been using this program to download the Betting information to EXCEL, then using a macro in EXCEL to store the data, thus building-up pictures of betting activity over the course of a horse race (say every 1 second).

Can someone tell me why the EXCEL worksheet/workbook that Betting Assistant is downloading the data too doesn't like macro's running within it. I've managed to get over the problem I had by linking another EXCEL workbook to the one used by BA.
Would it be poosible to add the 'Matched' volumes to the downloads to EXCEL?

Also, what I haven't been able to work-out is what does 'Trigger betting Enabled' do?
Can someone please explain?

I've used BA a couple of times to place bets but have found that it doesn't do what I thought it would do because BA has become 'unstable'. For instance, I've used the 'Override Odds' function and set the Back Odds to 1.20 expecting a bet to be placed at 1.20 only to find that the bet was placed at the current Odds i.e. 4.00.
I've noticed that the 'unstable' issue happens more when there are quiet a few entries in the 'Market (quick pick)' area.

When working correctly, does the function only place a bet at the Odds selected i.e. 1.20, or will it place the bet at the next available lowest Odds i.e. 1.20 not available so the bet is placed at the next available lowest odds of, say, 1.18?

[GaryRussell]

Originally posted by: LayItYouMug
thunderfoot. Override odds only overrides the odds that you are requesting. If 4.00 was available when you requested 1.20 then you would be matched at 4.00. This is quite normal and works this way through the normal interface. You are actually requesting to be matched at minimum odds of 1.20. To only bet when a price goes down to 1.20 you would have to use triggered betting through Excel. It's too big a subject to go into right now. I will be putting some example on my website over the coming week.

[GaryRussell]

Originally posted by: IanP
Layit - regarding the time delay. I asked a few days ago about whether the bet was submitted immediately the trigger cell was populated or waited for the refresh cycle. I've just done a test, setting the refresh to 15 secs and I reckon that the bet doesn't get submitted until the next refresh, not immediately.

[GaryRussell]

Originally posted by: G-Factor
Thunderfoot.
Using BA is a quicker version of the samer process that happens when placing a bet on the Betfair site, ie. it requests the bet straight away, and betfair gives you the best odds available. If 1.2 is requested and 1.18 is the best available, your 1.2 bet will appear on the lay side for someone else to take (or not).

If you want to only place the bet when your odds are the best available then you have to do it using the triggered betting in Excel.


Toma.
Are you placing the back and lay from the same sheet automatically, or making the back manually then asking for the lay automatically at 0.8 lower?

[GaryRussell]

Originally posted by: G-Factor
I need to type quicker!

[GaryRussell]

Originally posted by: LayItYouMug
G-Factor. Thanks for backing me up

[GaryRussell]

Originally posted by: Joey Silvera
Gary...any way of fixing the 1/1a problem with US markets in excel? (ie When 1 is a non-runner, 1A gets missed out)

[GaryRussell]

Originally posted by: thunderfoot
How does 'Triggered Betting' in EXCEL work?

I've got the additional columns:
Trigger
Odds
Stake
Bet ref
Bet time
Avg matched odds
Matched stake

... but don't know how to use 'em. Are we saying that with 'Triggered Betting' in EXCEL we can get EXCEL to feed-back bets to Betfair?

[GaryRussell]

Originally posted by: LayItYouMug
IanP. Apologies, I think I misunderstood the original question. I meant that upon a refresh it would place the bet immediately and not wait for the next refresh. It is true that the triggers will only be inspected on each refresh so if timing is critcial you should have a low refresh rate set.

[GaryRussell]

Originally posted by: G-Factor
And a thousand thanks to you for sharing your program with us. For someone who normally misses all the prices because of useless fingers it's awesome!

Can I just ask, using Excel, do the matched odds and stake columns update when bets are taken if only part or none of the bet is matched on the first refresh of the sheet?

[GaryRussell]

Originally posted by: LayItYouMug
Joey Silvera. Sorry, I did see your message yesterday. I will fix it shortly.

[GaryRussell]

Originally posted by: IanP
Could this be why some people are saying it's slow, though ? There's actually a seconds delay between a bet being identified and actually being submitted.