Decided to see how the currency checklist held up against all 28 pairs. I’m personally finding it extremely useful to identify pairs that meet my goals. Didn’t think of expanding it beyond the USD pairs initially but I thought of giving it a try against the checklist yesterday and it worked wonders for me. The filter clears to list automatically for tomorrow’s data.
Added the data manually, which is a bit tedious. I’ll probably learn how to code in MQL5 to export a .csv or .txt to get for this high level overview in Notion or Excel. Not high priority atm.
It was a steep learning curve and it wasn’t easy for me. So far it’s proved to be really useful though because I have everything I need in one workspace. Not having to juggle between multiple word docs and excel files is a plus. Having access to the reference material for a quick review when I need it is useful (since I’m still a newbie).
The trade journal has been really powerful because I’m able to tabulate it like excel but attach screenshots of what I saw before trade. Analyzing trades post execution is also easy. Also noticed that while going through the motions of filling data into both journal and currency checklist I reverse a few bad decisions and keep a lot of impulse decision making at bay. Still haven’t tried tradervue or myfxbook and I could just ditch this whole journal idea if I find them better options.
The checklist I thought would be a great initial use to build discipline to study and understand the currency pairs I was working with (wanted to focus on EURUSD, USDJPY, GBPUSD & AUDUSD at first). While using it I quickly realised how it can be used as a screener to determine trending currencies (intend to trend trade only for now) for the 28 pairs. Also thinking of applying it to exotic pairs if I’m able to code the MQL5 csv export.
What challenges did you face? There’s a good chance, I reckon, I’m overlooking some very obvious disadvantages being a newbie.
Edit: Just realised the checklist works for me because I intend to swing or trade intraday. I can’t imagine it being useful for a scalper at all.
The currency checklist was initially included as a novelty. A not so necessary addition included to help build a routine for daily analysis. It’s evolved to something like a screener.
The first draft had raw data for the 28 major pairs. It was there in the workspace to remind me I had to capture data when it became blank (filter set to previous day). Two major changes:
Default view updated to two table views against strong trends and ranges.
Lot more derivations (OHLC data replaced by derivations I find useful and different views for both tables)
I’m not happy I’m getting that many currencies still. Lots of refining to be done over time. Still better than default view and omitting candidates from stricter filters for the moment.
Also created a table for implied options volatilities. Historic data isn’t readily available so I thought I’d capture and upload a csv to the notion table on a daily basis. Novelty item for analysis later down the road. Will get rid of it it’s pointless later.
Economic calendar data is populated in MT5. I can use that to import news events in Notion for a more methodical approach for the analysis of that data. Thought I’d have to wait till I learnt python to scrape online data. Good to know I can do it sooner if needed.
On a personal note I decided against importing exotic pairs for now. Trading’s already difficult with 28 pairs…
Currency Analysis/Forecast table created. Table stores the analysis of currency pairs that were shortlisted wit the help of the Currency Checklist.
Key data like trend direction, projected pip movement & forecast day stored in separate data fields. Also has alerts to remind user to review analysis at later date. Relationship built to Currency Checlkist enables migrating some of the fields to front page and assists in the calculation of a “Projected Target”.
There’s more room for improvement still. For e.g. automate review dates and set for immediate review if projected trend changes or price overshoots target prematurely.
Just found out how date reminders work in Notion after I implemented them in my currency analysis. It basically fires alerts that you can view from anywhere in your Notion workspace.
Still haven’t made one. Very much a Notion newbie. But I’ll figure it out and post it after this weekend, if no complications. I need some time to make changes to my the journal section (where you document your trades), which I’ll explain in another post.
Things that are heavily customized to suit my thought process though:
Currency checklist which is heavily favored for a custom built MT5 csv upload
Currency forecasts, since I made the section in notion, is being used to store the analysis for the 28 pairs. Since a substantial amount of people don’t analyze and keep records of the 28 pairs this might be overkill or redundant.
I have also built table relationships and rollups (fields that bring related fields from related tables) between checklist, forecasts and journal. The workflow I’m still fleshing out in it’s entirety because I’ve just started the process of reviewing older trades. TLDR - I’m still ironing things out. LOL
Optimized the roll-up tables and formula to generate other bits of information like trend direction, pip targets, etc from the analysis/forecasts. Have tested the workflow extensively the past month or so and works really in its:
Ability to draw on the analysis for each of the currency easily from without leaving workspace
Ability to create and edit a trade journal entry, tying it to checklist and analysis
Biggest benefits to the workflow is how elements can be incorporated as part of your trading plan. E.g. Not opening positions if no trade journal entry is made or not opening any trades till you finish reviewing currency pairs due for analysis for the day.
It greatly reduces impulse decision making, if used properly and as intended, and, at the time of trade execution, simplifies decision making to a mostly yes/no decision.
Decided against creating a template. The thread was created with the intention of finding other Notion users and exchanging ideas to improve workspaces/workflows. If someone else wants to use the ideas to develop a template of their own they’re free to do so.
The established filters pop up quite a few potential currency pairs. One way I pick the easier trades is to compare the low and high values from the previous 10 candles without having to open any charts to see price action.
New addition:
Small change in the form a to-do list, above the currency data. Small and almost insignificant modification that, to me, makes a huge difference in maintaining a routine. I’m sure there are definitely better ways to accomplish this for power notion users. This is good enough for me, for the time being atleast. Might evolve later.
Hi there, I also use Notion, mainly to journal my trades and log my my backtesting. The tables are better than traditional spreadsheets and it’s easier to ASR & review my past trades. Although my templates are much more simpler and minimalistic, some of yours have inspired me to try out new new things/templates. Great to see other traders using Notion, and following Hannah FX.
So glad to find another person working on Notion too. Yea, that’s totally the intention. Bounce ideas & hopefully improve whatever process we each have in place
I am starting using Notion as well to journal everything.
I am new in this so I am figuring out how to use it, Was doing a little research on Google and got loved with your template.
Now, I am just making some weekly reviews of my pairs.
May you be able to share it someday? It would be very helpful, bro.
If don’t, thanks anyway.
I am using excel today using an old template that really looks like crap. Spending so many hours on it, it would be nice if it looked nicer. I received a trading journal template for notion that I tried. All good but I’m missing statistics. I haven’t really tested notion out and learned its features. But is it possible to do statistics like winrate in percent, winrate on different strategies. Montly winrate, most successfull pairs and so on? Maybe someone has a template with this that I could try and build from there?
Apologies for the delayed reply. Was away. I’ve honestly not even attempted making a template yet but what concerns me is how personally customized it is for my requirements, like that file upload. And as I’m evolving as a trader I’m also constantly evolving the workspace (getting rid of stuff that helped me earlier but is not as impactful at present).
I took a lot of ideas from stuff I was reading/watching and tried to adapt it to my requirements. Took ideas not only from Hannahforex but also from a few excel templates I came across, reporting template on forex tester 4 and a book by Kathy Lien.
I think my knowledge is limited, compared to most notion power users, but I can share my experience and knowledge from the constant tinkering I do in this area for my benefit if you have specific problem areas.
That’s my biggest gripe with notion to be honest. I’ve not found a way to aggregate the data as easily as you can with an excel pivot table for instance.
There might be workarounds I haven’t explored yet because notion has the ability to sync with google worksheets.There might be a way to build a dashboard in a google worksheet based on a notion import.
You can implement a boolean value using the logic functions though. For e.g. creating a checkbox that automatically populates if a trade is a winner. Here’s an example I did to determine whether I took any trades against the recommendations from my weekly currency analysis.
The issue is that if you wanted to find the winrate for specific periods, currency pairs or strategies you’d have to apply a table filter to arrive at the number. The more specific it is the lengthier the drill-down. It’d not fulfill your requirement though if you wanted to tabulate the win-rate for all the currencies/strategies or wanted to find say the top 5/bottom 5 like you can with a quick excel pivot table.
It’s exactly the winrate for different strategies that I’m after. Maybe I should just investigate excel pivot table since I wasnt aware of the function. Thanks!
This might hep. I created a gif where I created a quick excel pivot table here. It’s really useful for drilling down into your data and is quick to apply with a little bit of practice.
Notion just implemented simple tables a few days back. I haven’t tried it out yet. This might open up a few possibilities.
