Scraping websites to excel. 7 tabs

Imekamilika Ilichapishwa Miaka 6 iliyopita Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

Scraping project 1

In this project I need to scrape E-sports statistics from Counter-Strike:GO games. This also requires scraping odds on some of them (not all of them are offered by bookmakers). This file will be in constant use so it has to work well.

I'm not familiar with python that's why I choose excel as it's the easiest way for me to continue my project. I provided screenshots in the file to make it easier to understand.

7 tabs with scraping procedure all very similar.

Tab 1 “Entire History”:

Scrape Entire History from provided links (screenshot provided). There are countless pages which makes it a bit more tricky. Combine it with second scraping process to provide deeper statistics (marked with orange color).

Tab 2 “Last 6 Months”

Same as above with only one difference:

I want excel to remove older entries than from 6 months ago.

Tab 3 “Last 3 Months”

Same as above – just data from last 3 months.

Tab 4 “Win- Lose Entire History”

Scrape entire history from provided links – just one source this time but also multiple pages.

Tab 5 “Win- Lose 6 months”

I want excel to clear older entries than from 6 months ago.

Tab 6 “Win- Lose 3 months”

Same as above – just data from last 3 months.

Tab 7 Upcoming games

To be discussed but you can understand roughly the idea. There are multiple options here: direct scraping, widget scraping (html) etc. I'm open to your opinion.

Excel Web Scraping

Kitambulisho cha Mradi: #13765625

Kuhusu mradi

37 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

kolosibalint

Hi there, I have 4 years experience in Excel VBA programming including automated data extraction from websites. I created many tools to collect sports results from sites like Flashscore, Soccerway, ESPN, Basketballr Zaidi

€200 EUR kwa siku 3
(Maoni 120)
7.0

37 wafanyakazi huru wanazabuni wastani wa €152 kwa kazi hii

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Zaidi

€180 EUR kwa siku 3
(Maoni 324)
8.0
mantislin

Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me Zaidi

€154 EUR kwa siku 5
(Maoni 315)
7.7
phpXpertbd

Dear Sir, I'm very much delighted to let you know that i did data scraping with PHP-cURL, PhantomJS, Node.js, Selenium from many sites. I just scraped the data from web site and then wrote the data in mysql database Zaidi

€200 EUR kwa siku 6
(Maoni 66)
7.1
Harun1986

Dear Sir, I will provide you Current data from (source website). Also, I can scrap after login from current data Scraping source website, I Will follow (name, details (Email, phone, website, etc ) If the Source site d Zaidi

€155 EUR kwa siku 3
(Maoni 192)
6.6
flashsaiful

I am a professional Freelancer. I would like to work on this project. I have done a lot of similar project of this. Feel free to let me know if you would like to look a sample

€155 EUR kwa siku 3
(Maoni 171)
6.8
DelowarHossen

Hello honorable client, I read your full post very carefully and very much interested to work this project with 100% accurately, your minimum budget with timely delivered guaranteed. I am expert of advanced Internet re Zaidi

€250 EUR kwa siku 2
(Maoni 33)
5.8
stevegtdbz

Hello Sir, I have completed many similar projects at past. I will use a python script to scrap the data you need. Please let me know if i can help

€50 EUR kwa siku 2
(Maoni 83)
5.9
pm9887

Hi, I have vast experience in Lead Generation, Data Entry and Data processing. You can check my competencies. I can give you the best quality in quick turn around time with the good competitive price. Thanks

€98 EUR kwa siku 6
(Maoni 71)
5.7
mladenbiz

hello I'm experienced freelancer familiar with the type of work your project requires. I'm a hard worker, and if you need a reliable freelancer, please contact me. Best regards, ~mladenbiz

€88 EUR kwa siku 3
(Maoni 64)
5.8
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 7 years of experience. I have successfully completed few projects for US clients which involved web sc Zaidi

€155 EUR kwa siku 3
(Maoni 44)
5.8
muradeltaher

Hi There, I'm a Mechanical Engineer familiar with Microsoft Word, Microsoft Excel Google docs Spreadsheet, Wordpress, Magneto I Provide certain services : 1. Data Entry 2. Web Research 3. Social Media Ma Zaidi

€155 EUR kwa siku 3
(Maoni 71)
5.0
Gates777

Hello? I am very interesting in your project. I checked your description very carefully and understood all. I can do this in a short time with high quality I am expert in php, c#, python, web automation, simulation Zaidi

€200 EUR kwa siku 3
(Maoni 10)
4.8
ajaszin

Hi, We have 9+ years experience in various freelance works. I would like to chat with you for more detailed discussion regarding this work. Looking forward for your Personal Message. Thanks & Regards, Jasin A.

€160 EUR kwa siku 4
(Maoni 23)
4.5
Ramez125

Hey, I am a professional in extracting data from a web page. I work with some useful tools which is why I can get data from web page fast and accurately. My skills and services include: - Web scraping - Data entry - Da Zaidi

€30 EUR kwa siku 0
(Maoni 27)
4.7
nimesha1994

Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your project right Zaidi

€80 EUR kwa siku 3
(Maoni 6)
4.2
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format Zaidi

€377 EUR kwa siku 5
(Maoni 19)
4.0
Max01

hello hope you are doing well I am interested to work on this project. Gladly waiting to serve you with my extensive skills. we can use any php HTMLDOM or python scrapy

€250 EUR kwa siku 7
(Maoni 5)
3.2
abdulghaffar11

Hello, DON'T AWARD PROJECT BEFORE DISCUSSION, I have few questions to ask, knock me for further discussion, I have 5 years experience in this skills thank you!

€100 EUR kwa siku 3
(Maoni 3)
2.6
atiffani451

HELLO DEAR ! If you are reading my profile then I'm assuming you are considering me for your next project so this is my one chance to impress you and tell you why you should pick me over anyone else. I specialize in Da Zaidi

€44 EUR kwa siku 3
(Maoni 8)
3.0
HaykDag

Hi , I am an excel and Vba specialist , I can do your project by Vba code , it will work max fast , if you want chat me and I can start workin now. Afther Project I will support you without any charges if you want to d Zaidi

€155 EUR kwa siku 5
(Maoni 5)
2.6