Closed

Automated Excel Sheet (google sheets may be easier?)

I need a automatically updated Excel spreadsheet.

I want it to take the days ASX (Australian Stock Exchange) top Gainers Losers Data from [login to view URL] or reliable website for each day from now onwards.

I need the current price at close of market and % change, then I need the next day % change and the day after that % change.

Essentially I want it to continuously collect data for each days gainers and losers creating history of data that grows every day.

I'd also like the ASX overall performance in there as well, showing the price and % change, and then % change for the following two days.

Probably made it sound a lot more confusing than it is but the excel template I sent should clear it up, you may notice I only have the next days data % change for the first date 15th and none for second date 16th. Because the data is not out yet :)

Any clarification please message me

Skills: Data Entry, Data Processing, Excel, PHP, Web Scraping

See more: google sheets, excel, i am looking to build excel sheet contains multiple sheets, excel convert google sheets, excel vs google sheets 2017, can google sheets do everything excel can, disadvantages of google sheets, google sheets automation, google sheets vs excel formulas, differences between google sheets and excel, google sheets for dummies, google sheets formulas, php, excel, web scraping, microsoft excel, split excel sheet multiple sheets, excel copy sheet multiple sheets, excel macros google sheet, data mining collect data website directory excel sheet, improve performance multiple pivot tables single excel sheet

About the Employer:
( 0 reviews ) Australia

Project ID: #16980109

21 freelancers are bidding on average $163 for this job

jaylancer43

Hello Sir, Thank you for this opportunity, I have done similar projects before. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (https://ww More

$200 AUD in 2 days
(570 Reviews)
8.2
schoudhary1553

Hello, I can help with you in your project Automated Excel Sheet (google sheets may be easier?). I have more than 5 years of experience in Freelancer Certifications Required. We have worked on several similar projec More

$180 AUD in 3 days
(258 Reviews)
7.5
mantislin

Hi sir, 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 vie More

$121 AUD in 3 days
(381 Reviews)
7.6
uumarkhalid31

Hi, I am expert in automating the processes and i have make scraper of ASX for in client in recent past. I am quite familiar with this website and i know how to get data effectively from this website. Please contact More

$200 AUD in 3 days
(235 Reviews)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$200 AUD in 7 days
(193 Reviews)
6.7
vivekbansode25

Hello, Hope you doing well. I strongly feel that before we can arrive on a fair conclusion for the price and timeline, I would need more details about the Project which will help us understand your vision and pla More

$200 AUD in 3 days
(26 Reviews)
6.4
archanaoswal

I have excellent command on MS Excel and can create the required sheet. I can also do it in Google Sheets and have created a similar sheet for cryptocurrency earlier [login to view URL] More

$180 AUD in 3 days
(45 Reviews)
5.3
AlexandrUKR

i can create it in excel or access, please clarify possible next steps

$250 AUD in 7 days
(17 Reviews)
5.0
$160 AUD in 3 days
(19 Reviews)
4.6
Orientwork

I am a Data Entry/Data Processing Expert. I also have experience in word and excel. PDF to Word and Excel I know the value of time. I am very hard working and always deliver work on time. My motive is to make my employ More

$50 AUD in 5 days
(61 Reviews)
5.0
hanlan

A proposal has not yet been provided

$200 AUD in 2 days
(15 Reviews)
5.0
surekash7096

I have expertise in Excel and experience in building automated sheets for stock prices from the exchange. Ready to start work immediately.

$100 AUD in 2 days
(68 Reviews)
5.2
adampohp79

Dear Sir. Glad to meet you. I'm Web developer specializing in web scraping crawling and indexing web pages. Skills: python, scrapy, selenium, requests, beautifulsoup, mechanize, lxml, urllib2, automation, bots, More

$222 AUD in 3 days
(16 Reviews)
4.5
aubrey03

A proposal has not yet been provided

$138 AUD in 3 days
(24 Reviews)
4.9
pushar71

Hello Please share the excel file, i am keen to do this project for you, i am online and ready to start. Please connect for further discussion i have done several data visualization and analytics projects and i am a c More

$155 AUD in 5 days
(3 Reviews)
4.5
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, 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, fo More

$155 AUD in 7 days
(27 Reviews)
4.3
redincorpindia

Dear client I saw your requirements regarding the web scraping application in excel / google sheet. I can develop this application within a day maximum based on your requirements. I developed many applications is sim More

$180 AUD in 1 day
(11 Reviews)
4.3
kishu0079

A proposal has not yet been provided

$120 AUD in 1 day
(2 Reviews)
3.1
ibrahimanjum330

A proposal has not yet been provided

$277 AUD in 5 days
(4 Reviews)
2.4
BeyoutiF00L

We write and design with our heart, and edit without it. The content and Design plays a very important role in deciding, whether a visitor, will bounce off, or return as a customer. Each word that we putin text is espe More

$30 AUD in 2 days
(4 Reviews)
1.5