This is a one-time research and data entry project. You don't have to write any code unless you want to. I need a table (Excel spreadsheet) listing all stocks in the BOVESPA. I need the following info for each one: - symbol - company name - last closing price - market capitalization - P/E ratio - lowest price of the last 52 weeks - highest price of the last 52 weeks The Excel file must be clean - one stock per row, one data element per column, without any extraneous information or formatting. First row is for data element names. ========== additional information ======== To webscrape from [url removed, login to view] (your choice), use this example (this example is for company name ABYARA PLANEJAMENTO IMOBILIARIO S.A.): [url removed, login to view] Symbol is ABYA3 (it's called "trading codes" in this page) Last Price = 28.99 (from "Quotes" table near the top) Capital Stock Composition (Common) = 50,852,430 Market Capitalization = 50,852,430 * 28.99 = 1,474 B Net income = 8,746 (unit is thousands) P/E Ratio = (Net income) / (Market Cap) = 168 Highest/Lowest 52wk is not found in this page, you need to look for it somewhere else (I don't know where).
This project is for experts only. Do not ask the buyer how you are going to get this data.
* * *1) Microsoft Excel file with the data
2) You must explain fully how you got the data, so that I can validate its accuracy.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).