This Mathcad worksheet automatically downloads historical forex (or foreign exchange rate) rates. It does this with a VBScript component that imports data from a web service.
Portfolio Analysis
Download Stock Quotes into Mathcad
This Mathcad worksheet automatically downloads historical stock quotes from Yahoo Finance with a VBScript button. You don’t need to manually import the data with text files.
Value at Risk with Monte Carlo Simulation
This Excel spreadsheet calculates Value at Risk through the Monte Carlo simulation of geometrical brownian motion in VBA.
Importing Historical Stock Prices from Yahoo into Excel
This Excel spreadsheet imports historical stock prices from Yahoo Finance (http://finance.yahoo.com).