|| Home Modelling Exercises Template Models Book Testimony Excel Case Studies ||

Templates that Develop Statistical Analysis

Because it is sometimes frustrating to find programs that deal with the important problem of autocorrelation in financial and economic data. The file below includes techniques that allows you to easliy enter data and then make regression analysis that includes the autocorrelation.

Subject

Excel Exercise File

Video

Chapter Reference

Page Reference

Financial Ratio Download 1 - Finding Tickers

Financial Ratio Download 1







Financial Ratio Download 2 - Reading One URL with Workbooks.open

Financial Ratio Download 1

https://www.youtube.com/watch?v=V__Lmzmcw_s

Chapter 16

193

Financial Ratio Download 3 - Stock Summary by Date

Financial Ratio Download 2

https://www.youtube.com/watch?v=IqQLg7y61pg

Chapter 16

193

Financial Ratio Download 4 - Moving Sheets

Financial Ratio Download 3



Chapter 16

193

Financial Ratio Download 5 - Reading Multiple Companies

Financial Ratio Download 4

https://www.youtube.com/watch?v=_byg3ojjUgo

Chapter 16

193

Financial Ratio Download 6 - Extracting Data from Sheets

Financial Ratio Download 5

https://www.youtube.com/watch?v=D2mClmUwkro

Chapter 16

193

Financial Ratio Download 7 - Selecting Companies with TRUE/FALSE

Financial Ratio Download 5

https://www.youtube.com/watch?v=Nri1In4rDw0

Chapter 16

193

Financial Ratio Download 8 - Reading Companies from Market Watch








…..
……………………………………………………………………………………………………………………
…..
………………………………………………………………………
…..
………………………………………………………………………………………………….
…..
………………………………………
…..
……………………………………………………