Build a day trading journal with Google sheets for beginners

von
Coursera Project Network
In diesem Angeleitetes Projekt werden Sie:

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
BeginnerAnfänger
CloudKein Download erforderlich
VideoVideo auf geteiltem Bildschirm
Comment DotsEnglisch
LaptopNur Desktop

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.

Kompetenzen, die Sie erwerben werden

Google SheetsStocksDay TradingInvestmentFinance

Schritt für Schritt lernen

In einem Video, das auf einer Hälfte Ihres Arbeitsbereichs abgespielt wird, führt Sie Ihr Dozent durch diese Schritte:

  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.

Ablauf angeleiteter Projekte

Ihr Arbeitsbereich ist ein Cloud-Desktop direkt in Ihrem Browser, kein Download erforderlich

Ihr Dozent leitet Sie in einem Video mit geteiltem Bildschirm Schritt für Schritt an.

Häufig gestellte Fragen

Häufig gestellte Fragen

Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..