Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Yeti)
  • No Skin
Collapse

BFbotmanager Automation Discussion

Scheduled Pinned Locked Moved Automation
884 Posts 98 Posters 57.4k Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    alexander hughes
    replied to alexander hughes on last edited by
    #81

    Lastly, we need to merge these 2 connections to get the finished CSV.

    Merge.JPG

    Click get data, combine queries, merge.

    merge1.JPG

    Highlight EventId on both.

    query2.JPG

    Click the funny arrow thing beside query 2 and select the columns you want. Obviously not EventId as you already have that.

    merged.JPG

    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.

    Marketname.JPG

    Use marketname or markettype to do it.

    save.JPG

    Perfect.

    Close and load to existing worksheet.

    done.JPG

    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.

    A 1 Reply Last reply
    1
  • A Offline
    A Offline
    alexander hughes
    replied to alexander hughes on last edited by
    #82

    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

    combine2.JPG

    keep.JPG

    Highlight the ones in green, right click header and remove other columns.

    BFmarketskeep.JPG

    Close and load as a connection same as above.

    A 1 Reply Last reply
    1
  • A Offline
    A Offline
    alexander hughes
    replied to alexander hughes on last edited by alexander hughes
    #83

    Newstep.JPG

    binarycombine.JPG

    Type that exactly, press enter.

    file1.JPG

    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.JPG

    Highlight Provider MatchId and EventId then right click the headers and remove other columns.

    3columns.JPG

    Click the drop down arrow next to provider. Select over 2.5 goals test only.

    filtered.JPG

    conditional column.JPG

    Add a conditional column

    SelectionId.JPG

    This adds the selection ID we found way back at the beginning.

    Finish.JPG

    Make sure the column is named selectionId

    Click close and load to (top right)

    closeandload.JPG

    Only create a connection.

    folder1done.JPG

    A 1 Reply Last reply
    1
  • A Offline
    A Offline
    alexander hughes
    replied to A Former User on last edited by
    #84

    @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.

    btcexport.JPG

    It should look similar. If it doesn't have a filter name column it's probably because you exported instead of exporting all.

    exportbm.JPG

    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

    btcexport.JPG

    BM

    bfmarkets.JPG

    What information do we need.

    To find out we select a few over 2.5 selections and use export My S.

    025info.JPG

    bmexport25.JPG

    Don't change anything apart from the tipster name.

    o25bmexamples.JPG

    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.

    excelblank.JPG

    On the data tab, click Get data then Launch power query editor.

    powerquery.JPG

    Right click in the blank bit on the left underneath queries. New query - other sources - blank query.

    query1.JPG

    Then you get the function bar and the query pane shows you are now doing query1.

    folderdotfiles.JPG

    Press Fx then type folder.files("yourfirstfilepath")

    Yourfirstfilepath as in 1 of the 2 you saved not these exact words. Press enter.

    result.JPG

    Now we want to make sure we only take the latest file from the folder.

    Latest.JPG

    Click on the filter arrow on date created. Then date/time filter then is latest.

    Query settings.JPG

    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

    A ? 2 Replies Last reply
    2
  • ? Offline
    ? Offline
    A Former User
    replied to alexander hughes on last edited by
    #85

    @alexander-hughes wow cheers buddy ... yes I'm using Excel...

    I'll have a play around Thursday...

    Thanks for your time

    Rgds Mark

    A 1 Reply Last reply
    0
  • Greg MitchellG Offline
    Greg MitchellG Offline
    Greg Mitchell
    replied to Andrew Gray on last edited by
    #86

    @Andrew-Gray Ta. Put it into action and it seems to work ok.

    1 Reply Last reply
    0
  • A Offline
    A Offline
    Andy Lucy
    replied to alexander hughes on last edited by
    #87

    @alexander-hughes thanks alot
    got that in there now to try and work out how to import the tips tomorrow 👍

    1 Reply Last reply
    0
  • A Offline
    A Offline
    alexander hughes
    replied to A Former User on last edited by alexander hughes
    #88

    @Mark-Girling 35goal.JPG

    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.

    navig.JPG

    Load up 2/3 markets and make sure you tick the over/under market you want.

    export.JPG

    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 ?

    ? 1 Reply Last reply
    1
  • A Offline
    A Offline
    alexander hughes
    replied to Andy Lucy on last edited by
    #89

    @Andy-Lucy layaway.gz

    I use this.

    A 1 Reply Last reply
    👍
    0
  • ? Offline
    ? Offline
    A Former User
    replied to Jono on last edited by
    #90

    @Jono I'd like to bet on my own filtered games within these odds but I'm struggling once I export them how to modify the spreadsheet so BFBM recognises them...

    Thanks for your help all

    Rgds Mark

    A 1 Reply Last reply
    0
  • ? Offline
    ? Offline
    A Former User
    replied to alexander hughes on last edited by
    #91

    @alexander-hughes thanks I'll try that tomorrow......

    1 Reply Last reply
    0
  • A Offline
    A Offline
    Andrew Gray
    replied to Greg Mitchell on last edited by
    #92

    @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)

    Greg MitchellG 1 Reply Last reply
    0
  • Greg MitchellG Offline
    Greg MitchellG Offline
    Greg Mitchell
    wrote on last edited by
    #93

    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:

    b330cbca-df82-405a-9d5b-741030722b85-image.png

    Will that work and only place a bet if the 2nd Fav is in Trap 1 AND the 3rd Fav is in Trap 2?

    A 1 Reply Last reply
    0
  • A Offline
    A Offline
    Andy Lucy
    wrote on last edited by
    #94

    hi guys does anyone have a bot for lay away 1.0 strat? i want too make one but bit confused as never done one on hear so was going too use it and learn from its settings hopefully.

    A 1 Reply Last reply
    1
  • A Offline
    A Offline
    alexander hughes
    replied to Adam Cubbage on last edited by
    #95

    @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.

    1 Reply Last reply
    1
  • Adam CubbageA Offline
    Adam CubbageA Offline
    Adam Cubbage
    wrote on last edited by
    #96

    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

    A 1 Reply Last reply
    0
  • JonoJ Offline
    JonoJ Offline
    Jono
    replied to A Former User on last edited by
    #97

    @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.

    ? 2 Replies Last reply
    0
  • A Offline
    A Offline
    alexander hughes
    replied to A Former User on last edited by
    #98

    @Mark-Girling thisoption.JPG

    Bet if specific market selection is within set price.

    thisoption1.JPG

    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.

    ? 1 Reply Last reply
    1
  • ? Offline
    ? Offline
    A Former User
    wrote on last edited by
    #99

    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

    A JonoJ 2 Replies Last reply
    0
  • A Offline
    A Offline
    alexander hughes
    replied to Jono on last edited by
    #100

    @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.

    1 Reply Last reply
    0

  • Login

  • Login or register to search.
  • First post
    Last post
0
  • Login

  • Login or register to search.