Pull college basketball data using VBA
$250-750 USD
Thanh toán khi bàn giao
I’ll try to explain this the best I can. I want to setup 3 loops to pull data for college basketball games. I'm experienced in VBA but I'm having trouble creating a loop that does not error out after 15 games or so. There is some kind of security on the ncaa's site that prevents this type of data scraping I'm told. The workaround which has been mostly effective is to put in a wait for 5 seconds or so after each run in the loop.
However, I’ve pulled the webpage using VBA code (like below), this appears to error out after a number of runs so I need some help w/ another method to pull this data. I think the best way to do this quickly is to use HTML tags which is something I'm unfamiliar with.
QueryQuote:
With Sheets("Data").[login to view URL](Connection:="URL;" & str, Destination:=Sheets("Data").Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
Here’s the general idea of what I’m trying to do
1. For a given set of teams (which I will have) pull the box in the lower left corner of each teams page using the following link…The loop will have the general link [login to view URL] + the teams number which I will have already ex. 111066, 111067, etc. It will up to 120 games in one run
[login to view URL]
2. From there I can generate a list of hyperlinks to boxscores. For the boxscores I need all of player data for the two teams involved in the game. The following hyperlink would be used
[login to view URL]
3. Lastly I will need all of the play by play data for the game. This includes everything from the headings Time, Team1, Score, Team2 until you get to the bottom of the page
[login to view URL]
Here’s a couple of must haves
• This needs to be done in VBA and the code needs to format the data into cells in excel
• I need a description/walkthrough once this is done of how the code works. I need to be able to troubleshoot if something goes wrong
• I need to be able to set a time trigger for the code
• I need to verify on my machine that the code will function w/out error and fully run through each of the 3 steps above for up to 150 games
• I just need the data, nothing else. Just exactly what is on the webpage in excel. Simple as that
ID dự án: #17581400
Về dự án
Được trao cho:
Hello. I have scraped ncaa at the past. I use vb.net which is the parent language of vba. So instead of writing the code in vba which is limited I will write it in vb.net as a standalone program. The program will h Thêm
14 freelancer chào giá trung bình$451 cho công việc này
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 385 + projects with 100% client satisfaction. I have more than 5 Thêm
Hi there, Most probably you are getting blocked by the site after repeated hits so i have been scraping sites for a very long time and can provide solutions which will use tor proxies and other similar all free solu Thêm
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can develop a VBA based solution for your basketball data extraction needs fr Thêm
I Have good knowledge of VBA scripting, Python and Java programming language. As of now I am working as software developer.