Hello,
I am trying to do a project that is based in the analysis of stock quotes over several years. However I have a few questions and I hope you can help me.
The project
I want to analyze how certain stocks behave between specific dates, i.e, what is the percentage growth or decay between those specific dates. We are talking about more than 300 different companies over a period of 25 years. I am planning in getting the data from Yahoo finance, namely over the historical quotes options (where i can download the data). For exemple, for a stock like Microsoft, at some point i want to know what was the percentage change in the quote between the initial date of January 5th 1986 and October 2nd 1988.
The problems
The first problem is that i want to do the above study for several different date intervals and for all the 300+ companies in the exact same intervals.
1. When I download the individual data from Yahoo finance for all the companies, must i put it in 300+ different cheats within the same excel page? Or is there na easier alternative?
2. Is there a way to create a pivot table where i can reunite all the data from all the years and all the companies, and then i can analyze for each specific period how all the companies behave in terms of percentage chance?
3. If so, how can I automatize this so I don't need to create all the formulas for each specific company?
4. Is there a way to atribute a tittle to each of these periods (for example, between January 5th 1986 and October 2nd 1988 - imagine i can cal it Period 1) so I don't need to choose these dates one by one, but just the title of them?
I know these are many questions, but I really would like some help, namely on how i can start all this and which are my best options in terms of excel possibilities to do it.
Thank you so much.
I am trying to do a project that is based in the analysis of stock quotes over several years. However I have a few questions and I hope you can help me.
The project
I want to analyze how certain stocks behave between specific dates, i.e, what is the percentage growth or decay between those specific dates. We are talking about more than 300 different companies over a period of 25 years. I am planning in getting the data from Yahoo finance, namely over the historical quotes options (where i can download the data). For exemple, for a stock like Microsoft, at some point i want to know what was the percentage change in the quote between the initial date of January 5th 1986 and October 2nd 1988.
The problems
The first problem is that i want to do the above study for several different date intervals and for all the 300+ companies in the exact same intervals.
1. When I download the individual data from Yahoo finance for all the companies, must i put it in 300+ different cheats within the same excel page? Or is there na easier alternative?
2. Is there a way to create a pivot table where i can reunite all the data from all the years and all the companies, and then i can analyze for each specific period how all the companies behave in terms of percentage chance?
3. If so, how can I automatize this so I don't need to create all the formulas for each specific company?
4. Is there a way to atribute a tittle to each of these periods (for example, between January 5th 1986 and October 2nd 1988 - imagine i can cal it Period 1) so I don't need to choose these dates one by one, but just the title of them?
I know these are many questions, but I really would like some help, namely on how i can start all this and which are my best options in terms of excel possibilities to do it.
Thank you so much.
