How to Calculate if a Stock is Undervalued or Overvalued
Discover a simple technique to calculate if a stock is a good buy, based on easily-found financial data. This approach is similar to the techniques pioneered by Warren Buffet and Benjamin Graham.
Bulk Historical FX Rate Downloader
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.
WTI Oil Price History in Excel
Automatically download historical prices for West Texas Intermediate crude oil into Excel. Once in Excel, you can analyze, visualize and back-test the data.
Download Forex Data and Plot RSI in Excel
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.
Multiple Stock Quote Downloader for Excel
This Excel spreadsheet downloads multiple historical stock quotes from Yahoo Finance into Excel. Just enter a series of ticker symbols, two dates, and click a button.
Correlation Matrix – Guide and Spreadsheet for Investors
Learn why investors should know about correlation matrices, and download an Excel-VBA spreadsheet to calculate this important asset allocation tool
Foreign Exchange Rate Function in Excel
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.
What's New Here?Subscribe to RSS feed
How to Calculate if a Stock is Undervalued or Overvalued
Discover a simple technique to calculate if a stock is a good buy, based on easily-found financial data. This approach is similar to the techniques pioneered by Warren Buffet and…
A Review of “Option Volatility & Pricing: Advanced Trading Strategies and Techniques”
“The least successful traders have a certain naïve confidence in their math skills”.
Bulk Historical FX Rate Downloader
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…
WTI Oil Price History in Excel
Automatically download historical prices for West Texas Intermediate crude oil into Excel. Once in Excel, you can analyze, visualize and back-test the data.
Download Forex Data and Plot RSI in Excel
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.
Multiple Stock Quote Downloader for Excel
This Excel spreadsheet downloads multiple historical stock quotes from Yahoo Finance into Excel. Just enter a series of ticker symbols, two dates, and click a button.
Correlation Matrix – Guide and Spreadsheet for Investors
Learn why investors should know about correlation matrices, and download an Excel-VBA spreadsheet to calculate this important asset allocation tool
Roll-Geske-Whaley Method to Price American Options
Learn how to price American call options with the Roll-Geske-Whaley method, and get an Excel spreadsheet.
ING Direct Orange Key
ING Direct Canada will give you a $25 bonus (or $50 until the end of December 2012) when you open any account with an initial deposit of $100.
The Volatility Surface – A Practitioner’s Guide by Jim Gatheral
Much of my life as a so-called financial analyst has focused on understanding the abstract concept of the volatility surface.