How to trade the emini S&P (ES) with Excel spreadsheet
Eminiways: trading with 35-minute data.
Please see our ARCHIVES
Our goal is to show how Microsoft Excel can stand by itself as a Primary Trading Tool.
We trade using 35-minute bar data from e-Signal. That data is put in an Excel spreadsheet, calculations are updated, and trades are entered and exited through Interactive Brokers when appropriate at the 35-minute intervals during the days and weeks of market activity.
On average, we trade about 5-10 times a month, and we do hold trades overnight. At times during the last 5 years, the volatility has gotten so unruly that we were forced to NOT hold trades overnight (as a risk management choice), but before that and up to the present time, except during times of extreme volatility, we hold trades overnight.
Here is a site which provides ideas related to emini S&P futures trading (ES), and suggestions for timing, entry, exit, reversals, optimization, and performance analysis. All these methods, strategies, ideas have been tested in real life, and are useful for the small-time trader.
“The most important predictor of happiness is earned success.”
eMini Trading System– First Steps– how to
Let’s take a moment to lay out a sequential description of how to build a trading system.
We will provide our own answers, and you can supplement or adjust or ignore, if you wish. (or contact us). Our discussion comes from 20 years of exploration in this area.
A. General: choose market (we focus on ONE market to trade only, the eMini S&P). What data provider (eSignal). What platform (Excel). What brokerage (Interactive Brokers).
B. The System: 1. Predictive (no), or 2. following (yes, short to medium term trend following). We do not predict. We follow the action of the price bars.
3. Type of price data, EOD (end of day price data)? NO. We use intraday bars.
Intraday price data ? (yes, intraday data, using 12 bars each full trading day of 6 3/4 hours (6:30 a.m. PST to 1:15 p.m. PST) (please adjust for other time zones). (35 Minute price bars).
The practical application of these instructions for daily data collection means that you must enter price data into your spreadsheet at 7:05 a.m. PST (end of first bar time period), again at 7:40 a.m. (end of second bar time period), and then the price data from the third bar at 8:15. And so on, until knocking off at 1:15 p.m. PST. Only 12 data collection times, during the trading day, and the last at or after the Close. This can all be accomplished easily with e-Signal Interval Tabular Price data, and an Excel spreadsheet.
4. Determine a direction-based entry signal. Some say that this doesn’t matter all that much, but we beg to differ. We have multiple entry strategies, each for its own system, and they are short-term, medium term, or long-term trend following, trading anywhere from 3 times a week to 2 times a month.
Our archives show many different ways that we use Microsoft Excel to assist us in our trading decisions.
Good luck in your trading!
Shade An Area Between 2 Lines
Trading With Microsoft Excel Spreadsheets HOW TO CREATE A SIMILAR CHART WITH MICROSOFT EXCEL, 1. Go online and follow the many directed instruction sites which will show you and tell you how to construct it. If you are curious, you can Google “How To Shade An Area Between 2 Lines in Excel” and if you…
Excel Weighted Moving Average and Center of Gravity Oscillator
May 14, 2024 Excel Weighted Moving Average and Ehlers Center of Gravity Oscillator Trading with Excel Spreadsheets—or Useful Excel Calculations for Trading Analysis We have been perusing some of the offerings that John Ehlers has given all of us, in his books, and his many article on Technical Analysis from his perspective as an Engineer.…
Follow My Blog
Get new content delivered directly to your inbox.
eminiways 
You must be logged in to post a comment.