This free Excel spreadsheet downloads multiple FX rate histories from a web service. You can then plot and analyze the exchange rate data, and backtest your trading strategies with Excel’s broad suite of tools and functions.
Automatically download historical prices for West Texas Intermediate crude oil into Excel. Once in Excel, you can analyze, visualize and back-test the data.
This Excel spreadsheet downloads historical Forex data and plots the Relative Strength Index (RSI) and volatility of the currency-pair. You can also inspect and verify the calculations used to generate the results.
This Excel spreadsheet downloads multiple historical stock quotes into Excel. Just enter a series of ticker symbols, two dates, and click a button.
Learn why investors should know about correlation matrices, and download an Excel-VBA spreadsheet to calculate this important asset allocation tool
This Excel spreadsheet has a VBA function (UDF) that scrapes live foreign exchange rates from Yahoo Finance. Read on for the free Excel spreadsheet and VBA.
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.
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.
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.)
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.