Stock Dividend Data Downloader.

The following (free) file downloads dividend data.

Ex Dividend Date
Dividend pay date.
Dividend Yield.

The instructions are:

Enter your symbols in Column A
Press the “Get Dividend Data” button.

Below is an image of the file.

Stochastics Indicator – Excel VBA and Formula versions

This post includes  two example excel files that show both VBA and Formula based calculations for the indicator “Stochastics”.

Both files contain the exact same set of Open High Low Close data. The formula based version should be easier to understand and serves as a way to verify that the VBA code that I wrote is [...]

MACD VBA

This post includes links to two example xls files that show both VBA and Formula based calculations for the indicator MACD or Moving Average Convergence [...]

Data Converter to Convert OHLC Data to a larger timeframe.

If you have ever wanted to take your existing Open High Low Close historical trading data and convert it into larger time frame, the following Excel VBA based data converter I wrote may do the trick.

DataConverter.xls allows you to configure the Number of OHLC bars that should be condensed down into a single bar. You [...]