Скачать с ютуб How To Make A Day Trading Tracker In Google Sheets в хорошем качестве

How To Make A Day Trading Tracker In Google Sheets

How To Make A Day Trading Tracker In Google Sheets 📈 Link to download all my Portfolio Trackers:   / thinkstocks   ☑️ Follow me on Twitter:   / keithfrislid   🎥 Here is the camera I use for my videos: https://amzn.to/2PB865Q 🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶 https://www.sahg6dtr.com/28KL61/M2GJW/ In this video, I will walk you through the processes of making the best day trading tracker or journal in google sheets so you can stay organized, keep track of your winnings and track your progress over time! This video is long so make sure you are ready to sit in front of the computer for a while. Trust me when I say this, it is worth the watch! Make sure to like this video and subscribe to my channel to help my YouTube algorithm! Here are all the codes in this video: 🔹Target: =IF(ISBLANK(D6)," ",(C6-D6)*2+C6) 🔹Risk =IF(ISBLANK(D6),"",$M$4) 🔹Cost =IF(ISBLANK(J6)," ",J6*G6) 🔹Profit =IF(ISBLANK(K6),"",IF(H6="Long",((K6-J6)*G6),((J6-K6)*G6))) 🔹Total Profit =SUM(L:L) 🔹Total Trades =COUNT(L:L) 🔹Win Percentage =COUNTIF(M:M,"W")/M2 🔹Date =IFS(B6="","",A6="",now(),TRUE,A6) For some reason, YouTube doesn't allow the greater than sign in the description. Here are all the functions that contain the greater than sign, replaced with This blue circle 🔵. So you just need to manually put the greater than sign anywhere where the blue circle appears. 🔹Risk =IF(D6=0," ",If(C6🔵D6, F6/(C6-D6), F6/(D6-C6))) 🔹Shares =IF(D6=0," ",If(C6🔵D6, F6/(C6-D6), F6/(D6-C6))) 🔹Type =If(D6=0," ",If(C6🔵D6, "Long", "Short")) 🔹Result =IF(isblank(B6),"",If(isblank(K6),"OPEN",If(L6🔵0, "W", "L"))) Video Chapters: 0:00 Introduction 2:00 How It Works 5:00 How To Make This In Google Sheets 8:25 Target Function 11:30 Risk Function 14:37 Shares Function 17:37 Type Function 19:02 Cost Function 20:30 Profit Function 22:30 Result Function 24:04 Total Profit Function 24:30 Date Function 27:38 Total Trades Function 29:54 Status Data Validation 30:50 Win % Function 31:43 Finishing Touches Disclaimer: This is not financial advice. I am not a financial advisor. This video is meant for education and entertainment. Do not use this video as investing advice and consult with a professional advisor before buying or selling securities. AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link. #daytradingtracker #daytradingjournal #daytrading