Google Ad

How to retrieve live data for SPY futures in Twsdde.xls

The multiplier column in Twsdde.xls is not used by the code that constructs the links to retrieve data. Filling it in has no affect on the contract received. This creates an issue when attempting to retrieve data for Futures with more than one contract available with the same contract expiration month.

As an example, SPY futures

Continue reading How to retrieve live data for SPY futures in Twsdde.xls

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

Continue reading MACD VBA

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