One click trading - free program coming soon

[GaryRussell]

Originally posted by: IanP
It's about 6 posts up on this page

[GaryRussell]

Originally posted by: The Lion
Thanks Pillhead!

Should ha sussed that out from earlier posts.

Now to write some formulae!

[GaryRussell]

Originally posted by: Alexandru
I would like to know what can API offer more than LayIt program.

For example: if there are 5 soccer games starting at the same time, I am interested in recording the data on all the markets in all 5 games. With LayIt program, I would have to use around 150 worksheets in Excel and the recording process will be very very slow. Currently I record only 1 game at a time and it is slow. Can Personal API do this in a more efficient/quicker way?

[GaryRussell]

Originally posted by: The Gambling Monkey
In the spirit of LayItYouMugs program here is a formula that I have found to be profitable in the long run.
Some things to bear in mind though.
Place market is shown and this formula only goes in the corresponding trigger cell for the place selection eg. P6, P8, P10 etc..
The top left cell is C1.
There are sometimes long losing runs.
Non-runners, muck things up. I have a macro which runs in that case which uses the reduction factor to correct the prices in column A.
Column A must hold prices of all runners at a specified time, I use 13:00 or 1 hour before racing starts.

=IF(AND($E$2>$A$1-TIMEVALUE("00:00:30"),$E$2<$A$1-TIMEVALUE("00:00:01")),IF(AND(J6<2,(1-(J5/A5))>=0.25),"LAY",IF(J6<2,IF(LEFT(MID($C$1,FIND(":",$C$1)+4,5),FIND(" ",MID($C$1,FIND(":",$C$1)+4,5))-1)="5f",IF(COUNTA($C$5:$C$30)>14,"LAY","No Bet(Conflict)"),IF(COUNTA($C$5:$C$30)<=14,"BACK","No Bet")),"In Time")),"No")

It's not perfect but works for me.

[GaryRussell]

Originally posted by: RD
I'm interested in this triggered betting on 'in play'

How would I go about laying two horses at specific odds as the market goes to 'in play' in Excel. I know very little about Excel and really would like to know how you would do this.

[GaryRussell]

Originally posted by: The Lion
RD

I just got told how to trigger a bet yesteday and this is the first formula I have come up with.

Try pasting this into the trigger cell for the horses you want to back:

=IF(E2="In Play", "LAY","Not Yet")

And enter the odds and stake you want in the corresponding cells for each horse.

If I have sussed it out correctly, (and I remind you this is my first try too), it should wait until the race goes in play and then enter your lay bets at the oods and stake you have specified.

Try it with very small stakes first as I may be wrong!

While I am on, has anyone got anywhere with devising a reliable stoploss.

I can work out the formula OK as it is pretty simple, but I don't want my stoploss back bet to be taken until after the in running market has developed, cos it will be caught by everyone who is trying to get laid at 1.01 and other low odds right at the start. We have all done that haven't we?

I tried logging the time at which the display turns to 'in play' and then setting the trigger to start a few seconds after the race goes in play, but as the sheet is constantly being updated the value updates too.

Anyone been working on this? Would love to hear if you have.

Cheers..

[GaryRussell]

Originally posted by: The Lion
Actually I just saw the post from Shaun T a bit back. Are you still around Shaun? If so could I see your stoploss formula please? Or if anyone else has it if Shaun isn't on here anymore.

Cheers again!

[GaryRussell]

Originally posted by: RD
Thanks Lion. I'll give it a try.

[GaryRussell]

Originally posted by: shaun T
hi email me at nhmaster2001 AT yahoo DOT co DOT uk for stoploss spreadsheet

ShaunT

[GaryRussell]

Originally posted by: Rollo Tomasi
houchy,
Thanks for that. I did a resize on the columns to hide those not required.

[GaryRussell]

Originally posted by: mikeyboymike
Lion, to get around your problem, I work out the overround in a cell, and only when this cell is less than say 130 (or whatever) do you execute your formula.

I'd be interested to know which markets you would try to implement this. I have found that horse racing is very volatile in running towards the end of a race (understandably) and with the delay, it causes problems.

Football also is a problem as the market gets suspended every time something of note happens.

[GaryRussell]

Originally posted by: The Lion
Mikey:

Good thinking on the overound there. I will have a go at that.

It was racing I was looking at using the stoploss on. For soccer inplay games I don't really see much need for a stoploss. With the trades that I do I just keep an eye on the scores, cos odds just seem to drift until a goal is scored and then jump wildly.

I know what you mean about the volatile market at the end. I have found that my stoploss was firing even when it didn't have to. Which I suppose is better safe than sorry, but I did find that I was missing out on some losing lays.

I still find that the best method is to just watch the odds change in the main window of the program with the trading function on, and trade out if it looks like you may lose your whole liability, there is no substitute for human judgement, (or is there?)... I also try to trade out at a profit in play in most races, so I don't need to rely on the stopploss, but I am trying to develop as system that I can leave unattended if I have to. Does that make me a botter?

Thanks to Shaun for his stoploss sheet. I would recommend anyone who is interested in a stoploss ask him about his system.

Cheers.

The Lion Indeed.

[GaryRussell]

Originally posted by: mikeyboymike
One thing you have to be careful of is that the spreadsheet turns in play before all of the prices are set to zero.

[GaryRussell]

Originally posted by: bunneh
cant see the match coupons in Tennis anymore, only see Winner nothing else ?!

[GaryRussell]

Originally posted by: The Lion
Mikey:

Thanks mate I hadn't noticed that. I will keep my eye on it.

The Lion.