Build a day trading journal with Google sheets for beginners

提供:
Coursera Project Network
このガイド付きプロジェクトでは、次のことを行います。

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
Beginner初級
Cloudダウンロード不要
Video分割画面ビデオ
Comment Dots英語
Laptopデスクトップのみ

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.

あなたが開発するスキル

Google SheetsStocksDay TradingInvestmentFinance

ステップバイステップで学習します

ワークエリアを使用した分割画面で再生するビデオでは、講師がこれらの手順を説明します。

  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.

ガイド付きプロジェクトの仕組み

ワークスペースは、ブラウザに完全にロードされたクラウドデスクトップですので、ダウンロードは不要です

分割画面のビデオで、講師が手順ごとにガイドします

よくある質問

よくある質問

さらに質問がある場合は、受講者向けヘルプセンターにアクセスしてください。