Build Automated Google Sheets Trading Journal With Dropdown Scoring + Dashboard
Worldwide
I need a simple Google Sheets trading journal template created. Please also include a short note explaining how I add more rows without breaking formulas. See below: I already have the scoring logic and column names. I need someone to build the sheet with dropdown menus and formulas so each trade setup gets an automatic score. I only need 3 tabs: 1. Trade Log One row per trade. I will enter dropdown answers like Futures/Options, Call/Put, 4H story quality, 30m box quality, breakout quality, retest quality, RSI/Stoch/DXY check, risk plan, emotion, result, etc. 2. Scoring Rules A simple table that stores the dropdown choices and score values. 3.Dashboard Basic summary of total trades, wins/losses, average setup score, setup grades, and rule-following. The sheet should automatically calculate: Room Score 4H Score 30m Score Break + Retest Score Energy + Weather Score Risk Score Penalty Score Final Setup Score Setup Grade Trade Decision Setup grades: 85 to 100 = Clean 70 to 84 = Tradable 55 to 69 = Aggressive / Paper Only Under 55 = Skip I do not want to manually type scores. I want dropdown answers to create the score. Please include: Dropdown menus Formulas for at least 100 rows Frozen header row Basic conditional formatting Simple clean layout This does not need to be fancy. I just need it functional and easy to use in Google Sheets.
$10.00
Fixed-price- IntermediateExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:2 hours ago
- Interviewing:7
- Invites sent:4
- Unanswered invites:0
About the client
- United StatesBronx1:40 PM
- $2.3K total spent67 hires, 2 active
- Travel & HospitalityIndividual client
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by