I don't think vlookup would work in this case. Not sure what would without adding new columns. You can always add a column in the VBA that creates the first initial/last name identifier then you can...
SBR Top-Rated Sportsbooks
|
Best Sportsbooks List
|
| |||||
#1 FanDuel | SBR rating 4.8/5 | Review | #6 BetRivers | SBR rating 4.1/5 | Review | #2 Caesars | SBR rating 4.7/5 | Review | #7 Fanatics | SBR rating 4.1/5 | Review |
#3 DraftKings | SBR rating 4.7/5 | Review | #8 Betway | SBR rating 3.8/5 | Review | ||
#4 BetMGM | SBR rating 4.6/5 | Review | #9 Borgata | SBR rating 3.5/5 | Review | ||
#5 bet365 | SBR rating 4.6/5 | Review | #10 ClutchBet | SBR rating 2.9/5 | Review |
Type: Posts; User: akphidelt Search by Threads Advanced Search View New Posts
I don't think vlookup would work in this case. Not sure what would without adding new columns. You can always add a column in the VBA that creates the first initial/last name identifier then you can...
That's going to be pretty difficult. Have you figured it out yet?
I'd add a column in sheet a with a formula extracting D. Duffy, which you already know how to do. Then I'd at a column with a formula in the other sheet breaking Danny Duffy in to D. Duffy and use...
b_rad...
Try this out. Had some time after work. This took about 20-30 minutes. Was able to log every pick. It will take a little bit longer to make this dynamic where it goes in and updates the...
No problem. And yes, it's very frustrating and rewarding. Really fun learning new stuff.
PHP is what sites like Amazon or Facebook is written in. The most common web language in the world. But, in order to process the code you have to install Apache, PHP, and most likely a database like...
Oh yea, if you know regular expressions you can do anything. For example, this is how easy it is to get the html of a website...
$url =...
Just to get that data would be about 10-15 minutes. Would be another 10-15 minutes if I wanted to set up a table in the DB to store it.
The beauty of it though, you could scrape every games data,...
Ahhh, you must have it set to where all variables need to be declared. Well that's good that you got it to work. Always so many little things that can screw stuff up, lol.
This is super ghetto but it gets the job done on my end...
Sub GetPitchingStats()
Dim startPitcher As Long
Dim lastPitcher As Long
Dim qualified As String
Dim lastRow As Long
I'll take a stab at it after lunch... might be a little rusty on VBA but it should come back.
What about getting the statistics for the pitchers from ESPN stats pages... like this...
http://espn.go.com/mlb/stats/pitching/_/count/507/qualified/false/order/false
You can loop through the...
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,...