BFbotmanager Automation Discussion
-
Lastly, we need to merge these 2 connections to get the finished CSV.
Click get data, combine queries, merge.
Highlight EventId on both.
Click the funny arrow thing beside query 2 and select the columns you want. Obviously not EventId as you already have that.
The 3 new column names need edited to remove Query2. from the names.
Because we have downloaded loads of extra markets and used the eventId to merge we need to filter to just over 2.5.
Use marketname or markettype to do it.
Perfect.
Close and load to existing worksheet.
Save this file. Not in one of the 2 folders we set up though.
Then save the results as a csv file to upload to BM.
-
The workbook you were working on should still be open.
So repeat from stage
"On the data tab, click Get data then Launch power query editor."
At Folder.files use your 2nd file path.
After Binary.combine we should have something like
Highlight the ones in green, right click header and remove other columns.
Close and load as a connection same as above.
-
Type that exactly, press enter.
It should open out. My file had a few other strategies in it but that doesn't matter.
Now to tidy it a bit for later use.
Double click the Filter name header and change to Provider.
Double click the BF Event ID header and change to EventId.
Double click the MatchID header and change to MatchId.
Highlight Provider MatchId and EventId then right click the headers and remove other columns.
Click the drop down arrow next to provider. Select over 2.5 goals test only.
Add a conditional column
This adds the selection ID we found way back at the beginning.
Make sure the column is named selectionId
Click close and load to (top right)
Only create a connection.
-
@Mark-Girling Lets make it easy for you then. 1 time set up but then it's a doddle.
In this example we'll use the OVER 2.5 goals market.
You'll need 2 new folders. 1 for the BTC export. 1 for the markets export from BM.
Put the BTC export in it's folder.
It should look similar. If it doesn't have a filter name column it's probably because you exported instead of exporting all.
Load the markets in to BM and export them to a CSV and put it in the other folder you created.
At this point copy the file paths to both folders as you will need them.
So what information do we have in these exports.
BTC
BM
What information do we need.
To find out we select a few over 2.5 selections and use export My S.
Don't change anything apart from the tipster name.
So we want the end result of our work to include these columns (Handicap and bet type are obviously not required.
So now we use the 2 files we put in the 2 folders to get this result.
Open a blank excel workbook.
On the data tab, click Get data then Launch power query editor.
Right click in the blank bit on the left underneath queries. New query - other sources - blank query.
Then you get the function bar and the query pane shows you are now doing query1.
Press Fx then type folder.files("yourfirstfilepath")
Yourfirstfilepath as in 1 of the 2 you saved not these exact words. Press enter.
Now we want to make sure we only take the latest file from the folder.
Click on the filter arrow on date created. Then date/time filter then is latest.
On the right you should see query settings. If not go to view in top ribbon and click query settings.
Right click on Filtered rows and select insert step after.
TBC
-
@alexander-hughes wow cheers buddy ... yes I'm using Excel...
I'll have a play around Thursday...
Thanks for your time
Rgds Mark
-
@Andrew-Gray Ta. Put it into action and it seems to work ok.
-
@alexander-hughes thanks alot
got that in there now to try and work out how to import the tips tomorrow
-
@Mark-Girling
An example of what works based on over 3.5 goals.
I think it really only needs SelectionId, Provider and MarketId.
As you can see, for the goals markets, once you ave the SelectionId it's always the same no matter which game.
Best way to find it is to use BM.
Load up 2/3 markets and make sure you tick the over/under market you want.
Then export to csv. You'll get the information you desire for a selectionId.
Transform and combine the BTC export, upload it. Done.
Note :- MarketId in spreadsheets may be wrong as any ending with 0 or multiple 000s if treated as numbers might have them missing.
Are you using excel ?
-
I use this.
-
@alexander-hughes thanks I'll try that tomorrow......
-
@Greg-Mitchell I believe that should work Greg, as I just asked for clarification on a very similar question on the BFBM forum. You would obviously have to add in the selection conditions area what trap you actually want to bet on as well (or whatever criteria you use to determine it)
-
After a bit of help, but I want to put conditions on a bot which only puts a bet on if the 2nd and 3rd Favourites are in a certain position (Trap - Greyhounds).
I have set the conditions as follows:
Will that work and only place a bet if the 2nd Fav is in Trap 1 AND the 3rd Fav is in Trap 2?
-
@Adam-Cubbage If you are using excel pop up your csv file from BTC later tonight and i'll show you a really easy and quick way.
Takes a little effort to set up, but after that it's quicker than your kettle boils to export them, create the upload CSV and then upload it to BM.
-
Hey guys
Having trouble importing my football selections into BFBM, is there a video guide or some info in the feed I may have missed which can help me out.
Importing the horses was easy with the guide of the video that Martin created, was hoping there is something similar.
Cheers -
@Mark-Girling are you wanting to bet on any matches indiscriminately, ie any matches that fit the odds range flowing through BFBM, or will you be filtering by certain leagues or certain teams?
I prefer to do all my filtering and odds range in the BTC software, export the selections to google sheets and then upload them as tips.
That way I have a bit more control over the selections.
-
@Mark-Girling
Bet if specific market selection is within set price.
This looks to me to be what you want to use to check the home teams odds.
So a straightforward 02.5 within the odds plus that.
That's my guess.
-
Hi, I'm trying to bet on,
Over 2.5 Goals of odds between 1.7 - 1.9
when the home teams odds are below 1.67
i'm using Fairbot atm but want to convert a few Strategies,
Please help
rgds
Mark
-
@Jono Yeah.
I do it via power query. Don't even look at selections.
1 folder for the BM export. Download to that folder.
1 folder for BTC export, dito.
Open PQspreadsheet, click refresh, save it, upload it, voila.
Saves ages as you say.
