Messages

Forum Index : Systems & Strategies : Messages Page 6 of 7 «  3 4 5 6 7   »
Author: [Systems & Strategies] Topic: Excel Spreadsheets - Systems, Tools, Utilities and More
grecycle99 send a private message View Space | Friends | Playbook |
grecycle99
Participation Meter
Prospect
Joined: Jan 2010
Posts: 164
Location:
#126
Posted: 5/22/2013 10:47:22 AM
Great thanks

I'll update my excell and try the underdog

Thanks again for all the works guys are doing in here
Posted using a mobile device.
quote
Leprechaun send a private message View Space | Blog | Friends | Playbook |
Leprechaun
Participation Meter
Prospect
Joined: Mar 2009
Posts: 323
Location: United States
#127
Posted: 5/22/2013 10:59:18 AM
QUOTE Originally Posted by DegenGamble:

As far as Supersytems - use it any which way you want - I posted the PDF and links to the website for the revisions that bob bies posted - the reason why I didn't update the spreadsheet for this year is most of the time the plays coincided with the RPI system - so why go through updating them
When most of the plays matched the RPI system - on a side note i was thinking about a chase system that looked at the next 3 days of match ups for each team - then use criteria like RPI, starting pitchers whip, obp for each team, etc. the idea is if a team has better stats than their opponent in the next 3 games for ALL those games you would start a 3 game chase. This will allow you to take advantage of winning streaks - thoughts?


Degen-

I have a lot of thoughts on this because this is exactly how my system works.  I have studied streaks and playing an entire series from every way imaginable.  Using your code, I've been able to incorporate some stats into my system that I wasn't using before.  It is working pretty well so far.  I have some interesting data on series games that might be useful to everyone.  Let me see if I can get it all in some presentable form over the weekend and post a spreadsheet and then we can bounce some ideas off each other.

As far as the super systems go, I don't really use them or that spreadsheet.  I don't believe in the theory behind most of those systems.  I fixed the sheet for 2013 because I thought it would be useful for people on here and I was in the midst of doing a bunch of coding for this season anyway.  At the time I thought I was going to be posting more often...I still want to try and do that, but at the very least I want to contribute a bit more to the work you guys are doing.

Leprechaun
quote
Leprechaun send a private message View Space | Blog | Friends | Playbook |
Leprechaun
Participation Meter
Prospect
Joined: Mar 2009
Posts: 323
Location: United States
#128
Posted: 5/22/2013 11:09:04 AM
QUOTE Originally Posted by BuckeyeKaptn:

Another note, I've gone through and tried a 3g chase on ALL the games that come up on the RPI sheet, whether an A game or not.  That doesn't work, everything is in the negative.  Start a chase on the A game only.  Same with the TR rankings.


One last note...I wanted to add that I've found that a 3 game chase is just too many games to be profitable in almost every scenario because the win percentage you need for it to be profitable.  It can work in certain scenarios where you play the dog in game A when you know they will be a dog in game B (or a slight favorite) but that can be tough to predict.  I think it's best to look at 2 game chases that start on game A or on game B of a series.  Less plays but you end up ahead of 3 game chases in the long run due to the enormous losses that come on C games.  I'll try to post some data to back this up over the weekend.  An interesting angle that I've found profitable is to bet a team on game A and then play them again on game B in the right scenarios.  This is somewhat what my system is based on.  Anyway, I don't want to get too complicated with the post, just wanted to say that in my opinion, looking at 2 game chases (and also 2 game series) is probably the best angle if you want to "chase".

Leprechaun
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 578
Location: Ohio
#129
Posted: 5/24/2013 2:22:26 PM
Leprechaun, 
If/when you have time, could you check the SuperSystem spreadsheet for me?  I haven't gotten any plays at all for sys #1 since may 5th, and there seems like there should be for other systems.  All I get is for Sys 6 and 7, with an occasional #3.
I would appreciate it
quote
Leprechaun send a private message View Space | Blog | Friends | Playbook |
Leprechaun
Participation Meter
Prospect
Joined: Mar 2009
Posts: 323
Location: United States
#130
Posted: 5/24/2013 7:48:32 PM
QUOTE Originally Posted by BuckeyeKaptn:

Leprechaun, 
If/when you have time, could you check the SuperSystem spreadsheet for me?  I haven't gotten any plays at all for sys #1 since may 5th, and there seems like there should be for other systems.  All I get is for Sys 6 and 7, with an occasional #3.
I would appreciate it


Whoops...posted in the other thread first before I saw this.  I'll get this fixed and post any updates here in this thread as soon as I can.

Leprechaun
quote
Leprechaun send a private message View Space | Blog | Friends | Playbook |
Leprechaun
Participation Meter
Prospect
Joined: Mar 2009
Posts: 323
Location: United States
#131
Posted: 5/24/2013 10:48:08 PM
I fixed the spreadsheet for now.  Go back and redownload from the link in post #79.  I didn't change the file name so make sure you delete the old one.  Somehow the formulas were changed.  I don't know when that happened, maybe when I was fiddling with things last month?  I thought the only changes I made were to the code and that the formulas were all the same as they ever were.  Either way, it appears to be fixed now and it's time for this Leprechaun to find himself a cold beer at the end of the rainbow.  Let me know if you see any other issues.

Leprechaun
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 578
Location: Ohio
#132
Posted: 5/25/2013 12:44:45 AM
Thanks, works great.  I made a copy of it to kinda mess with and try get the workings of it...to learn how to make my own, so I wouldn't have to ask you or DeGen if it breaks down.  I'm gonna have to get a book from the book store.  Any suggestions...Excel for Dummies?!
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 578
Location: Ohio
#133
Posted: 5/25/2013 9:38:47 AM
QUOTE Originally Posted by Leprechaun:

I fixed the spreadsheet for now.  Go back and redownload from the link in post #79.  I didn't change the file name so make sure you delete the old one.  Somehow the formulas were changed.  I don't know when that happened, maybe when I was fiddling with things last month?  I thought the only changes I made were to the code and that the formulas were all the same as they ever were.  Either way, it appears to be fixed now and it's time for this Leprechaun to find himself a cold beer at the end of the rainbow.  Let me know if you see any other issues.

Leprechaun

What does it mean when a team is highlighted in dark blue?  It's not for doubleheaders.  I thought it was for having the dominant pitcher, but that doesn't seem to be it, losing or winning previous game either.
quote
Leprechaun send a private message View Space | Blog | Friends | Playbook |
Leprechaun
Participation Meter
Prospect
Joined: Mar 2009
Posts: 323
Location: United States
#134
Posted: 5/25/2013 12:15:01 PM
QUOTE Originally Posted by BuckeyeKaptn:


What does it mean when a team is highlighted in dark blue?  It's not for doubleheaders.  I thought it was for having the dominant pitcher, but that doesn't seem to be it, losing or winning previous game either.


Buckeye-

I had never taken a close look at these formulas until now.  I just took for granted that they were already done correctly.  From what I can tell, the shading criteria seems to change for each system.  For example, in system #6, the team is only highlighted if it's not a C game AND the team has a pitching edge.  From what I see for the rules of this system (http://www.guide-to-baseball-betting.com/ebook-revisions.html), I don't know why Degen included those last two filters for that system.  There is similar highlighting in the other columns that doesn't seem to be included in the original system rules.  Maybe they were his own highlights to look for an extra edge when betting?  It's also possible that they are leftover remnants from him trying to build the filters in via conditional formatting instead of hard coding them into their own rows.  That's a question he will have to answer.  At a quick glance, I'd say just ignore the highlights.  If you have a chance one day, I'd say run the filters for each of the systems manually to confirm you're getting the right plays.

Leprechaun
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 578
Location: Ohio
#135
Posted: 5/25/2013 12:20:06 PM
Lol.  Like you, I'm not following it too much.  Kinda updating daily more as a backtest than wager tool.  I have others doing well...UD etc. to worry about that...running manually etc.  It's interesting though, but I'm not going to worry about anymore problems etc, with it.
Thanx
BK
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#136
Posted: 5/25/2013 12:56:07 PM
QUOTE

Originally Posted by Leprechaun:



Buckeye-

I had never taken a close look at these formulas until now.  I just took for granted that they were already done correctly.  From what I can tell, the shading criteria seems to change for each system.  For example, in system #6, the team is only highlighted if it's not a C game AND the team has a pitching edge.  From what I see for the rules of this system (http://www.guide-to-baseball-betting.com/ebook-revisions.html), I don't know why Degen included those last two filters for that system.  There is similar highlighting in the other columns that doesn't seem to be included in the original system rules.  Maybe they were his own highlights to look for an extra edge when betting?  It's also possible that they are leftover remnants from him trying to build the filters in via conditional formatting instead of hard coding them into their own rows.  That's a question he will have to answer.  At a quick glance, I'd say just ignore the highlights.  If you have a chance one day, I'd say run the filters for each of the systems manually to confirm you're getting the right plays.

Leprechaun

You got it Leprechaun - it started off really strong last year - if you review the thread - it started to tank - so we added pitching and over.470 win record filters to see if it improved.

It's possible that the systems are most profitable between may and end of June.

I only tracked it for a few weeks - as everyone knows i'm terrible at tracking and backtesting.

 

quote
djknoell send a private message View Space | Friends | Playbook |
djknoell
Participation Meter
Prospect
Joined: Nov 2007
Posts: 79
Location: Minnesota
#137
Posted: 5/28/2013 1:14:31 AM
Can someone please help me?. When I download a spreadsheet that says google doc it downloads as a excel spreadsheet. Is there some kind of setting I need to change? If so, how?
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 578
Location: Ohio
#138
Posted: 5/28/2013 6:54:47 AM
Google Docs is a cloud or something for you to store your documents.  Look at the letters after the dot in the name of the document.  If it is XLSM, it is an Excel file, and will be that way unless you don't have Excel, which then I haven't a clue what it will download as....I've always had Excel.  I guess you can right click and choose what program to open it with "Open With..."
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 578
Location: Ohio
#139
Posted: 6/2/2013 8:59:42 AM
DeGen, I'm finally getting the hang of making a spreadsheet.  I've been  ripping through some of your old ones to make my own.  I was able to figure out how to pull data from TeamRankings.com and kinda make formulas to get me the stats I want.  I doubt I'll ever get to the point where I'll see a system, sit down and make a spreadsheet for it in a hour, (or at all) but at least I make one for my needs.
quote
literato
RSI Wagerline RSI Rating
send a private message View Space | Friends | Playbook |
literato
Participation Meter
Prospect
Joined: Jun 2013
Posts: 36
Location: France
#140
Posted: 6/14/2013 12:57:42 PM
QUOTE Originally Posted by DegenGamble:

MLB RUN ESTIMATOR

This spreadsheet is based off of Marko123 – MLB Prediction Formula thread.  See covers thread on details on the system and picks.  This is a work in progress in its early stages

Features:

·         Today’s matchups are updated from baseballpress.com when you click the “Update Lineup” button

·         Pitching and Team stats needed to complete the Run Estimation formula are updated when you click on the “Update Pitching Stats” and “Update team Stats” Button

·         NOTE: From time to time a new pitcher (say one called up from AAA) or if a pitcher goes to a different team – an error will occur when updating the pitcher stats.  You will need to update the Pitcher List with the proper links from baseball reference and re-run the query.

You can download from the link below:

https://docs.google.com/open?id=0B5dydT9Oe6Jbdkd1alJRRENtVnM

Please see Marko123’s thread on Covers for more details about the system – MLB Prediction Formula

Congratulations for this post very useful and very well done these files, I wanted to use against the Run estimator and I came across a bug after you click on the "Update Lineup" button.un pop up appeared indicating me an error in the macro in the progression of the update (stop 47/48)

once the page vb open I fell over.so if someone could look and tell me what to do to rectify the program or simply update all the file (I use Excel 2010) it would be nice.

UpdateStartingPitchers Macro
'


    Dim spRange As Range
    Dim LR As Long
    Dim rowCount As Long
    Dim lastRow As Long
       
    'Set Worksheets
    Call SetWorksheets
    
    'Find how many rows in Starting Pitcher sheet - Get Row Count
    rowCount = spitch.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).row
   
    'Delete rows from Starting Pitcher Sheet
    spitch.Range("A2" & ":" & "D" & rowCount).ClearContents
       
    'Get total rows in Schedule table
    LR = sched.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).row
   
    'turn on automatic calculations for the remainder of this macro to process Update Pitcher Macro correctly
    Application.Calculation = xlCalculationAutomatic
   
    'Loop through first column (BY) and find last row with value
    For Each spRange In sched.Range("BY2:BY" & LR)
        If Len(spRange.value) > 0 Then
            lastRow = spRange.row
        End If
    Next spRange

 

Sorry for my English i'm french

quote
orhane send a private message View Space | Friends | Playbook |
orhane
Participation Meter
Prospect
Joined: Dec 2012
Posts: 216
Location:
#141
Posted: 6/24/2013 9:07:50 PM
http://www.betfirm.com/handicapping-nba-double-digit-comebacks/ is there any chance to track back this system? i think it is possible that there is value in this. maybe some excel experts here can help. i could not manage this on my own.
quote
JicJac
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
JicJac
Participation Meter
Veteran
Joined: Oct 2009
Posts: 4067
Location: Nevada
#142
Posted: 7/13/2013 10:23:48 AM
Hi Degen,
Ive downloaded some of your sheets and they are awesome. sorry but im not savvy at all with this stuff and liked the fact that it seemed to be automated. I tried to update them and get a message that says:

compile error
method or data member not found

and then:

cant execute in break mode

Can you please give some direction? Thanks
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#143
Posted: 7/13/2013 11:29:25 AM
QUOTE Originally Posted by JicJac:

Hi Degen,
Ive downloaded some of your sheets and they are awesome. sorry but im not savvy at all with this stuff and liked the fact that it seemed to be automated. I tried to update them and get a message that says:

compile error
method or data member not found

and then:

cant execute in break mode

Can you please give some direction? Thanks

Which spreadsheet?  The spreadsheets import (scrape) data from various websites - if the website changes - it tends to cause the spreadsheet to be modified.  I don't keep them up to date - but if there is a simplel fix for one of them I can take a look
quote
JicJac
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
JicJac
Participation Meter
Veteran
Joined: Oct 2009
Posts: 4067
Location: Nevada
#144
Posted: 7/13/2013 11:45:54 AM
Thanks, Its the RPI system workbook.

quote
markos007 send a private message View Space | Blog | Friends | Playbook |
markos007
Participation Meter
Prospect
Joined: Aug 2012
Posts: 7
Location:
#145
Posted: 7/21/2013 7:30:49 AM
H DEGENi, I tried using the system "Streak Finder" you posted, but unfortunately after updating (with my connection speed is disgusting) I throw no value in O / U and not in the bet area. I just made the friend request to exchange emails and see if I can help with that. I downloaded all systems q you published and none seems to work well after update. Must be some way I'm doing it incorrectly ... Please HELP!
quote
juniorknot send a private message View Space | Blog | Friends | Playbook |
juniorknot
Participation Meter
Prospect
Joined: Dec 2013
Posts: 11
Location:
#146
Posted: 12/7/2013 7:37:38 PM
DegenGamble u have NBA 2013/2014  system spreadsheet???
quote
CatchR send a private message View Space | Friends | Playbook |
CatchR
Participation Meter
Prospect
Joined: Apr 2013
Posts: 2
Location: Bulgaria
#147
Posted: 4/11/2014 9:42:22 AM
I know it's a time consuming job to make it and I can't say enough how much  I appreciate it!
I just wanted to ask is there a working file for 2014 for 
MLB SUPER SYSTEMS

Cheers 
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#148
Posted: 4/16/2014 9:44:40 PM
I'm back in the game and have a 'pure' MLB RPI system sheet ready to go.  Will make it available closer to May 1.
quote
Danrules24 send a private message View Space | Blog | Friends | Playbook | My Sportsbook: South Point |
Danrules24
Participation Meter
Veteran
Joined: May 2012
Posts: 2903
Location: Nevada
#149
Posted: 4/17/2014 12:01:44 AM
QUOTE

Originally Posted by CanisMajor:

I'm back in the game and have a 'pure' MLB RPI system sheet ready to go.  Will make it available closer to May 1.

Looking forward to it!

quote
dplewis34 send a private message View Space | Friends | Playbook |
dplewis34
Participation Meter
Prospect
Joined: Aug 2013
Posts: 76
Location:
#150
Posted: 5/1/2014 4:19:47 PM
I am needing help in excel. I am tracking records of multiple systems and I want to add the records up. Currently my formula is =left(B1,1)+left(B2,3) etc. With the records changing from say 9-0 to 10-0 it messes up the formula and I have to change the number of characters from 1 to 2. Is there an easier formula I can use for this. For instance: left(B1,everything left of "-")
quote
Forum Index : Systems & Strategies : Messages Page 6 of 7 «  3 4 5 6 7   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.