Stock market analytics
- or -
Post a project like this1608
£350(approx. $436)
- Posted:
- Proposals: 16
- Remote
- #2588134
- OPPORTUNITY
- PRE-FUNDED
- Awarded
18 years expert in PHP, MySQL, HTML, CSS, JavaScript, jQuery, Ajax, Bootstrap, Chrome Extension, VB, VBA, AutIT Programming & Website Data Scraping
Ambala
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Internet Researcher/Research/Data entry/Lead generation/Data collection/Web search/Data scrapping/Market research/PDF conversion/web scrapping/virtual assistant/Email database/Excel/Email Database
Vadodara
Data analyst | Writer & Researcher | Statistician | Wikipedia editor & Publisher
Bay Minette
214842423247690390495618310059481104630119279819288261971398240051027757802895761
Description
Experience Level: Expert
What I need is pretty simple. I’d like an analysis done of all stocks on both the London Stock Exchange and the New York Stock Exchange for the last five years. There were 6460 stocks in NYSE: https://www.nyse.com/listings_directory/stock
There were 24,000 stocks in London Stock Exchange: https://www.londonstockexchange.com/exchange/prices-and-markets/stocks/prices-search/stock-prices-search.html
I do not have the raw data, you will need to get the OHLC data for all stocks for last five years from whichever provider you choose, maybe the above sites, or yahoo, or barchart.com or other.
I want an excel list of any stock that opened at least 4% above or below the previous days close and I want some key fields related to that gap, as per the attached excel template. All field headers have an explanation in them if you click on it. I've also filled in five rows for one stock, with actual correct data to help with understanding. I just want a price for the complete job, a total price and estimated time to complete (maximum two weeks, quicker is better). Make sure you do some research first to ensure you are clear on the size of the job, there are a lot of stocks on these two exchanges and a lot of gaps, so ideally you need to be able to automate the research to produce the list, not do it all manually and you need to obtain the source raw data.
This is the third time I've had to post this job, because last two freelancers that took it, couldn't complete the work even after many promises and wasted weeks. Don't apply if you don't fully understand it, don't apply if you cant source the raw data, don't apply if you can't create the excel calculations to convert the raw data into the template format I want. This cannot be done manually, it's five years of data for over 30,000 stocks to be analysed, you need to automate gathering of the raw data and automate running the calculations to produce the final result.
There were 24,000 stocks in London Stock Exchange: https://www.londonstockexchange.com/exchange/prices-and-markets/stocks/prices-search/stock-prices-search.html
I do not have the raw data, you will need to get the OHLC data for all stocks for last five years from whichever provider you choose, maybe the above sites, or yahoo, or barchart.com or other.
I want an excel list of any stock that opened at least 4% above or below the previous days close and I want some key fields related to that gap, as per the attached excel template. All field headers have an explanation in them if you click on it. I've also filled in five rows for one stock, with actual correct data to help with understanding. I just want a price for the complete job, a total price and estimated time to complete (maximum two weeks, quicker is better). Make sure you do some research first to ensure you are clear on the size of the job, there are a lot of stocks on these two exchanges and a lot of gaps, so ideally you need to be able to automate the research to produce the list, not do it all manually and you need to obtain the source raw data.
This is the third time I've had to post this job, because last two freelancers that took it, couldn't complete the work even after many promises and wasted weeks. Don't apply if you don't fully understand it, don't apply if you cant source the raw data, don't apply if you can't create the excel calculations to convert the raw data into the template format I want. This cannot be done manually, it's five years of data for over 30,000 stocks to be analysed, you need to automate gathering of the raw data and automate running the calculations to produce the final result.
Steven M.
100% (33)Projects Completed
14
Freelancers worked with
13
Projects awarded
39%
Last project
3 Sep 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Steven, thank you for inviting me to send a proposal for your project. I'm interested but I'm fully booked with work for the upcoming two to three weeks. You mentioned that you wish to get the job done within 2 weeks time. Can the turnaround deadline be possibly extended to a longer period of time?
859848
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies