How-to Videos

• How to calculate returns with Excel
• How to calculate standard deviation with Excel
• How to use Excel for 'Time Value of Money' calculations
• How to calculate portfolio standard deviation with Excel
• How to save CSV files as Excel files
• TVM: Mortgage using Excel (how-to use the solver)
• TVM: Mortgage interest using Excel (how-to use the solver)
• Bonds: Bond price using Excel (how-to use the solver)
• Bonds: Bond yield using Excel (how-to use the solver)
• Bonds: Bond call value using Excel (how-to use the solver)
• Excel: Zero rates (Excel Spreadsheet)
• Excel: Bootstrap Method (Excel Spreadsheet)
• Yahoo! Finance Option Trading
• How to find and trade foreign stocks
• STATA: Introduction
• STATA: Installing fetchquotes and fetchkeystats
• STATA: Using fetchquotes to download stock prices
• STATA: Using fetchkeystats to download stock key statistics
• STATA: Preparing a stock portfolio
• STATA: Estimating CAPM for a single stock
• STATA: Estimating portfolio CAPM
• STATA: Estimating CAPM for a portfolio using broader market portfolio instead of S&P 500
• STATA: Saving code file
• STATA: Saving data file
• STATA: Using loops
• STATA: Downloading and saving Fama-French factors as Stata data file
• STATA: Installing freduse
• STATA: Estimating multi-factor CAPM for a portfolio (with a foreign stock) using market portfolio and using Fama/French factors
• STATA: Estimating multi-factor CAPM for a portfolio (with a foreign stock) using broad market portfolio and using Fama/French factors
• STATA: Installing components
• STATA: Installing a previously installed command for updates
• STATA: Return Comparisons: Dividend Yield
• STATA: Return Comparisons: Dividend Yield (Simple)
• STATA: Return Comparisons: All
• STATA: Event Study
• Excel: Short stock position hedge with a call option (Excel Spreadsheet)
• Excel: Long stock position hedge with a put option (Excel Spreadsheet)