User Comments

In this case the time is not represented by TimeSpan value which correct text representation is in the form you typed: 1:25:00 (hours:minutes:seconds), but just an integer value, like you can see 84 minutes. So in the filter type: 85

Eric, in last days I published 4 articles with videos, showing how to create a simple bot trigger and in two articles (videos) I showed how to use Bot Trigger. So you say:

1) You are not able to copy one of bot scripts to your computer.
2) Setup Execute Trigger Bot, what means entering two parameters: TriggerFilePathname and BotName
3) You are not able to start this bot on selected market, just for testing.
4) And you are not definitely able to use Bot Executor, or Bot Executor for Selections tool to execute your strategy on many markets automatically.

On the other hand you still prefer some kind of Spreadsheet reporting bot solution. From years I develop bespoke solutions for betfair, people tend to name a software, an application, a program just a bot.

May I ask you which betfair application you use, the bot which interacts with Microsoft Excel spreadsheet and do your betting for now? If you prefer only Spreadsheet type of bot operation, that I think you should use spend some time to learn Visual Basic for Automation because I do not think you will manage to run your automated bot solution without it. I think there are 2 or 3 betfair applications offering spreadsheet bet triggering, like Bet Angel, Gruss Betting Assistant or Cymatic.

I never wasted my time with Excel Spreadsheet betting as I prefer my own bot programming, but others on this forum may have some experiences with use of the above mentioned “bots”.

I am sorry Eric, but I still do not understand.

How other betfair apps work with Excel? I believe that betfair app populates Excel worksheet, so every selected market is populated on different Sheet (Page). Excel just presents betfair market data.

Triggers are constructed on sheet cell values, and any action (bet placing) is again triggered by exact value in certain cells, right?

You said that you use Excel worksheet and your bot to bet on your selections throughout a day, so you must link all betfair markets to Excel worksheet and then setup triggers for selected horses. All that must be quite a lot of work.

You use some staking plan, so to execute such staking plan on Excel worksheet you must create a program some VBA code because I cannot believe that you are able to do so just by setting some formulas in cells, like you do in setting up your selections triggers, am I right?

So you have got some knowledge about programming, my question is then, why do not you use Bfexplorer Bot Trigger to program your staking plan? If you manage to do so then you can create your action bot, simply by setting parameters for Place Bet bot, name such bot setting and use this bot name within Execute Trigger Bot and your Staking plan trigger.

Having such bot setup you can use Bot Executor, or in your case Bot Executor for Selections, to execute your betting strategy with defined staking plan on selected horses.

Eric, could you be more specific in what way spreadsheet will help to make a trigger betting on a race depending on a previous horse results?

I cannot imagine the way the spreadsheet would load all previous horse results and help you to trigger a bet depending on those results.

In some case betfair takes activation just couple seconds, sometimes you need to wait minutes.

I will prepare series of articles describing how to use this bot.

When you have a look at on other betfair API apps which support automation or trigger betting/trading, then such apps either offer limited number of trigger values you can use or are specialized in some kind of trigger betting.

You are on betfair a couple years now, we started at the same time, and you know that there never quite a lot of features you could use, therefore I still support betfair bot programming (Bfexplorer BOT SDK), but with trigger bot I added bot orchestrations, because sometimes you just need to setup action bot with different parameters, or you just need additional triggers.

This bot should solve what you asked in your article: Settings of many bots.

It is still programming, but scripting language used for trigger programming should be more readable for a common user, not a programmer.

I will try to create a lot of examples, so in some cases you should be able to use such triggers just by copying some parts of them and create your new one.

I will explain this trigger on simple betting strategy like Back correct score 0 – 0 and lay draw, on your example of how to setup many bots, or for Eric horse racing strategy.

If you have got some strategies then let me know, or the one used generally on betfair, maybe not profitable but if a good examples for some trigger programming then just post the idea on bfexplorer forum.

Behind any betfair strategy is a well, a data recording and analyzing, so I want to add some tools for such operations as well.

I will investigate this issue, maybe it is just rounding problem.

The video in my article just demonstrates how to use the bot: Execute Till Target Profit. When testing this bot on greyhounds markets I had luck that both lay bets were winning bets.

This bot checks profit from running strategy and when set profit is reached it stops/blocks further execution of an action bot.

It means you can use this bot in any strategy where you start further execution only after previous result is known, and stop your strategy after set profit is reached.

If you want to automate your strategy then first you load markets on which you want to run your strategy to Event Browser. In the Event Browser you can filter only desired markets, and then open the execution of your strategy on all or only on selected markets to Bot Executor.

The Bot Executor is then responsible to open a market at set time and execute your strategy on the market. Bot Executors keeps market data monitoring till running bot/s finish/es execution.

I already explained when you should use Bot Executor to run your strategies in this article:

http://bfexplorer.net/Community/ForumContent/56#Named Selections Horse Racing

Of course when testing you can run your strategy manually as I did in my video.

Yes, you can use a horse form in your trigger bot. I did not yet show how to create and use Execute Trigger Bot, but all is ready in the latest version of bfexplorer 1.6.5676.

You can use Bfexplorer Console tool to browse market data, read this article:

http://bfexplorer.net/Community/BlogContent/59#Bfexplorer Console

And test the code to show horses form.

If you post in a general description of your strategy (use parameter names), then I prepare a trigger bot and show you how to use it.

Please watch all main product feature videos:

http://bfexplorer.net/Products/ProductFeatures

Actually this spreadsheet ladder allows one click bot execution. You can type a bot name to every row on one or the other side of ladder.

As I said I see some potential in spreadsheet dashboards, for instance in tennis trading you could prepare different execution plans for different match scenarios.

I would like to ask to make a short video showing a problem you describe.

You are Czech, so are able to read the email from other Slovak user who notice some problems I was not able to reproduce:

http://bfexplorer.net/Community/BlogContent/58#How To Test Betfair Bot?

In your case I cannot see a problem why bfexplorer should show different profit balance on an open bet position when bet was placed on odds you described.

Your ladder can be built in simplified version using custom built bot and built-in bfexplorer spreadsheet.

In this bot I implemented bot execution similar to the one you can use in bfexplorer ladder context menu, when declaring the bot category name: My Ladder Bot.

In this case you can define/name your bots you want to execute from spreadsheet in columns B or E, when clicking on a cell with a bot name in the spreadsheet your bot is executed with changed BetType parameter of the bot depending on which column the bot name is, so B column sets Back, and E column sets Lay bet type for executed bot, if this bot supports BetType parameter, of course.

You can see that I declared general trading bot (Trade 3 ticks) to be executed from the spreadsheet. For now I cannot see any value in your approach, but I find it interesting to include such bot in Bfexplorer BOT SDK, as a sample for using Bfexplorer Spreadsheet and custom built bot.

I can see some advantage of using Bfexplorer Spreadsheet for building custom dashboards for some betting or trading solutions on more associated markets, or in any dashboard solution.

For a common user what is offered in the card view of Open Markets view, is really enough to managing bet position on a lot of open markets.

Bfexplorer spreadsheet can be used as well for data visualization, so it has some advantage for users who are familiar with bot programming.

I build bespoke solutions for betfair, so your ladder with selected price ranges can be built, but that is a question of your budget you are willing to pay for development of custom built software for betfair.

I made a video showing how you can use bfexplorer to execute your betting or trading strategy on selected market selections.

Bfexplorer is able to monitor a lot of markets concurrently, and run bots on such markets as well. Manually opening a lot of markets and executing bots on them make sense only if your betting/trading strategy involves market price monitoring for long period of time before bet placement is actually triggered.

If your strategy needs to execute a triggered bet placement just couple seconds before horse racing start, then you should use Bot Executor tool, and if you manually select your market selections then you should use Bot Executor for Selections tool.

Both tools start market monitoring automatically at time you set, and continue market monitoring till action bot is active on the market.

In my video I used OLBG web site to bet or trade on free tips offered by users of this web site. You can see that opening markets using bfexplorer Bet Event Browser is not as complicated as you could assume. You open Upcoming events and filter by event type, in my case Soccer, and/or Horse racing. Then you can use searching capabilities of bfexplorer to find desired market, or selection.

On my video can be seen that searching capabilities are supported by all grid views, I searched for preconfigured bots in My Bots view as well.

Bot Executor for Selections tool uses Bet Event or Market Selections view to add your market selections. You select your market selection and add it to Bot Executor for Selections by clicking on context menu (right click mouse button) Add Market Selection to Bot Executor.

After adding your sections to this tool you can assign an action bot you want to execute on these market selections. The tool uses My Bots preconfigured bots, so you can execute different betting or trading strategies on these selections. In my video I set to back one selection, and lay two other selections, on the one market selection I set to execute back trading bot to close position hedging for 3 ticks profit.

All bfexplore bot are configurable using a lot of parameters. For now there is only one bot supporting target triggered continuation of betting or trading on more markets: Execute Till Target Profit.

On the other hand bfexplorer offers Bfexplorer BOT SDK so if you are familiar with programming you can create your own custom bot to executed different methods of market selection or staking plan execution.

It is almost impossible to create a universal solution for market selection, bet triggering and staking plan execution, just by constructing bots with preset parameters.

As I said those familiar with programming can use Bfexplorer BOT SDK to program anything, for the rest I will try to make some kind of scripting bot.

Open the Output view clicking on the menu item View / Output. If betfair api refused to placed your bet then you could read the error message associated with this bet placing. I assume you will read the following message: Failed to place bet: INSUFFICIENT_FUNDS.

There is a list of product features with short videos. Click on the product feature you want to learn more and watch a video.

http://bfexplorer.net/Products/ProductFeatures

This video just shows possibilities of Bfexplorer BOT SDK and Bfexplorer UI (User Interface) to visualize some signals used for manual trading. Any BOT developer can develop similar ones.

Unfortunately, bots presented in this video are not available for public use, as are part of my bigger project for automated trading on horse racing markets utilizing machine learning.

What is the advantage of reversed ladder? I would say none.

Thanks to hrabia for donating 80 EUR for further development of this betfair tennis bot.

Thanks to dkonemedia for donating 30 GBP for further development of this tool. The goal target is set to 300 GBP for releasing this tool for public use. Any donated amount will give a donor a pre-release access to this tool.

This beta version includes tool integration with bfexplorer, so you reopen monitored market to bfexplorer by clicking on Open in bfexplorer button.

Betfair API implementation limits total amount of data retrieved through betfairAPI, therefore keep in mind that you can open for monitoring a reasonable amount of markets.

It is last price traded volume.