How to Create a Day Trading Journal & Data Collection Spreadsheet

In this video, I show you how you can create your own day trading journal to track your backtested or live trades and also a spreadsheet that allows you to collect data around the strategy you trade.
How to Create a Day Trading Journal & Data Collection Spreadsheet
Recommended Resources:
💰 Access Investor Capital: bit.ly/Darwine... - €20 Off: dw201235zrUNL
💻 Prop Firm: bit.ly/FundedE...
📔 Automated Journal: bit.ly/SwiftJo...
📈 Analysis Software: bit.ly/MyCharting
SOCIALS:
📱 Instagram - / ryantradesfx
// DISCLAIMER
This video is intended for entertainment and educational purposes only. I am not a financial advisor and any concepts or theories should always be tested on a demo account before being taken to the live markets. Your trading/investments are solely your responsibility.

[@RyanTradesFX]

Take your trading to the next level with my new and improved automated spreadsheet that has a dedicated Data Breakdown section. Watch here: kzbin.info/www/bejne/bKDMZ4uaoNJob8U

[@Beingtoorandom]

PLS WHEN YOU WANT TO CALCULATE THE WIN PERCENTAGE @9:50 WHAT IS THE FIRST SIGN YOU PRESS @RYANTRADES

[@Beingtoorandom]

CAN YOU WRITE THE FORMULA OUT PLS 🙏. I CANT SEE THE FOMULA

[@Beingtoorandom]

I GET THE ISSUE NOW ITS BECAUSE I DIDN'T INPUT A WIN OR LOSS. THANKS FOR THE Video MAN 🤙

[@RyanTradesFX]

@@Beingtoorandom No worries 👍

[@sanaullahsuk]

WHAT THE F bro i spend one hour creating this one then in comment section there is new one bro thank you for creating this video now i will make the new one

[@GalacticEchoHuch]

This is the formula of the time in case it's not clear =if(D2="","",D2-C2)

[@kennethmlgaard]

I can't get the formula to work.

[@GalacticEchoHuch]

@@kennethmlgaard I think the problem you're facing is that it's not exactly D2-C2 for you it might be other letter depending on the column you're putting it in... the formula is correct but the column's letter where he puts it is different from the one you used. so either put it at the same column as in the video or just change the letter from D (for example) to the one you're using... Hope you see what I mean.

[@djiorroburkit7976]

bless your soul

[@motv9185]

I’m doing it on the same colum he is and it doesn’t work

[@yanisadjahi4677]

same thing for me, tell me if you found the problem please@@motv9185

[@biscaynebuckets]

Banger. I wish I could like this vid 1000x. Well done, Ryan.

[@WangdaSh605]

Exactly what I was searching for. Loved it.

[@RyanTradesFX]

Thank you mate

[@MomIsrael]

just made my first automated trading journal with this video and i am so relieved!

[@WaveAction777]

With your win percentage, you can also have a "dollar value win percentage". This will give another dimension, because an extremely large loss in a trade will be reflected. Instead of having that extreme loss having the same value weight-wise as a very small loss.

[@keheliyakaushalya3486]

can u elaborate on how to do that

[@navellparham5207]

Thank you for this bruv couldn't have asked for a better introduction to data collection!

[@RyanTradesFX]

You’re welcome!

[@ahmadjudet]

Very inspiring! Currently, I still focus on learning in the NFC community. Every day brings new insights and opportunities to grow.

[@tobiemmanuel2595]

You’ve done so well for me Ryan thank you so much

[@RyanTradesFX]

Glad it helped!

[@chris26022]

great vid! can a future vid be more examples of your data collection please and thank you. So many traders forget how important this process is. Thanks again!

[@RyanTradesFX]

For sure man! Thanks for the kind words

[@Aylingfx]

Legend! Thanks for the help! On the open time I’m trying to put 630am and it seems to only know whole numbers. Do you know how I fix this?

[@aaronmulligan5973]

Brilliant video mate exactly what I needed THANK YOU!

[@RyanTradesFX]

Glad it helped mate

[@sebastiankaufmann3037]

Thanks Ryan, this takes me a big step further 🤗

[@rikoatic9207]

amazing video, thanks! updated my sheet to exatly how I want it.

[@ixmar9994]

Thanks for the guide! exactly what i was searching for - right off the bat.

[@RyanTradesFX]

Glad I helped. Thanks for watching!

[@ianroley7965]

Starts at 1:19 - "The day we're trading - like Monday, Tuesday etc...." so glad you obviously clarified that obviously cuz I obviously was already obviously stuck on the word obviously "Day" and obviously what obviously that obviously actually obviously meant.....

[@user-pt3po4yk6w]

GOD BLESS YOU MY FRIEND👏👏👏

[@bertusmoiane2614]

THANK U LOTS MATE!!!

[@bobbysworld7278]

Nice video good start for me with recording data, was struggling earlier, will check the other advance spreadsheet video soon. Thx

[@joshuagrundy6039]

Good stuff,just saved me £200 a year

[@RyanTradesFX]

Nice one bro 👌

[@maryanmohamed6818]

Thank you Ryan Really appreciate this video.

[@engineer14]

Hi Ryan, how do you get %WIN on flip or extreme? Thanks

[@Zexor_Xd997]

THANK YOU SO MUCHHH

[@harshithud3980]

Formula =if(D2="","",D2-C2)

[@KentaGauba]

SOLID TUTORIAL, Thanks bro!

[@jasonglaze8981]

Very helpful video, thank you very much

[@clintonoumaomondi608]

Thank you @RyanTradesFx for this gem of an insight. Could you please help in shedding insight on how you treat B.E trades, and those trades which you took partial/ closed along the way? How do you treat and incorporate such data in your journal entries?

[@RyanTradesFX]

I don't personally take partials so it's not something I record, there will be a way you could record that information though

[@factos1903]

THANKS MAN IT HELPS A LOT

[@RyanTradesFX]

You're welcome man!

[@Phura3534]

Thank you MAN, I needed it

[@RyanTradesFX]

You’re welcome!

[@kecradan]

Thanks for this Ryan, great video.

[@RyanTradesFX]

Thank you for the kind words Kevin, appreciate it!

[@jeffgoodman7117]

You have saved my head

[@peterogede8055]

Great content. Thanks man

[@MotiBot684]

Tanks bro 🤝

[@forexplorers]

quite helpful

[@DonEge800]

Can’t get the function to work on sheets. It says error and I have done it like in the video. Also I have the right columns in the function.

[@raphaeldeguzman7417]

IS IT POSSIBLE TO, LIKE, PUT COUNTERS FOR ASIA/LONDON/NY SESSION WINS, LOSSES, LONG & SHORT (AND WIN PERCENTAGE) SO I know which sessions do I win/lose on the most, and if i'm better at long or shorts.. seems like a crucial piece of information. also the entry type, so i know what entry type do I win the most on and on what entry type do I lose the most on. EDIT: ok i learned how to do it online, and it's perfect.

[@user-hj6gg4vm4s]

thank so much brother but please can you help with the code for the calculation of win and loss it looks blurry

[@shamshersingh3398]

you are awesome brother thank you so much

[@RyanTradesFX]

Thank you!

[@_f_6957]

Huge help mate. Thank you

[@RyanTradesFX]

Glad it helped mate 👍

[@naijapin9377]

Good morning bro, thank you for the video. I would like to know how to input the number of flip which were winners

[@hohoho488]

THANK YOU VERY MUCH. YOUR VIDEOS ARE USEFUL

[@RyanTradesFX]

Thanks for the kind words 🙏

[@josephnyirongo2152]

Thanks a lot man appreciate it

[@abel_k]

very helpful video thank you!!!

[@RyanTradesFX]

Thanks for the kind words 🤝

[@gamerbacondude9816]

Thank you so much❤

[@nosieooze9585]

This was a amezing video, thank you

[@RyanTradesFX]

Thank you for the kind words 🙏

[@UncertainSalmon23]

Thank for this man!

[@RyanTradesFX]

You’re welcome bro!

[@thilinadissanayake1463]

THANK YOU FOR THE GREAT VIDEO

[@RyanTradesFX]

Glad it was helpful!

[@SwitchMaxFX]

Thank you!!

[@Starrlight2]

Love this, thanks

[@RyanTradesFX]

You're welcome

[@willyumlevenberg]

Nice video. Why don't you make this doc template available for all?

[@LordP_Calmness]

The formula for Win or loss is =countif( you select the outcome,"Win or loss") Enter

[@EricButler1]

does flip and extreme mean reversal and continuation? I'm trying to understand these terms. looks like they're entry points but what points?

[@YousefAziz05]

Really helpful, thank you

[@RyanTradesFX]

Glad it helped!

[@octaviusbrightwell6215]

great info. I wish it were bigger and clearer tho to better see what you are doing! Thanks!

[@RyanTradesFX]

Check out my latest video! Updated version

[@breakaway2181]

Great content

[@davedot1214]

amazing! thank you!

[@RyanTradesFX]

You're welcome!

[@Deepanshu371]

is this better then notion ? can we able to do these calculations in notion

[@david-gv2ro]

thank you

[@emmanuelbakopoulos4807]

thank you🙏🙏🙏

[@viktorbocklandt6120]

Where i can find the codes for that atomatic part because i can't see them on the screen its blurry.

[@stefanosfx]

Thank you for this. Do you know what the formula would be if I wanted to collect data on win rate based on some dropdowns of lets say a specific setup on a specific timeframe on a specific day?

[@stefanosfx]

In a separate table to the side

[@RyanTradesFX]

do you mean testing multiple setups on the same spreadsheet?

[@ningggg6974]

@@RyanTradesFX Yes. the win rate of a setup.

[@RyanTradesFX]

Yeah it would be a sumifs formula

[@m.parvez]

Amazing absolutely awesome work. only I couldn't make the time duration formula. for example, I open a trade today at 12:00 and close tomorrow at 13:00 how that formula be? could you help me with that it would be highly appreciated .

[@nishipishi]

did you figure it out, I'm having the same problem

[@ndnym4443]

thank you so much!! subscribed (:

[@RyanTradesFX]

Thank you!

[@t-tube7946]

Thanks you very much 😊

[@Drïqstars]

Nice content

[@RyanTradesFX]

Thank you

[@ynedi]

What a legend thanks

[@RyanTradesFX]

You're welcome

[@esdee_sd]

Splendid! 💥

[@RyanTradesFX]

Thank you bro!

[@Circlejutkers]

Drop down isn’t there ????

[@NandoWonsong_]

thank you for this

[@RyanTradesFX]

No worries mate thanks for watching!

[@zackbyzker]

GREAT JOB MAN ! I HAVE TRIED MANY TIMES TO DO THE FORMULA IN CALCULATING THE WONNING PERCENTAGE AND ALL THE EQUATIONS BUT IT DOESNT WORK FOR ME ! I DONT KNOW WHY . I REALLY LOVE AND NEED THIS SPEARDSHEETS! CAN YOU PLEASE SHARE IT WITH US IF YOU DONT MIND!! WE WILL BE FOREVER GRATEFUL.

[@RyanTradesFX]

All the stuff in my spreadsheet is relevant to my strategy mate that’s why I showed how to create, if you change anything it will mess the formulas up and you’ll end up with an error

[@zackbyzker]

@@RyanTradesFX yo i appreciate your respond ! I tried more and it worked ! It works great man . Thank you so much ❤

[@RyanTradesFX]

@@zackbyzker No worries man

[@zulkifliladjupa2958]

Is there a video on how to make a forex risk calculator?

[@Mr99Lorenzo]

Thank you!

[@RyanTradesFX]

You’re welcome!

[@RyanDavis8603]

Is there a way to include a picture in this sheet?

[@Spartanz_Fx]

thanks mate!

[@RyanTradesFX]

You’re welcome mate

[@Nnamdiigwe]

Please I really need a help I not really get the formula to calculate the win percentage the screen is not bright can you write it down for me please I really appreciate the video

[@upcomingfx_Trader]

ok so with the outcome how can i calculate all the positive and the negative pips and the wins together

[@EricButler1]

Ryan,, what does "flip" and "exptreme" mean? I've newer to trading and never heard of those terms.

[@RyanTradesFX]

They're just an entry point for supply and demand traders

[@shahmeerhashmi3423]

what should be the formula if i want to add another column of how many win/loss for flip and extreme separately so It will help me that flip is more profitable or extreme? kindly reply

[@RyanTradesFX]

Check out my updated spreadsheet video - I show you how you can seperate different elements of your strategy and see each individual strike rate etc

[@meirwatkin5839]

excelent video

[@RyanTradesFX]

Appreciate it! 🤝

[@MahoCan]

Thanks for the video. Can we just download the file by any chance?

[@medhabyimeda9111]

Thankyou

[@RyanTradesFX]

You're welcome!

[@SpectraExtremeAirsoft]

thanks bro

[@RyanTradesFX]

You're welcome mate 👍

[@TraderJCpennies]

awesome vid. How do you calculate R on excel between shorts and longs. A vid about that would be great for those who want to start measuring their trades through the RR multiple.

[@RyanTradesFX]

Do you mean so you can separate the total R between long and short trades?

[@cloudfx9921]

Can any excel wizard help me? I would like to add in a prompt that will tell me what my best currency pair is to trade like to calculate which pair has the most wins

[@Thailandnet]

Hello, what version of Excel is used in your video?

[@RyanTradesFX]

It's just Google sheets

[@user-nh6sn4fh1e]

Hei Brother, i appreciate the video really much thank u for that ! any chance u could paste in the comments the formula to enter in the duration field for the automation?

[@RyanTradesFX]

In my example it was =if(D2=**,**,D2-C2) - It will depend what cells your times are in

[@peanut535]

Great video but the time format will not work, the time stays as the value I input and does not change to 1pm for example

[@RyanTradesFX]

I'd watch again mate cos it sounds like you've missed a step, if you've done everything correct it would change to the time you input

[@josephnyirongo2152]

Hey do you know how to making a trading dashboard on google spreadsheet I would appreciate it if you could make a video on that man

[@RyanTradesFX]

Will note it down, thanks for the suggestion

[@dewetvanrooyen8458]

Love excel XOXOX

[@user-jk5tj1xv3b]

How can one add dates, month and year automatically?

[@AhmadNuaymi]

Legend

[@RyanTradesFX]

Thanks 🤝

[@skip859]

for the formule =if(D2="";"";D2-C2)

[@RyanTradesFX]

Check my latest spreadsheet video in the pinned comment

[@BradKappa]

Bro what is the IF command for the duration? It's too dificult to read

[@RyanTradesFX]

=countif

[@widelings7029]

I have done the "Duration" column correctly, I have copied your formula, with my own rows in the formula. I am getting completely wrong calculations. The duration between 1 and 2 pm are: 0.041666~ Why am I getting this error? Is it because I am using HH:MM:SS time format in the open and close section?!?!?!?!?!??!?!?!??!?!?!??!!?

[@RyanTradesFX]

Potentially yeah, sounds like there could be something wrong with the format

[@chakri_148]

U should add pips, spread,lot size, support and regestance, , all rules followed, bad Trade or good trade, mistake,note

[@tradedrip828]

What do you use the stop loss section for?

[@Omnipotent645]

I guess to state where the stop loss was for this trade (1,5%? 3%?)

[@RyanTradesFX]

To see my average stop size. If I want to run a fixed SL I can see over a large sample size that my average stop was 10 pips for example

[@zuberihall8969]

I think what he meant to ask is. What do you do to determine the average stop size? Because thats the only thing you didn't explain how to do in the video.@@RyanTradesFX

[@rowanbartelink983]

The win and loss formula doesnt work for me, It gives an error, what do i do

[@RyanTradesFX]

Have you double checked you entered it in correctly and chosen the correct cells?

[@randomguyatfarm]

Wow! this is the best tutorial l've scene! You are just not helping you're teaching us!

[@RyanTradesFX]

Glad you took value 🙏

[@randomguyatfarm]

@@RyanTradesFX yes a lot! What monitor did you use in this recording? please drop

[@omarsadiki1033]

HY WATHS IS FLIP AND EXTREME ??

[@Imhimnreallife93]

I appreciate this a lot but bro you could have just saved a layout for us 🤦🏾‍♂️

[@Aylingfx]

It takes 5 mins to create, stfu