Build a day trading journal with Google sheets for beginners

Offered By
Coursera Project Network
In this Guided Project, you will:

Access Google spreadsheets and identify some important basics.

Build the day trading journal framework and calculate the target, risk, number and type of shares using the if formula. 

 Use data validation and conditional formatting to organize your journal, as well as apply the count function to calculate the win percentage.

Clock1 Hour
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

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.

Skills you will develop

Google SheetsStocksDay TradingInvestmentFinance

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Use data validation and conditional formatting to organize your journal, as well as apply the count function to calculate the win percentage.  

  2. Add functions to generate your cost, profit, results and total profit as well as apply the dynamic date function. 

  3. Calculate the target, risk, number and type of shares using the if formula. 

  4. Build the day trading journal framework.

  5. Access Google spreadsheets and identify some important basics.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.