Completed

Scrape real-time data and place into Google Sheets or Excel

I have completed many personal projects but am completely stuck after failing many times on my current task. I am trying to scrape real-time data from a website that refreshes every 15 seconds. I have been successful in scraping a mirror of this site into Google Sheets because the code behind the site is easier.

This is the formula

=iferror(index(importhtml($B$1&"#rev="&$B$2,"table",$B$3),A6+2,11),"")

This is an example of a site URL

[login to view URL]

Ultimately, the better data resides at [login to view URL] , where the "n's" change, for example, R3/C1 or R5/C5. The table has two headers, I want the data from TABLE OF STARTERS

So, what I am looking for is:

1. Scrape [login to view URL], where I can assign the n each time

2. Pull the data from the only table on the site, I have provided an example

3. The page refreshes every 15 seconds, so I want that new data every 15 seconds

4. I want the data to be imported to either Google Sheets or Excel so I can instantaneously run statistics on that data

5. No data needs to archived

Skills: Web Scraping, Excel, PHP, Javascript, Google Sheets

See more: read real time data currently opened excel sheet, displaying real time data excel window application, real time data used plot graph excel, real time data forex excel, real time data tradestation excel, real time data link excel, read real time data excel file, access excel real time data update, real time data excel form amibroker, net excel real time data, excel real time data, feed real time data excel, fetch real time data yahoo google, input real time data yahoo excel, tracking real time data gps google map api, real time data nse google, nse real time data yahoo google amibroker, real time data feed google, real time data feeder google amibroker

About the Employer:
( 0 reviews ) newtown, United States

Project ID: #21942598

Awarded to:

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 (goo More

$250 USD in 3 days
(732 Reviews)
8.5

28 freelancers are bidding on average $145 for this job

omsoftware

Hi Howard! Greetinsg from Omsoftware My name's Raj. I've read over your spec, I understand we're looking at php, javascript, excel, web scraping, google sheets and think I'm a great fit for the project. I'm very More

$147 USD in 7 days
(141 Reviews)
8.9
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$220 USD in 4 days
(343 Reviews)
8.0
mantislin

Hi there, This is Lin, Can we discuss more details about your project? then i can do example data or script for you, we can continue after you checked example data. I did more than 380+ scraping project, please view More

$144 USD in 3 days
(445 Reviews)
7.9
Friends4it

Dear Ezgoer89! Please check some of our Creative work [login to view URL] [login to view URL] [login to view URL] [login to view URL] Ready to build you highly professional and modern design for your website. Ready t More

$250 USD in 6 days
(322 Reviews)
7.8
zekovicm

Hi there,I am Web Scraping expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the More

$220 USD in 5 days
(155 Reviews)
7.6
polarjin2017

Hello? How are you? I am excited to work with you on Google doc, Google spreadsheet and PPT api. So I think I can help you if you want. [login to view URL] This is what i have done in google script with a More

$155 USD in 3 days
(184 Reviews)
7.3
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$200 USD in 5 days
(112 Reviews)
6.9
ferozstk

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on it with more than 7 years experience. Please feel free to contact me. I am looking forward to hear from you. More

$70 USD in 4 days
(162 Reviews)
6.8
sunbrek

Hi! My name is Guillermo, I'm a Director at Aurora Studio, a Development Studio based in the United States and I would like to help you with your project! The page is not refreshing on my side. Could you tell me more More

$250 USD in 3 days
(19 Reviews)
6.3
shinelancer

*** Hello. I have checked your description and website link. I can do your project well and asap. I have good experience with scraping. I want to discuss with you.

$150 USD in 7 days
(44 Reviews)
5.8
topexpert713

Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional Python,Scraping expert with over 5 years of experience. git More

$140 USD in 7 days
(19 Reviews)
5.3
smsaurabhv

Hi, I have gone through your requirement to scrape lots of websites. I am EXPERT in building scraping tools /scripts. Hence, I can SURELY work on your project. I am having 4 YEARS of EXPERIENCE in developing PHP-PYTHON More

$100 USD in 3 days
(75 Reviews)
5.6
Itsoftbd24

Dear Sir/Madam, I am uzzal hossain from Dhaka, Bangladesh. I have a team and I can do this urgently if you needed. I want to do your job perfectly. Thanks. Regards Uzzal Hossain

$100 USD in 5 days
(26 Reviews)
5.2
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL More

$60 USD in 2 days
(18 Reviews)
4.6
yashashahj1397

i have worked on scraper for [login to view URL] which was a very complex project.I can show you demo in uipath. i can do the best output result because i know the site better than anyone.I can scrap the website using uipath and ex More

$180 USD in 7 days
(12 Reviews)
4.3
wwwTom

I read your project description carefully and I am confident to finish your project. I am a excellent Web Scrapping expert and if you assign to me this project, you can get a cool result. And I am ready for your task a More

$120 USD in 4 days
(10 Reviews)
4.4
BestPrince1120

Hi Sir. I have read the example.png. Sure I can do it.

$100 USD in 2 days
(19 Reviews)
4.0
nikhil929

Hi, We have certain experience with scraping odds from Betfair and Bet365 and your project seems to related with it meanwhile we can scrape the data and saving them to Database meanwhile we can go further with More

$140 USD in 7 days
(6 Reviews)
3.8
wkcompany

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many More

$140 USD in 1 day
(16 Reviews)
3.2
Alexsfodik

*****Web Data Scraping Expert ***** Hello. I have read your job description carefully. I have full experience in Web Scraping with PHP and Python. So I can do your project perfectly. I can start just now and I can del More

$100 USD in 1 day
(2 Reviews)
2.6