Build an ultimate stock monitoring list using Google Sheets

제공자:
Coursera Project Network
학습자는 이 무료 안내 프로젝트에서 다음을 수행하게 됩니다.

Access Google spreadsheets and import a working file and learn basics such as data entry, formatting and calculation.

Start building the stock monitor using Google finance and data validation.

Add a dynamic stock rating using if formula and add graphs learn tips and tricks of data formatting and conditional formatting.

인터뷰에서 이 안내형 체험 보여주기

Clock1 Hour
Beginner초급용
Cloud다운로드 필요 없음
Video분할 화면 동영상
Comment Dots영어
Laptop데스크톱 전용

By the end of this project, you will be able to create a stock monitoring tracker using only Google sheets, which will help you track all your stock investments. The stock monitor list will automatically give you the live updated stock price as well as the percent change since a day ago. In addition to that it also provides the market capitalization of the stock as well as the 52-week high and low and the percentage that the current price is off of those 52-week high and lows. You can use a stock monitor like this for help categorizing your investment types as well as laying out potential buy or sell price thresholds that you might use to enter or exit out of a position. Based on these target buy or sell prices the monitor list will automatically calculate a stock rating for you determining whether the stock is a buy hold or sell and how far off each of those stocks is from the buy price. In addition to this you can use this information on the stock monitor list to create useful graphics and tools to get a quick visual sense of the information provided in the monitor list Along the way, you will be applying and practicing the basic features of spreadsheets such as formatting and calculations, as well as create tables and charts to use in your financial management that are efficient and versatile. This project will help you better manage your stock finances.

요구 사항

No technical prerequisites. This course is for beginners. Learner needs to have a google account.

개발할 기술

Google SheetsStocksData ValidationFinanceStocks Monitoring

단계별 학습

작업 영역이 있는 분할 화면으로 재생되는 동영상에서 강사는 다음을 단계별로 안내합니다.

  1. You will be able to learn tips and tricks of data formatting and conditional formatting.

  2. You will be able to add a dynamic stock rating using if formula and add graphs. 

  3. You will be able to calculate the stock 52 weeks high and low price as well as use data validation to create drop down menus. 

  4. You will be able to start building the stock monitor using Google finance function and calculate market capitalization.

  5. You will be able to access Google spreadsheets and identify some important basics.

안내형 프로젝트 진행 방식

작업 영역은 브라우저에 바로 로드되는 클라우드 데스크톱으로, 다운로드할 필요가 없습니다.

분할 화면 동영상에서 강사가 프로젝트를 단계별로 안내해 줍니다.

자주 묻는 질문

자주 묻는 질문

궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.