I need a developer familiar with YQL to execute this project for me. The goal of the project is to see extract the data and do a simple comparison to see what percentage of companies that beat their earnings forecast in the prior quarter, beat it in the following quarter.
Step 1: Go to <[url removed, login to view]> and grab the data only for companies that provided upside surprises. You must grab the data for every day of every company that provided upside surprises and save it in a database for as far back as Yahoo Finance API will allow. I did some quick research and figured out that you can get data for the past 8 months.
Step 2: Compare the names in the database and see if a name appears more than once. For instance, in the example above the name "Angeion Corporation" appears on May 28th. Since companies announce earnings roughly every 3 months, you should look to see if the name Angeion appears again.
Test: If no company appears two (or more) times in your database, you have an error of some sort because there has to be at least one company that beat forecasts in two consecutive quarters.
UI: I don't need a fancy UI. Just a simple UI that shows all of the data for the companies that beat the forecast in 2 (or more consecutive quarters) presented in an easy to understand manner. Also, some aggregate analysis data about how many company names provided upside surprises in the number of days analyzed and how many of them, in actual numbers as well as percentage terms, beat the forecast in two (or more) quarters. And any other interesting correlations that you discover while analyzing the data.
Storage & Historical analysis: Since the data will be pulled daily, I need some way to store and see the data historically in the years to come.
There may be other minor stuff I think off but the core scope will remain the same as above.