Completed

Excel / VBA Webscrape Code to obtain Betting Odds on Demand

I need VBA code to be able to scrape on demand data from the website [login to view URL] The code needs to be able to scrape NCAA College Football and NFL games week after week. I will need the output to be produced cleanly into an Excel spreadsheet so that I can link/extract data, run formulas, etc. from another worksheet.

The scraped data should list the current schedule lineups of teams, their game dates and start time as well as the odds provided. The odds need to scrape the full game totals as well as spreads (and the odds for totals/spreads). I also need the second half totals and spreads scraped.

Lastly, I need the score of the game by quarter/team, time and quarter of the game (just as shown in the screenshot examples provided, the +100, -115, etc.). When the games are being played live or have recently finished, the scoring data can be found on the same website.

I would like to be able to run the VBA code prior to any game’s beginning to see their schedules and odds in a similar fashion as the website displays, but in Excel. As the games go to halftime, I need to be able to refresh the data to allow for the second half totals/lines with odds to be updated and displayed as they become available. Please see the attached sample workbook for further details.

I only need/want the data from Heritage which shows as (section data-vertical-sbid="169" data-index="5") in source data.

An example worksheet has been provided, it is not required to be in that specific format, but all data included should be able to be loaded with the VBA code.

All necessary data will be able to be found in the following:

College Football:

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

NFL:

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

Навички: Excel, Javascript, Архітектура ПЗ, Visual Basic, Веб-скрапінг

Деталі: excel vba menu code, excel vba code optmization, excel vba code optimis, code excel vba color alternating rows, excel vba code log websites, excel vba code ftp, excel vba code update, update code project excel vba, excel vba code open internet explorer, inventory excel vba code, excel vba calling code workbook, excel vba cleanup code, excel vba scource code, free excel vba macro code lotto numbers, rewrite excel vba application code, excel vba rewrite code, excel vba optimize code, excel vba clean code, excel vba system code explained, excel vba stock code

Про роботодавця:
( 0 відгуки(-ів) ) United States

ID Проекту: #17596217

Доручено:

mantislin

Dear sir, This is Lin, i did more than 380+ scraping project, please view my profile page here https://www.freelancer.com/u/mantislin.html then you will know. Can we discuss more details about your project? t Більше

$117 USD за 3 дні(-в)
(302 відгуків(-и))
7.5

15 фрілансерів(-и) у середньому готові виконати цю роботу за $147

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 Більше

$250 USD за 3 дні(-в)
(283 відгуків(и))
7.6
rostovsoft

I can develop VBA application of any complexity. I have more than 10 years of professional software development. I’ve successfully finished large VBA application (scrapping korean options data) [login to view URL] Більше

$140 USD за 5 дні(-в)
(113 відгуків(и))
6.3
fatimatuzzohura

Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project. Thanks

$200 USD за 3 дні(-в)
(142 відгуків(и))
6.3
sknadeem123

hello. I can complete this work. I have experience with VBA Webscrape and more you can see my profile and reviews. we can discuss more. do let me know. thank you.

$148 USD за 3 дні(-в)
(59 відгуків(и))
6.0
RushService

Feel fee to contact me for VBA Webscrape [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after th Більше

$150 USD за 3 дні(-в)
(36 відгуків(и))
5.7
AlexandrUKR

please clarify posdible next steps

$250 USD за 7 дні(-в)
(19 відгуків(и))
5.1
stead121

Hello, sir. I am interested in your scraping project. I am professional web developer specializing in crawling data from ecommerce site([login to view URL], [login to view URL], [login to view URL]) I have a good experience in Більше

$150 USD за 3 дні(-в)
(9 відгуків(и))
4.5
GlobalServicesWO

Hello, greetings of the day. We believe we are a perfect match for your project and believe in customer satisfaction. Please check our previous work : [login to view URL] https://www.theprimewatches.c Більше

$120 USD за 5 дні(-в)
(1 відгук)
1.9
nehameshram13

Hello Client, I have read your requirement about - Excel / VBA Webscrape Code to obtain Betting Odds on Demand and I am sure I can complete it as per the given description. I do have skills like Software Archi Більше

$54 USD за 3 дні(-в)
(0 відгуків(и))
0.0
CryptoProgrammer

Hi, As I have gone through your projects descriptions so I can do it. I have 6 years+ of experience with all IT related skills which is needed for your project. I have completed lot of projects with Software Architect Більше

$100 USD за 6 дні(-в)
(0 відгуків(и))
0.0
technowiz7

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I am a Більше

$155 USD за 3 дні(-в)
(0 відгуків(и))
0.0
kishordute

I can do this automation within 5 days with minimum prices as well as if you allow then I can create a application in python which is much faster than vba.

$55 USD за 5 дні(-в)
(0 відгуків(и))
0.0
techvinod

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I am a Більше

$155 USD за 3 дні(-в)
(0 відгуків(и))
0.0
jmajhidcoap

I am well acquainted with MS Excel and can handle any kind of work related to it. I always strive to explore new things. I can accept challenges and deliver the task given to me within the time frame. MY PRINCIP Більше

$155 USD за 3 дні(-в)
(0 відгуків(и))
0.0