I have what I hope is a fairly straightforward data analysis project. I have a large-ish data set of numbers. It a daily historical run over the past 3 years involving stock returns. It is now in Excel, with about 1,066 column and 789 rows. The columns are the names of different stocks. The rows are different dates.
The numbers in the set range from 0 to -1.
What I am trying to do is use this historical set to create a model that can be used in the future.. In particular, I am looking to be able to answer this question: When a stock gets to -.04 or below, how likely is it that it will get to -.08 and -0.20, using the data set as our guide.
Please let me know if you have any interest and feel you could tackle this project!!!