Build a day trading journal with Google sheets for beginners from Coursera

By the end of this project, you will be able to create a stock day trading list using Google sheets, which will help you track all your stock investments. The day trading journal will automatically give you the updated target and risk price as well as the cost and the profit. In addition to that it also provides the win percentage and the total trades. You can use a day trading journal like this for categorizing your stock investment as well as laying out if the stock is win or loss. Based on the ticker, entry price and stop price you input, the journal will calculate the number of shares to buy and the total profit. This journal will help you stay organized, keep track of your winnings and track your progress over time Along the way, you will be applying and practicing the basic features of spreadsheets such as formatting and calculations, you will apply formulas such as the if and countif formula as well as data validation and conditional formatting to use in your financial management journal that is efficient and versatile and eventually help you better manage your stock finances. Note: This course works best for learners who are based in the North America region. Weâ€™re currently working on providing the same experience in other regions.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Creates a streamlined stock day trading list using Google Sheets for efficient investment tracking

Provides a comprehensive journal that automatically calculates target and risk prices, cost, and profit

Employs essential spreadsheet functionalities like formatting, formulas, and data validation for versatile financial management

Helps learners categorize stock investments and track win-loss ratios

Assumes basic spreadsheet proficiency, making it suitable for learners with some spreadsheet experience

Currently limited to learners in North America, with wider availability expected in the future

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Build a day trading journal with Google sheets for beginners with these activities:

Create a list of helpful resources

Show steps

This will help you to stay up-to-date on the latest developments in stock trading.

Browse courses on Stock Analysis

Show steps

Identify the resources you need.
Create a system for organizing your resources.
Add new resources to your list as you find them.

Read Intelligent Investor

Show steps

This book provides valuable insights into the fundamentals of investing.

View The Intelligent Investor Third Edition,... on Amazon

Show steps

Read the book.
Take notes on the key concepts.
Apply the concepts to your own investment strategy.

Read Security Analysis

Show steps

This book provides a comprehensive overview of security analysis techniques.

View Security Analysis, Seventh Edition: Principles... on Amazon

Show steps

Read the book.
Take notes on the key concepts.
Apply the concepts to your own investment strategy.

Three other activities

Expand to see all activities and additional details

Show all six activities

Solve stock practice problems

Show steps

Complete practice problems to reinforce the key concepts and techniques taught in the course and improve your problem-solving skills.

Browse courses on Stock Analysis

Show steps

Review the course material.
Identify areas where you need more practice.
Find practice problems online or in textbooks.
Solve the practice problems.
Check your answers and identify areas for improvement.

Design a stock day trading journal

Show steps

Creating a stock day trading journal will allow you to track your progress and identify areas for improvement.

Browse courses on Financial Management

Show steps

Gather your trading data.
Choose a format for your journal.
Create a system for tracking your trades.
Analyze your trading data.
Make adjustments to your trading strategy.

Write a blog post about your stock trading experiences

Show steps

Writing a blog post will help you to consolidate your knowledge and share your insights with others.

Browse courses on Financial Management

Show steps

Identify a topic for your blog post.
Research your topic.
Write your blog post.
Edit and proofread your blog post.
Promote your blog post.

Career center

Learners who complete Build a day trading journal with Google sheets for beginners will develop knowledge and skills that may be useful to these careers:

Business Analyst

Business Analysts analyze business processes and recommend improvements. This course helps build a foundation in business analysis by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with business analysis.

See salaries and explore the career path for Business Analyst

Data Analyst

Data Analysts collect, clean, and analyze data to identify trends and patterns. This course helps build a foundation in data analysis by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with data analysis.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use financial data to evaluate and forecast future financial performance. This course helps build a foundation in financial management by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with financial data analysis.

See salaries and explore the career path for Financial Analyst

Consultant

Consultants provide advice to clients on a variety of business issues. This course helps build a foundation in consulting by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with consulting.

See salaries and explore the career path for Consultant

Quantitative Analyst

Quantitative Analysts use mathematical and statistical models to analyze financial data. This course helps build a foundation in quantitative analysis by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with quantitative analysis.

See salaries and explore the career path for Quantitative Analyst

Actuary

Actuaries use mathematical and statistical methods to assess and manage financial risks. This course helps build a foundation in actuarial science by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with actuarial science.

See salaries and explore the career path for Actuary

Investment Banker

Investment Bankers help companies raise capital. This course helps build a foundation in investment banking by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with investment banking.

See salaries and explore the career path for Investment Banker

Portfolio Manager

Portfolio Managers manage investments for clients. This course helps build a foundation in portfolio management by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with portfolio management.

See salaries and explore the career path for Portfolio Manager

Financial Planner

Financial Planners help clients plan for their financial future. This course helps build a foundation in financial planning by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with financial planning.

See salaries and explore the career path for Financial Planner

Credit Analyst

Credit Analysts evaluate and recommend loans to clients. This course helps build a foundation in credit analysis by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with credit analysis.

See salaries and explore the career path for Credit Analyst

Auditor

Auditors examine financial records to ensure accuracy and compliance. This course helps build a foundation in auditing by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with auditing.

See salaries and explore the career path for Auditor

Tax Accountant

Tax Accountants prepare and file tax returns for clients. This course helps build a foundation in tax accounting by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with tax accounting.

See salaries and explore the career path for Tax Accountant

Investment Analyst

Investment Analysts evaluate and recommend investments to clients. This course helps build a foundation in investment analysis by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with investment analysis.

See salaries and explore the career path for Investment Analyst

Financial Risk Manager

Financial Risk Managers assess and manage financial risks for companies. This course helps build a foundation in financial risk management by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with financial risk management.

See salaries and explore the career path for Financial Risk Manager

Insurance Analyst

Insurance Analysts evaluate and recommend insurance products to clients. This course helps build a foundation in insurance analysis by teaching basic spreadsheet features, formulas, and data validation. This course may be useful for someone who wants to enter this career field, as it provides hands-on experience with insurance analysis.

See salaries and explore the career path for Insurance Analyst

Build a day trading journal with Google sheets for beginners

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses