1. #1
    HUY
    HUY's Avatar Become A Pro!
    Join Date: 04-29-09
    Posts: 253
    Betpoints: 3257

    I'm a professional programmer, let's make a system

    I'm a professional programmer with 15 years experience working in Python.

    I have made many sports models in the past. Some models were pretty good but none was better than the market.

    I can help you build your model, free of charge if I can learn something out of it.

    Hit me up.

  2. #2
    SsgKen
    SsgKen's Avatar Become A Pro!
    Join Date: 06-23-18
    Posts: 452
    Betpoints: 2532

    I know old coding like COBOL. I read about a teenager last year that used a TI programmable pocket calculator to write a model that predicted to World series winner but it was only +400 to tie up your money April to the Series,

  3. #3
    danwinkler
    danwinkler's Avatar Become A Pro!
    Join Date: 05-22-18
    Posts: 461
    Betpoints: 66

    Quote Originally Posted by HUY View Post
    I'm a professional programmer with 15 years experience working in Python.

    I have made many sports models in the past. Some models were pretty good but none was better than the market.

    I can help you build your model, free of charge if I can learn something out of it.

    Hit me up.
    Is there a way to write a program that will check email from a specific sender and then bet the picks in that email in your betting account? I hear about bots and stuff, so wondering if such program exists or possible to create. I used to follow a good service called "bettingresource" but I couldn't follow their picks regularly because of my business travels to various time zones. Would be great if there is a program that i can set to catch their picks email and then bet the picks in my betting account.

  4. #4
    danshan11
    I am good at coin flips, I really am!
    danshan11's Avatar Become A Pro!
    Join Date: 07-08-17
    Posts: 4,101
    Betpoints: 2888

    smartbet.io have them signup

  5. #5
    BTBFFF
    Update your status
    BTBFFF's Avatar Become A Pro!
    Join Date: 07-01-15
    Posts: 182
    Betpoints: 299

    Huy,

    Send me an email. I have a great idea with data points already collected. Have spent hours manually inputting and need to automate the process.

    andrew
    btbfff@gmail.com

  6. #6
    SsgKen
    SsgKen's Avatar Become A Pro!
    Join Date: 06-23-18
    Posts: 452
    Betpoints: 2532

    Quote Originally Posted by danwinkler View Post
    Is there a way to write a program that will check email from a specific sender and then bet the picks in that email in your betting account? I hear about bots and stuff, so wondering if such a program exists or possible to create. I used to follow a good service called "bettingresource" but I couldn't follow their picks regularly because of my business travels to various time zones. Would be great if there is a program that I can set to catch their picks email and then bet the picks in my betting account.
    The sportsbooks pretty much say that there are gaming bots that play the table games for you because they may have a 35X rollover. In the late 1990's I had a pocket calculator type thing that you could program various blackjack models with your own variations like; only split a pair of 7's vs house 3 if the count was better than [then you put in what variables you wanted]. If that was around in 1997, think of what must be out there now.

  7. #7
    bozeman
    bozeman's Avatar Become A Pro!
    Join Date: 11-11-09
    Posts: 2,161
    Betpoints: 5145

    Quote Originally Posted by HUY View Post
    I'm a professional programmer with 15 years experience working in Python.

    I have made many sports models in the past. Some models were pretty good but none was better than the market.

    I can help you build your model, free of charge if I can learn something out of it.

    Hit me up.
    hey huy, lets chat, I have an offer

  8. #8
    Chipup
    Chipup's Avatar Become A Pro!
    Join Date: 07-24-13
    Posts: 1,435
    Betpoints: 13

    xxx

  9. #9
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

    i have a good system for CBB, CFL and Tennis. If you like to chat, feel free to write me a msg

  10. #10
    Optional
    Optional's Avatar Moderator
    Join Date: 06-10-10
    Posts: 57,796
    Betpoints: 9194

    Quote Originally Posted by danwinkler View Post
    Is there a way to write a program that will check email from a specific sender and then bet the picks in that email in your betting account? I hear about bots and stuff, so wondering if such program exists or possible to create. I used to follow a good service called "bettingresource" but I couldn't follow their picks regularly because of my business travels to various time zones. Would be great if there is a program that i can set to catch their picks email and then bet the picks in my betting account.
    You could. But if you dont have control over the input data (emails) it would become too much work to decipher reliably enough to auto bet from. Easier to pay someone to enter the picks into your program.

    And you could only auto-bet at places that offer an API allowing it. Pinnacle, Betfair and a few others.

  11. #11
    SportsbetTracker
    SportsbetTracker's Avatar Become A Pro!
    Join Date: 04-30-10
    Posts: 26
    Betpoints: 55

    Quote Originally Posted by danwinkler View Post
    Is there a way to write a program that will check email from a specific sender and then bet the picks in that email in your betting account? I hear about bots and stuff, so wondering if such program exists or possible to create. I used to follow a good service called "bettingresource" but I couldn't follow their picks regularly because of my business travels to various time zones. Would be great if there is a program that i can set to catch their picks email and then bet the picks in my betting account.
    It should be possible if there are some caveats:

    1. The email text should be able to be programmatically accessed / read. If this is possible, then the logic to extract the bet's details: team, event, event date, and odds can be created. This is actually the easy part.

    2. The website is programmatically brought up.

    3. Most sites use a form of Ajax and other high-security programming hooks that make interacting with it programmatically difficult at best; certainly nothing I would risk with actual finances. Therefore, a method of heuristically navigating and interacting with the controls (text boxes, drop-down boxes, radio and check boxes),
    needs to be developed. Heuristics, in this sense, is a method in which emulates human entry by moving mouse pointers, clicks, entering text, etc.

    4. If the heuristic method is viable, then the next step is to compare email betting odds with the current betting site odds. For instance, you may get odds in an email that need to be acted in a timely manner, typically before the odds shorten or lengthen in a negative manner. If too much time has passed, the favorable odds you were sent in the email will not match the adjusted odds on the website. In this manner, the logic could be instructed to either ignore the changes if there is a difference, or to put in a "buffer" to allow for small changes, say half a point.

    5. The next step would be for the program to enter the information and make the bet, going in logical order, changing pages, and heuristically pushing buttons, confirmation buttons, etc. Optionally, the program would then email you with the details of this heuristically-entered bet, including obtaining the actual odds bet.

    In my opinion, even as a mid-level, non-industrial grade programmer I would not recommend this automation. I have actually considered it even back in the relatively easier HTML-loading days (8 years ago) when I had my Excel sheet betting system going. (The sheet automatically created bet amounts based upon a bankroll, previous bet results, and bet strengths.)

    Having said all that, I *believe* (without duckduckgoing) that there are services available that can make bets for you when you authorize them with your financial information and betting orders. For instance, you can cc your emails from the betting handicapper and they would make the bet for you within minutes of receiving the email. The advantage to such a service is that one can use several different betting sites and get the best odds. (I don't know the legality of betting sites themselves offering that service, but it would seem to be a good marketing angle if they did.)

  12. #12
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Any idea how to assinge a variable (VBA) the average of the last 15 cells in a column?

    Last15 = ' the average of the last 15 cells in, lets say, column C.

  13. #13
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Quote Originally Posted by Roscoe_Word View Post
    Any idea how to assinge a variable (VBA) the average of the last 15 cells in a column?

    Last15 = ' the average of the last 15 cells in, lets say, column C.
    Sub last15()

    Dim lastnumber as integer
    Lastnumber= application.worksheetfunction.count(work sheets("sheet1").range("a:a"))

    Dim last15average as integer

    Last15average= application.worksheetfunction.average(ra nge(cells(lastnumber - 14, 1), cells(lastnumber,1)))

    Msgbox (last15average)

    End sub

    Typing on a phone so I might have missed something somewhere. This looks at column a and gives the average of the last 15 number

  14. #14
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Quote Originally Posted by Waterstpub87 View Post
    Sub last15()

    Dim lastnumber as integer
    Lastnumber= application.worksheetfunction.count(work sheets("sheet1").range("a:a"))

    Dim last15average as integer

    Last15average= application.worksheetfunction.average(ra nge(cells(lastnumber - 14, 1), cells(lastnumber,1)))

    Msgbox (last15average)

    End sub

    Typing on a phone so I might have missed something somewhere. This looks at column a and gives the average of the last 15 number
    Thanks very much for that, Water.

    This line of code:

    Last15average= application.worksheetfunction.average(ra nge(cells(lastnumber - 14, 1), cells(lastnumber,1)))
    stops the program with a "run time error 6...overflow" message

  15. #15
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Is it all on one line?

    Will check when I get home.

  16. #16
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Quote Originally Posted by Waterstpub87 View Post
    Is it all on one line?

    Will check when I get home.
    Yep..on 1 line

    Thanks for the help!

  17. #17
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Quote Originally Posted by Roscoe_Word View Post
    Yep..on 1 line

    Thanks for the help!
    You are using column a on a sheet called sheet1?

  18. #18
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Here's the small program:

    Sub Last15()

    Dim LastNumber As Integer
    Dim Last15Average As Integer

    TopTeam = InputBox("enter top team")

    TopTeamFile2 = "C:\Users\Glenn\desktop" & TopTeam & ".xlsx"

    Workbooks.Open Filename:=TopTeamFile2

    LastNumber = Application.WorksheetFunction.Count(Work sheets("sheet1").Range("b:b"))

    Last15Average = Application.WorksheetFunction.Average(Ra nge(Cells(LastNumber - 14, 1), Cells(LastNumber, 1)))

    MsgBox (Last15Average)

    End Sub

    I'm using Column B.

    Don't know how to attach my excel file..sorry.



































































































































































































































  19. #19
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    My phone apparently put a space in between "worksheets" and "Range"

    should read

    Lastnumber= application.worksheetfunction.count(work sheets("sheet1").range("a:a"))

    Last15average= application.worksheetfunction.average(ra nge(cells(lastnumber - 14, 1), cells(lastnumber,1)))

    Also, do your workbooks open to "sheet1"

    You might add Sheets("Sheet1").select if this the case
    Last edited by Waterstpub87; 10-23-18 at 07:21 PM.

  20. #20
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Quote Originally Posted by Waterstpub87 View Post
    My phone apparently put a space in between "worksheets" and "Range"

    should read

    Lastnumber= application.worksheetfunction.count(work sheets("sheet1").range("a:a"))

    Last15average= application.worksheetfunction.average(ra nge(cells(lastnumber - 14, 1), cells(lastnumber,1)))

    Also, do your workbooks open to "sheet1"

    You might add Sheets("Sheet1").select if this the case
    Ahh...just can't get it. Never mind, my friend. Thanks much for the help. Win many bets, brother!

  21. #21
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Water, I got it to work....thanks for the help.

    Huy, sorry for hijacking your thread. I should have started a new one.

  22. #22
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,044
    Betpoints: 7292

    Quote Originally Posted by Roscoe_Word View Post
    Water, I got it to work....thanks for the help.

    Huy, sorry for hijacking your thread. I should have started a new one.
    Glad to hear it. Good luck with everything.

Top