Find Jobs
Hire Freelancers

Pull college basketball data using VBA

$250-750 USD

Imekamilika
Imechapishwa over 5 years ago

$250-750 USD

Kulipwa wakati wa kufikishwa
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
Kitambulisho cha mradi: 17581400

Kuhusu mradi

14 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
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 have all the functions you have in your excel but in a different user interface. And it will be able to work with any ncaa gamers no matter how many they are. Please feel free to contact me for more details. Regards, Marina Louki
$264 USD ndani ya siku 3
5.0 (138 hakiki)
6.5
6.5
14 wafanyakazi huru wana zabuni kwa wastani $451 USD kwa kazi hii
Picha ya Mtumiaji
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 years of the experience in Excel, Excel VBA, HTML, Javascript, Visual Basic Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. Thanks.
$600 USD ndani ya siku 5
4.9 (378 hakiki)
8.0
8.0
Picha ya Mtumiaji
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 create a scraper which will produce raw data in csv format and then manipulate and visualize this data in excel. Please contact me to discuss project details, Best regards, Vlad
$750 USD ndani ya siku 10
5.0 (69 hakiki)
7.5
7.5
Picha ya Mtumiaji
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 like to help you. Please, get in touch to discuss and understand all the details in deep. Based on what we will talk, I'll be able to give you a good proposal. Will wait for your contact. Experience building solutions like: Windows Desktop Apps (using Excel, Access, .NET,C++,C#, Winautomation) Scrapers Apps Scrape services Automation programs/bots Web apps/systems. Message me to have the whole idea about your project. Will wait for your contact. Thanks.
$600 USD ndani ya siku 5
5.0 (187 hakiki)
7.2
7.2
Picha ya Mtumiaji
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 solutions to add i will of course take money :). Also please send me your Vba code will run it here and see the issues. Thank you
$588 USD ndani ya siku 5
5.0 (64 hakiki)
7.0
7.0
Picha ya Mtumiaji
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 is your current Excel spreadsheet.
$264 USD ndani ya siku 1
5.0 (217 hakiki)
6.7
6.7
Picha ya Mtumiaji
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 from ncaa site. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
$250 USD ndani ya siku 3
5.0 (213 hakiki)
6.9
6.9
Picha ya Mtumiaji
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 Firefox. I am very excited to work with you so please feel free to contact me so we can discuss the details of this project.
$250 USD ndani ya siku 5
4.9 (157 hakiki)
6.3
6.3
Picha ya Mtumiaji
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/ https://www.freelancer.com/projects/data-processing/download-images-descriptions-from/ https://www.freelancer.com/projects/Web-Scraping/Project-for-Ahmed-14542395/ https://www.freelancer.com/projects/php/Getting-data-from-website-inserted/ https://www.freelancer.com/projects/Data-Entry/websites-list-put-nice-tab/ https://www.freelancer.com/projects/Software-Architecture/WebScraping-open-bidding/ https://www.freelancer.com/projects/Data-Entry/Find-Information-from-Websites-12594131/ https://www.freelancer.com/projects/Web-Scraping/Scraping-Instagram-data/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Project-for-romaniaexpert-12717079/ https://www.freelancer.com/projects/Web-Scraping/Website-data-scraping-12683056/ https://www.freelancer.com/projects/Software-Architecture/Script-convert-from-Starred-Location/ https://www.freelancer.com/projects/Data-Processing/Download-Images-from-Mass-List/ waiting your answer Regards
$250 USD ndani ya siku 1
4.9 (104 hakiki)
5.2
5.2
Picha ya Mtumiaji
I Have good knowledge of VBA scripting, Python and Java programming language. As of now I am working as software developer.
$555 USD ndani ya siku 10
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Broomfield, United States
5.0
3
Njia ya malipo imethibitishwa
Mwanachama tangu Ago 15, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.