Find Jobs
Hire Freelancers

spreadsheet automation

$10-30 USD

Closed
Posted about 6 years ago

$10-30 USD

Paid on delivery
I need to automate the attached spreadsheet. The only input is the list of stocks (Column A of the 'Stocks' tab). The rest must be generated automatically by 1. query the price history from Yahoo, and 2. calculate the correlation using proper formula. Input will be provided in simple input file (one symbol per line). Output can be Excel file or HTML TABLE in html file.
Project ID: 16462067

About the project

24 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
24 freelancers are bidding on average $55 USD for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Please pay me once job is 100% done.
$150 USD in 2 days
5.0 (581 reviews)
8.9
8.9
User Avatar
Hi there..... Warm Greetings We came along with your request for spreadsheet automation and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of .NET, Java, PHP, Python, Visual Basic We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$30 USD in 1 day
4.9 (440 reviews)
8.4
8.4
User Avatar
Hi there. I have scraped Yahoo stock prices before. If you want I can show you a demo. Contact me to discusss Maurice Marinus
$50 USD in 1 day
5.0 (137 reviews)
7.2
7.2
User Avatar
A proposal has not yet been provided
$30 USD in 2 days
5.0 (163 reviews)
6.7
6.7
User Avatar
A proposal has not yet been provided
$55 USD in 1 day
4.9 (55 reviews)
5.7
5.7
User Avatar
I have excellent command on MS Excel and know how to pull stock data from Yahoo. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair, pinnacle and tennisinsight websites - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API - Built a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
$150 USD in 3 days
4.9 (73 reviews)
6.0
6.0
User Avatar
HI, I have extensive experience in Excel using APIs to connect to external data source and also with excel formulae and Macros, Thanks Regards Vaidy
$35 USD in 2 days
4.9 (11 reviews)
5.4
5.4
User Avatar
Hi, Nice to meet you, I am good at Python and also web scraping. Could you please provide the Yahoo link so that i can make a try? regards,
$40 USD in 1 day
5.0 (15 reviews)
4.4
4.4
User Avatar
IM READY TO BE HIRED!! i can do the spreadsheet automation send message now so that we can discuss
$25 USD in 5 days
4.9 (3 reviews)
3.9
3.9
User Avatar
I'm a developer with more than 2 decades of experience writing computer software. The automation described sounds quite straightforward and is well inside my skillset. I've allowed extra time for unforseen issues, possible extension on features and due to the client being in a different timezone.
$111 USD in 3 days
5.0 (1 review)
0.7
0.7
User Avatar
A proposal has not yet been provided
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Sir, As i know, you want to find someone who can automate the attached spreadsheet. And you find the right person to work with. I have many experienced in doing this job. And I am an expert on doing excel document and HTML file.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi there, i've been freelancing for a while now working with small firms creating code for daily tasks. the recent project I worked on was to Convert docs to excel. let me know if you wanma discuss the opportunity further. regards, surabhi
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$23 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a software developer with experience in web development using Java, PHP and Javascript. I also have some experience using script languages to gather data from web pages and getting things done with them. This bid is an estimative, as you didn't specified what kind of interface (if any) you want.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello , Ive done several projects scraping yahoo data for trading and have very good skills whit VBA . There is one variable missing from your task and that is how long the period of extraction must be. You should keep in mind large periods and several stocks will result in a lets say heavy calculations. While it is not a problem for the software or for the developer it may be an issue for the end user since it may take several minutes to finish the work I would be happy to work with you over this task and possibly improving it for future use by your criteria
$35 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
San Diego, United States
5.0
346
Payment method verified
Member since Aug 17, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.