已完成

Pull college basketball data using VBA

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

技能: Excel, Excel VBA, HTML, Javascript, Visual Basic

查看更多: data excel workbook master workbook using vba, export data webpage excel sheet using vba, extract data email message body using vba, ncaa basketball data csv, download nba stats, basketball reference, export espn fantasy stats to excel, nba stats excel spreadsheet, sports database download, nba dataset csv, import yahoo fantasy football data to excel, data processing, vb.net, web scraping, extract data file using vba, import project data excel using vba, copy internet explorer data excel using vba, data extraction using vba, transfer data excel word using vba, filter data excel using vba

关于此雇主:
( 0个评论 ) United States

项目ID: #17581400

授予:

Attractionnet

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 更多

$264 USD 在3天内
(118条评论)
6.2

19 威客就此工作平均出价 $470

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (go 更多

$588 USD 在3天内
(612条评论)
8.3
schoudhary1553

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 更多

$600 USD 在5天内
(283条评论)
7.6
PigtailXL

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator and I'd 更多

$600 USD 在5天内
(165条评论)
7.0
Vlzinch

Hi! I’m experienced Python developer, and web-scraping is one of my main fields of knowledge. I've started with VBA scraping 8 years ago, but switched to Python, because it is much more powerful in this field. I can 更多

$750 USD 在10天内
(62条评论)
7.1
ehsankayani

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 更多

$588 USD 在5天内
(53条评论)
6.8
ksriniravi

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 更多

$250 USD 在3天内
(158条评论)
6.7
gangabass

I have huge web scraping experience and also I'm VBA specialist that's why I'm sure you'll be impressed with my work. I can provide you VBA code that will work on NCAA site just like you want and all I need to start 更多

$264USD 在1天里
(173条评论)
6.3
sypsoo

’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. The 更多

$350 USD 在5天内
(36条评论)
5.9
royalcalif

Pm me. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the 更多

$250 USD 在6天内
(68条评论)
5.3
aubrey03

I am an Excel VBA specialist with experience in creating web scraping tools using VBA and Selenium Basic. Selenium is a reference library which you can add in Excel so that you can manipulate browsers like Chrome or Fi 更多

$250 USD 在5天内
(31条评论)
5.0
VictorMobile

Thanks for your job posting. How are you doing well? Before we have full experienced good Variuos Game development. Our skills is follow as: Unity 3d, cocos2dx,UE4, 3d Modeling, 2d Game design, For social app devel 更多

$555 USD 在10天内
(2条评论)
4.3
Ahmed818

Hello, i am expert in this kind of jobs i finished more than 10 scraping jobs in this year most of them are scraping jobs using excel macros https://www.freelancer.com/projects/php/Web-scraping-16342603/ 更多

$250USD 在1天里
(28条评论)
4.2
naravila

Hello, I read your requirement and bid here. I am web development master. And i can finish your task perfectly. Please hire me. I want work with you. Please discuss detail over chart.

$555 USD 在10天内
(6条评论)
4.0
dataexplorer

Hey! I am happy to inform you that I have read your project Pull college basketball data using VBA description and understood all of your required requirement. I'd like to help you with confidence and satisfying resu 更多

$400 USD 在10天内
(6条评论)
2.5
BestPartner4You

hello,there. I have read all your requirements for 'Pull college basketball data using VBA' and I fully understood it. I am confident and I am sure that I am able to finish this project. Please come in contact with me, 更多

$555 USD 在4天内
(2条评论)
2.4
Krunalpatel0710

I Have good knowledge of VBA scripting, Python and Java programming language. As of now I am working as software developer.

$555 USD 在10天内
(0条评论)
0.0
kuull23

Hello. I am very good at web scraping. I can work on your project. Please contact me. thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

$750 USD 在10天内
(0条评论)
0.0
drishinfotech

Hello, Thank you for the posting. I have scraped various portals across multiple domains, I would like to collaborate with you on this task and deliver it as per your timeline and budget. The basis of my confi 更多

$555 USD 在10天内
(0条评论)
0.0