Comments

Hi Stefan,

Thanks for the advice below. I have solved the xplotly dll requirement by following your instructions and now have another question.

When I execute this bot the output report returns the error message "No time series available!"

Perhaps you have a tip on where I might be missing something?

Thanks

For more information read this article:

http://bfexplorer.net/Community/BlogContent/234#Save Betfair Data to Database

Visual Studio offers the NuGet package manager: 

https://www.nuget.org/ 

You can use it to quickly install all needed packages (assemblies/libraries) to your project, just type XPlot.Plotly 

On GitHub you can find source code for this project: 

https://github.com/TahaHachana/XPlot 

So alternatively you can clone or download XPlot, and build XPlot.Plotly.dll assembly yourself. 

Do not forgot that you have to replace path to bfexplorer assemblies this script is using as well. 

Well, I am not quite sure if you manage to do it yourself, as you ask for help in very base and common tasks any programmer/software developer must already know. I would really suggest to learn that first.

Yes, Microsoft Edge is my default Internet Browser, therefor the script opens Edge to show https://plot.ly/ charts. 

 Hi Stefan,

This looks like a nice addition, but I am having difficulty with the activation.  I have followed the video and receive the conosle error message in my output "FsiEvaluationException: Error:input.fsx(1,1):error FS0084 Assembly reference  '#r "D:\Projects\Bfexplorer\Development\Libraries\XPlot\bin\XPlot.Plotly.dll" was not dound or is invalid"

I imagine I need the dll file somewhere in my own C drive for reference but can not find it to add.

I noticed the graph opening in Microsoft Edge too, is this a possible default app setting somewhere?

I would welcome your advice and help with this and also please can you let me know where the stored data is actually stored for future access. (I have the store race data bot running but not sure how / where it is storing data)

Thanks very much.

Actually all you need is just to read the code. To any console application you can enter command line arguments, and in the code of the console application those arguments are passed as array of strings.

static void Main(string[] args)
{
    if (args.Length != 2)
    {
        throw new Exception("Please enter your betfair user name and password!");
    }

    var username = args[0];
    var password = args[1];

    var task = ExecuteMyTest(username, password);

    Task.WaitAll(task);
}

In the code you can see that the first argument (args[0]) represents your username and the second  argument (args[1]) your password. 

Go to the Solution Explorer and on the BetfairApiConsole project click with your right mouse button, select Properties menu item, and click on it. 

In the project properties window select Dubug, and in the Start Options sections, in the Command line arguments, enter your username and password. (the argument separator character is space). 

Execute your bot sdk project, and your betfair credentials will be used to login to betfair thriugh betfair api. You can debug your test bot project or create your own ones. 

In bfexplorer bot sdk you can find projects in C# or F# programming languages. 

Hi,

where is yours the "Save In-Play Market Prices" bot?

Need any upgrade?

I have just changed your subscription to Free Professional, you can execute bots now.

Thanks Stefan,

However, can you please check my status as I now receive an error message when trying to execute a bot . . . "Not Allowed To Use This Tool."

Thanks in advance.

Thanks Neil, community subscription is automatically prolonged to free subscription after your previous subscription expires (and you are allowed to use the community subscription), then after your donation I must changed your subscription status to Free Professional, please let me know when that happens.

Well, how to use bots?

Just try to browse all available bots, and you will find out that bot names suggest the bot functionality, and bot parameters in details describe this functionality.

For instance from your strategy, the cash out function. Bfexplorer offers this function/feature in bots having Close Position in their name (just type: close to Add a new order/bot dialog search input box to list all such bots).

I suggested using “Close Selection Bet Position At Odds” bot, as this bot operates on one selection, but you can use as well the bot: “Close Market Bet Position” that closes bet position on entire market, it cashes out all open selection bet positions. The Profit parameter is mandatory one, so if you want to force the bot to cash out at any profit/loss, you must set Profit to 0 and Loss to 0.001, what covers any profit or loss trigger condition.

Hi Stefan,

Wow, thanks for your detailed instructions . . . it works perfectly. I doubt I would ever have figured it out! I have made the donation for a month at this stage and will contribute to the forum.

Regards

Neil

NZ

If you want to trigger your action bots by football/soccer match score or time then you must use “Football Bot”.

Please install the latest version of bfexplorer:

http://bfexplorer.net/Products/Bfexplorer

In the old version the Score parameter was mandatory, and you want to trigger by match time only as well.

First you need to setup your two action bots, to place lay bet on “Over 2.5 Goals” and cash out.

1)

Use “Place Bet” bot and set following parameters: AllowPlacingBetInPlay to True (checked) , OfferMyBet to False, BetType to Lay, Stake, ExecuteOnSelection to 2, and name this bot setting: Lay Over 2.5 Goals

2)

Use “Close Selection Bet Position At Odds” bot and set following parameters: Odds to 0, ExecuteOnSelection to 2, and name this bot setting: Cash Out Over 2.5 Goals

3)

Use “Football Bot” and set following parameters: BotName to: Lay Over 2.5 Goals (use bot dialog to select your action bot, as typing the bot name you can make a mistake), Score to: 0 – 0, MatchTime to: 27, and name this bot setting: Lay Over 2.5 Goals at 27th minute and 0 – 0

4)

Use “Football Bot” and set following parameters: BotName to: Cash Out Over 2.5 Goals, MatchTime to: 46, and name this bot setting: Cash Out Over 2.5 Goals at 46th minute

5)

And finally to execute your strategy by one bot, use “Execute Bots” to add execute your two football bots, set the parameter BotNames to: Lay Over 2.5 Goals at 27th minute and 0 – 0; Cash Out Over 2.5 Goals at 46th minute (again use Select Bots dialog instead of typing bot names), and name this bot setting: My Football Lay Over 2.5 Goals Strategy (or of course name your bot settings as you like).

You execute “My Football Lay Over 2.5 Goals Strategy” on selected markets manually or you can use Bot Executor tool.

Hi, do you have any more information about this backtesting?

---------------------------
What do I need to be able to work with it?

No, there is no easy way to differentiate. Very unfortunate. Never mind, i'll keep manually choosing race meetings daily.

Use My Bet Position tool to close your bet position, or just see total profit/loss per market. Open Markets view also presents total numbers per market like: Total Matched, Unmatched Bets, Matched Bets, Profit Balance and so.

Read this article:

http://bfexplorer.net/Community/BlogContent/234#Save Betfair Data to Database

Unfortunately all information I have got about a race is already displayed in Event Browser. Maybe there is possible to distinguish between race types from a market name, and then you would be able to filter events in Event Browser view.

For GB and IE horse racing events, betfair offers timeform data, and I had done such projects which uses those data.

Betfair exposes their data through betfair api. In order to receive data from betfair server, the client (bfexplorer app) must sent a request to the server (betfair api server), the server replies with response data. This communication takes some time, and most of it depends on the Internet connection latency.

In my case I am from Slovakia so from my location the internet connection latency to betfair servers is about 70 ms. Users located in London have about 15 ms, basically as close your computer is to betfair ones in the Internet infrastructure, the better your Internet connection latency is.

So if I set update period to 50 ms, it actually does not mean that data from befair servers are delivered to bfexplorer every 50 ms, but instead it says that bfexplorer requests new data after 50 ms period.

To get real time period of market prices update time, you must add your Internet connection latency and of course a time needed to process those data by bfexplorer, and that depends on your computer power, this time is actually unimportant when comparing to the Internet connection latency time.

When using market/order streaming technology, a communication channel is open to betfair server, and bfexplorer only reads responses, so the intenet connection latency is applied only in one part of communication, and not twice like it is in REST client/server communication.

Betfair applies limitations to client/server communication asking developers not to update one market data quicker than 200 ms, such limitation is not applied to market/order streaming technology so you can set update period to 0.

Hi Stefan. What does it mean 50 ms update perod ? Every 50 ms prices are updated ? 50 ms is max. ?

First you need to define how you will bet on games. Have a look at on “Tennis Bot”:

http://bfexplorer.net/Articles/ByTag?tag=Tennis

From BDP, please see the answer to your other question below:

"The betfair market streaming service allows setting MarketFilter eventTypeIds, and many other filter criteria, what means that your app could be notified whenever betfair adds a new market to monitored eventTypeIds. The question is how frequently such filter setting queries data on betfair side?"

Notification of new markets fitting the subscription criteria will be pushed out by Betfair within ~50milliseconds of them being published into our database.