Recent Posts

Thread Author jenjay23 Post Entries
DegenGamble
DegenGamble

Quote Originally Posted by RunninRebel1990:

Hello All, Would anyone have a 2019 Version of this spreadsheet? Also can anyone possibly help with instructions on updating the schedule for this season. Any help would be much appreciated!!   Thanx

 

RunninRebel,

I updated the link with this years.  I hid system #4 as i did not update the L3 years in ballpark info as i don't use it for any of the capping I do.  Hope it helps you with yours.  Qualifying picks for Systems #1 & 3 have been doing pretty well.  Personally I pick and choose the qualifying picks from those systems after some minor personal capping of the teams/trends/spots.

https://drive.google.com/file/d/0B9UBaNk9s7UjMnFuNXlDWUM4cVE/view?usp=sharing

jaker122
jaker122
jaker,
Good luck with this idea this year. Hope it works out for all of us.
If you or any others like to use excel as a tool, i built a simple sheet that will identify qualifying dog picks (FIP filter difference from Stoffo), and allow you to choose the 2 games for the Parlay.  You can add bets to tracker and follow or bet the singles as well as parlays.  I find it a good way to keep archives etc.  Pretty simple, click today and click update each morning....add bets to tracker enters game in tracking sheets.  You can manually enter games in tracking as well if a slight difference from your picks you post.  Figured a few could use as a tool if they like or want to build off it for their own.
Link:
https://drive.google.com/file/d/10uoh8BScZljcJnQRIIcuvu_dPI4TIsno/view?usp=sharing
Danrules24
Danrules24
Good luck this year Dan ! Awesome system constantly providing incredible value 
DegenGamble
DegenGamble
Quote Originally Posted by sports_Network:

this system is doing well this season  (2018)
Just took a look ...get on it now before it fizzels (if past trends hold true)

It has been pretty good.  I don't follow to a tee but use Degen's old sheet to help my decisions in daily capping.
Although I cant guarantee this is 100% accurate as I just use it as a tool, here is a link to Degen's/my modified updated sheet for 2018 if you want to use as well.  It does take a good 10-15min to update and sometimes gets hung up when updating so could frustrate a few.  I usually close and try again if you get the debug error or if you know a bit of vba i run modules separately and seems to work ok.  If any manually cap these systems and see glaring issues let me know and I can try to fix if its in my excel knowledge realm 

https://drive.google.com/file/d/1ALeX6he0ZtHPxUsQiZmJLKAfynOzyWoX/view?usp=sharing

DegenGamble
DegenGamble
Sheet updated for 2018 if you like to use or look at daily.  Same link as below and I will track and update records throughout season.  Started tracking yesterday.
As Kapt'n pointed out, all the props to Degen who provided awesome sheets & info to build off of.

[Quote: Originally Posted by jenjay23] Here is a link to my sheet for the 5 Super Systems.  It looks like the data is importing properly and formula's defined to give the qualifying games for each system are correct. Qualifying plays should start coming hot n heavy over the next few weeks.  I personally "pick and play" games from systems 1, 2 & 5 and play them on various labby's that I track.  Historically they do pretty well.  I cant guarantee the accuracy in the sheet and if you play and identify something while you manually cap, let me know and I will see if its an easy fix.  I do run this sheet daily and track it's successes/failures and will update this link as the season goes on with somewhat accurate results.  Also any bugs that will occur with the sheet throughout the year will usually be fixed and updated as well.
GL & enjoy if you use or play

https://drive.google.com/file/d/0B9UBaNk9s7UjMnFuNXlDWUM4cVE/view?usp=sharing


cisco
cisco
Ready.  Good luck Cisco.  Thanks for sharing, effort on the forum and great systems!
jenjay23
jenjay23
Quote Originally Posted by stickbit:

also, curious NHL sheet for last season ended in late January it seems...is that when you stopped playing? any particular reason why? Thanks Jenjay and sorry for all the questions. 
Stick,
That was just the last day I updated the link here on covers.  I usually play until sometime in March or until I feel its a good time to stop.  If you want to see how it faired after the end of January I updated the link from last year.  This is the link to last years sheet.
https://drive.google.com/file/d/0B9UBaNk9s7UjSUdQLWx1S3UxQVE/view?usp=sharing

jenjay23
jenjay23
Stick,
This will be the first year to truly test and track the home/road theory.  In years past I utilized the thoughts of DR24 and CKP's MLB second half ideas and incorporated them throughout the year in NHL.  I moderately played  the qualifying games on my top pick labby lines last year and noticed success.  I certainly kept an eye on games as they arose and identified that there was a possible edge.  This year will give true results.  Back testing is more difficult to get a true number as top and bottom teams and PWR rankings vary throughout the year and on a day to day basis.  A quick test, just to see if there was some proof that the concept will profit was using top and bottom teams on how they finished the year, this shows really good, but will not reflect end results I will see this year.  Time will tell and hopefully it can show some profit.
GL
jenjay23
jenjay23
Quote Originally Posted by stickbit:

Thanks Jenjay - are you starting tonight I take it ? Full units ?

Stick, Since the sheet only pulls data from this years season, I try and hold out for at least 5-10 games played before playing TOPVRPI, RPIDog & Topdog.....and really pick and choose the games I play early on for simply action.  Yesterday since the Kings play there next 4 @ Home vs Cgy, Buf, NYI & MTL, I chose to play the Kings, since they lost I will follow up with them vs BUF.
jenjay23
jenjay23

For any that may have downloaded the sheet, prior to this post. I already noticed a F up on my part.  The link is updated...

jenjay23
jenjay23
Quote Originally Posted by oilcountry99:

Good luck jj23 

Thanks OIL, GL to you this season as well. 
Stickbit, didn't see your request so i sent one back to you.  I do play the 4 systems.  I use one other filter on the plays I make and that's personal discretion. That being said I would guess I play about 80-90% of the games identified.  The sheet helps me identify plays but if other capping tools and trends makes it not feeling right with me, I dont play them.  The $100 is for simplicity, but yes my labby uses 0.25 of a unit (X4) on each line or 1% of starting BR as a first bet on the progression until the line is clear.
GL
jenjay23
jenjay23
Here is the link to the sheet with a few systems I will play this year with the ability to track the bets that are placed to determine their successes/failures.  If you would like to utilize it for your own tracking or developing your own theories/systems its a good tool/template to start from.  Pretty easy to use, click "today", click "update".  By clicking the "add bets to tracker it will put the games identified into the appropriate tracking tab.  If you don't play those games you can simply clear the cells on the appropriate tracking tabs or insert the games you do play.  At the end of games you can fill the results in with either a "W" or a "L".  Let me know if you identify any bugs or have any questions if you choose to use this tool.  I am sure the sheet will require a few adjustments as time goes on and I will update the link with current results and as adjustments are made.
GL this season 

https://drive.google.com/file/d/0B9UBaNk9s7Uja0oxMDFPRjZSN1E/view?usp=sharing
jenjay23
jenjay23
Yes, I will post a link to this years sheet.  Probably wont be until the end of the week when I can verify all the data from the sites comes into excel in proper format as well as a few weeks of this years stats are present.


Danrules24
Danrules24
Thank you DR, second half dug me out of a hole that was desperately needed!!
Appreciate your efforts and dedication to posting in this form...
On the NHL 
CannedGoods
CannedGoods
no promises but i could see if I could help you out.  What are you trying to bring into excel? PM if easier
Danrules24
Danrules24
Very cool DR24 and CKP, very nice article for extremely well created and proven systems. Well deserved recognition for your efforts over the years in providing content and the dedication to the S&S forum to post and track all qualifying plays throughout the years.
Well done 
jenjay23
jenjay23
Oil,
I do not pull data from baseball reference in this sheet, but do from the "Super System" one posted in other thread.  It pulls from VBA, rather than a connection and was created by DEGEN .
GL
jenjay23
jenjay23
Thanks Oil.....didn't hide anything that i see? i downloaded from link and see it from my end.  Not sure but when first download you would have to click on top of excel "enable editing" button, followed by "Enable Content" button for macros.  Not sure if that is the issue or not but could be?
GL
jenjay23
jenjay23
This is the spreadsheet with a few systems I use to track and calculate the plays I make throughout the MLB season.  The top pick Labby's are personal capped games I chose and track, usually from other systems found on these forums. This year I am also going to play and track a 2TP progression using the calculated TOPVRPI & TOPDOG as picks. Historical results over past few years look positive to hopefully add a few units to the cause.  The sheet can be used as is or modified with a little excel knowledge to your own system thoughts.  Last years thread will have results from 2016 if you want to check it out.  a profit/loss graph can be seen by clicking on the header of each system on the summary tab from last years sheet.  GL

https://drive.google.com/file/d/0B9UBaNk9s7UjLXNUT0FXRTcyZVk/view?usp=sharing
DegenGamble
DegenGamble
Quote Originally Posted by jenjay23:

Here is a link to my sheet for the 5 Super Systems.  It looks like the data is importing properly and formula's defined to give the qualifying games for each system are correct. 
GL & enjoy if you use or play

https://drive.google.com/file/d/0B9UBaNk9s7UjMnFuNXlDWUM4cVE/view?usp=sharing

There was a few changes to some website formats which resulted in importing not working correctly.  I updated the link to hopefully have the sheet perform properly.
GL
Desktop View: Switch to Mobile View