## Zephyr Pain Index

This risk metric captures the time it takes to regain investment losses, and the severity and frequency of those losses. Get a free spreadsheet with open VBA.

## How to Calculate Mortgage Payments in Excel

Like me, you might have used an online mortgage calculator to predict your payments. But how do those tools come up with your payment amount? Well, armed with Excel, you… Read more »

## Mortgage Payment Calculator

Calculate your mortgage payments with this this free Excel spreadsheet. You can pick your payment frequency, and generate a schedule giving you the date of every payment

## Trade with Williams %R and Excel

Learn about the trading indicator that helped turned $100k into$1.1m in twelve months, and get a free automated Excel spreadsheet.

## How to Calculate the Stochastic Oscillator

Discover how to calculate the stochastic oscillator in Excel, and get a web-connected spreadsheet that automatically plots this critical technical indicator.

Get historical dividends for many companies, and generate a payout stream cross-referenced against time. Free spreadsheet!

## Plot Stock Returns Histogram in Excel

Plot the historical returns histogram from prices automatically downloaded from Yahoo Finance, all in Excel.

## Option Pricing with Skew and Kurtosis

Learn about the Corrado & Su (1996) model for pricing options with excess skew and kurtosis, and get a pricing spreadsheet.

## How to Calculate EMA in Excel

Learn how to calculate the exponential moving average in Excel and VBA, and get a free web-connected spreadsheet.