Invest Excel

Real-Time Forex Rates in Excel

Get real-time live foreign exchange rates in Excel with this free spreadsheet. The quotes are delayed by about 15 or 20 minutes but are updated every minute or so.

The Ulcer Index – A Measure of Investor Stress

Want a tool to measure the stress of holding a stock? Then try the Ulcer Index, a technical indicator that describes the pain of continuously falling share prices.

Find Financial Fraud with Benford’s Law

Discover how a peculiar concept called Benford’s Law helps detect accounting and business fraud, and get an Excel spreadsheet to help with your financial sleuthing.

Pricing Bond Options with a Binomial Tree

This Excel spreadsheet calculates the price of a Bond option with a binomial tree. Bond options give the purchaser the …

Google Finance Stock Quotes in Excel

Download historical stock quotes from Google Finance straight into Excel with this free spreadsheet. Everything is automated with some clever VBA (which you can view and extend.)

Barrier Options

Learn about Barrier Options and download pricing spreadsheets

How to Calculate Compound Annual Growth Rate in Excel

This tutorial will teach you how to calculate the compound annual growth rate, or CAGR, in Excel. You’ll also learn about some of the limitations.

Monte Carlo Option Pricing with Excel

Learn how to price options with the Monte Carlo method, and get a pricing spreadsheet for European, Asian, Barrier and Lookback options.

Relative Strength Index: Become a Better Trader

The Relative Strength Index helps you decide if a stock is overbought or oversold. Learn about it, and get an Excel spreadsheet that calculates RSI of a stock based on its ticker symbol.

Pick Winning Stocks with the Piotroski F-Score

Investing in the stock market is risky, but you can tilt the odds in your favour with a strategy based on the F-Score.

Garman Kohlhagen Model and VBA

Get VBA and an Excel spreadsheet for the Garman Kohlhagen model, a method of pricing European foreign exchange options.

Black-Scholes and Greeks in VBA

Get VBA and an Excel spreadsheet for Black-Scholes and the Greeks (Delta, Gamma, Vega, Theta, Rho) here. You can easily use the VBA in your own option pricing spreadsheets.

Value Shares with Graham’s Formula

Discover Graham’s formula, a simple method for predicting the fair values of shares, and download a spreadsheet.

Download Finviz Data into Excel

This Excel spreadsheet downloads stock quotes for 6855 companies from Finviz.com using VBA. The stock quotes includes over 65 pieces of financial data, including PE ratios, market capitalization, EPS, moving averages, earnings dates, average true range, and much more.

Beneish M-Score

Determine if a company has manipulated earnings with the Beneish M-Score. It’s simply a mathematical formula which uses data from a company’s financial reports.