1. #3151
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Fade pip query library day 9

    mem/lac O 1 unit
    den beats bkn 4 units
    tor/no U 2 units
    no beats tor 5 units
    phi/mia O 2 units
    sa/ut O 2 units
    ut beats sa 5 units
    mn beats hou 1 unit
    bos/phx U 1 unit

  2. #3152
    emceeaye
    emceeaye's Avatar Become A Pro!
    Join Date: 08-20-13
    Posts: 704
    Betpoints: 2709

    1st quarter fade of team who experienced let-down last night

    Pip,
    What do you think of this for tonight?

    0 < p:M3<=5 and AD and -2 > p:margin >=-7 and rest = 0 and p:overtime=1 and rest = 0 and [M1 > -2.5]
    Last edited by emceeaye; 02-23-15 at 04:45 PM.

  3. #3153
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by emceeaye View Post
    Pip,
    What do you think of this for tonight?

    0 < p:M3<=5 and AD and -2 > p:margin >=-7 and rest = 0 and pvertime=1 and rest = 0 and [M1 > -2.5]
    Sorry, I just got back from work and it looks like that game already sailed. But I sure as heck didn't see anything wrong with the query. I kind of stopped with those 1st quarter games because I got stung too many times. Maybe if I come across one where the two teams from last night were both major contenders, and the loss for one of them was heartbreaking, and today that team is playing some run of the mill team full of eager beavers who always come out strong and then fade at the end (bos as the spoiler rather than the team that lost the tough one the night before?)...Unfortunately I will probably always look for some reason to make that bet..

  4. #3154
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    mem/lac O 1 unit --> -1
    den beats bkn 4 units --> -4
    tor/no U 2 units --> -2
    no beats tor 5 units --> +5
    phi/mia O 2 units --> +2
    sa/ut O 2 units --> -2
    ut beats sa 5 units --> +5
    mn beats hou 1 unit --> -1
    bos/phx U 1 unit --> -1

    total +1
    running total +14
    (81-67)
    Last edited by pip2; 02-24-15 at 07:07 AM.

  5. #3155
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Fade pip query library day 10

    cle/det U 1 unit
    det beats cle 2 units
    tor beats dal 1 unit
    wsh beats gs 10 units
    gs/wsh O 3 units
    okc beats ind 4 units

  6. #3156
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    cle/det U 1 unit --> +1
    det beats cle 2 units --> -2
    tor beats dal 1 unit --> -1
    wsh beats gs 10 units --> -10
    gs/wsh O 3 units --> +3
    okc beats ind 4 units --> +4

    Total -5
    Running total +9
    (89-80)

  7. #3157
    FlyinAir
    SDQL
    FlyinAir's Avatar Become A Pro!
    Join Date: 07-14-14
    Posts: 1,612
    Betpoints: 221

    Good to see ya goin boys

  8. #3158
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Fade pip query library day 11

    phi/mil O 3 units
    phi beats mil 2 units
    cha/chi U 1 unit
    chi beats cha 2 units
    mem/sac O 1 unit
    sac beats mem 1 unit
    bos beats ny 2 units
    lal beats ut 1 unit
    orl beats mia 1 unit
    dal beats atl 1 unit
    dal/atl O 1 unit
    no beats bkn 2 units
    phx/den U 1 unit
    den beats phx 2 units
    wsh/mn O 1 unit
    wsh beats mn 1 unit
    por beats sa 1 unit

  9. #3159
    smize
    smize's Avatar Become A Pro!
    Join Date: 02-06-15
    Posts: 498
    Betpoints: 407

    What's the point in posting all losing picks? good luck with that.

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

    Quote Originally Posted by smize View Post
    What's the point in posting all losing picks? good luck with that.
    very entertaining indeed. don't you have better things to do?

  11. #3161
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    phi/mil O 3 units --> +3
    phi beats mil 2 units --> -2
    cha/chi U 1 unit --> +1
    chi beats cha 2 units --> -2
    mem/sac O 1 unit --> -1
    sac beats mem 1 unit --> +1
    bos beats ny 2 units --> +2
    lal beats ut 1 unit --> +1
    orl beats mia 1 unit --> -1
    dal beats atl 1 unit --> -1
    dal/atl O 1 unit --> -1
    no beats bkn 2 units --> +2
    phx/den U 1 unit --> +1
    den beats phx 2 units --> -2
    wsh/mn O 1 unit --> -1
    wsh beats mn 1 unit --> -1
    por beats sa 1 unit --> +1

    total 0 units
    running total +9
    (101-92)

  12. #3162
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Fade pip query library day 12

    cle beats gs 3 units
    gs/cle O 1 unit
    okc/phx U 2 units
    phx beats okc 3 units

  13. #3163
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    cle beats gs 3 units --> +3
    gs/cle O 1 unit --> -1
    okc/phx U 2 units --> -2
    phx beats okc 3 units --> +3

    total +3
    running total +12
    (107-95)
    Last edited by pip2; 02-27-15 at 09:28 AM.

  14. #3164
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Fade pip query library day 13

    mn beats chi 3 units
    mn/chi O 1 unit
    cle/ind U 1 unit
    ind beats cle 2 units
    cha/bos U 1 unit
    bos beats cha 1 unit
    mem beats lac 1 unit
    lac/mem U 1 unit
    mia beats no 1 unit
    ny/det O 1 unit
    lal beats mil 7 units
    orl/atl U 1 unit
    hou beats bkn 6 units
    bkn/hou O 1 unit
    sac beats sa 7 units
    sa/sac O 1 unit
    okc/por O 1 unit
    okc beats por 1 unit
    phi beats wsh 3 units

  15. #3165
    Heart
    Heart's Avatar Become A Pro!
    Join Date: 11-23-11
    Posts: 301
    Betpoints: 1457

    Going to give the trends (that make sense to me i.e. have an angle I can understand) another try starting tonight after some time to get back into routine after the all break. After whittling down to that subset I'm even further throwing out any trend hitting less than 53-54% on the season, or month, or day. Any unusual rest patterns will be taken into account as well.

  16. #3166
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by pip2 View Post
    cle beats gs 3 units --> +3
    gs/cle O 1 unit --> -1
    okc/phx U 2 units --> -2
    phx beats okc 3 units --> +3

    total +3
    running total +12
    (107-95)
    pip I see what you are doing, but don't you think odds need to be figured in? Especially with volume? That running total is minimal

  17. #3167
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by Heart View Post
    Going to give the trends (that make sense to me i.e. have an angle I can understand) another try starting tonight after some time to get back into routine after the all break. After whittling down to that subset I'm even further throwing out any trend hitting less than 53-54% on the season, or month, or day. Any unusual rest patterns will be taken into account as well.
    BOL Heart.. just beware of the contrarian trends too! Things trend without logic or reason. I am with you in regards to "whittling down"! I believe in "SDQL nformation overload" is what I called it! That is....Find a few steady long-term situations and follow them....regardless of the loud noise (contradictions)!

  18. #3168
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by JMon View Post
    pip I see what you are doing, but don't you think odds need to be figured in? Especially with volume? That running total is minimal
    Heh! I'm not sure if you are referring to the tracking of the results or the shoddy method of recording wins vs losses! But if you see what I am doing then you are definitely a few steps ahead of me. This is so preliminary at this point. Its like this big oddly-shaped clump of data that I have such little understanding of that I am afraid to touch it, so I keep walking around it and looking at it to see if it might fart or something.

    Right now the clump is at 352 losses, 485 wins, which is around 58%, so it has dropped a couple of percent in the 12 or so days since I started posting results...Maybe it is slowly settling back into its true 50% nature...

  19. #3169
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    mn beats chi 3 units --> -3
    mn/chi O 1 unit --> -1
    cle/ind U 1 unit --> +1
    ind beats cle 2 units --> +2
    cha/bos U 1 unit --> -1
    bos beats cha 1 unit --> +1
    mem beats lac 1 unit --> -1
    lac/mem U 1 unit --> +1
    mia beats no 1 unit --> -1
    ny/det O 1 unit --> +1
    lal beats mil 7 units --> +7
    orl/atl U 1 unit --> +1
    hou beats bkn 6 units --> -6
    bkn/hou O 1 unit --> -1
    sac beats sa 7 units --> -7
    sa/sac O 1 unit --> +1
    okc/por O 1 unit --> +1
    okc beats por 1 unit --> +1
    phi beats wsh 3 units --> +3

    total -1
    running total +11
    (127-116)

  20. #3170
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Fade pip query library day 14

    mn beats mem 5 units
    mia beats atl 2 units
    mil/ut O 2 units
    ut beats mil 1 unit
    tor/ny O 5 units
    ny beats tor 8 units
    bkn/dal O 1 unit
    bkn beats dal 1 unit
    phx beats sa 1 unit

  21. #3171
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    mn beats mem 5 units --> +5
    mia beats atl 2 units --> +2
    mil/ut O 2 units --> -2
    ut beats mil 1 unit --> +1
    tor/ny O 5 units --> +5
    ny beats tor 8 units --> +8
    bkn/dal O 1 unit --> -1
    bkn beats dal 1 unit --> +1
    phx beats sa 1 unit --> -1

    total +18
    running total +29
    (149-120)

  22. #3172
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Fade pip query library day 15

    lac/chi O 2 units
    chi beats lac 1 unit
    cha/orl O 1 unit
    orl beats cha 4 units
    okc/lal U 2 units
    lal beats okc 4 units
    no/den O 2 units
    cle/hou O 1 unit
    hou beats cle 2 units
    bos beats gs 3 units
    gs/bos U 1 unit
    phi/ind U 1 unit


    3/1/15 1:00pm Reduced Basketball 801 Los Angeles Clippers/Chicago Bulls Over 197 -102*
    3/1/15 1:00pm Reduced Basketball 802 Chicago Bulls +1½ -102* vs Los Angeles Clippers
    3/1/15 6:35pm Reduced Basketball 804 Los Angeles Lakers +3½ -108* vs Oklahoma City Thunder
    3/1/15 6:35pm Reduced Basketball 803 Oklahoma City Thunder/Los Angeles Lakers Under 197½ -103*
    3/1/15 6:05pm Reduced Basketball 805 Charlotte Hornets/Orlando Magic Over 184½ -105*
    3/1/15 6:05pm Reduced Basketball 806 Orlando Magic +1½ -107* vs Charlotte Hornets
    3/1/15 6:05pm Reduced Basketball 808 Boston Celtics +9 -107* vs Golden State Warriors
    3/1/15 6:05pm Reduced Basketball 807 Golden State Warriors/Boston Celtics Under 217 -105*
    3/1/15 6:05pm Reduced Basketball 809 Philadelphia 76ers/Indiana Pacers Under 189½ -105*
    3/1/15 3:30pm Reduced Basketball 813 Cleveland Cavaliers/Houston Rockets Over 208 -105*
    3/1/15 3:30pm Reduced Basketball 814 Houston Rockets -1 +102* vs Cleveland Cavaliers
    3/1/15 8:05pm Reduced Basketball 815 New Orleans Pelicans/Denver Nuggets Over 198½ -102*

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

    After one month of live tracking i have the following results for my SDQL database:
    NBA:
    114-99
    Flex Staking: -9 Profit
    Flat Staking: +9.3 Profit

    NHL:
    111-94
    Flex Staking:+108
    Flat Staking:+18,49

    NCAAB:
    209-182
    Flex Staking:+22
    Flat Staking:+16.55

    Overall:
    434-375
    Flex Staking:+121
    Flat Staking:+44.34

  24. #3174
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    lac/chi O 2 units --> -2
    chi beats lac 1 unit --> -2
    cha/orl O 1 unit --> -1
    orl beats cha 4 units --> -4
    okc/lal U 2 units --> -2
    lal beats okc 4 units --> -4
    no/den O 2 units --> -2
    cle/hou O 1 unit --> 0
    hou beats cle 2 units --> +2
    bos beats gs 3 units --> +3
    gs/bos U 1 unit --> +1
    phi/ind U 1 unit --> +1

    7-17
    Total -10
    Running total +19
    (156-137)





    3/1/15 1:00pm Reduced Basketball 801 Los Angeles Clippers/Chicago Bulls Over 197 -102*
    3/1/15 1:00pm Reduced Basketball 802 Chicago Bulls +1½ -102* vs Los Angeles Clippers
    3/1/15 6:35pm Reduced Basketball 804 Los Angeles Lakers +3½ -108* vs Oklahoma City Thunder
    3/1/15 6:35pm Reduced Basketball 803 Oklahoma City Thunder/Los Angeles Lakers Under 197½ -103*
    3/1/15 6:05pm Reduced Basketball 805 Charlotte Hornets/Orlando Magic Over 184½ -105*
    3/1/15 6:05pm Reduced Basketball 806 Orlando Magic +1½ -107* vs Charlotte Hornets
    3/1/15 6:05pm Reduced Basketball 808 Boston Celtics +9 -107* vs Golden State Warriors
    3/1/15 6:05pm Reduced Basketball 807 Golden State Warriors/Boston Celtics Under 217 -105*
    3/1/15 6:05pm Reduced Basketball 809 Philadelphia 76ers/Indiana Pacers Under 189½ -105*
    3/1/15 3:30pm Reduced Basketball 813 Cleveland Cavaliers/Houston Rockets Over 208 -105*
    3/1/15 3:30pm Reduced Basketball 814 Houston Rockets -1 +102* vs Cleveland Cavaliers
    3/1/15 8:05pm Reduced Basketball 815 New Orleans Pelicans/Denver Nuggets Over 198½ -102*
    Last edited by pip2; 03-01-15 at 11:07 PM.

  25. #3175
    FlyinAir
    SDQL
    FlyinAir's Avatar Become A Pro!
    Join Date: 07-14-14
    Posts: 1,612
    Betpoints: 221

    Pip,

    Ru ever going to make your own thread?

  26. #3176
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by FlyinAir View Post
    Pip,

    Ru ever going to make your own thread?
    Nope, but I'll take the hint, and not go on and on posting data that is just not as odd as it was when I first started posting it...

  27. #3177
    Shazzadude
    Shazzadude's Avatar Become A Pro!
    Join Date: 11-28-12
    Posts: 443
    Betpoints: 1336

    Keep posting please pip2.

  28. #3178
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by Shazzadude View Post
    Keep posting please pip2.
    Shazz I'll try to PM the fades to you

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

    NBA catches up. Now with 1 play pending up 140 units since Jan 29th on 3 sports.
    NHL +110
    NBA +9
    NCAAB +23
    NFL -2 (only 1 game)

  30. #3180
    birdsfan
    birdsfan's Avatar Become A Pro!
    Join Date: 11-19-14
    Posts: 47
    Betpoints: 84

    Hey guys was wondering how I would write up the equation for ncaa hoops to find favorites with double revenge?

    I have kept this by hand the last few years and was trying to go a little further back with it.

    thanks

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

    what do you mean by double revenge? I can write the code if i got more detail.

  32. #3182
    birdsfan
    birdsfan's Avatar Become A Pro!
    Join Date: 11-19-14
    Posts: 47
    Betpoints: 84

    Quote Originally Posted by nash13 View Post
    what do you mean by double revenge? I can write the code if i got more detail.
    Games in the conference tournaments where the favored team lost both regular season matchups.

  33. #3183
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    C and P:FL and PP:FL and P:season=season

  34. #3184
    InsaneStre4k
    InsaneStre4k's Avatar Become A Pro!
    Join Date: 07-16-15
    Posts: 55
    Betpoints: 540

    just a basic question for an NBA O/U streak query: if i want to know what a team SU/ATS/UO rsults are off a 4 game Unders or overs streak exactly is before 2007, i write: ou streak=4 and 2007
    because when i want it for a 4 game under streak it's not working p:U and ou streak=4 ???

  35. #3185
    FlyinAir
    SDQL
    FlyinAir's Avatar Become A Pro!
    Join Date: 07-14-14
    Posts: 1,612
    Betpoints: 221

    I'll be active if we have the gang still around

First ... 8889909192 Last
Top