Free Trading Log Spreadsheet Forex Trading Strategies

Record keeping and review ideas?

Hi all, noob here and I just wanted to say that I really enjoy reading all your ideas and insight. I’m just learning about forex after a long period trading shares and options. I just want to know what you all use to record and analyze your trades? I have been looking at Trading Journal online but there are a few things I would like to add to it. I want to be able to record/sort trades with different strategies, markets etc etc then able to easily look at stats on what is more profitable and review performance issues etc. I just use a spreadsheet for my share trading, but I thought that I might see if there is anything that other people use that they find useful - maybe also something I can upload a screen snapshot of my set up into. You never know if you don’t ask right?
submitted by higgeldypiggeldy1 to Forex [link] [comments]

Removed comments/submissions for /u/bobbyjasonsnype

Hi bobbyjasonsnype, you're not shadowbanned, but 5 of your most recent 41 comments/submissions were removed (either automatically or by human moderators).

Comments:

fsaxens in Forex on 30 May 20 (1pts):
It’s not so much where you journal trades, it is more about HOW you journal your trades. A simple spreadsheet where you record your trade details/history is effective enough.
What you really want...

Submissions:

hbm1ij in wallstreetbets on 18 Jun 20 (3pts):
F 🌈 🐻 s, THETA GANG
gchis2 in wallstreetbets on 03 May 20 (0pts):
Requesting all Autists
g1ego7 in wallstreetbets on 14 Apr 20 (3pts):
Finding Key Levels of Support and Resistance
f1tey7 in FreeEBOOKS on 10 Feb 20 (1pts):
Textbook Needed
I'm a bot. My home is at /CommentRemovalChecker - check if your posts have been removed! (How to use)
Help us expose and stand up to social media bias and censorship!
submitted by MarkdownShadowBot to CommentRemovalChecker [link] [comments]

Journaling 101

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.

Why Journal?

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.

Other notes

submitted by confluencefx to Forex [link] [comments]

My experience with Norbit's Gambit [google sheets link included]

Just want to share my experience doing Norbit's Gambit, for anyone that may want to learn on my experience, or tell me all the ways in which I am wrong.
I've posted a question earlier, asking how to make sure the market didn't swing in the wrong direction. And yes, I understand it's called a "gambit" for a reason.
=== TL;DR === - Wanted to save $65 on currency conversion while buying CAD $3,500 worth of US stock - Overestimated forex fee, underestimated NG cost - Murphy happened... - Lost potential gains of CAD $185.80 while waiting - Is the gambit ever worth it?
=== The goal === - On August 25th, use about CAD $3,500 to buy some US Netflix (NFLX) shares
=== The method === - Buy DLR in CAD - Call brokerage to journal over to US side - Sell DLR.U in USD - Buy NFLX with USD
In a lot of my research, I've been told the "fee" when going through the brokerage (Questrade in my case) is 2%. That's not too accurate.
=== The brokerage Forex rate/fee === So I assumed 2% of $3,500 would be $70.
However it's really an addition of 199 basis points to the exchange rate. I believe they use the closing exchange rate on the date of the transaction.
So if the exchange was 1.2500, it's 1.2699, and $CAD 1000 nets $USD 787.46 ($USD 12.54 short of ideal $USD 800). If we convert 12.54 to CAD, it's $CAD 15.68 or 1.568% on the original $CAD 1000.
But if the exchange is 1.2200, it's 1.2399, and $CAD 1000 nets $USD 806.51 ($USD 13.16 short of ideal $USD 819.67). If we convert 13.16 to CAD, it's $CAD 16.06 of 1.606% of the original $CAD 1000
The "conversion fee" is dependent on the exchange rate, but I can't figure out a quick direct way to calculate what the "fee" would be in source currency %. The closest guesstimate is to divide the basis points by the current exchange rate, as below:
On August 25th, the exchange rate was 1.2483. So the above guesstimate for the Forex "fee" would be $55.80. Or more accurately $54.91, close enough. Still, that's 21.5% lower than the broad *$70** estimate earlier.*
=== The NG effective fee === Here once again, the common consensus is that the NG's fee is just a cost of buying and selling an ETF. So, with QT's free ETF purchases, the guesstimate is just about $5 for the selling commission.
When I bought DLR ETF on August 25th, I got it for CAD $12.42 per share (that's not the day's close price, but what I actually paid). the US side of DLR.U is always US $9.93. The gives the DLR Exchange Rate of 1.2508... already different from the ideal 1.2483 (I suppose that's how the ETF makes money)
So, it would appear the cost/fee of NG is just CAD $0.99 + US $5.94 (CAD $8.40)... but not quite. Let's look as the actual US dollar amounts. Since we can only buy whole shares of DLR + ECN fee, from this point I am converting CAD $3,502.44 + $0.99 = $3,503.43
The difference between the ideal US $amount and what I am left with is the "fee" for doing NG. US $12.24, or CAD $15.28. This sets the NG's Effective Exchange Rate as 1.2538 or a "NG's fee" of 0.44%. Please note that this rate/fee is *based on the converted amount*: the more you convert, the less/cheaper it is.
So comparing the actual cost of NG vs QT's auto conversion and the guesstimates is quite different - Actual $15.28 vs $54.91 ($39.63 spread) - Guesstimate $5 vs $70 ($65 spread)
=== The Time factor === Now that I have US $2,794.32, let's buy some NFLX. The date now is Sept 5th (yes, the NG completed earlier, but I am human... also QT didn't call me when the journaling was completed so I got sidetracked).
Before doing the NG, I calculated that NFLX dropped about 2.02% in 10 days. It could also go up by same amount. That 2.02% rise on CAD $3,500 value would be a gain of $70.7... comparable to $65 guesstimate loss of doing currency auto-conversion through QT (QTAC). So in my analysis, at worth case it would be a wash, in best case I save some money on NG. ... We already know now that the actual cost of QTAC is much less ....
This was the end result of my NG: spent CAD $3,503.43 and 11 days later I have a US stock+cash Portfolio of value US $2,789.37
But considering the increase in NFLX stock over those 11 days, what if I would have just went with Questrade's Auto-conversion (QTAC) route?
In 11 days, the value of NFLX is @178.79 - Current value of 16 NFLX shares = US $2,860.64 - Plus cash US $77.57 for a Total Portfolio Value of US $2,938.21
If, on August 25th, I would have auto converted currency with QT and bought NFLX, I would have a portfolio value of US $2,938.21 on September 5th.
Instead, starting the Norbit's Gambit on August 25th, I bought NFLX on Sept 5th and have a portfolio value of US $2,789.37
Instead of saving a guesstimate of CAD $65, I have lost potential gains of US $148.84 or CAD $185.80
=== Murphy... or Loonie... whatever === In all of above, I tried to keep the currency fluctuations isolated. So apart from initial conversion on August 25th, all my future (September 5th) portfolio values were in USD. But as Murphy would have it, the BoC rate announcement made the loonie stronger in between my NG.
Based on above, doing QT auto-conversion - On August 25th, nets US $2,762.52 - On September 5th, nets US $2,817.62 I would have got US $55.10 more just by doing the QTAC later.
If I would have bought NFLX on September 5th after doing QTAC - 15 whole shares @178.79 + $4.95 comm leaves me with US $130.82 in cash - Total NFLX + Cash portfolio value of US $2,812.67
That's still US $23.30 more than doing the NG, although still less than just buying NFLX outright on August 25th and letting it grow.
=== Final conclusion === Smaller amount (CAD $3,500) for NG for a stock purchase that could/did swing 6% was not worth it. Loonie getting stronger also made the whole exercise fruitless, but even eliminating the currency fluctuation, the growth of the stock outperformed the savings of NG.
Playing with my numbers, assuming the currency fluctuation is fixed, for CAD $3,500, doing Norbit's Gambit vs Questrade's Auto-Conversion is breaking even when the stock appreciation is no more than 1.18% during the time it takes to complete NG (11 days in my case). Even if you are more punctual and can complete it in 5 days, you still need to make sure the stock doesn't appreciate more than 1.18% in 5 days.
By comparison, if converting CAD $10,000, it's break even if stock rises 1.27% during that time. When doing CAD $50,000 then 1.31%
Hmm.... so even at high amounts of CAD $50,000 the tolerance to stock fluctuation is pretty low. So is it worth it?
Ultimately I've:
For anyone that cares, here is public Google Sheets docs to verify my math (File -> Make a copy, in order to edit values) https://docs.google.com/spreadsheets/d/12nH8Q_0cKFtFTW_yomASHtpLXN6oYuTgkXeTNAMkQGY/edit?usp=sharing
submitted by hydraSlav to PersonalFinanceCanada [link] [comments]

How I Make My Forex Trading Journal! - YouTube How to create Simple Trading Journal - Excel Trading ... Free Trading Journal (UPDATED - Excel Spreadsheet) - YouTube Forex trading journal spreadsheet - YouTube #1 Forex Trading Journal - Excel Spreadsheet Template ...

I think we all know that using a trading log for our trading activities is pretty vital to ensure we are moving forward in our trading profits. Sometimes we are so tuned into simply learning a system we forget that we have real money on the line. I came across a trading log spreadsheet that you can use in your own Forex trading. The Trading Journal Spreadsheet began in 2005 as a way to track my own personal trading progress.By early 2007, I had shared what I created with a handful of other trading cohorts. They all loved it, and more importantly, they benefited from the analysis it provided, and were adamant that it should be available to other aspiring traders. The Trading Journal Spreadsheet began in 2005 as a way to track my own personal trading progress.By early 2007, I had shared what I created with a handful of other trading cohorts. They all loved it, and more importantly, they benefited from the analysis it provided, and were adamant that it should be available to other aspiring traders. Creating a simple Forex trading journal spreadsheet to track and analyze trades is not too difficult, however, not everyone knows how to do this. To that end, I’ve found a pretty good free Forex trading journal spreadsheet. I cannot take credit for creating it. It was uploaded by one fxgorilla over at forexfactory.com. I’ve tested this, and I think you guys might find it pretty useful for ... Supports: Stocks, forex, futures, CFDs, spread betting Pricing: $169. Edgewonk is downloadable trading journal software that offers pretty deep analysis of your trades. The upside is the customization possibilities pending you enter in detailed notes and tags for each trade. Also, since it is software, you only need to pay for it once; there is no monthly subscription. The downside is that the ... A Forex Trading Journal to Track Your Performance - Today's article is going to discuss one of the most important pieces of the puzzle of professional Forex trading; creating and maintaining a Trading Journal Spreadsheet. I am going to first explain to you why having a Forex trading journal is essential to becoming a professional trader, and then I am going to show you what my trading journal ... This can be used as a Forex trading journal. In this video – ‘How I Use My Excel Spreadsheet Trading Journal’ I briefly talk about the different options available when it comes to choosing what to actually create your trading journal in – mainly Microsoft Excel or Evernote. I then move on to what information you should record in your journal spreadsheet. I show you my personal trading ... Trading Journal Spreadsheet Download. I’ve had quite a few requests for a copy of the spreadsheet I use for my trading journal. I uploaded it to the server so feel free to download a copy if you’re interested. It’s not the most elegant spreadsheet but it does what I need. Here’s some details about the columns included: Expectancy: An average of column K (R Multiple). This formula must ... Conclusion Forex Trading Journal Excel Spreadsheet. These are some ideas; there are dozens of other questions that a journal can help answer. With this, we do not want to tell you to analyze the trades more than necessary because then we fall back to the opposite problem, the so-called analysis paralysis (the psychological block because of excessive analyzes). However, a successful trader is ... Get Forex trading journal here. Earn Forex XLS / Spreadsheet Journal. This is the simplest and most straightforward journal on this list. It is a spreadsheet / xls journal you can download, save and use as you need and see fit. This journal has the capability to track profit and loss, show updated balances and how your account is tracking.

[index] [23248] [9957] [17627] [16052] [28457] [8398] [26445] [825] [27300] [4343]

How I Make My Forex Trading Journal! - YouTube

In this video I talk you through the new updated versions of my free trading journal. I run through all the new updates that are specific to each of the spre... I show you guys how you can make your own forex trading journal using Google Sheets. Please LIKE if you want to see more like this! GET MORE OF ME! Insta: @t... This Video shows how to create Simple Trading Journal. you can take it to next level by adding formula, Graphs and so on. ⌚️ What's in this Video? : 00:00 Cr... A forex trading journal is useful for all aspects of trading from improving trade profitability, trading psychology and decision making. The trading journal ... Forex trading journal spreadsheet http://need-goods.com/forex Aqui você pessoalmente vai disse sobre forex trading iq option. Por sua vez aqui presente infor...

http://arab-binary-option.felcabomars.ml