One click trading - free program coming soon

[GaryRussell]

Originally posted by: BillKiller
LayIt, you once said you would look at making your program read data from a text file and act accordingly. For example:

Horse A, Back, 3.1, 15
Horse B, Lay, 2.0, 20

Are you still going to do this?

[GaryRussell]

Originally posted by: hamish james
having some problems . bet manager, cancel bets andp&l not functioning any help much appreciated

[GaryRussell]

Originally posted by: Toma
Hi Hamish, I to am experiencing problems today with my LAY bets I just keep getting ERROR....again any help appreciated!

[GaryRussell]

Originally posted by: Toma
I think I know what my problem is I am calculating odds that I want to LAY a selection at and I am guessing that the ERROR is because the ODDS are not acceptable to BETFIAR. on my screen it looks fine i.e. 1.8 etc. but because they are calculated odds I am guessing there may be decimal places included in that figure (even though I format the cell to 2 decimal places).

Anyone got any ideas how I can calculate the odds and ensure that they will compatible to Betfair?

[GaryRussell]

Originally posted by: mikeyboymike
Create a column with all of the valid odds, then use VLOOKUP. Excel help will explain how this works.

[GaryRussell]

Originally posted by: You are logged in as
Try using the round up function rather than formatting the cells

=+IF(F5>0,ROUNDUP(stake/F5,2),"")

[GaryRussell]

Originally posted by: IanP
Yes, having the unacceptable odds brings back ERROR .. it used to be NULL but Layit changed it over the weekend.

[GaryRussell]

Originally posted by: You are logged in as
If your calculations are throwing up rounded up odds that aren't on the betfair ladder you'd need to make a list of the betfair odds ladder and then just match your odds to the nearest value

Take a look at

<a href="http://www.cpearson.com/excel/lookups.htm" target="_blank">http://www.cpearson.com/excel/lookups.htm</a>

at the closest match lookups part. Should do what you need

[GaryRussell]

Originally posted by: Toma
Cheers Guys,

After racing today I will get stuck into your suggestions and hopefully sort it out for tomorrow....Once again thanks for your support very much appreciated!

[GaryRussell]

Originally posted by: LayItYouMug
There is a function in my program that rounds to the nearest acceptable Betfair odds. I will change the program to use this function on all requests making this error impossible.

[GaryRussell]

Originally posted by: Toma
Cheers Layit, that would be fantastic much appreciated mate!

[GaryRussell]

Originally posted by: chuffmagarley
Hi Gary ,
can you use your programme to set up lays in ,say the morning ,(that wont be taken due to them being short),and will be resubmitted after the suspend comes off ,IE goes in running,

I suspect Ill have to use triggered betting from Excel ,but Im not that au faix with it ..any help from anybody would be greatly appreciated..

cheers and a big thanks to Gary for his work on this FREE app....

[GaryRussell]

Originally posted by: soccergeez
is there a stop loss function available on the program anyone?

[GaryRussell]

Originally posted by: LayItYouMug
chuffmagarley. Probably could be accommodated by triggered betting. Don't have time right now to explain how. I will be adding some examples to the website over the coming week, this will be a good example.

[GaryRussell]

Originally posted by: LayItYouMug
soccergeez. No. I will try and include in a future version.