Google Ad

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.

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

Continue reading Data Converter to Convert OHLC Data to a larger timeframe.

Constant Volume Charts added

I have added the option of constant volumeĀ  bar charts (as alternative to time based) for the Excel/VBA based automated trading platform

The constant volume bar option, updates a new bar after a certain amount of volume has completed. This amount should be entered into D3 of the “Live” sheet. Checks are in place to prompt

Continue reading Constant Volume Charts added

How to add an indicator to Simulator.xls Chart (or any Excel Stock Chart).

If you have ever tried to add a simple moving average (or any data series) to a stock chart you may have noticed that after adding the series, the chart got all messed up!

Here is a short tutorial and an example file showing how to add a simple moving average to a stock chart. I

Continue reading How to add an indicator to Simulator.xls Chart (or any Excel Stock Chart).