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
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
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

    • ...hallucinates.... Student: “What if we gave the monkey LSD?” Guru: “The monkey already did LSD”
    • Question: To those that had/have cancer, what were the signs that made you think “something is not right here” to make you go see a doctor? Answer: So, 5/25/2018, I woke up, got ready for work, and as I walked to my car, I started gagging. Like something was stuck in my throat and I needed to clear it. And then it went away.   But 10 minutes after that, I was T-boned at 40mph on the driver side door. But what made me see a doctor was while my muscles felt better and bruises were going away, the gagging still continued, I started having fevers, my neck felt swollen, I was having such a hard time breathing, and I'd have random sharp pains in my chest, but not from where the seat belt saved me.   2 weeks after the accident, I finally see an urgent care doctor, who looks me over, tells me I'm fine, but luckily requests a neck X-ray. And I ask for a chest X-ray, which he rolls his eyes but let me have (most of my pain was in the neck, so I understand).   The very next day, he calls and says “So, that chest X-ray shows there's a 4 inch mass on your heart and lungs, and your lungs have been filling up with fluid, as well as in your pericardial (heart) wall. We need you to come in tomorrow.”   Turns out the big mass, due to the accident, caused my heart and lungs to tear and fill with fluid, the swollen neck and gagging was caused by 2 metastasized tumors, and the fevers and weight loss were symptoms. Stage 4b Hodgkin's Lymphoma.   But thankfully, we went very aggressive with chemo (and had a lot of bad side effects that don't normally happen to patients), and now I'm about 16 months cancer-free. Yay lucky X-rays! Rachel Jurina, Quora Source: https://www.quora.com/To-those-that-had-have-cancer-what-were-the-signs-that-made-you-think-something-is-not-right-here-to-make-you-go-see-a-doctor   Profits from free accurate cryptos signals: https://www.predictmag.com/  
    • As a man, the reality of life is the harshest part. I don’t mind looking older or becoming weaker over time; it’s nature.   Have you ever heard that the only people who will be loved unconditionally are women and children? Men will only be loved as long as they can provide until they are no longer needed. It doesn’t matter if you already did your best to get your kids to the best school or get the best things for them, if you stop before they’re done with it, there will be no thank you. The only thing they will remember is that they have to quit school at 15, ignoring all the previous 15 years of life you provided for them. The only people who will accept you, no matter what, are your parents. But in this situation, you might be that ungrateful child.   EDIT: Wow, I didn’t think this would get so much attention.   For those who disagree, I can only say that everyone has their problem. If you don’t get the chance to face such a thing, be grateful. Remember, sometimes what you throw in the garbage is something that someone wishes ever to have.” – ElZee, Quora   Profits from free accurate cryptos signals: https://www.predictmag.com/    
    • The good thing i had noticed so far is that the traderpot value is also on the rise..
    • yup its a gradual rollout the right way in my opinion, its really good and its exciting for the sto in 2027
×
×
  • Create New...

Important Information

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