Scrape Web Data to Produce CSV Data Table
- or -
Post a project like this1767
$50
- Posted:
- Proposals: 7
- Remote
- #2423773
- Awarded
Wordpress Developer *Full Stack Web Developer * Shopify Developer*PHP* REACT JS
Islamabad
142971397011712504082419237265801126695912761601
Description
Experience Level: Entry
Estimated project duration: 1 day or less
Hello!
Please also reference the excel file attached. When researching stocks, I manually gather a variety of information from www.finance.yahoo.com. I would like to build a process using python that will loop through a list of companies and automatically write data from www.finance.yahoo.com to a CSV. I am new to python programming so I would appreciate a simple, commented process allowing me to break down how the process was built so that I can own and use it going forward. I have Anaconda for Windows which will be used to execute the script.
On the tab titled 'Ticker List', these are the list of N companies that will be researched.
On the tab titled 'Finished Product', this is an example of the final output.
Columns B to D are sourced from https://finance.yahoo.com/quote/[Ticker]/key-statistics
Columns E to H are sourced from https://finance.yahoo.com/quote/[Ticker]/financials
Columns I to M are sourced from https://finance.yahoo.com/quote/[Ticker]/analysis
Generally speaking, the table structure is the same for all companies. But, as you can see with UBER for columns E to H, the source web page only contains 3 columns of annual financial data whereas the other companies (C and AAP) contain 4. If the information does not exist in a consistent format allowing for simple code, please simply return 'N/A'.
Thank you!
Please also reference the excel file attached. When researching stocks, I manually gather a variety of information from www.finance.yahoo.com. I would like to build a process using python that will loop through a list of companies and automatically write data from www.finance.yahoo.com to a CSV. I am new to python programming so I would appreciate a simple, commented process allowing me to break down how the process was built so that I can own and use it going forward. I have Anaconda for Windows which will be used to execute the script.
On the tab titled 'Ticker List', these are the list of N companies that will be researched.
On the tab titled 'Finished Product', this is an example of the final output.
Columns B to D are sourced from https://finance.yahoo.com/quote/[Ticker]/key-statistics
Columns E to H are sourced from https://finance.yahoo.com/quote/[Ticker]/financials
Columns I to M are sourced from https://finance.yahoo.com/quote/[Ticker]/analysis
Generally speaking, the table structure is the same for all companies. But, as you can see with UBER for columns E to H, the source web page only contains 3 columns of annual financial data whereas the other companies (C and AAP) contain 4. If the information does not exist in a consistent format allowing for simple code, please simply return 'N/A'.
Thank you!
Gregory S.
100% (4)Projects Completed
4
Freelancers worked with
3
Projects awarded
57%
Last project
19 Aug 2022
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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