Build Automated Google Sheets Trading Journal With Dropdown Scoring + Dashboard

Posted 15 hours ago

Worldwide

Summary

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
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Google Sheets
Dashboard
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
Member since Oct 28, 2011
  • United States
    Bronx1:40 PM
  • $2.3K total spent
    67 hires, 2 active
  • Travel & Hospitality
    Individual client

Explore similar jobs on Upwork

Tableau
SAP Crystal Reports
Analytics
Zapier
GIS
ArcGIS
Geology
Report Writing
Remote Sensing
Microsoft Excel
Microsoft PowerPoint
Engineering Geology
Digital Mapping
ArcGIS Online

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo