Excel Spreadsheets

• Black Scholes Pricer   Options pricing Excel spreadsheet that uses the exact solution to the Black Scholes Equation. Calculates Call and Put values. Not a trivial task in Excel due to the way the Error Function is expressed in Excel.

Data Analysis Examples

• Are Real Estate Prices Dependent on Mortgage Rates? by Lucas Finco
• PieChartController.xlsWorkforce Generation Distribution evolution over time for a Fortune 500 Co.by Lucas Finco   (contains macros)

Software

• Diversifi (Coming Soon!)   What Sharpe ratio does your portfolio have? Will certain stocks work well together to diversify away your risk? With this tool, you can answer these questions. Enter stock symbols and quantities, and their past performance is merged into a theoretical portfolio that you can see graphed over the past.