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

    • Why not to simply connect you account to myfxbook which will collect all this data automatically for you? The process you described looks tedious and a bit obsolete but may work for you though.
    • The big breakthrough with AI right now is “natural language computing.”   Meaning, you can speak in natural language to a computer and it can go through huge data sets, make sense out of them, and speak back to you in natural language.   That alone is a huge breakthrough.   The next leg? AI agents. Where they don’t just speak back to you.   They take action. Here’s the definition I like best: an AI agent is an autonomous system that uses tools, memory, and context to accomplish goals that require multiple steps.   Everything from simple tasks (analyzing web traffic) to more complex goals (building executive briefings or optimizing websites).   They can:   > Reason across multiple steps.   >Use tools like a real assistant (Excel spreadsheets, budgeting apps, search engines, etc.)   > Remember things.   And AI agents are not islands. They talk to other agents.   They can collaborate. Specialized agents that excel at narrow tasks can communicate and amplify one another’s strengths—whether it’s reasoning, data processing, or real-time monitoring.   What it Looks Like You wake up one morning, drink your coffee, and tell your AI agent, “I need to save $500 a month.”   It gets to work.   First, it finds all your recurring subscriptions. Turns out you’re paying $8.99 for a streaming service you forgot you had.   It cancels it. Then it calls your internet provider, negotiates a lower bill, and saves you another $40. Finally, it finds you car insurance that’s $200 cheaper per year.   What used to take you hours—digging through statements, talking to customer service reps on hold for an hour, comparing plans—is done while you’re scrolling Twitter.   Another example: one agent tracks your home maintenance needs and gets information from a local weather-monitoring agent. Result: "Rain forecast next week - should we schedule gutter cleaning now?"   Another: an AI agent will plan your vacations (“Book me a week in Italy for under $2,000”), find the cheapest flights, and sort out hotels with a view.   It’ll remind you to pay bills, schedule doctor’s appointments, and track expenses so you’re not wondering where your paycheck went every month.   The old world gave you tools—Excel spreadsheets, search engines, budgeting apps. The new world gives you agents who do the work for you.   Don’t Get Too Scared (or Excited) Yet William Gibson famously said: "The future is already here – it's just not evenly distributed."   AI agents will distribute it. For decades, the tools that billionaires and corporations used to get ahead—personal assistants, financial advisors, lawyers—were out of reach for regular people.   AI agents could change that.   BUT, remember…   We’re in inning one.   AI agents have a ways to go.   They’re imperfect. They mess up. They need more defenses to get ready for prime time.   To be sure, AI is powerful, but it’s not a miracle worker. It’s great at helping humans solve problems, but it’s not going to replace all jobs overnight.   Instead of fearing AI, think of it as a tool to A.] save you time on boring stuff and B.] amplify what you’re already good at. Right now is the BEST time to start experimenting. It’s also the best time to find investments that will “make AI work for you”. Author: Chris Campbell (AltucherConfidential)   Profits from free accurate cryptos signals: https://www.predictmag.com/     
    • What a wild year.   AI seems to be appearing everywhere you look, Paris hosted a weird Olympics, unrest continues in the Middle East, the US endured a crazy-heated election, and the largest rocket ever to fly successfully landed in a giant pair of robot arms.   Okay, but what about the $money stuff?   Well, this year we've seen a load of uncertainty - inflation is still biting and many businesses have gone down.   Property has been very fractured, with developments becoming prohibitively expensive, while other markets have boomed.   It hasn't been an easy ride, that's for sure.   However, the stock market has had some outstanding results, and for those who know how to trade, some have done VERY well for themselves.   Some have replaced their incomes. Some have set themselves up for the rest of their days on this planet.   How about you? How did you go? Author: Louise Bedford    Profits from free accurate cryptos signals: https://www.predictmag.com/  
    • U Unity Software stock watch, attempting to move higher off the 22.4 triple+ support area at https://stockconsultant.com/?U  
    • TSSI TSS stock, watch for an ascending triangle breakout above 11.49, target 15 area at https://stockconsultant.com/?TSSI
×
×
  • Create New...

Important Information

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