Backtesting a SuperTrend Trading Strategy Using Excel ...
How to Backtest a Trading Model in Excel Excel Trading ...
Strategy Backtesting in Excel - SpreadsheetML
Forex Manual Backtest – Backtesting Report and Using Excel
BacktestingXL Pro Excel Trading and Investing Models ...
Use Excel to Backtest a Trading Strategy using an ATR Stop ...
How do you guys backtest a strategy?
I'm new to the forex trading and one of the advices that I often come across is to always backtest a strategy first. First thing that came to mind is to just go through the chart and start moving forward, simulating a trade and logging if the strategy wins or loses. I actually did this in a 15M chart for a range of 3 months, and while the results were enlightening (my strategy sucked only 36% win rate for that pair and strategy), I found the process very tedious. So my question is are there automated ways to back test a strategy? Like maybe excel or an application? I was looking into mt5 and expert advisors the other day, and I tried the strategy tester using a free expert advisor. Should I create a script that mimics my strategy and test it using mt5? I have a bit of programming but I don't know where to start.
Looking for feedback/marketing advice/people willing to test out a windows app i'm making for backtesting
Hi all, a trader friend convinced me to try building an app to automatically download historical forex data for backtesting purposes. It lets you specify what symbols you're interested in, and tries to get 9 years of data, automatically updating it into excel files (one per day plus a few files with a year, 2 years, 5, etc). Would love someone to check it out and let me know if it works and any suggestions for marketing it! I'm not a software company, just a developer. FWIW I asked the mods for permission first!
Disclaimer: None of this is financial advice. I have no idea what I'm doing. Please do your own research or you will certainly lose money. I'm not a statistician, data scientist, well-seasoned trader, or anything else that would qualify me to make statements such as the below with any weight behind them. Take them for the incoherent ramblings that they are. TL;DR at the bottom for those not interested in the details. This is a bit of a novel, sorry about that. It was mostly for getting my own thoughts organized, but if even one person reads the whole thing I will feel incredibly accomplished.
For those of you not familiar, please see the various threads on this trading system here. I can't take credit for this system, all glory goes to ParallaxFX! I wanted to see how effective this system was at H1 for a couple of reasons: 1) My current broker is TD Ameritrade - their Forex minimum is a mini lot, and I don't feel comfortable enough yet with the risk to trade mini lots on the higher timeframes(i.e. wider pip swings) that ParallaxFX's system uses, so I wanted to see if I could scale it down. 2) I'm fairly impatient, so I don't like to wait days and days with my capital tied up just to see if a trade is going to win or lose. This does mean it requires more active attention since you are checking for setups once an hour instead of once a day or every 4-6 hours, but the upside is that you trade more often this way so you end up winning or losing faster and moving onto the next trade. Spread does eat more of the trade this way, but I'll cover this in my data below - it ends up not being a problem. I looked at data from 6/11 to 7/3 on all pairs with a reasonable spread(pairs listed at bottom above the TL;DR). So this represents about 3-4 weeks' worth of trading. I used mark(mid) price charts. Spreadsheet link is below for anyone that's interested.
I'm pretty much using ParallaxFX's system textbook, but since there are a few options in his writeups, I'll include all the discretionary points here:
I'm using the stop entry version - so I wait for the price to trade beyond the confirmation candle(in the direction of my trade) before entering. I don't have any data to support this decision, but I've always preferred this method over retracement-limit entries. Maybe I just like the feeling of a higher winrate even though there can be greater R:R using a limit entry. Variety is the spice of life.
I put my stop loss right at the opposite edge of the confirmation candle. NOT at the edge of the 2-candle pattern that makes up the system. I'll get into this more below - not enough trades are saved to justify the wider stops. (Wider stop means less $ per pip won, assuming you still only risk 1%).
All my profit/loss statistics are based on a 1% risk per trade. Because 1 is real easy to multiply.
There are definitely some questionable trades in here, but I tried to make it as mechanical as possible for evaluation purposes. They do fit the definitions of the system, which is why I included them. You could probably improve the winrate by being more discretionary about your trades by looking at support/resistance or other techniques.
I didn't use MBB much for either entering trades, or as support/resistance indicators. Again, trying to be pretty mechanical here just for data collection purposes. Plus, we all make bad trading decisions now and then, so let's call it even.
As stated in the title, this is for H1 only. These results may very well not play out for other time frames - who knows, it may not even work on H1 starting this Monday. Forex is an unpredictable place.
I collected data to show efficacy of taking profit at three different levels: -61.8%, -100% and -161.8% fib levels described in the system using the passive trade management method(set it and forget it). I'll have more below about moving up stops and taking off portions of a position.
And now for the fun. Results!
Total Trades: 241
TP at -61.8%: 177 out of 241: 73.44%
TP at -100%: 156 out of 241: 64.73%
TP at -161.8%: 121 out of 241: 50.20%
Adjusted Proft % (takes spread into account):
TP at -61.8%: 5.22%
TP at -100%: 23.55%
TP at -161.8%: 29.14%
As you can see, a higher target ended up with higher profit despite a much lower winrate. This is partially just how things work out with profit targets in general, but there's an additional point to consider in our case: the spread. Since we are trading on a lower timeframe, there is less overall price movement and thus the spread takes up a much larger percentage of the trade than it would if you were trading H4, Daily or Weekly charts. You can see exactly how much it accounts for each trade in my spreadsheet if you're interested. TDA does not have the best spreads, so you could probably improve these results with another broker. EDIT: I grabbed typical spreads from other brokers, and turns out while TDA is pretty competitive on majors, their minors/crosses are awful! IG beats them by 20-40% and Oanda beats them 30-60%! Using IG spreads for calculations increased profits considerably (another 5% on top) and Oanda spreads increased profits massively (another 15%!). Definitely going to be considering another broker than TDA for this strategy. Plus that'll allow me to trade micro-lots, so I can be more granular(and thus accurate) with my position sizing and compounding.
A Note on Spread
As you can see in the data, there were scenarios where the spread was 80% of the overall size of the trade(the size of the confirmation candle that you draw your fibonacci retracements over), which would obviously cut heavily into your profits. Removing any trades where the spread is more than 50% of the trade width improved profits slightly without removing many trades, but this is almost certainly just coincidence on a small sample size. Going below 40% and even down to 30% starts to cut out a lot of trades for the less-common pairs, but doesn't actually change overall profits at all(~1% either way). However, digging all the way down to 25% starts to really make some movement. Profit at the -161.8% TP level jumps up to 37.94% if you filter out anything with a spread that is more than 25% of the trade width! And this even keeps the sample size fairly large at 187 total trades. You can get your profits all the way up to 48.43% at the -161.8% TP level if you filter all the way down to only trades where spread is less than 15% of the trade width, however your sample size gets much smaller at that point(108 trades) so I'm not sure I would trust that as being accurate in the long term. Overall based on this data, I'm going to only take trades where the spread is less than 25% of the trade width. This may bias my trades more towards the majors, which would mean a lot more correlated trades as well(more on correlation below), but I think it is a reasonable precaution regardless.
Time of Day
Time of day had an interesting effect on trades. In a totally predictable fashion, a vast majority of setups occurred during the London and New York sessions: 5am-12pm Eastern. However, there was one outlier where there were many setups on the 11PM bar - and the winrate was about the same as the big hours in the London session. No idea why this hour in particular - anyone have any insight? That's smack in the middle of the Tokyo/Sydney overlap, not at the open or close of either. On many of the hour slices I have a feeling I'm just dealing with small number statistics here since I didn't have a lot of data when breaking it down by individual hours. But here it is anyway - for all TP levels, these three things showed up(all in Eastern time):
7pm-4am: Fewer setups, but winrate high.
5am-6am: Lots of setups, but but winrate low.
12pm-3pm Medium number of setups, but winrate low.
I don't have any reason to think these timeframes would maintain this behavior over the long term. They're almost certainly meaningless. EDIT: When you de-dup highly correlated trades, the number of trades in these timeframes really drops, so from this data there is no reason to think these timeframes would be any different than any others in terms of winrate. That being said, these time frames work out for me pretty well because I typically sleep 12am-7am Eastern time. So I automatically avoid the 5am-6am timeframe, and I'm awake for the majority of this system's setups.
Moving stops up to breakeven
This section goes against everything I know and have ever heard about trade management. Please someone find something wrong with my data. I'd love for someone to check my formulas, but I realize that's a pretty insane time commitment to ask of a bunch of strangers. Anyways. What I found was that for these trades moving stops up...basically at all...actually reduced the overall profitability. One of the data points I collected while charting was where the price retraced back to after hitting a certain milestone. i.e. once the price hit the -61.8% profit level, how far back did it retrace before hitting the -100% profit level(if at all)? And same goes for the -100% profit level - how far back did it retrace before hitting the -161.8% profit level(if at all)? Well, some complex excel formulas later and here's what the results appear to be. Emphasis on appears because I honestly don't believe it. I must have done something wrong here, but I've gone over it a hundred times and I can't find anything out of place.
Moving SL up to 0% when the price hits -61.8%, TP at -100%
Adjusted Proft % (takes spread into account): 5.36%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%
Adjusted Proft % (takes spread into account): -1.01% (yes, a net loss)
Now, you might think exactly what I did when looking at these numbers: oof, the spread killed us there right? Because even when you move your SL to 0%, you still end up paying the spread, so it's not truly "breakeven". And because we are trading on a lower timeframe, the spread can be pretty hefty right? Well even when I manually modified the data so that the spread wasn't subtracted(i.e. "Breakeven" was truly +/- 0), things don't look a whole lot better, and still way worse than the passive trade management method of leaving your stops in place and letting it run. And that isn't even a realistic scenario because to adjust out the spread you'd have to move your stoploss inside the candle edge by at least the spread amount, meaning it would almost certainly be triggered more often than in the data I collected(which was purely based on the fib levels and mark price). Regardless, here are the numbers for that scenario:
Moving SL up to 0% when the price hits -61.8%, TP at -100%
Winrate(breakeven doesn't count as a win): 46.4%
Adjusted Proft % (takes spread into account): 17.97%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%
Winrate(breakeven doesn't count as a win): 65.97%
Adjusted Proft % (takes spread into account): 11.60%
From a literal standpoint, what I see behind this behavior is that 44 of the 69 breakeven trades(65%!) ended up being profitable to -100% after retracing deeply(but not to the original SL level), which greatly helped offset the purely losing trades better than the partial profit taken at -61.8%. And 36 went all the way back to -161.8% after a deep retracement without hitting the original SL. Anyone have any insight into this? Is this a problem with just not enough data? It seems like enough trades that a pattern should emerge, but again I'm no expert. I also briefly looked at moving stops to other lower levels (78.6%, 61.8%, 50%, 38.2%, 23.6%), but that didn't improve things any. No hard data to share as I only took a quick look - and I still might have done something wrong overall. The data is there to infer other strategies if anyone would like to dig in deep(more explanation on the spreadsheet below). I didn't do other combinations because the formulas got pretty complicated and I had already answered all the questions I was looking to answer.
2-Candle vs Confirmation Candle Stops
Another interesting point is that the original system has the SL level(for stop entries) just at the outer edge of the 2-candle pattern that makes up the system. Out of pure laziness, I set up my stops just based on the confirmation candle. And as it turns out, that is much a much better way to go about it. Of the 60 purely losing trades, only 9 of them(15%) would go on to be winners with stops on the 2-candle formation. Certainly not enough to justify the extra loss and/or reduced profits you are exposing yourself to in every single other trade by setting a wider SL. Oddly, in every single scenario where the wider stop did save the trade, it ended up going all the way to the -161.8% profit level. Still, not nearly worth it.
As I've said many times now, I'm really not qualified to be doing an analysis like this. This section in particular. Looking at shared currency among the pairs traded, 74 of the trades are correlated. Quite a large group, but it makes sense considering the sort of moves we're looking for with this system. This means you are opening yourself up to more risk if you were to trade on every signal since you are technically trading with the same underlying sentiment on each different pair. For example, GBP/USD and AUD/USD moving together almost certainly means it's due to USD moving both pairs, rather than GBP and AUD both moving the same size and direction coincidentally at the same time. So if you were to trade both signals, you would very likely win or lose both trades - meaning you are actually risking double what you'd normally risk(unless you halve both positions which can be a good option, and is discussed in ParallaxFX's posts and in various other places that go over pair correlation. I won't go into detail about those strategies here). Interestingly though, 17 of those apparently correlated trades ended up with different wins/losses. Also, looking only at trades that were correlated, winrate is 83%/70%/55% (for the three TP levels). Does this give some indication that the same signal on multiple pairs means the signal is stronger? That there's some strong underlying sentiment driving it? Or is it just a matter of too small a sample size? The winrate isn't really much higher than the overall winrates, so that makes me doubt it is statistically significant. One more funny tidbit: EUCAD netted the lowest overall winrate: 30% to even the -61.8% TP level on 10 trades. Seems like that is just a coincidence and not enough data, but dang that's a sucky losing streak. EDIT: WOW I spent some time removing correlated trades manually and it changed the results quite a bit. Some thoughts on this below the results. These numbers also include the other "What I will trade" filters. I added a new worksheet to my data to show what I ended up picking.
Total Trades: 75
TP at -61.8%: 84.00%
TP at -100%: 73.33%
TP at -161.8%: 60.00%
Moving SL up to 0% when the price hits -61.8%, TP at -100%: 53.33%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%: 53.33% (yes, oddly the exact same winrate. but different trades/profits)
Adjusted Proft % (takes spread into account):
TP at -61.8%: 18.13%
TP at -100%: 26.20%
TP at -161.8%: 34.01%
Moving SL up to 0% when the price hits -61.8%, TP at -100%: 19.20%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%: 17.29%
To do this, I removed correlated trades - typically by choosing those whose spread had a lower % of the trade width since that's objective and something I can see ahead of time. Obviously I'd like to only keep the winning trades, but I won't know that during the trade. This did reduce the overall sample size down to a level that I wouldn't otherwise consider to be big enough, but since the results are generally consistent with the overall dataset, I'm not going to worry about it too much. I may also use more discretionary methods(support/resistance, quality of indecision/confirmation candles, news/sentiment for the pairs involved, etc) to filter out correlated trades in the future. But as I've said before I'm going for a pretty mechanical system. This brought the 3 TP levels and even the breakeven strategies much closer together in overall profit. It muted the profit from the high R:R strategies and boosted the profit from the low R:R strategies. This tells me pair correlation was skewing my data quite a bit, so I'm glad I dug in a little deeper. Fortunately my original conclusion to use the -161.8 TP level with static stops is still the winner by a good bit, so it doesn't end up changing my actions. There were a few times where MANY (6-8) correlated pairs all came up at the same time, so it'd be a crapshoot to an extent. And the data showed this - often then won/lost together, but sometimes they did not. As an arbitrary rule, the more correlations, the more trades I did end up taking(and thus risking). For example if there were 3-5 correlations, I might take the 2 "best" trades given my criteria above. 5+ setups and I might take the best 3 trades, even if the pairs are somewhat correlated. I have no true data to back this up, but to illustrate using one example: if AUD/JPY, AUD/USD, CAD/JPY, USD/CAD all set up at the same time (as they did, along with a few other pairs on 6/19/20 9:00 AM), can you really say that those are all the same underlying movement? There are correlations between the different correlations, and trying to filter for that seems rough. Although maybe this is a known thing, I'm still pretty green to Forex - someone please enlighten me if so! I might have to look into this more statistically, but it would be pretty complex to analyze quantitatively, so for now I'm going with my gut and just taking a few of the "best" trades out of the handful. Overall, I'm really glad I went further on this. The boosting of the B/E strategies makes me trust my calculations on those more since they aren't so far from the passive management like they were with the raw data, and that really had me wondering what I did wrong.
What I will trade
Putting all this together, I am going to attempt to trade the following(demo for a bit to make sure I have the hang of it, then for keeps):
"System Details" I described above.
TP at -161.8%
Static SL at opposite side of confirmation candle - I won't move stops up to breakeven.
Trade only 7am-11am and 4pm-11pm signals.
Nothing where spread is more than 25% of trade width.
Looking at the data for these rules, test results are:
Adjusted Proft % (takes spread into account): 47.43%
I'll be sure to let everyone know how it goes!
Other Technical Details
ATR is only slightly elevated in this date range from historical levels, so this should fairly closely represent reality even after the COVID volatility leaves the scalpers sad and alone.
The sample size is much too small for anything really meaningful when you slice by hour or pair. I wasn't particularly looking to test a specific pair here - just the system overall as if you were going to trade it on all pairs with a reasonable spread.
Here's the spreadsheet for anyone that'd like it. (EDIT: Updated some of the setups from the last few days that have fully played out now. I also noticed a few typos, but nothing major that would change the overall outcomes. Regardless, I am currently reviewing every trade to ensure they are accurate.UPDATE: Finally all done. Very few corrections, no change to results.) I have some explanatory notes below to help everyone else understand the spiraled labyrinth of a mind that put the spreadsheet together.
I'm on the East Coast in the US, so the timestamps are Eastern time.
Time stamp is from the confirmation candle, not the indecision candle. So 7am would mean the indecision candle was 6:00-6:59 and the confirmation candle is 7:00-7:59 and you'd put in your order at 8:00.
I found a couple AM/PM typos as I was reviewing the data, so let me know if a trade doesn't make sense and I'll correct it.
Insanely detailed spreadsheet notes
For you real nerds out there. Here's an explanation of what each column means:
Pair - duh
Date/Time - Eastern time, confirmation candle as stated above
Win to -61.8%? - whether the trade made it to the -61.8% TP level before it hit the original SL.
Win to -100%? - whether the trade made it to the -100% TP level before it hit the original SL.
Win to -161.8%? - whether the trade made it to the -161.8% TP level before it hit the original SL.
Retracement level between -61.8% and -100% - how deep the price retraced after hitting -61.8%, but before hitting -100%. Be careful to look for the negative signs, it's easy to mix them up. Using the fib% levels defined in ParallaxFX's original thread. A plain hyphen "-" means it did not retrace, but rather went straight through -61.8% to -100%. Positive 100 means it hit the original SL.
Retracement level between -100% and -161.8% - how deep the price retraced after hitting -100%, but before hitting -161.8%. Be careful to look for the negative signs, it's easy to mix them up. Using the fib% levels defined in ParallaxFX's original thread. A plain hyphen "-" means it did not retrace, but rather went straight through -100% to -161.8%. Positive 100 means it hit the original SL.
Trade Width(Pips) - the size of the confirmation candle, and thus the "width" of your trade on which to determine position size, draw fib levels, etc.
Loser saved by 2 candle stop? - for all losing trades, whether or not the 2-candle stop loss would have saved the trade and how far it ended up getting if so. "No" means it didn't save it, N/A means it wasn't a losing trade so it's not relevant.
Spread(ThinkorSwim) - these are typical spreads for these pairs on ToS.
Spread % of Width - How big is the spread compared to the trade width? Not used in any calculations, but interesting nonetheless.
True Risk(Trade Width + Spread) - I set my SL at the opposite side of the confirmation candle knowing that I'm actually exposing myself to slightly more risk because of the spread(stop order = market order when submitted, so you pay the spread). So this tells you how many pips you are actually risking despite the Trade Width. I prefer this over setting the stop inside from the edge of the candle because some pairs have a wide spread that would mess with the system overall. But also many, many of these trades retraced very nearly to the edge of the confirmation candle, before ending up nicely profitable. If you keep your risk per trade at 1%, you're talking a true risk of, at most, 1.25% (in worst-case scenarios with the spread being 25% of the trade width as I am going with above).
Win or Loss in %(1% risk) including spread TP -61.8% - not going to go into huge detail, see the spreadsheet for calculations if you want. But, in a nutshell, if the trade was a win to 61.8%, it returns a positive # based on 61.8% of the trade width, minus the spread. Otherwise, it returns the True Risk as a negative. Both normalized to the 1% risk you started with.
Win or Loss in %(1% risk) including spread TP -100% - same as the last, but 100% of Trade Width.
Win or Loss in %(1% risk) including spread TP -161.8% - same as the last, but 161.8% of Trade Width.
Win or Loss in %(1% risk) including spread TP -100%, and move SL to breakeven at 61.8% - uses the retracement level columns to calculate profit/loss the same as the last few columns, but assuming you moved SL to 0% fib level after price hit -61.8%. Then full TP at 100%.
Win or Loss in %(1% risk) including spread take off half of position at -61.8%, move SL to breakeven, TP 100% - uses the retracement level columns to calculate profit/loss the same as the last few columns, but assuming you took of half the position and moved SL to 0% fib level after price hit -61.8%. Then TP the remaining half at 100%.
Overall Growth(-161.8% TP, 1% Risk) - pretty straightforward. Assuming you risked 1% on each trade, what the overall growth level would be chronologically(spreadsheet is sorted by date).
Based on the reasonable rules I discovered in this backtest:
Date range: 6/11-7/3
Adjusted Proft % (takes spread into account): 47.43%
Demo Trading Results
Since this post, I started demo trading this system assuming a 5k capital base and risking ~1% per trade. I've added the details to my spreadsheet for anyone interested. The results are pretty similar to the backtest when you consider real-life conditions/timing are a bit different. I missed some trades due to life(work, out of the house, etc), so that brought my total # of trades and thus overall profit down, but the winrate is nearly identical. I also closed a few trades early due to various reasons(not liking the price action, seeing support/resistance emerge, etc). A quick note is that TD's paper trade system fills at the mid price for both stop and limit orders, so I had to subtract the spread from the raw trade values to get the true profit/loss amount for each trade. I'm heading out of town next week, then after that it'll be time to take this sucker live!
Date range: 7/9-7/30
Adjusted Proft % (takes spread into account): 20.73%
Starting Balance: $5,000
Ending Balance: $6,036.51
Live Trading Results
I started live-trading this system on 8/10, and almost immediately had a string of losses much longer than either my backtest or demo period. Murphy's law huh? Anyways, that has me spooked so I'm doing a longer backtest before I start risking more real money. It's going to take me a little while due to the volume of trades, but I'll likely make a new post once I feel comfortable with that and start live trading again.
The majority of this sub is focused on technical analysis. I regularly ridicule such "tea leaf readers" and advocate for trading based on fundamentals and economic news instead, so I figured I should take the time to write up something on how exactly you can trade economic news releases. This post is long as balls so I won't be upset if you get bored and go back to your drooping dick patterns or whatever.
How economic news is released
First, it helps to know how economic news is compiled and released. Let's take Initial Jobless Claims, the number of initial claims for unemployment benefits around the United States from Sunday through Saturday. Initial in this context means the first claim for benefits made by an individual during a particular stretch of unemployment. The Initial Jobless Claims figure appears in the Department of Labor's Unemployment Insurance Weekly Claims Report, which compiles information from all of the per-state departments that report to the DOL during the week. A typical number is between 100k and 250k and it can vary quite significantly week-to-week. The Unemployment Insurance Weekly Claims Report contains data that lags 5 days behind. For example, the Report issued on Thursday March 26th 2020 contained data about the week ending on Saturday March 21st 2020. In the days leading up to the Report, financial companies will survey economists and run complicated mathematical models to forecast the upcoming Initial Jobless Claims figure. The results of surveyed experts is called the "consensus"; specific companies, experts, and websites will also provide their own forecasts. Different companies will release different consensuses. Usually they are pretty close (within 2-3k), but for last week's record-high Initial Jobless Claims the reported consensuses varied by up to 1M! In other words, there was essentially no consensus. The Unemployment Insurance Weekly Claims Report is released each Thursday morning at exactly 8:30 AM ET. (On Thanksgiving the Report is released on Wednesday instead.) Media representatives gather at the Frances Perkins Building in Washington DC and are admitted to the "lockup" at 8:00 AM ET. In order to be admitted to the lockup you have to be a credentialed member of a media organization that has signed the DOL lockup agreement. The lockup room is small so there is a limited number of spots. No phones are allowed. Reporters bring their laptops and connect to a local network; there is a master switch on the wall that prevents/enables Internet connectivity on this network. Once the doors are closed the Unemployment Insurance Weekly Claims Report is distributed, with a heading that announces it is "embargoed" (not to be released) prior to 8:30 AM. Reporters type up their analyses of the report, including extracting key figures like Initial Jobless Claims. They load their write-ups into their companies' software, which prepares to send it out as soon as Internet is enabled. At 8:30 AM the DOL representative in the room flips the wall switch and all of the laptops are connected to the Internet, releasing their write-ups to their companies and on to their companies' partners. Many of those media companies have externally accessible APIs for distributing news. Media aggregators and squawk services (like RanSquawk and TradeTheNews) subscribe to all of these different APIs and then redistribute the key economic figures from the Report to their own subscribers within one second after Internet is enabled in the DOL lockup. Some squawk services are text-based while others are audio-based. FinancialJuice.com provides a free audio squawk service; internally they have a paid subscription to a professional squawk service and they simply read out the latest headlines to their own listeners, subsidized by ads on the site. I've been using it for 4 months now and have been pretty happy. It usually lags behind the official release times by 1-2 seconds and occasionally they verbally flub the numbers or stutter and have to repeat, but you can't beat the price! Important - I’m not affiliated with FinancialJuice and I’m not advocating that you use them over any other squawk. If you use them and they misspeak a number and you lose all your money don’t blame me. If anybody has any other free alternatives please share them!
How the news affects forex markets
Institutional forex traders subscribe to these squawk services and use custom software to consume the emerging data programmatically and then automatically initiate trades based on the perceived change to the fundamentals that the figures represent. It's important to note that every institution will have "priced in" their own forecasted figures well in advance of an actual news release. Forecasts and consensuses all come out at different times in the days leading up to a news release, so by the time the news drops everybody is really only looking for an unexpected result. You can't really know what any given institution expects the value to be, but unless someone has inside information you can pretty much assume that the market has collectively priced in the experts' consensus. When the news comes out, institutions will trade based on the difference between the actual and their forecast. Sometimes the news reflects a real change to the fundamentals with an economic effect that will change the demand for a currency, like an interest rate decision. However, in the case of the Initial Jobless Claims figure, which is a backwards-looking metric, trading is really just self-fulfilling speculation that market participants will buy dollars when unemployment is low and sell dollars when unemployment is high. Generally speaking, news that reflects a real economic shift has a bigger effect than news that only matters to speculators. Massive and extremely fast news-based trades happen within tenths of a second on the ECNs on which institutional traders are participants. Over the next few seconds the resulting price changes trickle down to retail traders. Some economic news, like Non Farm Payroll Employment, has an effect that can last minutes to hours as "slow money" follows behind on the trend created by the "fast money". Other news, like Initial Jobless Claims, has a short impact that trails off within a couple minutes and is subsequently dwarfed by the usual pseudorandom movements in the market. The bigger the difference between actual and consensus, the bigger the effect on any given currency pair. Since economic news releases generally relate to a single currency, the biggest and most easily predicted effects are seen on pairs where one currency is directly effected and the other is not affected at all. Personally I trade USD/JPY because the time difference between the US and Japan ensures that no news will be coming out of Japan at the same time that economic news is being released in the US. Before deciding to trade any particular news release you should measure the historical correlation between the release (specifically, the difference between actual and consensus) and the resulting short-term change in the currency pair. Historical data for various news releases (along with historical consensus data) is readily available. You can pay to get it exported into Excel or whatever, or you can scroll through it for free on websites like TradingEconomics.com. Let's look at two examples: Initial Jobless Claims and Non Farm Payroll Employment (NFP). I collected historical consensuses and actuals for these releases from January 2018 through the present, measured the "surprise" difference for each, and then correlated that to short-term changes in USD/JPY at the time of release using 5 second candles. I omitted any releases that occurred simultaneously as another major release. For example, occasionally the monthly Initial Jobless Claims comes out at the exact same time as the monthly Balance of Trade figure, which is a more significant economic indicator and can be expected to dwarf the effect of the Unemployment Insurance Weekly Claims Report. USD/JPY correlation with Initial Jobless Claims (2018 - present) USD/JPY correlation with Non Farm Payrolls (2018 - present) The horizontal axes on these charts is the duration (in seconds) after the news release over which correlation was calculated. The vertical axis is the Pearson correlation coefficient: +1 means that the change in USD/JPY over that duration was perfectly linearly correlated to the "surprise" in the releases; -1 means that the change in USD/JPY was perfectly linearly correlated but in the opposite direction, and 0 means that there is no correlation at all. For Initial Jobless Claims you can see that for the first 30 seconds USD/JPY is strongly negatively correlated with the difference between consensus and actual jobless claims. That is, fewer-than-forecast jobless claims (fewer newly unemployed people than expected) strengthens the dollar and greater-than-forecast jobless claims (more newly unemployed people than expected) weakens the dollar. Correlation then trails off and changes to a moderate/weak positive correlation. I interpret this as algorithms "buying the dip" and vice versa, but I don't know for sure. From this chart it appears that you could profit by opening a trade for 15 seconds (duration with strongest correlation) that is long USD/JPY when Initial Jobless Claims is lower than the consensus and short USD/JPY when Initial Jobless Claims is higher than expected. The chart for Non Farm Payroll looks very different. Correlation is positive (higher-than-expected payrolls strengthen the dollar and lower-than-expected payrolls weaken the dollar) and peaks at around 45 seconds, then slowly decreases as time goes on. This implies that price changes due to NFP are quite significant relative to background noise and "stick" even as normal fluctuations pick back up. I wanted to show an example of what the USD/JPY S5 chart looks like when an "uncontested" (no other major simultaneously news release) Initial Jobless Claims and NFP drops, but unfortunately my broker's charts only go back a week. (I can pull historical data going back years through the API but to make it into a pretty chart would be a bit of work.) If anybody can get a 5-second chart of USD/JPY at March 19, 2020, UTC 12:30 and/or at February 7, 2020, UTC 13:30 let me know and I'll add it here.
So without too much effort we determined that (1) USD/JPY is strongly negatively correlated with the Initial Jobless Claims figure for the first 15 seconds after the release of the Unemployment Insurance Weekly Claims Report (when no other major news is being released) and also that (2) USD/JPY is strongly positively correlated with the Non Farms Payroll figure for the first 45 seconds after the release of the Employment Situation report. Before you can assume you can profit off the news you have to backtest and consider three important parameters. Entry speed: How quickly can you realistically enter the trade? The correlation performed above was measured from the exact moment the news was released, but realistically if you've got your finger on the trigger and your ear to the squawk it will take a few seconds to hit "Buy" or "Sell" and confirm. If 90% of the price move happens in the first second you're SOL. For back-testing purposes I assume a 5 second delay. In practice I use custom software that opens a trade with one click, and I can reliably enter a trade within 2-3 seconds after the news drops, using the FinancialJuice free squawk. Minimum surprise: Should you trade every release or can you do better by only trading those with a big enough "surprise" factor? Backtesting will tell you whether being more selective is better long-term or not. Hold time: The optimal time to hold the trade is not necessarily the same as the time of maximum correlation. That's a good starting point but it's not necessarily the best number. Backtesting each possible hold time will let you find the best one. The spread: When you're only holding a position open for 30 seconds, the spread will kill you. The correlations performed above used the midpoint price, but in reality you have to buy at the ask and sell at the bid. Brokers aren't stupid and the moment volume on the ECN jumps they will widen the spread for their retail customers. The only way to determine if the news-driven price movements reliably overcome the spread is to backtest. Stops: Personally I don't use stops, neither take-profit nor stop-loss, since I'm automatically closing the trade after a fixed (and very short) amount of time. Additionally, brokers have a minimum stop distance; the profits from scalping the news are so slim that even the nearest stops they allow will generally not get triggered. I backtested trading these two news releases (since 2018), using a 5 second entry delay, real historical spreads, and no stops, cycling through different "surprise" thresholds and hold times to find the combination that returns the highest net profit. It's important to maximize net profit, not expected value per trade, so you don't over-optimize and reduce the total number of trades taken to one single profitable trade. If you want to get fancy you can set up a custom metric that combines number of trades, expected value, and drawdown into a single score to be maximized. For the Initial Jobless Claims figure I found that the best combination is to hold trades open for 25 seconds (that is, open at 5 seconds elapsed and hold until 30 seconds elapsed) and only trade when the difference between consensus and actual is 7k or higher. That leads to 30 trades taken since 2018 and an expected return of... drumroll please... -0.0093 yen per unit per trade. Yep, that's a loss of approx. $8.63 per lot. Disappointing right? That's the spread and that's why you have to backtest. Even though the release of the Unemployment Insurance Weekly Claims Report has a strong correlation with movement in USD/JPY, it's simply not something that a retail trader can profit from. Let's turn to the NFP. There I found that the best combination is to hold trades open for 75 seconds (that is, open at 5 seconds elapsed and hold until 80 seconds elapsed) and trade every single NFP (no minimum "surprise" threshold). That leads to 20 trades taken since 2018 and an expected return of... drumroll please... +0.1306 yen per unit per trade. That's a profit of approx. $121.25 per lot. Not bad for 75 seconds of work! That's a +6% ROI at 50x leverage.
Make it real
If you want to do this for realsies, you need to run these numbers for all of the major economic news releases. Markit Manufacturing PMI, Factory Orders MoM, Trade Balance, PPI MoM, Export and Import Prices, Michigan Consumer Sentiment, Retail Sales MoM, Industrial Production MoM, you get the idea. You keep a list of all of the releases you want to trade, when they are released, and the ideal hold time and "surprise" threshold. A few minutes before the prescribed release time you open up your broker's software, turn on your squawk, maybe jot a few notes about consensuses and model forecasts, and get your finger on the button. At the moment you hear the release you open the trade in the correct direction, hold it (without looking at the chart!) for the required amount of time, then close it and go on with your day. Some benefits of trading this way: * Most major economic releases come out at either 8:30 AM ET or 10:00 AM ET, and then you're done for the day. * It's easily backtestable. You can look back at the numbers and see exactly what to expect your return to be. * It's fun! Packing your trading into 30 seconds and knowing that institutions are moving billions of dollars around as fast as they can based on the exact same news you just read is thrilling. * You can wow your friends by saying things like "The St. Louis Fed had some interesting remarks on consumer spending in the latest Beige Book." * No crayons involved. Some downsides: * It's tricky to be fast enough without writing custom software. Some broker software is very slow and requires multiple dialog boxes before a position is opened, which won't cut it. * The profits are very slim, you're not going to impress your instagram followers to join your expensive trade copying service with your 30-second twice-weekly trades. * Any friends you might wow with your boring-ass economic talking points are themselves the most boring people in the world. I hope you enjoyed this long as fuck post and you give trading economic news a try!
Hi everyone, I have been trading (Forex) for a while and fine-tuned my set of rules over time to be trading somewhat profitably. However, it is still quite manual and with that comes emotion. I use an Excel plugin (MexelTrader) that exports all live and historical data out of MT4 to excel and here I have been able to build my 'algorithm'. Although my excel is great and I have been able to automate large portions I have this feeling there must be alternatives that do more and are quickeeasier. How do I actually backtest it, testing its performance over historical data and multiple currency pairs? From what I have covered on Reddit and across the internet my options are either learn to code (Python it seems is best) or find someone who can code, to run a programme testing my parameters. Are these the only two options? Any insight/assistance will be greatly received. I am looking to take my trading to the next step and see this as a vital step.
So here it is, three more days and October begins, which marks one year of trading for me. I figured I would contribute to the forum and share some of my experience, a little about me, and what I've learned so far. Whoever wants to listen, that's great. This might get long so buckle up.. Three years ago, I was visiting Toronto. I don't get out much, but my roommate at the time travels there occasionally. He asked everyone at our place if we wanted to come along for a weekend. My roommate has an uncle that lives there and we didn't have to worry about a hotel because his uncle owns a small house that's unlived in which we could stay at. I was the only one to go with. Anyways, we walk around the city, seeing the sights and whatnot. My friend says to me "where next?" "I don't know, you're the tour guide" "We can go check out Bay Street" "what's 'Bay Street?'" "It's like the Canadian Wall street! If you haven't seen it you gotta see it!" Walking along Bay, I admire all the nice buildings and architecture, everything seems larger than life to me. I love things like that. The huge granite facades with intricate designs and towering pillars to make you think, How the fuck did they make that? My attention pivots to a man walking on the sidewalk opposite us. His gait stood out among everyone, he walked with such a purpose.. He laughed into the cell phone to his ear. In the elbow-shoving city environment, he moved with a stride that exuded a power which not only commanded respect, but assumed it. I bet HE can get a text back, hell he's probably got girls waiting on him. This dude was dressed to kill, a navy suit that you could just tell from across the street was way out of my budget, it was a nice fucking suit. I want that. His life, across the street, seemed a world a way from my own. I've worn a suit maybe twice in my life. For my first communion, it was too big for me, I was eleven or whatever so who gives a shit, right? I'm positive I looked ridiculous. The other time? I can't remember. I want that. I want the suit. I want the wealth, the independence.I want the respect and power, and I don't give a shit what anyone thinks about it. Cue self doubt. Well, He's probably some rich banker's son. That's a world you're born into. I don't know shit about it. \sigh* keep walking..* A year later, I'm visiting my parents at their house, they live an hour away from my place. My dad is back from Tennessee, his engineering job was laying people off and he got canned... Or he saw the end was near and just left... I don't know, hard to pay attention to the guy honestly because he kind of just drones on and on. ("Wait, so your mom lives in Michigan, but your dad moved to Tennessee... for a job?" Yea man, I don't fucking know, not going to touch on that one.) The whole project was a shit show that was doomed to never get done, the way he tells it. And he's obviously jaded from multiple similar experiences at other life-sucking engineer jobs. My mom is a retired nurse practitioner who no longer works because of her illness. I ask him what he's doing for work now and he tells me he trades stocks from home. I didn't even know you could do that. I didn't know "trading" was a thing. I thought you just invest and hope for the best. "Oh that's cool, how much money do you need to do that?" "Ehh, most say you need at least $25,000 as a minimum" "Oh... guess I can't do that..." Six months later, I get a call and it's my dad. We talk a little about whatever. Off topic, he starts asking if I'm happy doing what I'm doing (I was a painter, commercial and residential) I tell him yes but it's kind of a pain in the ass and I don't see it as a long term thing. Then he gets around to asking if I'd like to come work with him. He basically pitches it to me. I'm not one to be sold on something, I'm always skeptical. So I ask all the questions that any rational person would ask and he just swats them away with reassuring phrases. He was real confident about it. But basically he says for this to work, I have to quit my job and move back home so he can teach me how to trade and be by my side so I don't do anything stupid. "My Name, you can make so much money." I say that I can't raise the $25,000 because I'm not far above just living paycheck to paycheck. "I can help you out with that." Wow, okay, well... let me think about it. My "maybe" very soon turned into a "definitely." So over the next six months, I continue to work my day job painting, and I try to save up what I could for the transition (it wasn't a whole lot, I sucked at saving. I was great at spending though!). My dad gives me a book on day trading (which I will mention later) and I teach myself what I can about the stock market using Investopedia. Also in the meantime, my dad sends me encouraging emails. He tells me to think of an annual income I would like to make as a trader, and used "more than $100,000 but less than a million" as a guideline. He tells me about stocks that he traded that day or just ones that moved and describes the basic price action and the prices to buy and sell at. Basically saying "if you bought X amount of shares here and sold it at X price here, you could make a quick 500 bucks!" I then use a trading sim to trade those symbols and try to emulate what he says. Piece of cake. ;) Wow, that's way more than what I make in a day. He tells me not to tell anyone about my trading because most people just think it's gambling. "Don't tell your Mom either." He says most people who try this fail because they don't know how to stop out and take a loss. He talks about how every day he was in a popular chatroom, some noob would say something like, "Hey guys, I bought at X price (high of day or thereabout), my account is down 80% .. uhh I'm waiting for it to come back to my entry price.. what do I do??" Well shit, I'm not that fucking dumb. If that's all it takes to make it is to buy low, sell high, and always respect a stop then I'll be fantastic. By the end of September, I was very determined. I had been looking forward everyday to quitting my painting job because while it used to be something I loved, it was just sucking the life out of me at this point. Especially working commercial, you just get worked like a dog. I wasn't living up to my potential with that job and I felt awful for it every minute of every day. I knew that I needed a job where I could use my brain instead of slaving my body to fulfill someone else's dream. "Someone's gotta put gas in the boss's boat" That's a line my buddy once said that he probably doesn't know sticks with me to this day. It ain't me. So now it was October 2018, and I'm back living with Mom n' Pops. I was so determined that on my last day of work I gave away all of my painting tools to my buddy like, "here, I don't need this shit." Moving out of my rental was easy because I don't own much, 'can't take it with ya.' Excited for the future I now spend my days bundled up in winter wear in the cold air of our hoarder-like basement with a space heater at my feet. My laptop connected to a TV monitor, I'm looking at stocks next to my dad and his screens in his cluttered corner. Our Trading Dungeon. I don't trade any money, (I wasn't aware of any real-time sim programs) I just watch and learn from my dad. Now you've got to keep in mind, and look at a chart of the S&P, this is right at the beginning of Oct '18, I came in right at the market top. Right at the start of the shit-show. For the next three or four weeks, I watch my dad pretty much scratch on every trade, taking small loss after small loss, and cursing under his breath at the screen. Click. "dammit." Click. "shit." Click. Click. "you fuck." Click. This gets really fucking annoying as time goes on, for weeks, and I get this attitude like ugh, just let me do it. I'll make us some fucking money. So I convince him to let me start trading live. I didn't know anything about brokers so I set up an account using his broker, which was Fidelity. It was a pain and I had to jump through a lot of hoops to be able to day trade with this broker. I actually had to make a joint account with my dad as I couldn't get approved for margin because my credit score is shit (never owned a credit card) and my net worth, not much. Anyways, they straight up discourage day trading and I get all kinds of warning messages with big red letters that made me shit myself like oooaaahhh what the fuck did I do now. Did I forget to close a position?? Did I fat finger an order? Am I now in debt for thousands of dollars to Fidelity?? They're going to come after me like they came after Madoff. Even after you are approved for PDT you still get these warning messages in your account. Some would say if I didn't comply with "whatever rule" they'd even suspend my account for 60 days. It was ridiculous, hard to describe because it doesn't make sense, and it took the support guy on the phone a good 20 minutes to explain it to me. Basically I got the answer "yea it's all good, you did nothing wrong. As long as you have the cash in your account to cover whatever the trade balance was" So I just kept getting these warnings that I had to ignore everyday. I hate Fidelity. My fist day trading, I made a few so-so trades and then I got impatient. I saw YECO breaking out and I chased, soon realized I chased, so I got out. -$500. Shit, I have to make that back, I don't want my dad to see this. Got back in. Shit. -$400. So my first day trading, I lost $900. My dumbass was using market orders so that sure didn't help. I reeled the risk back and traded more proper position size for a while, but the commissions for a round trip are $10, so taking six trades per day, I'm losing $60 at a minimum on top of my losing trades. Quickly I realized I didn't know what the hell I was doing. What about my dad? Does HE know? One day, in the trading dungeon, I was frustrated with the experience I'd been having and just feeling lost overall. I asked him. "So, are you consistently profitable?" "mmm... I do alright." "Yea but like, are you consistently profitable over time?" ......................... "I do alright." Silence. "Do you know any consistently profitable traders?" "Well the one who wrote that book I gave you, Tina Turner.. umm and there's Ross Cameron" ...................... "So you don't know any consistently profitable traders, personally.. People who are not trying to sell you something?" "no." ................... Holy fucking shit, what did this idiot get me into. He can't even say it to my face and admit it. This entire life decision, quitting my job, leaving my rental, moving from my city to back home, giving shit away, it all relied on that. I was supposed to be an apprentice to a consistently profitable day trader who trades for a living. It was so assumed, that I never even thought to ask! Why would you tell your son to quit his job for something that you yourself cannot do? Is this all a scam? Did my dad get sold a DREAM? Did I buy into some kind of ponzi scheme? How many of those winning trades he showed me did he actually take?Are there ANY consistently profitable DAY TRADERS who TRADE FOR A LIVING?Why do 90% fail? Is it because the other 10% are scamming the rest in some way? Completely lost, I just had no clue what was what. If I was going to succeed at this, if it was even possible to succeed at this, it was entirely up to me. I had to figure it out. I still remember the feeling like an overwhelming, crushing weight on me as it all sunk in. This is going to be a big deal.. I'm not the type to give up though. In that moment, I said to myself, I'm going to fucking win at this. I don't know if this is possible, but I'm going to find out. I cannot say with certainty that I will succeed, but no matter what, I will not give up. I'm going to give all of myself to this. I will find the truth. It was a deep moment for me. I don't like getting on my soapbox, but when I said those things, I meant it. I really, really meant it. I still do, and I still will. Now it might seem like I'm being hard on my dad. He has done a lot for me and I am very grateful for that. We're sarcastic as hell to each other, I love the bastard. Hell, I wouldn't have the opportunity to trade at all if not for him. But maybe you can also understand how overwhelmed I felt at that time. Not on purpose, of course he means well. But I am not a trusting person at all and I was willing to put trust into him after all the convincing and was very disappointed when I witnessed the reality of the situation. I would have structured this transition to trading differently, you don't just quit your job and start trading. Nobody was there to tell me that! I was told quite the opposite. I'm glad it happened anyway, so fuck it. I heard Kevin O'Leary once say, "If I knew in the beginning how difficult starting a business was, I don't know that I ever would've started." This applies very much to my experience. So what did I do? Well like everyone I read and read and Googled and Youtube'd my ass off. I sure as hell didn't pay for a course because I didn't have the money and I'm like 99% sure I would be disappointed by whatever they were teaching as pretty much everything can be found online or in books for cheap or free. Also I discovered Thinkorswim and I used that to sim trade in real-time for three months. This is way the hell different than going on a sim at 5x speed and just clicking a few buy and sell buttons. Lol, useless. When you sim trade in real-time you're forced to have a routine, and you're forced to experience missing trades with no chance to rewind or skip the boring parts. That's a step up because you're "in it". I also traded real money too, made some, lost more than I made. went back to sim. Traded live again, made some but lost more, fell back to PDT. Dad fronted me more cash. This has happened a few times. He's dug me out of some holes because he believes in me. I'm fortunate. Oh yeah, about that book my dad gave me. It's called A Beginner's Guide to Day Trading Online by Toni Turner. This book... is shit. This was supposed to be my framework for how to trade and I swear it's like literally nothing in this book fucking works lol. I could tell this pretty early on, intuitively, just by looking at charts. It's basically a buy-the-breakout type strategy, if you want to call it a strategy. No real methodology to anything just vague crap and showing you cherry-picked charts with entries that are way too late. With experience in the markets you will eventually come to find that MOST BREAKOUTS FAIL. It talks about support/resistance lines and describes them as, "picture throwing a ball down at the floor, it bounces up and then it bounces down off the ceiling, then back up." So many asinine assumptions. These ideas are a text book way of how to trade like dumb money. Don't get me wrong, these trades can work but you need to be able to identify the setups which are more probable and identify reasons not to take others. So I basically had to un-learn all that shit. Present day, I have a routine in place. I'm out of the dungeon and trade by myself in my room. I trade with a discount broker that is catered to day traders and doesn't rape me on commissions. My mornings have a framework for analyzing the news and economic events of the particular day, I journal so that I can recognize what I'm doing right and where I need to improve. I record my screens for later review to improve my tape reading skills. I am actually tracking my trades now and doing backtesting in equities as well as forex. I'm not a fast reader but I do read a lot, as much as I can. So far I have read about 17-18 books on trading and psychology. I've definitely got a lot more skilled at trading. As of yet I am not net profitable. Writing that sounds like selling myself short though, honestly. Because a lot of my trades are very good and are executed well. I have talent. However, lesser quality trades and trades which are inappropriately sized/ attempted too many times bring down that P/L. I'm not the type of trader to ignore a stop, I'm more the trader that just widdles their account down with small losses. I trade live because at this point, sim has lost its value, live trading is the ultimate teacher. So I do trade live but I just don't go big like I did before, I keep it small. I could show you trades that I did great on and make people think I'm killing it but I really just don't need the validation. I don't care, I'm real about it. I just want to get better. I don't need people to think I'm a genius, I'm just trying to make some money. Psychologically, to be honest with you, I currently feel beaten down and exhausted. I put a lot of energy into this, and sometimes I work myself physically sick, it's happened multiple times. About once a week, usually Saturday, I get a headache that lasts all day. My body's stress rebound mechanism you might call it. Getting over one of those sick periods now, which is why I barely even traded this week. I know I missed a lot of volatility this week and some A+ setups but I really just don't give a shit lol. I just currently don't have the mental capital, I think anyone who's been day trading every day for a year or more can understand what I mean by that. I'm still being productive though. Again, I'm not here to present an image of some badass trader, just keeping it real. To give something 100% day after day while receiving so much resistance, it takes a toll on you. So a break is necessary to avoid making bad trading decisions. That being said, I'm progressing more and more and eliminating those lesser quality trades and identifying my bad habits. I take steps to control those habits and strengthen my good habits such as having a solid routine, doing review and market research, taking profits at the right times, etc. So maybe I can give some advice to some that are new to day trading, those who are feeling lost, or just in general thinking "...What the fuck..." I thought that every night for the first 6 months lol. First of all, manage expectations. If you read my story of how I came to be a trader, you can see I had a false impression of trading in many aspects. Give yourself a realistic time horizon to how progress should be made. Do not set a monetary goal for yourself, or any time-based goal that is measured in your P/L. If you tell yourself, "I want to make X per day, X per week, or X per year" you're setting yourself up to feel like shit every single day when it's clear as the blue sky that you won't reach that goal anytime soon. As a matter of fact, it will appear you are moving further AWAY from that goal if you just focus on your P/L, which brings me to my next point. You will lose money. In the beginning, most likely, you will lose money. I did it, you'll do it, the greatest Paul Tudor Jones did it. Trading is a skill that needs to be developed, and it is a process. Just look at it as paying your tuition to the market. Sim is fine but don't assume you have acquired this skill until you are adept at trading real money. So when you do make that leap, just trade small. Just survive. Trade small. get the experience. Protect your capital. To reach break even on your bottom line is a huge accomplishment. In many ways, experience and screen time are the secret sauce. Have a routine. This is very important. I actually will probably make a more in-depth post in the future about this if people want it. When I first started, I was overwhelmed with the feeling "What the fuck am I supposed to DO?" I felt lost. There's no boss to tell you how to be productive or how to find the right stocks, which is mostly a blessing, but a curse for new traders. All that shit you see, don't believe all that bullshit. You know what I'm talking about. The bragposting, the clickbait Youtube videos, the ads preying on you. "I made X amount of money in a day and I'm fucking 19 lolz look at my Lamborghini" It's all a gimmick to sell you the dream. It's designed to poke right at your insecurities, that's marketing at it's finest. As for the bragposting on forums honestly, who cares. And I'm not pointing fingers on this forum, just any trading forum in general. They are never adding anything of value to the community in their posts. They never say this is how I did it. No, they just want you to think they're a genius. I can show you my $900 day trading the shit out of TSLA, but that doesn't tell the whole story. Gamblers never show you when they lose, you might never hear from those guys again because behind the scenes, they over-leveraged themselves and blew up. Some may actually be consistently profitable and the trades are 100% legit. That's fantastic. But again, I don't care, and you shouldn't either. You shouldn't compare yourself to others. "Everyone's a genius in a bull market" Here's the thing.. Markets change. Edges disappear. Trading strategies were made by traders who traded during times when everything they did worked. Buy all the breakouts? Sure! It's the fucking tech bubble! Everything works! I'm sure all those typical setups used to work fantastically at some point in time. But the more people realize them, the less effective they are. SOMEONE has to be losing money on the opposite side of a winning trade, and who's willing to do that when the trade is so obvious? That being said, some things are obvious AND still work. Technical analysis works... sometimes. The caveat to that is, filters. You need to, in some way, filter out certain setups from others. For example, you could say, "I won't take a wedge pattern setup on an intraday chart unless it is in a higher time frame uptrend, without nearby resistance, and trading above average volume with news on that day." Have a plan. If you can't describe your plan, you don't have one. Think in probabilities. You should think entirely in "if, then" scenarios. If X has happens, then Y will probably happen. "If BABA breaks this premarket support level on the open I will look for a pop up to short into." Backtest. Most traders lose mainly because they think they have an edge but they don't. You read these books and all this stuff online telling you "this is a high probability setup" but do you know that for a fact? There's different ways to backtest, but I think the best way for a beginner is manual backtesting with a chart and an excel sheet. This builds up that screen time and pattern recognition faster. This video shows how to do that. Once I saw someone do it, it didn't seem so boring and awful as I thought it was. Intelligence is not enough. You're smarter than most people, that's great, but that alone is not enough to make you money in trading necessarily. Brilliant people try and fail at this all the time, lawyers, doctors, surgeons, engineers.. Why do they fail if they're so smart? It's all a fucking scam. No, a number of reasons, but the biggest is discipline and emotional intelligence. Journal every day.K no thanks, bro. That's fucking gay. That's how I felt when I heard this advice but really that is pride and laziness talking. This is the process you need to do to learn what works for you and what doesn't. Review the trades you took, what your plan was, what actually happened, how you executed. Identify what you did well and what you can work on. This is how you develop discipline and emotional intelligence, by monitoring yourself. How you feel physically and mentally, and how these states affect your decision-making. Always be learning. Read as much as you can. Good quality books. Here's the best I've read so far; Market Wizards -Jack Schwager One Good Trade -Mike Bellafiore The Daily Trading Coach -Bret Steenbarger Psycho-cybernetics -Maxwell Maltz Why You Win or Lose -Fred Kelly The Art and Science of Technical Analysis -Adam Grimes Dark Pools -Scott Patterson Be nimble. Everyday I do my research on the symbols I'm trading and the fundamental news that's driving them. I might be trading a large cap that's gapping up with a beat on EPS and revenue and positive guidance. But if I see that stock pop up and fail miserably on the open amidst huge selling pressure, and I look and see the broader market tanking, guess what, I'm getting short, and that's just day trading. The movement of the market, on an intraday timeframe, doesn't have to make logical sense. Adapt. In March I used to be able to buy a breakout on a symbol and swing it for the majority of the day. In the summer I was basically scalping on the open and being done for the day. Volatility changes, and so do my profit targets. Be accountable. Be humble. Be honest. I take 100% responsibility for every dime I've lost or made in the market. It's not the market makers fault, it wasn't the HFTs, I pressed the button. I know my bad habits and I know my good habits.. my strengths/ my weaknesses. Protect yourself from toxicity. Stay away from traders and people on forums who just have that negative mindset. That "can't be done" mentality. Day trading is a scam!! It can certainly be done. Prove it, you bastard. I'm posting to this particular forum because I don't see much of that here and apparently the mods to a good job of not tolerating it. As the mod wrote in the rules, they're most likely raging from a loss. Also, the Stocktwits mentality of "AAPL is going to TANK on the open! $180, here we come. $$$" , or the grandiose stories, "I just knew AMZN was going to go up on earnings. I could feel it. I went ALL IN. Options money, baby! ka-ching!$" Lol, that is so toxic to a new trader. Get away from that. How will you be able to remain nimble when this is your thought process? Be good to yourself. Stop beating yourself up. You're an entrepreneur. You're boldly going where no man has gone before. You've got balls. Acknowledge your mistakes, don't identify with them. You are not your mistakes and you are not your bad habits. These are only things that you do, and you can take action necessary to do them less. It doesn't matter what people think. Maybe they think you're a fool, a gambler. You don't need their approval. You don't need to talk to your co-workers and friends about it to satisfy some subconscious plea for guidance; is this a good idea? You don't need anyone's permission to become the person you want to be. They don't believe in you? Fuck 'em. I believe in you.
How to derive historical financial data for forex instrument backtesting
Hello, If you believe backtesting strategies for forex major currency pairs is unhopeful please leave a comment with an explanation. I'm a CS major at Columbia with internships in back office global bank infrastructure positions here in NY and have great interest in trading algorithmically because I can't trust my behavior to enter trades, among other obvious reasons. I would like to know what the best sources are for obtaining historical data (OHLCV, etc) for (forex) backtesting purposes. Is a large excel file used in practice, or are historical prices derived via API's? It seems that I need to pay after some research online, but I know you redditors can deliver. edit I found a free source here for EURUSD. There are other pairs available too.
Hello everyone, I'm kinda new to trading and I want to start doing backtesting but without spending money on Forex tester for now. Any good options for manual testing? I was thinking mt4 candle by candle and input values into a excel sheet, the problem here is how to build that excel sheet, what values to put it, and what calculations do I need to set everything up nicely and good. Is there any tester for mt4 free or something like that? Any help would be good. THANKS 😀
WolfpackBOT - The World's Fastest Crypto Trading Bot https://preview.redd.it/s5j8hgsgsi131.png?width=799&format=png&auto=webp&s=e0e5597fa32aa74f78fcfbb5cc08d143f8b8ca3b There are basically two different ways you can make mazuma from digital currencies. You can purchase a couple of coins currently, hold them for an extensive period and offer them after the esteem has risen significantly or you can get started with exchanging digital forms of money, here once more, you can exchange physically or run with the best crypto exchanging bots. While holding cryptographic money for a more drawn out term has turned out to be fulfilling, it takes a bounty of time and tolerance for you to optically observe the estimation of your speculation increase.If you are somebody, who does not have the persistence to hang tight for so long, at that point digital currency trading provides you with the immaculate chance to make some mazuma. Numerous prosperous digital currency dealers do recommend you purchase low and sell high. In any case, this is easier verbalized than done. Digital currencies have been cosmically unpredictable since the earliest reference point. They are the main tradable resources whose esteem shifts in twofold digit rates every day. The cost does not generally go up either. Along these lines, timing the market is the way to turning into a prosperous cryptographic money merchant. Exchanging digital money isn't any advanced science. All you require is a record on a digital money trade and some cryptographic money in your wallet. This would have been the situation, had you started exchanging these computerized resources route in 2010. Presently, on the off chance that you try to put in any limitation request on any famous cryptographic money trade, you will outwardly see another application set appropriate above you're, putting forth a superior arrangement. Hence, you are constrained to put orders at market esteem. The way that a superior offer quickly negated your offer does not assign that somebody is continually crushing before the PC. You just set off crypto exchanging bot when you submitted your request. The best bitcoin exchanging bots have surmounted the whole cryptographic money exchanging biological system, and this is primarily because of the way that they are more effective than people, particularly when it comes down to exchanging. Presently that you ken that bots have surmounted the crypto exchanging market, you more likely than not understood as of now that the chances of making mazuma when piled facing a great many bots are cosmically svelte. You could ace all the distinctive specialized investigation strategies and exceed the bots. In any case, in addition to the fact that this is tedious withal very tedious. So instead of investing more energy finding out about the specialized investigation, you can set up the crypto exchanging bots all alone. By the end of this article, not exclusively will you ken probably the most profitably rewarding cryptographic money exchanging bots out there, yet moreover will be enabled with the intelligence of winnowing your very own exchanging bot later on. Variables to Look for When Culling the Best Crypto Trading Bots
A standout amongst the most vital viewpoints to consider is the dependability of an exchanging bot. You would not operate to lose on a brilliant open door because your crypto bot went disconnected or stopped working for quite a while. You may contend that there is no real way to make sure about the dependability of a specific exchanging bot. Notwithstanding, you aren't the just a single using a bot. Scan for what alternate clients who have used a particular bot need to verbally express about its consistent quality or basically allude to our rundown of the best bitcoin exchanging bots underneath.
With regards to cryptographic forms of money, you can't inculpate anybody yet yourself if there should be an occurrence of a hack. When you initiate using an exchanging bot, you are giving the bot access to your mazuma. This can be very jeopardous, particularly if the exchanging bot is beginning in the field. There is no telling how secure a specific bot is. In this way, while separating an exchanging bot, complete quintessential research and winnow a bot that has been broadly extolled for its security.
Everything comes down to this fundamental part. Is the bot profitably worthwhile or not? An inquiry for which it is elusive an answer. The primary reason you chose to run with an exchanging bot is to benefit over its exchanging ability. There is no influential pertinence in using a bot that isn't profitably rewarding. In this way, discover the productivity of a bot up to you put both your time and mazuma into it.
The fundamental motivation behind why digital currency rose to acclaim is that the entire system is plenarily straightforward. There is the wrong spot for any injustice. The equivalent ought average even from the exchanging bot that you choose to run with. Attempt to winnow a bot whose engineers are unmistakable for their work in the network. Straightforwardness benefits to fabricate trust as well as also profits you to connect with the ideal individuals to adjust any issue.
Simplicity of profit
The entire cogency of running with a robotized bitcoin exchanging is to make the whole procedure of transferring cryptographic forms of money simple for everybody. A bot which accompanies a simple to use interface is the one that is exceptionally well known. Having the capacity to control the bots with only a couple of snaps of the mouse is something you should pay individual mind to, in the bot that you choose to use. Considering every one of the variables we have arranged a rundown of the best ten digital currency exchanging bots in 2019, the review will be unendingly refreshed with the goal that data remains apropos. Top 10 Best Crypto Trading Bots in 2019
This may be a new bot in the crypto exchanging market. In any case, this newcomer has figured out how to blow some people's minds because of the comprehensive exhibit of highlights that this bot gives. One of the defeats of most exchanging bots is that they kept running on your neighborhood machine. This betokens they run just when you have turned on your PC. With the lift in enthusiasm for cloud-predicated advancements, Cryptohopper uses cloud innovation to keep the bot running day in and day out. By running the bot on a cloud, clients will most likely put in exchange requests notwithstanding amid the night. In this manner, no open door is missed. Another critical reason that prompted the lift in the notoriety of Cryptohopper is its simplicity of usage, particularly for the tyro. The bot has incorporated with an outside exchanging signaller. This assigns anybody can initiate using this bot by running it on autopilot. This is a help to the nascent dealers, who need not stress over setting exchanging signals for their bot. The bot withal gives progressively experienced clients a chance to mess around and set their own exchanging signals. Along these lines, it is satisfying the desiderata of both. Aside from this, the bot is incidentally outfitted with highlights, for example, trailing stops, specialized examination, formats, and backtesting. Formats benefit you to design a nascent setting for your bot quickly, and specialized investigation sanctions you to redo and arrange your own settings. Like every extraordinary thing, the crypto container comes with a sticker price fastened to it. The cost starts from $19 every month for the fundamental arrangement and goes up to $99 per month if you operate their most extravagant arrangement. When you buy into any of the organizations, you can start using the bot on prominent trades like Binance, Huboi, Kucoin, Bittrex, Coinbase, Poloniex, Kraken, Cryptopia, and Bitfinex. On the off chance that you are slanted to spend the additional buck on an exchanging bot, at that point Cryptohopper is an extraordinary separate.
Even though 3Commas bot is nascent to the exchanging bot scene, it could give its clients huge increases, notwithstanding amid the crypto bear showcase. The new element that dissevers this bot from other bots is its workforce to trail any crypto advertise. This authorizes the bot to close the exchange at the most profitably excellent position, yet the objective addition set by the utilizer had just been come to. This element benefits enormously amid the crypto bull run. Additionally, the bot adventitiously endorses clients to exchange numerous cryptographic forms of money simultaneously. In this manner, it is not passing up any great exchanging opportunity that goes along the way. The bot is set up on the cloud and is available through the site. This betokens the bot runs 24X7. The bot can be designed with Binance and Bittrex at this moment and increasingly legitimate trades, for example, BitFinex, Poloniex, KuCoin, and so forth will be coordinated anon. The 3Commas comes with a sticker price appended to it. The starter plan will cost you $24, and the most luxurious genius pack would set you back by $82. On the off chance that you operate to give crypto bot exchanging a go, at that point, you could use the 3Commas starter plan and later peregrinate to the more rich schemes.
This is another mainstream exchanging bot with more than 6000 dynamic merchants using its lodging on a quotidian substructure. Good with a few exchanging stages including Binance and GDAX, it very well may be kept running on your nearby PC. This can keep running on Windows, Linus, and the Mac stages, so running on your neighborhood machine would not be a bind. The bot has 32 diverse pre-arranged exchanging systems which give clients a wide cluster of choices to induce some automated revenue. Among these techniques, the three most well-known ones are the Bollinger band, step addition, and ping pong. Numerous clients have detailed having made a bounty of benefits with the BB procedures. Gunbot isn't in freedom to use and accompanies a one-time level rate running from 0.1BTC to 0.3BTC, contingent upon the highlights that you would savor to optically observe in the bot. Aside from this, the bot supplementally comes as a Lite rendition that has encircled highlights yet can be habituated to test around with the lesser measure of mazuma. The post-buy support given by the organization is truly surprising. Clients get their issues settled in less than multi-day. The main pickle with regards to this bot is that you ought to in every case reliably outwardly look at the present market state. If the instability of the crypto advertise is high, at that point you ought to most likely turn the bot off to shun any misfortune
This is the most diverse digital money exchanging bot in subsistence at present. For any individual who needs to gain proficiency with some things about exchanging bots and not spend any mazuma getting one, at that point Gekko is the bot for you. The Gekko trading bot is an open source bitcoin exchanging bot venture that is accessible for anybody to use for nothing. The way that it is in freedom to use is the fundamental purpose behind its wide prevalence. Like some other open-source ventures, Gekko is free of for all intents and purposes all bugs and even the ones the pop are fixed up at lightning speeds. The Gekko bot can collaborate with a few trades, including Bitfinex, Polonix, and BitStamp. The bot uses a web interface to associate with the clients and can keep running on a neighborhood machine with Windows, Linux, or the Mac OS. The bot comes pre-designed with some exchanging system. You can initiate using the bot on autopilot as anon as you introduce and design it with a trade. In any case, if you would savor to use your very own exchanging system, the bot withal endorses you to design it to your savoring. While the present design is respectable for trying different things with the bot, there are a few other exchanging techniques accessible online that would benefit you make an all the more profitably worthwhile wager. The bot will withal send you a notice at whatever point it executes a specific exchange. This is finished by incorporating it with the Telegram envoy. Consequently, you will dependably ken how well your bot is performing. The main drawback to the Gekko exchanging bot is that it isn't very utilizer-heartfelt. There are a few aides in the digital world that direct you through the underlying setup process. Be that as it may, this procedure isn't extremely direct and you would presumably hit a barricade at any rate once amid the underlying setup.
Another allowed to use digital currency exchanging bot, Zenbot can be considered as a further developed form of the Gekko exchanging bot. Nonetheless, as Gekko has been around for a more extended time, it is all the more generally used. Much the same as Gekko, Zenbot programming can be downloaded from Github and introduced on your neighborhood PC. The product is perfect with Windows, Mac just as the Linux working frameworks. The bot comes pre-arranged with an entirely nice exchanging system. In any case, its real potential can be opened only when you initiate executing your exchanging order. The primary bind with the allowed to use bots is that they are frequently not very utilizer-genial. In any case, this isn't the situation with Zenbot. The entire setup process is extremely effortless, and you can have the bot fully operational in all respects speedily. The bot chips away at all prevalent trades, for example, Bitfinex, Poloniex, Bittrex, and so on. As it is an open source venture, it is without now of a few bugs, and regardless of whether one springs up, it will be adjusted all around speedily. The Zenbot can effortlessly actualize with a few informing stages, for example, slack, Telegram, and so on to give you the updates of any exchange that was executed. Adventitiously, the Zenbot withal braces high-recurrence exchanging. This is a component that outlined the personnel of the Gekko bot. The Zenbot is being refreshed, and more highlights are being incorporated traditionally. Hence, making it a bot for you to reliably outwardly analyze.
WolfpackBOT: WolfpackBOT is a cryptographic money exchanging programming application that has been created with the most developed highlights of any robotized exchanging programming of its sort. The WolfpackBOT has been intended to execute exchanging directions with the usage of restrictive numerical calculations, and specialized investigation bespeakers predicated on the client's predefined assignments.
The cryptographic money advertise as of now bearish, and many exchanging bots easily miss the scarcest vacillations. WolfpackBOT has been built to execute trading directions at a lightning speed and is fit for making up to a large number of exchanges every day, relying upon the states of the market. WolfpackBOT is among the few cryptographic money exchanging bots that give crypto aficionados full self-governance, security, and control of their exchanging bot and its related API keys. A large portion of the crypto trading bots out there are cloud-predicated stages that are constrained by outsider frameworks. While these stages guarantee dealers of outright wellbeing and security, insightful brokers ken that in the crypto space, outsider frameworks like trades and other cloud-predicated steps are hacked proximately consistently. Since WolfpackBOT programming and your related API keys are put away individually PC or devoted VPS, WolfpackBOT can sidestep a significant number of the security issues related to cloud-predicated frameworks. WolfpackBOT has been created for the whole crypto network, from experienced merchants to novices, with three in all respects reasonably valued membership levels. WolfpackBOT accompanies a few membership bundles that authorize clients to exchange with a wide scope of chances predicated on their favored membership.
cryptotrader_reviewAlmost all digital money merchants would have aurally seen about the crypto dealer exchanging bot. The across the board fame of this bot is because it was one of the absolute first bots to be kept running on the cloud and accessible to the clients day in and day out. The crypto broker bot is plenarily web-predicated and in this manner, open from anyplace you can associate with the digital world. The bot can be easily designed with a few well-known trades, for example, Poloniex, Bittrex, Kraken, and so on. This bot does not come for nothing out of pocket. You can operate from the few organizations accessible. The valuing initiates with 0.003BTC every month for the most simple arrangement and this goes up to 0.0472 BTC every month for their excellent arrangement. While all plans do offer clients support for programmed exchanging, the early highlights and as far as possible for the more indulgent plans is higher than that given the basic arrangement. Any early component that is caused is most readily accessible on the higher bundle designs and are later accessible on the basic plans. On the off chance that you would simply savor to exchange on a solitary trade and with exceptionally delineated mazuma, at that point the basic arrangement will get the job done. Be that as it may, on the off chance that you are outwardly looking at the higher volume of exchanges, at that point run with the higher bundle. This bot additionally sustains algorithmic exchanging. In this manner, I am making it effortless for clients to execute their very own arrangements. The bot can be effortlessly modified. In this manner, I am making it a broadly utilized cryptographic money exchanging bot.
btcrobotWe simply needed to incorporate the pioneer of digital currency exchanging bots on our rundown of the best crypto exchanging bots. The Bitcoin robot started as a Bitcoin exchanging bot. In any case, it can now withal be designed to exchange different digital currencies, for example, Ethereum and Litecoin. The bot is accessible as a product and should be downloaded and keep running on your neighborhood machine. This betokens the exchanges will be executed just as long as you keep your PC turned on. The bot can effortlessly work with a few digital money trades and is by and large broadly utilized even today. The bot isn't accessible free of expense and costs you a premium. The cost of the bot ranges from $19.99 every month for the principal plan. In any case, clients usually buy the platinum plan that costs just $399 one time charge and offers utilizer unlimited access to every one of the highlights. The benefits made by individuals using this bot verbalizes for itself. Supplementally, they do offer a 60-days mazuma back assurance. Along these lines, you should look at them once.
This can't be considered as a bot. In any case, the USI tech BTC settlement promises mechanized benefits for your BTC speculations. The USI Tech was at first intended for Forex exchanging. In any case, after the raise of the ubiquity of Bitcoin, they additionally offer BTC bundles. Not at all like some other BTC exchanging bot where you require to give the API key of your trade account to execute exchanges, on USI Tech, you will require to winnow from among the few BTC master exchanges. At that point, you will begin accepting your segment of benefits at whatever point exchange is made. The USI Tech stage basically ensures extraordinary comes back to your speculations. The entire procedure of purchasing your absolute first BTC bundle is withal simple and pellucidly elucidated on their site. You can explore different avenues regarding the benefits that you gain. In any case, the number of bundles you purchase, the more dominant will be your benefit
Margin.De (Leonardo Bot)
Edge LeonardobotThis is a cryptographic money exchanging bot with the most utilizer-genial interface. The GUI of the bot is easy to use, and the highlights gave are extremely puissant. The bot was structured with two exchanging techniques ping pong and Margin exchanging actualized into it. In any case, you can withal modify it with your very own custom settings. This bot lays incredible complement on the visual parts of exchanging. The specialized examination done by the bot is immensely simple to break down. What more? The bot has an astonishing component called visual exchanging. This interface feels rich smooth to use and offers clients the most extreme authority over the exchanges. The bot was at first evaluated at 0.5 BTC consistently. Notwithstanding, presently, it is accessible at a one-time cost extending from $89 to $1999 with the most elevated arrangement offering a bigger number of highlights than th
I created a strat and paper tested it. Live. Everything I know says this cant be true though.
Member for a couple years but I've been lurking for the past 10-12 months. First thing is I'm not trying to brag. I'm legit asking if something can be messed up while paper trading by someone who also trades live and understands how to properly document trades. It's funny. My last posts on /r forex were about scalping and I was stuck/fixated on the 5 minute chart. I was even looking into venom trading simply because their spreads were ridiculously low or something. My focus has changed quite a bit over the years lol. I've been trading for about 2 years now and I am in the green overall, but I'm probably pretty standard in that I am just over a break-even trader. Over the past year I have spent...fuck, I don't even know how many hours in front of the charts. I've spent entire weekends and days off just switching between desktop and laptop charting. I've got multiple notebooks and excel sheets full of random ideas and strats. I put something together, backtested it with great results and then I began testing it like all my other ideas: through live paper trading for a period of 8 weeks. The numbers are insane. Everything I know about trading says it can't be true. Everything i know also says I traded it correctly. Is there any way to skew live paper trading results?
Backtested for 18 Months (manually)
Paper traded it for 5 months live.
Backtesting results were similar to live trading results. Max drawdown of 14.63%.
I hate losing money, which is why I backtest and paper trade for so long. It's also why I'm treating this strat like an english paper and asking for more eyes on it.
these numbers don't make sense to me, but I recorded them live, and want to go in on them with actual cash. I just want to see if there's anything I could be missing. I've looked at fundamentals...figured maybe Bernie and the DNC, Hillary, Trump, Oil prices, gold, the attempted coup in Turkey, terrorist attacks, Brexit, the French election, etc could be swaying the results, but it doesnt seem so...
I have open and exit entries of all my trades (simple backtest of my strategy) on an excel sheet. I'd like to see how they would look if I took them on a live account in order to see the drawdowns and margin levels past 10-15 years. Is there a plugin for mt4 or software (preferably free) that I can upload this and see all that info i'm looking for? Note: I tried darwin but their forex market products are too little that I cannot test all my forex pairs + it failed to do so like 100 times so im not gonna try anything with them anymore.
Hello! My name is Chris, and I'm trying to make trading a primary source of income. Although I would prefer to trade in many different markets, I feel that forex serves as an excellent starting point. Now, I understand that the vast majority of traders aren't profitable, and actually lose everything they have in their trading account. And I'm trying to avoid that myself. So, I have decided not to trade with real money at all until I am fully confident in at least one strategy and am proficient in executing it without straying from its rules and parameters. At this point in time, I am actively looking for strategies that are simple, (no more than three indicators) and directional (obviously). I plan not to ever trade without a stop loss, and I do not accept any strategies that don't offer a 2:1 reward/risk ratio (ex. max profit = 20 pips, max loss = 10 pips). Additionally, I intend not to risk more than 3% of my trading account for a particular trade. I also prefer (but am open to others) H1, H4 and daily timeframes. Now, unfortunately, backtesting is quite a time-consuming and exhausting feat. And I know for sure that I am going to be constantly tempted to stop, or give up, or slow down my progress. And I'm sure you might, or might have felt that way yourself. Well, if you happen to be like me and you are committed to becoming the person you need to become to trade well, please consider contacting me. Maybe we can share support and ideas and encouragement to keep going even when we're stuck. I'd also love to hear how you became interested in forex in the first place, and what you would want to do with the money you make. Anyway, just throwing this out there for anyone who may be interested. Thank you for reading, and I wish you all the best. Chris
Fear of Missing Out The fear of missing out on potentially profitable trades is paradoxically the cause of much trading failure. FOMO causes recklessness in trading to feed a need for relief of the angst brought about by the fear. Unless your focus is placed on preserving capital and risk management, the inevitable result is consistent losses. We all know the key to trading is choosing high probability trades and proper risk management, then why don't we do this? Fear of Missing Out and Trading Forex Have you ever experienced a losing streak only to result in you taking a step back to rethink your strategy? On many occasions, this renewal of a cautious mindset may have led to a new string of successive profitable periods only to be followed by another series of losses. The cause of this cyclical pattern, in some cases, is a shifting of focus from one of risk management to profit. If you focus on managing your trades in such a way that you chose only the best setups and risk just a small amount on each trade, then this will lead to a successful period. A profitable period leads to overconfidence and laxity in risk management. Once this occurs, the focus may shift to making more which leads to the fear of missing out on any apparent profit potential. Fear of missing out and trading poorly go hand in hand. High Probability Trades If your focus is on the profit, you will end up taking lower probability trades. You can't focus on two things at once: both profits and high probability trade setups. The paradox is that the more you focus on profits, the more sloppy you'll become in your trading technique and the less profit you'll make. The problem with high probability trades is that they're not that common. Patience and discipline are required. Many traders don't either understand the need or method of attaining discipline and patience. Some traders insist on a trading plan but neglect the need for internal practice/ visualization or confidence in the system. Visualization will be addressed later in more depth, but patience and discipline will come more naturally if you have faith in the system. The strong confidence in the system can be a result of backtesting and combining fundamentals with technicals. Fundamentals are helpful because they are the real reasons price moves in a particular direction in the first place. High probability trades should be a result of a confluence of information. Fear of missing out and trading without a confluence of reasons to take the trade feed off each other. In other words, if you fear to miss a possible trading opportunity you may be less likely to be critical of the trade and therefore pay less attention to the necessary confluence of reasons to take it. If you pay less attention to the confluences, you'll end up taking poorer trade setups which will lead to more losses. More losses lead to the need to make up for losses or revenge trading. This focus on revenge trading only leads to taking riskier trades, and the cycle continues. Risk Management No system is perfect; there will always be drawdowns. Avoiding fear of missing out and trading higher probability trades is only half the recipe. You must keep your risk relatively small in order to skew the possibility of equity growth in your favor. It is the lesser risk that helps retain your working capital, so you can take advantage of the bull runs when they occur. If you don't keep your risks small then not only will you have insufficient capital left to take advantage of a winning streak, you won't have the mental willpower either. Drawdowns can have a severe effect on your motivation and mental stamina. Only realistic expectations of account gains will result in a tempered risk approach. All of this information on risk management is good, but most traders still have difficulty implementing what they know they should do. This difficulty is where visualization fits in. It helps build up the discipline necessary through mental exercise, without having to risk real money.Visualization Refer back to an earlier article on visualization here. You must think of yourself as a risk manager and not a profiteer. The profits will come as long as you've done your job as an excellent risk manager. Again, risk management includes choosing the best possible trades, knowing precisely what those type of trade set ups are in advance (part of a trading plan), knowing what to risk and reward should be before you place a trade (part of a trading plan), not taking bad or even mediocre trade setups, looking for a confluence of factors that results in a high probability trade, reading the news so to understand the fundamentals behind a currency movement. All of this and more can be practiced through visualization. Visualization should be an opportunity for rehearsal and focussing on what you need as a trader: risk management skills. You may find your mind wanders away from this focus, but visualization will help you to continue to refocus, This practice of redirecting will carry over into your real trading. The discipline you need as a trader will, as a result, be directly related to the amount of mental practice that you do. Visualization will also help in addressing what possible obstacles you may have to endure. One common obstacle is drawdowns. You can see yourself as continuing to practice good money management skills even during a drawdown. This practice will help you avoid even worse losses. Certainty and Trading The sense of certainty in trading comes from knowing your system inside out. This sense only comes with real practice in real time and through imagery. Paradoxically, the more you take your attention away from making a profit and place it on risk management, the more likely you'll be in profit. The more detailed you make your imagery, the more confident you will feel that you are a good risk manager. This certainty should transfer over to reality in the form of greater profits.
I've recently been working on creating and refining a new edge. Journaling is an essential part of that process and it inspired me to make this post since some people might not see the importance of keeping one.
Journaling is one of the most important aspects of your trading.
It can be a chore, but keeping a trading journal is incredibly useful.
Because if you set one up and use it correctly, that's where you'll find patterns. Patterns in the markets, patterns in your trades, and patterns in your trading behaviour. You can use a journal find new edges. Or to refine your entries, exits, SLs, TPs, holding times, etc. Or to find and address any bad trading behaviours (eg. moving SLs when you shouldn't be, or skipping valid set ups out of fear). You get the idea - it's really handy.
What should you put in your journal?
As much as you can - without discouraging yourself from actually using it consistently. That's going to differ for everyone. Do some googling (or ask people here on reddit) to see what other people have found useful variables to track. There's also lots of templates available online to copy (eg. here or here). Keep in mind that different technical set ups will require different variables to track. A few that I think are very useful yet often overlooked include - maximum adverse excursion, maximum favourable excursion, tracking the performance (using R multiples) of a few alternative exit methods, and the name of the day of the week at entry.
So what should you do?
Step 1 - Think long and hard about the appropriate variables you think you should track - ones that could influence your trade performance. Step 2 - Update your journal regularly. I like to do it at the end of every trading day while the trades are still fresh in my mind. Find what works for you. Step 3 - Periodically go back and analyse your journal. You might find that your win rate drops significantly on Fridays and thus makes your Friday trades have a negative expectancy. You might find that having RSI divergence at your entry signal increases the expectancy of the trade by 13%. You might find that exiting at ATR significantly outperforms both exiting at your Bollinger bands or exiting at a 161.8% fib extension. You get the idea? Step 4 - Act on the information provided by your journal. Skip those Friday trades. Add RSI divergence to your entry requirements. Exit at ATR. Whatever.
Journaling is incredibly useful for backtesting, forward testing, and live trading. Your journal is your best friend. Use one.
Create a folder for trading screenshots. Take a screenshot of the chart every time you enter, exit or modify a trade. Annotate the screenshots in an image editor (eg. MS Paint) if you want. Find a naming convention that works. Here's an example from my folder. Sort this folder in numerical order and you'll have a chronological chart book of all your trades which can be useful for visually searching for patterns.
I use a paid program called Edgewonk as my journal. It's just a glorified excel document that makes the analysis easier. You can just use the filter feature in excel to see how variables (and combinations of variables) affect your trades. Here's an export of some of the things I track in it for one of my set ups.Notethisspreadsheetdoesn'tincludethetrackingofdifferentexitmethods,ortradescreenshots,oranyanalysis.
If you feel like sharing the variables you track in your trading journal, I'm sure people would like to read about them in the comments.
I am new to forex and my backtesting stratergy is very simple, I need historic daily high, low, open and close data for at least one currency pair in Excel/CSV format, that I can manipulate using matalb. My issue, where the hell can you find historic daily high low open and close data in CSV format
I started with forex trading recently, ( demo account, <2% per trade, log all trades into excel, testing, etc...). When i read about technical analysis, there`s minimum strict rules and almost all indicators are recommended to try because all other people believe they are useful in some situation. does anybody backtested all those indicators, should we blindly believe and try all indicators in our strategy ? I know that majority of people is using them but are there actually any proofs that those indicators really helps you ? Moving averages are not rocket science, but what i should think about fibonacci or SAR ? I was like WTF when i was reading about these... All traders say don't trade just because of "good feeling" but we do actually trade just because "blue indicator" is near or "red indicator" - that`s just naive approach. I know that technical analysis is just one part of complex forex world ,but i believe we all should backtest automatically basic indicators to see when they really helps, this would greatly help people to develop better strategies. Do you know any papers/studies or blogs of forex people with more engineering approach to forex ? I really liked traits-of-successful-traders-guide from fxcm, its not technical analysis but they are telling you about basics facts e.g. best hours, success of sample strategies, effective leverage - thats how tutorial for beginners should look like. Babypips.com are maybe informative but very very naive, not explaning numbers much. Thanks.
Technical & fundamental news on currencies.I would advise newer traders not to trade solely on external opinions because that won't cement your own methodology or reasons for trading.Excellent website for if you want an overview of the markets and daily reports. Also includes a trading journal and a lot of media attention.
This is absolutely amazing! I can't put a value on this! It's one of the best gems of the internet. Podcasts interviewing successful traders, some are notable such as 50pips, Walter Peters & Chris Kapre.
One of the best free online schools which tracks your progress and teaches you heaps on information. The forum is the gem, where many people keep trade journals and put up their strategies. Don't copy them but borrowing concepts and ideas is good.
SUPER IMPORTANT This website is paramount to your success, still in development but will provide users with an easy way to document trades. Success is determined by your willingness to follow through with the boring bits so keep this one in your bookmarks.
The common trait he sees in successful traders, how long it took him to become profitable, the most important trade that made him successful, his favourite books and why they both like Jessica Peletier.
A warehouse worker went through his trials and tribulations to be given the offer of managing an $80 million fund. How he started with $800 and no clue what to do, 2 biggest mistakes he sees traders making, how he continues to improve and what has happened to his lifestyle since becoming a full-time trader.
How Timothy Sykes inspired her, what minimalism is all about and how it's spread to every facet of her life, what her single pair to trade is, what the 2 best traits for successful traders are and plenty more!
What plastic bottles have to do with trading, how much money you need to have to be properly funded and go full-time, how much work you have to do and how long it'll take to get there, 2 best traits to have and loads loads more!
Can you actually trade from a beach? The use of hypnosis to make him a better trader, the method that works with his psychology, how much you need to get started, how long it took him to become profitable and what he would do differently if he had to start over! plus loads more!
Personal Favorite I love this guy because he's true and noble. He is philanthropic, offers trading courses that are cheap and really knows what he's talking about. He explains how a 3 second glance can stop you 2nd guessing yourself, how much he made with $3000 in 6 months and plenty more!
How he's turned some traders around in 30 minutes, why you never trade on a monday, the courses he bought, why he teaches outside the classroom and why he sent his kids to learn chinese.
Edit - I've spent about 2 hours making this now. I hope you guys find it useful! I'll continue to update it and may you all find trading success. If you want to help me out spread the link! put it on forums or share it with friends. Good luck to you all and happy trading! Edit 2 - My brain is fryed... time for a rest. Edit 3 Once I've categorized this post making it easier to navigate i'll be adding books to read, videos to watch & the traders that will help on your journey to self-sufficiency. Happy trading everybody!
In this article, we are going to see what information we need to collect for a manual backtest, particularly in forex; how to gather them, what can be found in a backtesting report and what do they tell us and how we can calculate the information we’ve gathered using Excel. If you are new to backtesting and you want to know what the backtesting is or how we can backtest automatically and ... This post continues the series of video articles about how to use Microsoft Excel to backtest trading strategies. In this post I show how to calculate a stop-loss using the ATR and then how to backtest the trading strategy. For the previous video articles see, An Easy Way to use Excel to Backtest a Trading Strategy – Part 2. The Average True Range BacktestingXL Pro is an add-in used to automatically backtest trading strategies in Microsoft Excel 2010-2016. It is specifically designed for testing end-of-day trading strategies in Excel using historical data. It includes advanced backtesting capabilities that closely mimic real-life trading situations. Sold on MyCommerce. Buy Now. Categories: Analysis & Data, Trading Models Tags ... The trading strategy was backtested on the EUR/USD forex pair on the 1-hour timeframe. The backtest was carried out over three periods of 20,000 1-hour periods (3 years, 3 months). I then combined these backtests and the results are shown in the table below. Criteria Result; Initial Capital: $100,000 : Final Capital: $1,386,579 : Profit: $1,286,579 : Wining trades: $6,858,641 : Losing trades ... Strategy Backtesting in Excel Strategy Backtesting Expert Overview The Backtesting Expert is a spreadsheet model that allows you to create trading strategies using the technical indicators and running the strategies through historical data. The performance of the strategies can then be measured and analyzed quickly and easily. During the backtesting process, the Backtesting Expert runs through ... There are several ways to backtest an Excel trading model.. You can do it visually by recording the buy, sell, and out signals given by your model in an Excel spreadsheet, including the date, time, and theoretical trade prices. This is very slow and cumbersome. Further, backtesting manually only gives you a rudimentary idea of your model’s performance. Using an excel spreadsheet for backtesting Forex strategies is a common method in this type of backtesting. How to Backtest a Trading Strategy Using Excel . Many traders believe that one shouldn't have to be a programmer or an engineer to backtest a strategy. This method takes us back to the very basics, which anyone can use. Spreadsheet programmes such as Excel are among the best ways to ...
How to backtest a MACD Trading Strategy in Excel - Part 1 ...
Today I am demonstrating how to use the onDemand function to backtest lower time frame strategies in ThinkorSwim. I will also demonstrate how to import strat... Part 1 of a video providing a step-by-step guide showing how to build a backtest model using Excel. The backtest is using weekly historical data from the S&P... This video will show you How to Backtest a Forex Trading Strategy, as well as 3 TIPS on BACKTESTING... Trading Platform I Use: https://www.tradingview.com/... This video provides an easy way for anyone to backtest a trading strategy. If you are interested in testing your own trading strategies, there are a range o... FREE Advanced Pattern Tutorial - https://www.thetradingchannel.net/optinpage EAP training program - https://goo.gl/5cP1Z5 Trading view link: https://www.trad... FREE: Advanced Pattern Tutorial - https://www.thetradingchannel.net/optinpage CHECK OUT: EAP Training Program - https://goo.gl/7RrMM5 JOIN: "Advanced Pattern... This video shows how anybody can test their own trading strategies using Excel. I demonstrate how to use historic price data and to calculate technical indic...