Building Candlestick Charts with Google Sheets from Coursera

In this 1-hour long project-based course, you will learn how to extract stock price data from public sources, build Japanese candlestick charts and customize them, interpret stock price charts and draw conclusions.

This course runs on Coursera's hands-on project platform called Rhyme. On Rhyme, you do projects in a hands-on manner in your browser. You will get instant access to pre-configured cloud desktops containing all of the software and data you need for the project. Everything is already set up directly in your Internet browser so you can just focus on learning. For this project, you’ll get instant access to a cloud desktop with Google Chrome pre-installed.

Prerequisites:

In order to be successful in this project, you should be familiar with Google Sheets. You are also advised to have some familiarity with the capital markets.

This course's content is not intended to be investment advice and does not constitute an offer to perform any operations in the regulated or unregulated financial market.

Notes:

- You will be able to access the cloud desktop 5 times. However, you will be able to access instructions videos as many times as you want.

- 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.

What's inside

Syllabus

Building Candlestick Charts with Google Sheets

Learners will be able to create beautiful japanese candlestick charts using Google Sheets. Japanese candlestick charts are a powerful tool and one of the most popular types of graphs you will see in technical analysis of the stock market. Knowing how to build them from scratch will allow you to analyse the price movements of the stock and develop your abilities to see trends. You will also learn how to look up stock price data in different sources, how to plot different prediction lines and corridors on a candlestick chart, and how to style it in different ways.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches learners how to extract and leverage financial data to analyze market trends

Provides hands-on experience with pre-configured cloud desktops and Google Sheets

Suitable for beginners with familiarity with Google Sheets and capital markets

Focuses on practical application of candlestick charts in technical analysis

Can empower learners to develop skills for independent stock price analysis

May not provide a comprehensive foundation in financial analysis or investing principles

Reviews summary

Google sheets candlestick chart builders

According to students, this informative course teaches learners how to use Google Sheets to build candlestick charts, a useful skill for financial data analysis. Simple yet effective in approach, learners praised the course's clear explanations and practical, easy-to-follow steps. However, some learners wished for more comprehensive coverage of technical analysis and complex charting techniques.

Become adept at interpreting candlestick charts.

"this course helped me to use modern tools efficiently to predict the market"

"The project was very insightful but was shorter than expected."

"We could have got more knowledge on making trendlines and moving averages."

Course is relevant to financial data analysis & data projection.

"Thank you for the knowledge you've taught & shared with us! It is essential for our data analysis & projections."

"Provides basics of what is candlestick chart and how to read the candles"

"Great understanding of the topic. Explanation is clear and everything is straight forward."

Well-structured course with easy-to-follow lessons.

"Brief lecture about the instructions."

"Easy to understand the topics discussed."

"Steps to follow are easily explained"

Additional insights & tools could enhance the course.

"Could have been comprehensive, with more emphasis on analysis area."

"The project was too short and easy, should have put more insights and points to understand technical analysis."

"It would have been more beneficial to use Excel as the functionality of being able to change colors and adding trendlines is much better."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Building Candlestick Charts with Google Sheets with these activities:

Review: Technical Analysis of the Financial Markets

Show steps

Read a book on technical analysis to deepen your understanding of candlestick charts and stock market trends

View Intermarket Analysis on Amazon

Show steps

Purchase a copy of Technical Analysis of the Financial Markets
Read through Chapters 1-5, which cover the basics of technical analysis and candlestick charting
Apply what you've learned by practicing identifying trends in stock charts
Complete the exercises at the end of each chapter to reinforce your understanding

Join a study group for the course

Show steps

Collaborate with other students to discuss course concepts and practice analyzing candlestick charts

Browse courses on Technical Analysis

Show steps

Identify classmates who are interested in forming a study group
Establish regular meeting times and decide on a format for your discussions

Follow tutorials on Coursera's Rhyme platform

Show steps

Practice creating candlestick charts and analyzing stock data through hands-on tutorials

Browse courses on Japanese Candlestick Charts

Show steps

Create a Coursera account and sign up for the course
Access the Rhyme platform and follow the provided tutorials
Apply what you learn by creating your own candlestick charts and analyzing stock data

Four other activities

Expand to see all activities and additional details

Show all seven activities

Analyze historical stock data using candlestick charts

Show steps

Reinforce your understanding of candlestick charting by analyzing real-world stock data

Browse courses on Candlestick Charts

Show steps

Select a company of interest and gather its historical stock data
Create a candlestick chart for the stock data
Identify patterns and trends in the candlestick chart
Write a brief report summarizing your analysis

Create a candlestick chart visual guide

Show steps

Develop a visual guide that explains how to interpret candlestick charts for effective stock analysis

Browse courses on Japanese Candlestick Charts

Show steps

Gather different types of candlestick charts and identify their patterns
Create a visual representation of each pattern, along with a brief explanation
Combine all the visuals into a comprehensive guide

Assist a financial advisor with stock analysis

Show steps

Gain practical experience analyzing stocks and applying candlestick charting techniques under the guidance of an expert

Show steps

Identify financial advisors who may be willing to take on volunteers
Reach out and express your interest in volunteering
Assist with tasks such as data gathering, chart analysis, and report preparation
Seek feedback and guidance from the financial advisor

Mentor junior traders on candlestick charting

Show steps

Share your knowledge and expertise by mentoring others who are new to candlestick charting

Show steps

Identify individuals who would benefit from your guidance
Share your knowledge of candlestick charting and provide practical tips
Answer questions and provide feedback on their analysis

Career center

Learners who complete Building Candlestick Charts with Google Sheets will develop knowledge and skills that may be useful to these careers:

Trader

A Trader buys and sells stocks, bonds, or other financial instruments. This course would be a perfect fit, as it provides hands-on experience with building candlestick charts, which are the primary tool used by traders for visualizing and interpreting financial data. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for traders.

See salaries and explore the career path for Trader

Technical Analyst

A Technical Analyst uses charts and graphs to identify trading opportunities. This course would be a perfect fit, as it provides hands-on experience with building candlestick charts, which are the primary tool used by technical analysts for visualizing and interpreting financial data. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for technical analysts.

See salaries and explore the career path for Technical Analyst

Market Analyst

A Market Analyst researches and analyzes financial markets and trends. This course would be particularly beneficial as it helps build a foundation in candlestick charting, a key tool for understanding and predicting market movements. By learning how to interpret stock price charts, one can develop their skills in identifying and assessing market opportunities and risks.

See salaries and explore the career path for Market Analyst

Risk Analyst

A Risk Analyst evaluates and manages financial risks for businesses and individuals. This course would be particularly beneficial as it helps build a foundation in candlestick charting, a key tool for identifying and assessing financial risks. By learning how to interpret stock price charts, one can develop their skills in recognizing and mitigating potential risks.

See salaries and explore the career path for Risk Analyst

Investment Analyst

An Investment Analyst investigates and evaluates potential investment opportunities. This course would be particularly beneficial as it helps build a foundation in candlestick charting, a key tool for technical analysis commonly used in investment and financial planning. By learning how to interpret stock price charts, one can develop their skills in identifying trends and making informed investment decisions.

See salaries and explore the career path for Investment Analyst

Data Scientist

A Data Scientist uses data to solve complex problems. This course may be helpful as it provides hands-on experience with data extraction, data analysis, and data visualization. These skills are essential for data scientists, and the course provides a practical foundation in these areas.

See salaries and explore the career path for Data Scientist

Quantitative Analyst

A Quantitative Analyst develops and applies mathematical and statistical models to financial data. This course may be helpful as it provides hands-on experience with building candlestick charts, which are commonly used by quantitative analysts for visualizing and interpreting financial data. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for quantitative analysts.

See salaries and explore the career path for Quantitative Analyst

Actuary

An Actuary uses mathematical and statistical techniques to assess and manage financial risks. This course may be helpful as it provides hands-on experience with data extraction, data analysis, and data visualization. These skills are essential for actuaries, and the course provides a practical foundation in these areas.

See salaries and explore the career path for Actuary

Financial Engineer

A Financial Engineer designs and develops financial products and services. This course may be helpful as it provides hands-on experience with data extraction, data analysis, and data visualization. These skills are essential for financial engineers, and the course provides a practical foundation in these areas.

See salaries and explore the career path for Financial Engineer

Quantitative Researcher

A Quantitative Researcher develops and applies mathematical and statistical models to financial data. This course may be helpful as it provides hands-on experience with data extraction, data analysis, and data visualization. These skills are essential for quantitative researchers, and the course provides a practical foundation in these areas.

See salaries and explore the career path for Quantitative Researcher

Financial Planner

A Financial Planner helps individuals and families plan for their financial futures. This course may be useful as it provides hands-on experience with building candlestick charts, which can be used to visualize and interpret financial data related to investments, retirement planning, and other financial matters. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for financial planners.

See salaries and explore the career path for Financial Planner

Data Analyst

A Data Analyst collects, processes, and analyzes data to help businesses make informed decisions. This course may be useful as it provides hands-on experience with building candlestick charts, which are commonly used by data analysts for visualizing and interpreting financial data. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for data analysts.

See salaries and explore the career path for Data Analyst

Portfolio Manager

A Portfolio Manager manages investments for individuals and institutions. This course may be useful as it provides hands-on experience with building candlestick charts, which are commonly used by portfolio managers for visualizing and interpreting financial data. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for portfolio managers.

See salaries and explore the career path for Portfolio Manager

Financial Advisor

A Financial Advisor provides financial advice and guidance to clients. This course may be useful as it provides hands-on experience with building candlestick charts, which can be used to visualize and interpret financial data related to investments, retirement planning, and other financial matters. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for financial advisors.

See salaries and explore the career path for Financial Advisor

Financial Analyst

A Financial Analyst helps businesses and individuals make sound financial decisions. This course may be useful as it provides hands-on experience with building candlestick charts, which are commonly used by financial analysts for visualizing and interpreting financial data. The course also covers data extraction from public sources and basic data analysis techniques, which are essential skills for financial analysts.

See salaries and explore the career path for Financial Analyst