Recent Posts

Thread Author BuckeyeKaptn Post Entries
BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by grecycle99:

Hello my friend,   Should I replace all the teams urls by this url : https://www.covers.com/sport/hockey/nhl/2018-2019/team/winnipeg-jets for each teams? Thanks

Yes, if you go to each team's past results and look and copy that url into column E for that team...that'll work until I fix it so all you have to change is the year like previously.  Don't worry about the formula you will be replacing. This is all in the hidden URL tab for anyone else that wishes to do this.

Covers has redesigned the look of the team page too.

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by grecycle99:

Hello my friend,   Should I replace all the teams urls by this url : https://www.covers.com/sport/hockey/nhl/2018-2019/team/winnipeg-jets for each teams? Thanks

 

Yep.  I haven't had the time, so I'm trying to do it before opening day for MLB and then October for NHL.

BuckeyeKaptn
BuckeyeKaptn

Covers changed the URLS for all teams but currently Blue Jackets won't post.  I have been waiting for MLB and now I have to go change the urls. Dagnabbit

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by BuckeyeKaptn:

Quote Originally Posted by projectsmith:

Just set up an account to come on here and thank you BuckeyeKaptn :DThe GSGA really helps with my Salami and First Period Goal wagering.     So many thanks.  I look forward to seeing how the MLB spreadsheet looks   GL
I'm glad it's helped.  Yeah, Spring Training is around the corner.  I just have to add (I believe) MLB to the backtest spreadsheet.  Everything else is pretty much done.  Just need to check the daily update at the beginning of the season.

Nope, I have to update The NHL to the back test sheet.  My bad.

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by projectsmith:

Just set up an account to come on here and thank you BuckeyeKaptn :DThe GSGA really helps with my Salami and First Period Goal wagering.     So many thanks.  I look forward to seeing how the MLB spreadsheet looks   GL

I'm glad it's helped.  Yeah, Spring Training is around the corner.  I just have to add (I believe) MLB to the backtest spreadsheet.  Everything else is pretty much done.  Just need to check the daily update at the beginning of the season.

 

Danrules24
Danrules24

Dan's unit is $10.00

Danrules24
Danrules24

Quote Originally Posted by jaime2309:

Quote Originally Posted by Danrules24:

Friday, game 4, Toronto-130 and Pitt -160, $50 to win $93.75
Dan why did it jump from $30 to $50?

The progression is 1u (1 x your unit), 2u, 3u, 5u, 8u, 12u, 16u, 25u .

Danrules24
Danrules24

Quote Originally Posted by jaime2309:

Dan, not to disagree with you but Boston is currently at -150 across every major book. Sharks sit at -145. Just throwing it out there. We will go with whatever you decide. Cheers!

I put my wagers in about 6-7 hours before puck drop when I'm on lunch (at work).  Both were at -145.  Since I was on the road delivering, I didn't have my stats available.  I took Boston because....because a hunch, idk.  

BuckeyeKaptn
BuckeyeKaptn

I was going to update the backtests on this thread's spreadsheet, adding different components. I then decided to just make a new spreadsheet with my computations on it.  Basically, I combined all sheets into one and am presenting it to you.  Currently only for MLB.  I'll upload and update when NHL is added.  I will also remove the backtest sheets from Sports 18.

https://drive.google.com/file/d/1xqZP5yYduTfJADk37lPRGBhb2-kF1yJn/view?usp=sharing

This is an interactive sheet, in that you can change different aspects to get data you want.  Change only cells that are in yellow. The two type of parlays are Top 2 and Top 2 ML (Home, Away, Both and -1.5 RLs). You can change the RSRA Dif number to view parlays that are based on this number and higher.  Change to 0 to view all plays.

You can get certain data for inclusive dates (only RSRA plays not the parlays).

This spreadsheet does not pull data from the internet, can be read, edited offline.

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by BuckeyeKaptn:

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

I have uploaded a new version.

This one has different tabs/sheets that can be used for those that have an older version of Excel, such as grecycle99.  These tabs have a "1" after the name.

I tried to organize the sheets a bit, it's a work in progress.  I'm going to eventually dim the colors a bit.  I find that I do get colorful when I make a workbook.

For NHL, I have added the -1.5 run line stats on the NHL Systems tab.  As Covers does not have run lines archived, I took the ML parlay lines (which I make by a formula with the money lines) and added +350.  Using a web based parlay calculator, I found that this number is significantly lower than what a RL Parlay would pay out over a ML Parlay (usually +400 to +500, I found).

I have the last 5 years back test for MLB for ML and RL parlays added in.  Each type is on it's own tab/sheet.

Same for NHL, except that 2013 to 2016 years aren't complete for RL, and the same years for ML need to be rechecked.  So, only 2017/8 is done.

I think this should do it until MLB starts.  I'll clean up/organize the look of the pages, finish the back tests and make sure my Query for MLB odds is correct before releasing the next version.

If I find anything that will help for NHL, I will do a version for that.  I was thinking of adding a road/home strength of schedule to the 2 sheets.

One last thing.  There was a problem once I started with the Query connection where the previous days plays were posted instead of the "today's plays".  It was fixed.  I had to uncheck the background refresh in properties.

Again, any problems, let me know.  I don't check the web site daily but at least every few days.  Now that Christmas is over, I have time to fix any problem (I'm a USPS mailman, man in blue).

Good wagering!!!

BuckeyeKaptn
BuckeyeKaptn

This is to grecycle99's problem.  Not this coming update with the backtests, but once I figure out how to do it, I will post an update that will give the odds for those that have the older Excel programs or a work around to avoid the Query Connection.

BuckeyeKaptn
BuckeyeKaptn

I had completed the backtests for MLB which will include the -1.5 parlay plays.  Then I noticed numerous discrepancies on the worksheet/template I use. 

new_smh

I have to go back and redo all calculations for each year.  Plus, being this template was a copy from NHL, the backtests from that sport are incorrect too.  I will go back and correct NHL.  The good thing is that I made the formulas for the -1.5 parlays and I will add NHL's -1.5 backtest to the sheet.

 

Danrules24
Danrules24

Toft... Agreed. I always go off a system, not following the guidelines and that's how I always lose. I did that this past year my mlb. Had I followed the system correctly, my bank roll woulda ended the year at 7 times what I started . At least I doubled it. 

 

Danrules24
Danrules24

Quote Originally Posted by JeffPilson:

Quote Originally Posted by smurph_daddy:

Both books I looked had the top two favorites as Vegas and SJ. So I played those. EDM also a large favorite so that may be what Dan plays. Hopefully all 3 win
  I jumped on VGK / SJ as well... Good luck Smurph!

Me too. I refreshed the page up until 1215 then put it in . 

Danrules24
Danrules24

Quote Originally Posted by jaime2309:

Dan, not sure if this has been asked but have you ever tried doing a round robin with this? Just a thought.

Please explain...

Danrules24
Danrules24

Quote Originally Posted by Danrules24:

Wednesday, Game 1, Vegas -150 and Pitts -180 new_poop, $10 to win $15.93

It seems that the one team who is in BOTH this system parlay and my GSGA parlay is the one that loses.

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by grecycle99:

Hi buckeyekaptn, When I try to update the file, theres window popping for debugging for the query. Is it possible that came on because I use excel 2007?

Still in VBA, click on Sheet9 (NHL) and change in Private Sub All_Click () ....halfway down

Call UpdateNHLOdds to Call UpdateNHLOdds1

and in Private Sub Odds_Click()

Call UpdateNHLOdds to Call UpdateNHLOdds1

 

Now, go into NHL Odds1 and CLEAR NOT DELETE Column B.  Notice in the shaded area Col AO are the rotation numbers, top two at 35.  Changes these to 1 and 2 to complete the sequence. If any rotation numbers on any website aren't in any of the shaded area of AO, make the change on AO.  

Still not saving, go into NHL tab and click on Odd.  If everything shows up properly, I remembered everything and you can save now. I will be doing the same update for MLB.  Do the same fix for that sport when it happens.  I named all macros similar between NHL and MLB so you just have to sub MLB for NHL. Let me know if any more problems. 

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by grecycle99:

Hi buckeyekaptn, When I try to update the file, theres window popping for debugging for the query. Is it possible that came on because I use excel 2007?

I didn't delete the old version, just changed the name and hid it.  Unhide NHL Odds1.  What you're going to do is put "1" in certain areas.  Save your copy, so if there's a screw up, you can just exit out and not save it...restart again.  I don't recall that version well so I hope my directions work for you.

Get into Visual Basic.  For me, that's under Developer to the left. Click on Data Module.  Scroll down to UpdateNHLOdds1 ().  Halfway down, change NHLOdds.Range("A2").PasteSpecial xlPasteValues to NHLOdds1.Range("A2").PasteSpecial xlPasteValues (adding the 1).

In Support Module, right at the top, add "Global NHLOdds1 As Worksheet" and under SetWorksheets () add "Set NHLOdds1 = Worksheets("NHL Odds1")". You can copy and paste without the quotes right into VBA. 

One more post coming...DON"T HIT SAVE!!!

 

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by grecycle99:

Hi buckeyekaptn, When I try to update the file, theres window popping for debugging for the query. Is it possible that came on because I use excel 2007?

Yes.  The one I use is the newest Excel 365/2016 one.  Your version didn't have the query.  A fix coming.

BuckeyeKaptn
BuckeyeKaptn

Quote Originally Posted by BuckeyeKaptn:

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

Updated the NHL Odds tab.  The rotation numbers normally used are different, as I stated in post #23.  The odds are now pulled from a query instead of from a macro.  This will make updating the odds quicker.  I noticed that I am able to do that for the Covers tab also (using queries instead of a macro.  However, each team would need to have it's own worksheet (including MLB) and I needed to get this out today.

I also fixed where if you had a dog play the team wouldn't post below in My Plays tab.

Updated through today's plays.

Desktop View: Switch to Mobile View