Comments

And what would you do with that?  

Frankly to say I am not quite sure you understand what you can see on those videos. Those videos were actually made to report my progress on quite big project I am working on now for couple weeks. 

Yes, I developed similar app/bot for MySQL as well.

Hi Stefan,

is not possible make the same on MYSQL Database?

Bye Vincent

Unfortunately I did not have a time to add this bot to Community ones.  

I will do so in the update after betfair will cease Australian exchange service endpoint, so some changes will be required to bfexplorer as well.

What you executed by using Bfexplorer Console is just script, showing recorded data in XPlot charts. You need to execute the bot called: "Record Market Selection Data" to record those data first.

 Hi, I have the same question as Mir on this very useful looking bot . Where do we find the save market data bot dislayed? It looks like there is a Database "connection string" selection available within the bot. I have browsed through the SDK but have not found one with this property. Thanks for helping to find this or maybe describing how to create it.

Hi Stefan,

Thanks for this information. Instructions worked well.

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.