Auto trade during the day

[LeTiss]

Where can I download this original sheet Peter?

I'm not so keen on the bells and whistles upgrade

I think this is the one you were referring to?

BetAngel_auto trading bot.xls

That's the one, thanks

I'm having trouble with the cells automatically clearing though. I'm having to keep pressing start on sheet 2

[lasse78]

I am Willing to pay somebody make me the Excel I want and implant it to betangel...

[mattiebee99]

I was wondering if someone can help me.I am trying to implement a trailing stop into the automated sheet however I arent having much luck. I have tried manually entering "TRAILING_STOP:TRUE" into the current instructions on the dashboard tab and then tried the bet angel tab. I also have the stop loss ticked. It tries to place the bet, however it doesnt execute the bet instruction on Bet Angel.

[bilko]

Hi Peter, thanks for providing the attached.

Recognising that it is a base from which to build from and it is up to everyone to expand upon its current capabilities if they want to, not being an EXCEL expert I have a couple of questions for the gurus out there:

The description of the formula in CELL E25 appears not to match the actual formula in E25 - is this just a typo or is it relevant to the process in any way?

How do I get the spreadsheet to trade more than one runner - do I just type in the command "=Sheet2!E20" in the relevant runners Bet rules field in column L on the Bet Angel spreadsheet, or do I have to replicate the instructions for runner one on sheet2 for the other runner(s)and put the appropriate command in column L?

If I just have to type in the command, won't this mean that the spreadsheet will not fire any new orders on a runner if there are unmatched bets on another runner outstanding?

Any guidance provided will be much appreciated.
Regards
Doug

Hi Doug

Were you able to find how to do this,if so can you please tell me.Plus how can I change the cut of time.

Thanks
Bill

[Bet Angel]

Did you check out this spreadsheet?

viewtopic.php?f=31&t=2085

[bilko]

Yes I did thought it had a mind of its own.

[bigdave]

Hi all

Just seen this thread and thought i'd have some input.
I've been using betangel for around 5 years or so now and over that period I spent hours (literally hundreds of hours) developing an excel spreadsheet the watches the event i am in in full and triggers trades when the conditions are correct.

The absolute key to creating anything like this is testing, testing and more testing. The formulas you enter onto the sheet can get quite complex and each minor tweak that you make can have a major effect, even if you think it is a very minor change.
Also, every so often, the way the market behaves can change which can put you off if you have a couple of losing trades. Extensive testing over a prolonged period is what is required BUT it is possible to have an automated excel sheet do your trading for you.

I have recently (with one or two things taken from the sheets mentioned earlier like clearing the sheet automatically) got to the point where i am happy to leave the sheet scalping the market for me when i am away from the computer.

Keep testing your formulas and then test some more!

[enzabella2009]

Hi guys,
Is it possible to place 100 bets or over on a single football match during the 90 minutes of the game using an auto trade bots?. I have been struggling to keep up with all the in play matches so, i have 3 months to lern how to use a bot before all the main european leagues start again. Bare in mind I am not bothered of the risks . All advices are welcome. thank you in advance

[mcosta007]

there is any manual with a list of commands to apply on spreadsheets ?

ps: sorry for my bad english.

[pryba88]

there is any manual with a list of commands to apply on spreadsheets ?

ps: sorry for my bad english.

I would love this too! The betangel guide for the excel integration did not give explanations for all commands available


Thanks
Dan

[ODPaul82]

The BA commands within excel correspond to the same features within the BA application itself.

OFFSET : X - How many ticks you want to place your offset bet against

FILL_KILL : TRUE/FALSE - Fill or kill the bet

KILL DELAY : x Number of seconds before you place your fill or kill bet

BATCHES : x - How many batches to split your offset bets to

STOP : x - Price to put your stop loss at.

STOP_PLACE : x - Not 100% sure as never used it, could potentially be the equivalent to stop on opening bet?

TRAILING_STOP : TRUE/FALSE - Is this going to be a trailing stop loss or not

WITH_GREENING : TRUE/FALSE - Is it going to have automatic greening up

CLOSE_TRADE - Close position using net stake (i.e. you back £100 at 3, lay price is now 2.5, it will lay at £100)

GREEN - Attempts to green up the market

CANCEL - Cancels the individual bet that you are on if it is unmatched.

CANCEL_ALL - Cancels all of your unmatched bets in the market

CANCEL_ALL_BACK - Cancels all of your unmatched back bets

CANCEL_ALL_LAY - Cancels all of your unmatched lay bets.

[Zenyatta]

The STOP only sets at what price the stop loss is triggered. However at this point, the price will usually have moved on and you will often miss it...because the prices move fast it will already have passed the trigger price, so the STOP PLACE is the maximum number of ticks you'd accept... the actual place of the 'get out' price (the exchange has to give you the best possible price so the price you get will be somewhere between the trigger point and the stop place).

[TheTub]

STOP : x - Price to put your stop loss at.

This is not correct.

x is the number of ticks away to place the stop. You cannot specify a price here.

STOP_PLACE:x

This is where to actually place the stop bet. In volatile markets your stop may trigger 5 ticks away but the price may move on another 10 ticks by the time your bet hits the market. So it makes sense to build in a buffer to give your stop order a greater chance of being matched. So if STOP is 5 ticks then STOP_PLACE needs to be 6 or greater depending on the market volatility.

[Zenyatta]

Note: I should point out there is still a bug with the GREEN_ALL command. This has cost me money, so I'd better point it out for other users.

Attempting to GREEN_ALL will sometimes give an 'Account exceedeed avaliable balance' error unless you have all the funds required to cover the entire cost of the corresponding LAY bets (if you BACKed and offset initially). This is a bug, because you shouldn't need to cover the entire cost of the lay bets if you already placed corresponding back bets (GREEN_ALL fails to take into account your current P&L position).

[TheTub]

I'm fairly sure that is not a bug. I think I'm right in saying that error message is generated by Betfair.