I gave this a shot and the problem is, for example under the Home Wins column:
I end up getting an L if the game is a Home Loss or a Road game. How would I eliminate the "Road" results from the "Home Wins" column?
Under the "Home Wins" column I should have a blank or a "0" as a place holder for road results.
Ideally vba formulas would probably be best.
Formula(HomeWinStreak)
Formula(HomeLossStreak)
Formula(RoadWinStreak)
Formula(RoadLossStreak)
Or even better 1 formula to do it all Formula(Streak)
Trick is how to write them. Maybe a4u2fear could chime in
I was a bit sloppy when writing the first response. The formula should have been:
IF(AND(K3="Home",M3="W"),"W","")
i.e. just change the "L" to "" or 0 or whatever you want it to be.
I don't have time to write the VBA for it but maybe someone else has.
Originally Posted by oilcountry99
I gave this a shot and the problem is, for example under the Home Wins column:
I end up getting an L if the game is a Home Loss or a Road game. How would I eliminate the "Road" results from the "Home Wins" column?
Under the "Home Wins" column I should have a blank or a "0" as a place holder for road results.
Awesome thread guys. Hope I can help. Expert in excel. Also produced web programs, was on another site with an NBA tracker. Have it on www.akptracker.com. Can scrape any data off any site.
B_rad, I promise you if you took the time to do this through php and MySQL you would never use excel again. And it's completely free to do. Just download Xampp from apachefriends.org. Either way, hope I can help. Love this stuff.
Akphidelt would like to speak more with you in regards to the work you have done - I dont have private message capabilities yet so I can give email if you are interested. Thanks
Hey guys!
Looks like I missed quite a bit
Has anyone ever had their code do so much stuff it goes to not responding?
Over a full nhl season i need to pull in about a month at a time. it will not handle the full 6- 7 months.
b_rad_1983,
How are you importing it?
If you are using VBA then the amount of data should not matter if coded properly. However, it can take some tweaking.
If you are using formulas or queries, then it is pretty easy to overwhelm Excel so that it hangs and the way around that is to use VBA.
Hi thom321,
I ended up re- coding my vba and seems to be working better,
i had too much stuff out of place.
I would like to know if there is a way to only import the "Summary" table of the following link,
http://www.covers.com/pageLoader/pag...core63849.html
I do not what the whole page for that day, only the summer
here is my basic import layout
For gameday = 63274 To 63849
Sheets("Temp").Select
With Sheets("Temp").QueryTables.Add(Connection:= _
"URL;http://www.covers.com/pageLoader/pageLoader.aspx?page=/data/nhl/results/2014-2015/boxscore" & gameday & ".html", Destination:= _
Range("$A$1"))
.Name = test
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingrts
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
B-rad, I don't know how to only import some of it, but I would rather just grab what you need from the import, or delete what's not needed after it's imported
That's currently what I'm working on.
Thanks for the reply!
All is trying to do is pull in the odds for each game this year.
I've been gone for a couple of years (old man with medical problems) but decided to have another look. Stumbled onto this thread. It's great, thanks.
A4, I believe that Webselection type is where you can change what tables to bring in. Just need to add a line below it that indicates which tables from a page.
No matter what I do, covers takes forever it seems to import.
Bsims, do you have a project on the go?
After several years on the sidelines, I've decided to enter the analytical fray again. The first step is to review past efforts and decide which ones show enough promise to take another look at. This is non trivial, because I have over a decade and thousands of hours of work to go through.Bsims, do you have a project on the go?
