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.

Как устроены проекты с консультациями

Ваше рабочее пространство — это облачный рабочий стол в браузере. Ничего не нужно загружать.

На разделенном экране видео преподаватель предоставляет пошаговые

Часто задаваемые вопросы

Часто задаваемые вопросы

Остались вопросы? Посетите Центр поддержки учащихся.