Search:

A4K. Few things:

The display alerts command helps speed up the code. You have =false then =true right after. You want to put the =false at the beginning of code (below Public sub....) then...

A4K, can you post your code? This thread is older than another I have posted and I can't tell exactly which code you are using and why it is happening.

Yes that is correct. NHLdata is the sheet where each game is loaded, then you take the data and put it into another sheet, then the NHLdata is erased and then populated with the next imported game....

nevermind i found it, you are using my code directly:

CodeStart=Application.Match("Options", Sheets("NHLData").Range("A1:A100"), 0)

Look at the sheet "NHLData" or the sheet if you have renamed...

b_rad, please look for CodeStart = and post what it equals to (or what you set it to). This is the line in the code you need to investigate. CodeStart is not getting set properly. Maybe the...

b_rad. The type mismatch occurs for example when you are using a variable as an integer, but it is say a type string or empty.

What I "think" happened, is after you imported your webpage, either...

Vit, are you looking for just a template or everything filled in? I've never wanted to really share my whole data package as it took me years to create.

i will start a new excel thread this...

Actually it has nothing to do with developing trends. What I did is create a way to estimate a teams points per game not using historical data, then see how it tested in prior years using all of...

let me know if you need help.

mods can we get this moved to handicapper think tank? I think it's better suited there.

Public NHLyear As String
Public NHLmonth As String
Public NHLday As String

Public Sub importdata()

'add a new sheet to put the data in
Application.DisplayAlerts = False...

Added more code (below). In this updated code, you'll see I've added the code to loop through the day of games just imported to find all games and lines.

While it may look a bit weird as there is...

Thanks

It's difficult to find systems that work. What it has been great is debunking myths such as teams on B2B doing very poorly or the team with a lot of rest being highly profitable.

54462

If you work hard enough, you can come up with something like I have here over 6 NHL seasons.

I can continue if anyone is working on it or following. Obviously, there is a lot of work to do. We still have to create loops to go through all games in a day into our NHLGames sheet, and then we...

Your code should now look like:

Public NHLyear As String
Public NHLmonth As String
Public NHLday As String

Public Sub importdata()

'add a new sheet to put the data in...

CodeStart will be returned with the value of 97.

Now you will want to place your first game's data and line into another sheet, so create another sheet called "NHLGames", and say in cell A1 you...

Now that you've loaded your first game, you need to find the data you want to place into another sheet where you will store all of your data.

First you need to determine whether or not there is...

Ok will add more soon, out of town this weekend getting wasted.

You can pull pick lines, money lines, totals by game and period

Click the run tab at the top and click run sub/userform and you will have the website imported into an excel sheet called NHL Data.

I will continue on and go further if interest is there.

Once in visual basic, click the insert tab and insert a module.

Now to insert your first webpage into excel with the data from SBR's site (i.e for 10/03/2007)
(paste code below into the module:
...

For starters. Open up Excel. Recent versions like 2007 and 2010 will have a tab called "Developer". If you don't see it, click the Microsoft logo at the top far left, then click Excel options at...

If so, I can help if enough people are interested. I have pulled all odds/results off SBR's data from 07/08 till today. While I have decided I do not want to share my Excel data, I decided I will...