Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

pmsinc

Backtesting Morning Range Breakout Using Excel VBA

Recommended Posts

I am looking for someone to help me code in Excel VBA a morning range breakout study. I have 7 years of 5 minute SPX data I bought to emulate the ES. I started some code but it is getting beyond my programming ability.

 

My thoughts were to measure the range of 10,30,60, etc minutes after 9:30 EST. Then to get the maximum proft and loss based on a breakout of that range.

Then see what the chances of getting X points per day would be over 7 years and look at the expectancy.

 

Is anyone interested in this that can code VBA?

Share this post


Link to post
Share on other sites

it would be easier to download the free Ninjatrader and let the wizard to do it for you.

 

or, if you are serious about trading and backtesting,

get MultiCharts.

Edited by Tams

Share this post


Link to post
Share on other sites

Years since I used excel with that caveat does it actually need programming? Can't you do it using cell formulas and queries? Tams suggestion is probably your best bet but it means learning how to use another bit of software.

Share this post


Link to post
Share on other sites
  Tams said:
it would be easier to download the free Ninjatrader and let the wizard to do it for you.

 

or, if you are serious about trading and backtesting,

get MultiCharts.

 

Does anyone have EL code for opening range breakout that works in MultiCharts? I couldn't find anything with Google but it feels like reinventing the wheel writing it from scratch.

Share this post


Link to post
Share on other sites
  Harlequin said:
Does anyone have EL code for opening range breakout that works in MultiCharts? I couldn't find anything with Google but it feels like reinventing the wheel writing it from scratch.

 

 

 

Coding it in EasyLanguage is not that difficult.

 

If you can articulate your thought/logic in English, you can code it in EasyLanguage.

 

I use the following process:

1. Write out one thought at a time,

2. Write out one action at a time,

3. Write out one action per sentence,

4. Write out one sentence per line.

 

in no time you will have your strategy coded in EasyLanguage.

Share this post


Link to post
Share on other sites

Hi,

I'm a new member and I'm pretty proficient with excel/vba. I worked as a front-end developer for a proprietary options trading firm and they used excel as the client so I've done a fair amount of coding using vba...it's been about a year since I've fooled around w/ excel. I've been using C# but I wouldn't mind brushing on my vba skills... if you still need help give me a reply and I'll see what I can do.

Share this post


Link to post
Share on other sites

Here's the first pass results, equity chart from 9/06 to 6/24/09 (attached).

 

The steady profit trend on the graph was from 1/08 to 10/08 (peak equity was right before the Oct crash).

 

Some explanations and limitations:

1)This is run using 1 contract ES futures contract, $2.50/commission each way (what I pay)

2)Rules for the test:

*High and Low of the open bar (15 min on this test) set the breakout markers

*1 trade only per day

*Exit on the close

*Entry was by the first close above the open bar high, or below the open bar low

*No entries taken after 11AM

*No Stops or Profit targets used.

 

Numbers for the system, trading 1 contract:

Net profit - $20,585

Profit factor - 1.12

Percent profitable - 49%

Avg trade profit - $30

Max consecutive losing trades - 7

Max drawdown - $15k

Adjusted profit factor - 1.01

 

Because of the low net profit per trade, and low adjusted profit factor, the system would still need a lot more work.

 

Tradestation would not give me the 7 years of data I asked for yet (pending download) but hopefully this gives you a first crack at how it might fare.

es_15min_breakout.gif.765111ce52510dccd2ee1a619a05c5d6.gif

Edited by CarbonElemental

Share this post


Link to post
Share on other sites

Here's the system using a $1k stop on each trade.

 

$1k stop is the optimal over this span of data without adding in more filtering.

 

Net is that total profits are now $28,900 and profit factor of 1.09 raw (1.16 long and 1.03 shorts). 1.02 adjusted overall.

 

Max consec losing trades is 8.

 

Based on a visual scan of the trades, it would need to treat short and long trades differently, with the long trades needing more room stop wise and the short trades could have a tighter stop.

es_15min_breakout_1k_stop.gif.fcbbd8b810e9eb9619bf58c0e72ee129.gif

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • In Italy, I saw many of our brothers from different parts of Africa, sleeping and living in the park, the weather was very cold and its obvious that they were looked down upon. It made me want to cry and several questions overwhelmed my heart.   Is it not better to remain in Africa than to be homeless in this freezing cold weather?   I wish I have all the money in the world to rescue them...   Is this the reason why our skin color is looked down upon?   Do our government officials see this sight when they also travel outside of the country...does it hurt them or pain them like it pained me? By Frank Abah, Quora   Profits from free accurate cryptos signals: https://www.predictmag.com/   
    • ELV Elevance Health stock, watch for an upside gap breakout at https://stockconsultant.com/?ELV
    • ORLY OReilly Automotive stock, nice top of range breakout, from Stocks to Watch at https://stockconsultant.com/?ORLY
    • Date: 28th March 2025.   Market Selloff Deepens as Tariff Concerns Weigh on Investors     Global stock markets extended their losing streak for a third day as concerns over looming US tariffs and an escalating trade war dampened investor sentiment. The flight to safety saw gold prices surge to a record high, underscoring growing risk aversion. Stock Selloff Intensifies The MSCI World Index recorded its longest losing streak in a month, while Asian equities saw their sharpest decline since late February. US and European stock futures also signalled potential weakness, while cryptocurrency markets retreated and bond yields edged lower. Investors are scaling back their exposure ahead of President Donald Trump’s expected announcement of ‘reciprocal tariffs’ on April 2. His latest move to impose a 25% levy on all foreign-made automobiles has sparked fresh concerns over inflation and economic growth, prompting traders to reassess their strategies. Investor Strategies Shift Market experts are adjusting their portfolios in anticipation of heightened volatility. ‘It’s impossible to predict Trump’s next move,’ said Xin-Yao Ng of Aberdeen Investments. ‘Our focus is on companies that are less vulnerable to tariff policies while taking advantage of market dips to find value opportunities.’ Yield Curve Signals Economic Concerns In the bond market, the spread between 30-year and 5-year US Treasury yields widened to its highest level since early 2022. Investors are bracing for potential Federal Reserve rate cuts if economic growth slows further. Long-term Treasury yields hit a one-month peak as inflation risks tied to tariffs spurred demand for higher-yielding assets. Boston Fed President Susan Collins noted that while tariffs may contribute to short-term price increases, their long-term effects remain uncertain. Gold Hits Record High as Safe-Haven Demand Rises Amid market turbulence, gold prices soared 0.7% on Friday, reaching an all-time high of $3,077.60 per ounce. Major banks have raised their price targets for the precious metal, with Goldman Sachs now forecasting gold to hit $3,300 per ounce by year-end. Looking Ahead As investors digest economic data showing US growth acceleration in Q4, attention will turn to Friday’s release of the personal consumption expenditures (PCE) price index—the Federal Reserve’s preferred inflation measure. This data will be critical in shaping expectations for future Fed policy moves. With markets on edge and trade tensions escalating, investors will closely monitor upcoming developments, particularly Trump’s tariff announcement next week, which could further dictate market direction.   Always trade with strict risk management. Your capital is the single most important aspect of your trading business.   Please note that times displayed based on local time zone and are from time of writing this report.   Click HERE to access the full HFM Economic calendar.   Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE!   Click HERE to READ more Market news.   Andria Pichidi HFMarkets   Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in Leveraged Products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • Crypto hype is everywhere since it also making new riches as well, i however trade crypto little as compared to other forex trading pairs.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.