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.

jswanson

A Statistical Method For Stop Placement

Recommended Posts

In the September 2012 issue of Futures magazine, author Neil Rosenthal began a multi-part series on system development. During the first series Neil uses MetaTrader 4 (MT4) to code a simple system and demonstrates how he uses Excel to analyze the results as the first step to building a trading system. After discovering a market edge – what I call a key concept – Neil demonstrates his process of finding an initial hard stop value for his system. I found his method similar to what I use. I thought it would be helpful if I recount his method here.

 

While many people focus on the specifics of a trade entry, trade exit is also vitally important. After you have discovered what you think is a solid “key concept” the next question you may wish to explore is: Where should the initial stop be placed? Within Neil’s article he calls this his ISL (initial stop loss).

 

The Trading System

 

Because we not focusing on a specific trading system I’m going use Neil’s idea of using a random entry method. That is, upon the open of the market a virtual coin will be flipped. If the coin comes up heads, we go long. If it comes up tails, we go short. This will take the focus off the trading system and place the emphasis on the true point of this post, how to determine where to place your ISL. Indeed this process is applicable to all system trading development.

 

I’m going to trade this on Euro currency futures market and will use the 830 open (Central) as the time to open a new trade and the 1500 close (Central) to close the trade. Trades will be executed and managed on a 5-minute bar chart. Below is the TradeStation code that will act as the foundation of our trading system. If you are familiar with the steps I use to develop a trading system, you will recognize this stage of development as the “Baseline” system. This Baseline system will act as our stake-in-the-ground or reference point to compare the modified version against.

 

 

 

vRandomNumber = Intportion( Random(100) );

If ( vRandomNumber >= 50 ) Then buy("LE") next bar at market

Else sellshort("SE") next bar at market;

 

 

The Results

 

 

The system was executed over a five-year period ending July 31, 2012. No slippage or commissions were deducted from the results. The test generated 1,269 trades. The number of short trades (625) accounted for 49% of the trades and the number of long trades (644) accounted for 51% of the trades. As expected the number of winning trades is near the 50% mark at 51%. You can see that this system actually produced a positive net profit of $27,200 with an average trade of $21.43. If we factor slippage and commissions the system would appear to be a break-even system.

 

RandomSystemResults.png

 

We can probably improve the average profit per trade by limiting what we lose on trades that move against us. This is the purpose of having an ISL. By using an Excel spreadsheet to analyze the maximum adverse excursion (MAE) for our winning and losing trades we can help narrow down a proper value for our ISL. MAE is the amount a trade moves against us. For example, if we open a trade that immediately climbs to a profit of $100, then falls to $75 into the red before we finally close the trade at our $250 profit target, our MAE would be $75.

 

So we now know we wish to examine the MAE of our system, but how do we do that?

 

Trade Recorder Function

 

Fortunately, I created an EasyLanguage function called TradeRecorder which does exactly what we need. By placing this function within our strategy code all our required trade information is sent to an Excel formatted file on our hard drive. From there it’s just a mater of cut-and-pasting our trade information into another Excel spreadsheet to analyze our results. Please read this article for a more complete description on what TradeRecorder can do.

 

Data Analysis

 

Now that we have all the trades in an Excel file I can take this data and cut-and-paste it into another spreadsheet called Trade Analysis, which is available at the bottom of this post. This spreadsheet is nothing fancy but will compute what we are looking for. Using the sort feature in Excel I can separate the winning and losing trades. Then I can use Excel’s built in functions to generate the mean and standard deviation of the MAE values.

 

Below are the values generated by Trade Analysis for our example run of our trading system.

 

RandomEntryMAEResults.png

 

In our example trading system we can see winning trades have a mean MAE of around 19 ticks. This suggests that a stop value smaller than this value will likely result in stopping-out of winning trades. In other words, the stop value would not be large enough. On the other hand, if we look at our losing trades we can see the mean MAE is 72 ticks. Such an extreme move against us is unlikely to produce a positive trade and we should be looking at cutting our losses. Notice how losing trades move strongly against our position while winning trades take much less “heat”. With this information we already have a ballpark idea on where to place our ISL. Furthermore, the same analysis can be done with the maximum favorable excursion (MFE) to help us locate a proper profit target to test. But more on that later.

 

While it may be tempting to place a stop just beyond our 19 tick mean, a more optimal number can be found by using optimization. We are not done yet on determining our ISL. However, it will have to wait for a future post.

 

Video

 

Below is a video that explains in detail on how to use the Trade Recorder function with the Trade Analysis spreadsheet. These two tools can be used to help you determine your ISL for systems you develop. Both these tools are available as a free download at the bottom of this post.

 

 

Downlaods

 

The trading system code and an excel spreadsheet used in this post is available here.

Share this post


Link to post
Share on other sites

TradeStation is great, but there are limits to what can be gleaned from the reports that a strategy test generates . . .

 

For other ideas for useful Excel trade analysis using the TradeRecorder function that JSwanson has kindly provided, have a look at 'Trading Systems that Work' by Thomas Stridsman.

 

BlueHorseshoe

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

    • "To make more capable, powerful AI models, developers need a steady flow of fresh data to train their models on. However, they’re starting to run out. Current generative AIs have scraped everything from the Internet that can be scraped. The alternative is to use “synthetic” data—training data generated by earlier forms of AI instead of original sources found on the Internet.  Using synthetic data is tempting. It’s cheaper than licensing datasets (an increasingly common requirement); there’s virtually no limit to the amount of data, text, or images AIs can create; and no one’s privacy is violated. The problem is that, over several generations, AIs trained synthetically develop what has been called “Model Autophagy Disorder,” or MAD, by the researchers at Rice University who discovered it. They like the acronym “MAD” because it’s similar to “Mad Cow Disease,” a calamitous, fatal brain disease that turned up in beef cattle in the 1980s when they were fed the ground-up remains of their butchered colleagues.  The word “autophagy” is a combination of the Greek “auto,” meaning self, and “phagy,” to eat. After training successive visual AI models on synthesized data, the scientists found a disturbing pattern: images of faces began to show grid-patterned scratch marks and eventually began more and more to look like the same face. Images of numbers gradually distorted until they became a mass of unintelligible squiggles.  “Even after a few generations of such training, the new models can become irreparably corrupted,” computer engineer Richard Baraniuk said in a university press statement.  As synthetic data, and synthetically trained AIs, proliferate online, the problem will feed on itself and become steadily worse, he warned. “One doomsday scenario is that if left uncontrolled for many generations, MAD could poison the data quality and diversity of the entire Internet,” Baraniuk said. “Short of this, it seems inevitable that as-to-now-unseen unintended consequences will arise from AI autophagy even in the near term. “Without enough fresh real data,” he added, “future generative models are doomed to MADness.” TRENDPOST: If AI developers come to believe that it is no longer possible to advance generative AI much beyond its current state, two things will happen. First, engineers will switch from developing new models to tweaking existing ones and continue customizing them to make off-the-shelf versions for specific industries. Second, developers will turn their obsession with AI power from generative systems to general AI, which can reason and make decisions without the need for human guidance.  That day might be closer than any of us, including AI engineers, are ready to deal with." Zgbs73                        
    • TS Tenaris stock, watch for a top of range breakout above 39.17 at https://stockconsultant.com/?TS
    • UAL United Airlines stock nice breakout setup at https://stockconsultant.com/?UAL
    • AAL American Airlines stock, good trend, watch for a range breakout at https://stockconsultant.com/?AAL
    • Date: 10th January 2025. Why is the British Pound Declining?   The Great British Pound is the worst performing currency of 2025 so far after witnessing sharp declines for 3 consecutive days. The decline is largely being triggered by the bond selloff, lack of business confidence due to the UK Autumn budget and political uncertainty. Will the trend continue?     The GBP Index Declines 2% In 2025! Why Is The Pound Dropping? The Great British Pound is the worst performing currency of the week and of the year so far. Below you can see a table showing the Pound’s performance in January 2025 so far. GBPUSD -2.25% EURGBP +1.69% GBPJPY -1.44% GBPCHF -1.42% GBPAUD -1.91% GBPCAD -2.00% A key reason for the GBP’s decline is the latest labor budget, which is driving a selloff in UK bonds. Bonds across the global market are declining, including in the US and Germany. However, the global decline is mainly due to monetary policy. The decline in UK bond yields is due to concerns regarding the UK budget, higher costs for business and investor confidence. As a result, investors are selling UK bonds, but also reducing their exposure to the Pound. Bond Selloff and Rising Yields: Higher bond yields can sometimes strengthen a currency by attracting increased investor demand. However, this effect is unlikely when rising yields result from a bond selloff driven by declining investor confidence. The UK 30-Year Bond Yields are at their highest level since 1998 and the 10-Year Bond Yields are up to the highest level since the banking crisis of 2008. Investors’ concerns are that the higher costs for business will be passed onto consumers, triggering higher stickier inflation. As a result, the Bank of England will struggle to reduce the cost of borrowing in 2025 and foreign investors will become more cautious of operations in the UK. The short-term impact is that the UK Chancellor may struggle to meet her fiscal rules. Her budget margin of £9.9bn to avoid overshooting borrowing has likely shrunk to about £1 billion due to market shifts, even before the OBR updates its forecasts. This uncertainty may force the Treasury to cut future spending plans, but the full picture won’t emerge until the OBR's March forecast. According to reports, the UK Chancellor cannot risk higher increases in taxes and will be forced to cut public spending. The GBPUSD Falls To A 60-Week Low! The GBP is struggling against all currencies, but the sharpest decline can be seen against the USD. The GBP’s decline is partially due to the incoming president, Donald Trump, who is expected to introduce Dollar-supporting measures, but also potentially impose tariffs on the UK.   The new White House administration is likely to impose new tariffs on imports from China, Canada, and Mexico. This is likely to potentially disrupt supply chains and prompt the Federal Reserve to adopt tighter monetary policy, thereby strengthening the national currency. Some experts believe the UK will face tariffs or be pressured to adopt more pro-American economic policies. This is also something the EU will likely experience. In addition to this, reports suggest that the UK Prime Minister, Keir Starmer, and Trump supporters are not on good terms, nor agree on much including on Geo-politics. Therefore, the decline is also related to concerns the UK may be put into a difficult position by the new US administration. According to analysts, Dollar strength is likely to continue throughout the year due to the new administration’s measures, but also due to a hawkish Federal Reserve. In the latest FOMC meeting minutes, the committee stated it expects interest rates to decline at a slower pace. The Federal Reserve is likely to only cut 0.50% in 2025 and may not cut until May or June. Liz Truss 2022 Or James Callaghan 1976? Is this the first Pound crisis? The GBP has experienced many "sterling crises” in the past. For example, Black Wednesday from 1992 and after Brexit in 2016. However, there have been similar crises in the past which are very similar to the current situation. For example, the Liz Truss Budget from 2022 which saw the GBP decline more than 23%. During the Sterling Crisis of 1976 the GBPUSD fell from 2.0231 to 1.5669. Both sterling crises were due to the budget, inflation and rising bond yields. Today’s issues for the GBP and UK are very similar, however, the performance of the GBP will depend on if the new SI contributions triggers lower economic activity, inflation and if the Federal Reserve indeed avoids cutting interest rates in the near future. If inflation rises it will dampen consumer demand and the Bank of England will be forced to pause any rate adjustments. As a result, the economy may contract or stall further pressuring the GBP. However, this cannot yet be certain. KPMG experts anticipate accelerated economic growth this year, supported by monetary policy and increased government spending. They project GDP to rise to 1.7%, more than doubling last year’s 0.8%. This growth, according to their estimates, will be driven by a recovery in consumer spending, expected to increase by 1.8% compared to 1.0% last year. In addition to this, if the Federal Reserve unexpectedly opts for more frequent rate cuts, the GBP and EUR are likely to benefit. When monitoring the price movement and patterns which can be seen in the exchange rate, the decline looks similar to the price movement seen in 2022, during the Truss reign. The price has now fallen below the support level from April 2024. The next support levels can be seen at 1.20391 and 1.17992. Technical analysis for the GBP can also be viewed in HFM’s latest Live Trading Session.   Key Takeaways: The Great British Pound is the worst performing currency of the year so far, having declined by more than 2.00%. A key reason for the GBP’s decline is the latest labor budget, which is driving a selloff in UK bonds. UK 30-year bond yields are at their highest since 1998, while 10-year yields have reached levels last seen during the 2008 banking crisis. Investors reduce exposure to the GBP as the US edges closer to a new president and pro-Dollar supportive measures. The UK labour government will not reconsider higher taxes but may be forced to reduce public spending. 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.
×
×
  • Create New...

Important Information

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