This short video shows how to setup database and bot for saving betfair market prices. We use Microsoft SQL Server Express database and SQL Server Management Studio to manage database and query data.
After attaching database mdf file, you need to rename it to: MarketPricesDatabase
Your installation of SQL server will use different name, so you need to change the connection string when setting up your bot. The default connection string is:
Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=MarketPricesDatabase;Integrated Security=True
So SQL server name is: (LocalDb)\MSSQLLocalDB, but on your computer this database server name will consists from computer name, so:
Therefor you need to set your bot to use different connection string, for instance:
Data Source= MyComputerName\SQLEXPRESS;Initial Catalog=MarketPricesDatabase;Integrated Security=True
You can execute your bot on manually open markets, or using Bot Executor on many market setting to start bot execution at set time, relative to official market start time.
Comments ( 3 )
is not possible make the same on MYSQL Database?
Yes, I developed similar app/bot for MySQL as well.
This bot called "save market prices" looks very similar to the "save in play market prices". Are they both available somewhere now the new release is available?