|
|
||
|
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 Continue reading Stochastics Indicator – Excel VBA and Formula versions 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. In addition to the free files located under “Instructions and Downloads”, there is now a new file under “Products and Services” for live trading via Interactive Brokers. This Excel VBA based file is an all in one solution for testing, trading and charting. This is very similar to a version I have been using for my Continue reading Added new file for Live trading with Interactive Brokers I have high hopes for performance improvements each time MSFT releases an new version or service pack. This time the claim with Office 2007 service pack 2 that had me curious was: “Improves the charting mechanism in Excel 2007. This includes better parity with Office 2003, improved robustness, and targeted performance improvement” Benchmark.xls is a Continue reading Excel still slow with SP2, despite claims of improved charting. |
Excel Based Automated Channels. Updated every five minutes (9:05 EST to 4:15 EST). Click image for full size.
|
|
|
Copyright © 2010 ExcelTrader - All Rights Reserved |
||
Recent Comments