Support Videos
Excel Related
Stock Data and Basic Beta Computation
WinORS Related
Bond Portfolio Related
How to Download Historical Stock Price Data into Excel from Yahoo!How to Sort and Compute Period Returns ヨ from a Yahoo stock price download
How to Construct a Bond Portfolio in WinORSHow to Auto Generate a Bond Portfolio Report in WinORS
Computing and Charting Stock Returns and Stock Price Volatility
How to Create Log Returns and Volatility MeasureHow To Chart Rolling Volatility vs Stock PriceHow To Create a Chart of Stock Volume vs Market VolumeHow to compute Beta and Vasicek Adjusted Beta in Excel from Yahoo data
Importing and Cleaning Market Data
How To Import Market Data into WinORSHow To Replace Missing Data and Set Variable Types for Imported Data
Equity Hedge Fund Portfolio & Related
Create a Basic MWord Document from Excel with Charts
How to Create a Basic MWord Document from an Excel Spreadsheet with Charts
How to Create an Equity Portfolio by a Random Selection of StocksHow to Sort an Equity / Hedge Portfolio by Ticker SymbolHow to Update Stock Prices for all Tickers in an Equity / Hedge PortfolioHow to Insert a Portfolio Insurance TabFutures Hedge on Equity Portfolio with Append to WriteORS DocumentHow to Append New WinORS Reports to an Existing WriteORS DocumentHow to Solve for a Markowitz and Sharpe (w/Vasicek Beta) Efficient Set
Efficient Set Methods - Basic & Advanced
Basic Efficient Set Creation for an Equity Portfolio on Tab AHow to Create a Constrained Efficient Set from the Markowitz Model
Regression Analysis and Related
Basic Stepwise with OLS Regression Follow-upHow to Add Seasonal Dummy VariablesHow to Take the Natural Log (Ln) of data cells excluding Column with a G