Seven Day Program Requirements
Part 1
Read stock symbols from a data source (coder picks data source - Excel, Access, Notepad, etc).
Go to Yahoo finance historical prices page @ <[login to view URL]> (where YHOO is the stock currently being analyzed) and bring back the historical data. Please note that the historical data is on multiple pages.
Write this to a "Historical Data" data store (you pick- Excel, Access, SQL, etc) for each stock?
Perform the following analysis on the data written to the “Historical Data?? tab and write the following to “Results?? data store.
·? ? ? ? ? ? ? ? For January, calculate the number of years where the stock rose, declined or stayed flat (did not change by more than $1) over the 1st seven days of the month. Write that value. Calculate the average price change over those seven days based and show the avg. amount the stock rose, remained flat, or declined. Write these values.
·? ? ? ? ? ? ? ? For January, calculate the number of years where the stock rose, declined or stayed flat (did not change by more than $1) over the last seven days of the month. Write that value. Calculate the average price change over those seven days based and show the avg. amount the stock rose, remained flat, or declined. Write these values.
·? ? ? ? ? ? ? ? Do the same in the first 2 bullets above for each month Feb- Dec.
Part 2? Error Handling
If a Stock does not have data for the time period being asked for say 5 years, and the company has only 2 years, Please put a note on the results page: “Stock history was shorter than the timeframe requested??.
If no data found, put a note on the results page “No data found??.
IF the website was unavailable after 5 tries put “Website unavailable??.
Note: I have included a sample of how the output should look. I did it in Excel but it is? NOT a requirement for that to be the output mechanism. Coder chooses.