Hi there everyone. submitted by
A friend of mine does some trades (not sure if this is the right terminology) on forex and since he was having success in it I decided to create an excel spreadsheet so he could track his losses and profits along with some other data. However none of the formulas that I have tried correctly calculate the outcome of a trade.
I am not very familiar with forex myself so I tried searching for that formula or just a way to calculate the profit so I could put that in the excel, but sadly no luck anywhere.
Could anyone let me know how to do it or explain how it's calculated? Thank you in advance!
I am posting this as I hope it will help other Australian options traders trading in US options with their tax treatment for ATO (Australian Tax Office) purposes. The ATO provides very little guidance on tax treatment for options trading and I had to do a lot of digging to get to this point. I welcome any feedback on this post.
The Deloitte Report from 2011
My initial research led me to this comprehensive Deloitte report
from 2011 which is hosted on the ASX website. I've been through this document about 20 times and although it's a great report to understand how different scenarios apply, it's still really hard to find out what's changed since 2011.
I am mainly relating myself to the scenario of being an individual
and non-sole trader
(no business set up) for my trading. I think this will apply to many others here too. According to that document, there isn't much guidance on what happens when you're an options premium seller and close positions before they expire.
Note that the ATO sometimes uses the term "ETO" (Exchange Traded Option) to discuss what we're talking about here with options trading.
Also note: The ATO discusses the separate Capital Gains Tax ("CGT") events that occur in each scenario in some of their documents. A CGT event will then determine what tax treatment gets applied if you don't know much about capital gains in Australia.
ATO Request for Advice
Since the Deloitte report didn't answer my questions, I eventually ended up contacting the ATO with a request for advice and tried to explain my scenario: I'm an Australian resident for tax purposes, I'm trading with tastyworks in $USD, I'm primarily a premium seller and I don't have it set up with any business/company/trust etc
. In effect, I have a rough idea that I'm looking at capital gains tax but I wanted to fully understand how it worked.
Initially the ATO respondent didn't understand what I was talking about when I said that I was selling a position first and buying it to close. According to the laws, there is no example of this given anywhere because it is always assumed in ATO examples that you buy a position and sell it. Why? I have no idea.
I sent a follow up request with even more detail to the ATO. I think (hope) they understood what I meant now after explaining what an options premium seller is!
First, I have to consider translating my $USD to Australian dollars. How do we treat that? FX Translation
If the premium from selling the options contract is received in $USD, do I convert it to $AUD on that day it is received?
Subsection 960-50(6), Item 5 of the Income Tax Assessment Act 1997 (ITAA 1997) states the amount should be translated at the time of the transaction or event for the purposes of the Capital Gains Tax provisions. For the purpose of granting an option to an entity, the time of the event is when you grant the option (subsection 104-20(2) ITAA 1997).
This is a very detailed response which even refers to the level of which section in the law it is coming from. I now know that I need to translate my trades from $USD to $AUD according to the RBA's translation rates
for every single trade. But what about gains or losses on translation?
There is one major rule that overrides FX gains and losses after digging deeper. The ATO has a "$250k balance election
". This will probably apply to a lot of people trading in balances below $250k a lot of the FX rules don't apply. It states:
However, the $250,000 balance election broadly enables you to disregard certain foreign currency gains and losses on certain foreign currency denominated bank accounts and credit card accounts (called qualifying forex accounts) with balances below a specified limit.
Therefore, I'm all good disregarding FX gains and losses! I just need to ensure I translate my trades on the day they occurred. It's a bit of extra admin to do unfortunately, but it is what it is.
This is the scenario where we SELL a position first, collect premium, and close the position by making an opposite BUY order. Selling a naked PUT, for example. What happens when you open the position?
The option is grantedCGT event D2 happens when a taxpayer grants an option. The time of the event is when the option is granted. The capital gain or loss arising is the difference between the capital proceeds and the expenditure incurred to grant the option.
This seems straight forward. We collect premium and record a capital gain. What happens when you close the position?
Closing out an optionThe establishment of an ETO contract is referred to as opening a position (ASX Explanatory Booklet 'Understanding Options Trading'). A person who writes (sells) a call or put option may close out their position by taking (buying) an identical call or put option in the same series. This is referred to as the close-out of an option or the closing-out of an opening position.
CGT event C2 happens when a taxpayer's ownership of an intangible CGT asset ends. Paragraph 104-25(1)(a) of the ITAA 1997 provides that ownership of an intangible CGT asset ends by cancellation, surrender, or release or similar means.
CGT event C2 therefore happens to a taxpayer when their position under an ETO is closed out where the close-out results in the cancellation, release or discharge of the ETO.
Under subsection 104-25(3) of the ITAA 1997 you make a capital gain from CGT event C2 if the capital proceeds from the ending are more than the assets cost base. You make a capital loss if those capital proceeds are less than the assets reduced cost base.
Both CGT events (being D2 upon granting the option and C2 upon adopting the close out position) must be accounted for if applicable to a situation.
My take on this is that the BUY position that cancels out your SELL position will most often simply realise a capital loss (the entire portion of your BUY position). In effect, it 'cancels out' your original premium sold, but it's not recorded that way, it's recorded as two separate CGT events - your capital gain from CGT event D2 (SELL position), then, your capital loss from CGT event C2 (BUY position) is also recorded. In effect, they net each other out, but you don't record them as a 'netted out' number - you record them separately
From what I understand, if you were trading as a sole tradecompany then you would record them as a netted out capital gain or loss, because the trades would be classified as trading stock
but not in our case here as an individual person trading options. The example I've written below should hopefully make that clearer. EXAMPLE:
Trade on 1 July 2020: Open position
- SELL -1 SPY 85 PUT, exp 30 August 2020
- Collect Premium USD$1 per unit, and brokerage USD$5
- = USD$100 premium collected, minus USD$5
- = Net amount of USD$95 collected
- FX Translation rate on the date of the trade: AUD $1.00 = $USD 0.70
- Net Premium Collected in $AUD
- = USD$95 x (1/.7)
- = AUD$135.71
- CGT Event D2 triggered and a capital gain of $135.71 is recorded
Trade on 15 July 2020: Close position
- BUY 1 SPY 85 PUT, exp 30 August 2020
- Pay Premium $0.50 per unit, and brokerage $5
- = $50 premium paid, plus $5
- = Net amount of USD$55 paid
- FX Translation rate on the date of the trade: AUD $1.00 = $USD 0.60
- Net Premium Collected in $AUD
- = USD$55 x (1/.6)
- = AUD$91.66
- CGT Event C2 triggered and a capital loss of $91.66 is recorded
We can see from this simple example that even though you made a gain on those trades, you still have to record the transactions separately, as first a gain, then as a loss. Note that it is not just a matter of netting off the value of the net profit collected and converting the profit to $AUD because the exchange rate will be different on the date of the opening trade and on the date of the closing trade we have to record them separately.
What if you don't close the position and the options are exercised?
The option is granted and then the option is exercisedUnder subsection 104-40(5) of the Income Tax Assessment Act 1997 (ITAA 1997) the capital gain or loss from the CGT event D2 is disregarded if the option is exercised. Subsection 134-1(1), item 1, of the ITAA 1997 refers to the consequences for the grantor of the exercise of the option.
Where the option binds the grantor to dispose of a CGT asset section 116-65 of the ITAA 1997 applies to the transaction.
Subsection 116-65(2) of the ITAA 1997 provides that the capital proceeds from the grant or disposal of the shares (CGT asset) include any payment received for granting the option. The disposal of the shares is a CGT event A1 which occurs under subsection 104-10(3) of the ITAA 1997 when the contract for disposal is entered into.
You would still make a capital gain at the happening of the CGT event D2 in the year the event occurs (the time the option is granted). That capital gain is disregarded when the option is exercised. Where the option is exercised in the subsequent tax year, the CGT event D2 gain is disregarded at that point. An amendment may be necessary to remove the gain previously included in taxable income for the year in which the CGT event D2 occurred.
This scenario is pretty unlikely - for me personally I never hold positions to expiration, but it is nice to know what happens with the tax treatment if it ultimately does come to that.
What about the scenario when you want to BUY some options first, then SELL that position and close it later? Buying a CALL, for example. This case is what the ATO originally thought my request was about before I clarified with them. They stated:
When you buy an ETO, you acquire an asset (the ETO) for the amount paid for it (that is, the premium) plus any additional costs such as brokerage fees and the Australian Clearing House (ACH) fee. These costs together form the cost base of the ETO (section 109-5 of the ITAA 1997). On the close out of the position, you make a capital gain or loss equal to the difference between the cost base of the ETO and the amount received on its expiry or termination (subsection 104-25(3) of the ITAA 1997). The capital gain or loss is calculated on each parcel of options.
So it seems it is far easier to record debit trades for tax purposes. It is easier for the tax office to see that you open a position by buying it, and close it by selling it. And in that case you net off the total after selling it. This is very similar to a trading shares and the CGT treatment is in effect very similar (the main difference is that it is not coming under CGT event A1 because there is no asset to dispose of, like in a shares or property trade).
Other ATO Info (FYI) The ATO also referred me to the following documents.
They relate to some 'decisions' that they made from super funds but the same principles apply to individuals they said.
The ATO’s Interpretative Decision in relation to the tax treatment of premiums payable and receivable for exchange traded options can be found on the links below. Please note that the interpretative decisions below are in relation to self-managed superannuation funds but the same principles would apply in your situation [as an individual taxpayer, not as a super fund]. Premiums Receivable: ATO ID 2009/110
- Key quote from this decision: CGT Event D2 will apply on the writing of an ETO by the Fund. The Fund as grantor of the option will make a capital gain (or loss) of the difference between the capital proceeds (that is, the premium receivable) and the cost of granting the option (for example, brokerage fees) at the time the option is granted
- My take on this is that you will realise a capital gain on issuing of the selling position. I don't see how you could realise a capital loss in that scenario? Or maybe if you sell a position and the brokerage is so high that it outweighs the premium received (a dumb trade) then that would be a capital loss (a rare scenario).
- Premiums Payable: ATO ID 2009/111
- Key quote from decision: When the Fund opens a position by buying an ETO, no immediate taxation consequences arise. CGT Event C2 will happen to the Fund when its position under an ETO is closed out where the close-out results in the cancellation, release or discharge of the ETO
- Don't forget to declare your trades on your tax return and keep a nice spreadsheet
- Keep track of the exchange rates for each day you make a trade. You could do as you go and check the RBA exchange rates website for the daily number, or just do it all at once at the end of the financial year
- Finally - I recommend ensuring that you save a portion of your income to pay the capital gains tax at the end of the year so you don't have to withdraw it from your portfolio and pay exchange rate fees to convert it back to Australian dollars. It will depend on your marginal tax rate what that percentage will work out to be in the end.
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. submitted by
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
- Raw Winrates:
- 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%
- Winrate: 46.4%
- 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%
- Winrate: 65.97%
- 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
- Raw Winrates:
- 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:
- Winrate: 58.19%
- 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.
Raw Data 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
- Winrate: 58.19%
- 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!
- 86 Trades
- Date range: 7/9-7/30
- Winrate: 52.32%
- 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.
Use Forex Education Profit Calculator to understand how much you can earn on trading with different pairs, time periods and a lot more. Best Forex broker 2019 Open account Log in en FX Trading Trading platforms Referral program Promotions Analysis & education Copytrading Your Finances. Trading conditions ... Evaluate and compare the results of several possible market scenarios. Through Profit/Loss (Forex) calculator you can quickly assess the possible profit or loss and consider this information while choosing the trading instrument and strategy. Set Deal volume, Open and Close price, choose directon of trade (Buy/Sell) and press "Calculate". At the link below you will find the Forex Trading Income Calculator in Excel spreadsheet format. The calculator shows the possible income projections based on the desired risk, amount of capital, type of lot size used, and the PIP value for major USD pairs. The following notes apply. Lot Size = The lot size you… Forex Profit Calculator Spreadsheet. Posted by webmaster May 31, 2020 May 31, 2020. Wie kann ich am wochenwnde mit anyoption geld verdienen. Hedging strategien forex. Fina bitcoin. Bitcoin transactions queue. Can… Geld verdienen flaschen sammeln. 12400 bitcoins. Bitcoins kaufen wenner steigt. Bitcoin mining 980 ti. Kryptowährungen erfolgreich handeln. Unter anderem können Sie sowohl von ... Forex Pips (Profit/Loss) Calculator. quantity. Add to cart. Send Question. This Excel Workbook made to help people calculate the Profit and Loss in pips (Daily/Weekly/Monthly) – Unlocked WorkBook (Editable) (Protected with no passwd) NOTE : I have a GBP Version, after buying the current USD Version, contact me on Telegram to send you the GBP one. (You will find the contact detail in the same ... Our profit and loss calculator will help you find out how much you stand to lose or gain if your stop-loss and/or take-profit levels have been reached. Select your base currency, the currency pair you are trading on, your trade size in lots and account type. Set the opening price and your stop loss and take profit values. Calculating Forex Profit and Loss. Online forex trading offers number of distinct advantages. Besides real time rates, your profit and loss is calculated on real time basis by the forex trading software and is displayed live online. Even though this is an important advantage in forex trading account but I strongly recommend that you must be aware about the methodology to calculate your profit ...
Build a Free Forex Trading Journal Using Excel Spreadsheet There is no doubt about the importance of having a Trading Journal for your Forex Trading career, ... Got questions? Drop Me A Line Email: [email protected] Connect With Me On Facebook http://www.Facebook.com/eddieharveyfanpage Follow Me on Twitter htt... IMPORTANT: I have updated the video with an important new feature that you can find here: https://www.youtube.com/watch?v=CPlx8nmuXgE&t=169sHow to Build A Forex... http://www.informedtrades.com/ A lesson on how to calculate profits and losses in the forex market for active traders and investors in foreign exchange and c... Quick explanation of my risk/reward spreadsheet. Click this link to download for free: https://drive.google.com/open?id=0BzJh5rMoj57MMjdINVNXaUdaSXc How to calculate pips in forex trading? A lot of people are confused about pips forex meaning and the forex trading pip value. You need the value per pip to ...