Python For Finance Financial Analysis For Investing

Use Python to Find Good Investments. Learn Pandas, NumPy, Matplotlib for Financial Analysis & Automate Value Investing.

Last updated 2022-01-10 | 4.5

- How to automate financial analysis with Python using Pandas and Numpy
- Learn to find attractive companies to invest in using fundamental analysis with Pandas
- Identify when to buy and sell stocks based on technical analysis using Pandas and Numpy

What you'll learn

How to automate financial analysis with Python using Pandas and Numpy
Learn to find attractive companies to invest in using fundamental analysis with Pandas
Identify when to buy and sell stocks based on technical analysis using Pandas and Numpy
Export your financial analysis to Excel in formatted multi sheets
How to calculate a fair price (intrinsic value) of a stock with Python using Pandas
Introduction to Pandas
Numpy and Visualization of financial data
Use Monte Carlo simulation to optimize your portfolio allocation
Understand risk when buying stock shares
Learn how to evaluate an investment to lower the risk
Learn about Intrinsic value
Market value
Book value
and Shares
Master the concepts Dividend
Earnings per share (EPS)
Price/Earnings (PE) ratio
and Volume Yield
Cover a Python Crash Course with all the basic Python
How to use DataFrames for financial analysis
Use Matplotlib to visualize DataFrames with time series data
How to join
merge and concatenate DataFrame
Export data from Python to Excel in nice colorful sheets with charts
Calculate concrete intrinsic values (a fair price to buy a stock for) for 50 companies
Read and interpret Dept/Equity (DE) ratio
Current ratio
Return of Investment (ROI) and more
Use revenue
Earnings-per-share (EPS)
and Book value to determine if a company is predictable and worth investing in.
How to use Price/Earnings (PE) ratio to make calculations
How to use Pandas Datareader to read data directly form API of financial pages
To read financial statements from API's
Web scraping of pages and how to convert data to correct format and types
How to calculate rate of return (RoR)
percentage change
and to normalize stock price data
Understand and learn to calculate the CAGR (Compound Annual Growth Rate)
A deep dive case study of DOW theory
How to calculate technical indicators
like
Moving Average (MA)
MACD
Stochastic Oscillator
and more
Make financial calculations with NumPy
Calculate with vectors and matrices using NumPy
How to calculate the Volatility of a stock
Correlation and Linear Regression between securities between investments
How the Beta is used and how to calculate it
Deep dive into using CAPM
Optimize your portfolio of investments
Learn what Sharpe Ratio is and how to use it
How to use Monte Carlo Simulation to simulate random variables
Use Sharpe Ratio and Monte Carlo Simulation to calculate the Efficient Frontier
Advice on next books to read about investing

* Requirements

* Some knowledge of programming is recommended
* All software and data used in course is free
* Ability to install Anaconda (guide in course)

Description

  • How to automate financial analysis with Python using Pandas and Numpy
  • Learn to find attractive companies to invest in using fundamental analysis with Pandas
  • Identify when to buy and sell stocks based on technical analysis using Pandas and Numpy
  • Export your financial analysis to Excel in formatted multi sheets
  • How to calculate a fair price (intrinsic value) of a stock with Python using Pandas
  • Introduction to Pandas, Numpy and Visualization of financial data
  • Use Monte Carlo simulation to optimize your portfolio allocation
  • Understand risk when buying stock shares
  • Learn how to evaluate an investment to lower the risk
  • Learn about Intrinsic value, Market value, Book value, and Shares
  • Master the concepts Dividend, Earnings per share (EPS), Price/Earnings (PE) ratio, and Volume Yield
  • Cover a Python Crash Course with all the basic Python
  • How to use DataFrames for financial analysis
  • Use Matplotlib to visualize DataFrames with time series data
  • How to join, merge and concatenate DataFrame
  • Export data from Python to Excel in nice colorful sheets with charts
  • Calculate concrete intrinsic values (a fair price to buy a stock for) for 50 companies
  • Read and interpret Dept/Equity (DE) ratio, Current ratio, Return of Investment (ROI) and more
  • Use revenue, Earnings-per-share (EPS), and Book value to determine if a company is predictable and worth investing in.
  • How to use Price/Earnings (PE) ratio to make calculations
  • How to use Pandas Datareader to read data directly form API of financial pages
  • To read financial statements from API's
  • Web scraping of pages and how to convert data to correct format and types
  • How to calculate rate of return (RoR), percentage change, and to normalize stock price data
  • Understand and learn to calculate the CAGR (Compound Annual Growth Rate)
  • A deep dive case study of DOW theory
  • How to calculate technical indicators, like, Moving Average (MA), MACD, Stochastic Oscillator, and more
  • Make financial calculations with NumPy
  • Calculate with vectors and matrices using NumPy
  • How to calculate the Volatility of a stock
  • Correlation and Linear Regression between securities between investments
  • How the Beta is used and how to calculate it
  • Deep dive into using CAPM
  • Optimize your portfolio of investments
  • Learn what Sharpe Ratio is and how to use it
  • How to use Monte Carlo Simulation to simulate random variables
  • Use Sharpe Ratio and Monte Carlo Simulation to calculate the Efficient Frontier
  • Advice on next books to read about investing

Course content

16 sections • 185 lectures

One Question Preview 02:18

What is a good investment and what is a bad investment?

  • Can you see that from the stock price?

  • You need technical indicators?

  • Will that help you from a market crash?

Learn about intrinsic value and how to use it.

Get the most out of this course Preview 04:11

How to get the most out of the course?

We will cover the following.

  • Who is the course for?

  • What to expect?

  • What resources are available?

Introduction Preview 00:30

Introduction to the section.

Download Anaconda (includes Python and Jupyter notebook) Preview 01:32

In this lecture we will download Anaconda.

Anaconda includes

  • Python

  • Jupyter notebook

In the resources is a link where to download the FREE version of Anaconda and how to install it on your platform.

After this lecture you should have all needed installations on your system running.

Resources and setup environment in Jupyter notebook Preview 04:24

Download the the resources, it includes.

  • All the source code in notebooks.

  • Exercises for the sections.

How to setup the environment

  • Two ways to ensure correct libraries are installed.

  • Make sure to follow this to get the same experience in the course.

Prompt rating Preview 00:34

Introduction Preview 00:55

Introduction to the section.

Jupyter Notebook Cheat Sheet. Preview 00:03

If you are new to Jupyter Notebook, you can download the cheat sheets.

Jupyter Notebook: The Dashboard Preview 03:23

Learn about the Dashboard in Jupyter Notebook.

You will learn how to

  • Create folders

  • Upload Notebooks

  • Create Notebooks

  • See running Notebooks.

Feel free to skip this lecture if you are familiar with Jupyter Notebook.

Jupyter Notebook: Run and restart a Notebook Preview 03:04

Learn how to Run and restart a Notebook.

You will learn how to:

  • How to execute a cell with code

  • Stop a running cell in Jupyter Notebook.

  • Restart and clear the output in a Notebook.

Feel free to skip this lecture if you are familiar with Jupyter Notebook.

Jupyter Notebook: Copy and reorganize code Preview 02:01

In this lecture you will learn how to:

  • Copy code cells

  • Reorganize the code cells

  • Delete code cells.

Feel free to skip this lecture if you are familiar with Jupyter Notebook.

Jupyter Notebook: Comment and markdown Preview 02:21

In this lecture you will learn:

  • How to insert comments in your code cells.

  • How to insert markdown cells with description

Feel free to skip this lecture if you are familiar with Jupyter Notebook.

Jupyter Notebook: Tab + Tab + Shift & Tab Preview 06:14

In this lecture you will learn:

  • How to autocomplete code in Jupyter Notebook.

  • How to list all methods available in an object.

  • How to get the documentation of a method.

Feel free to skip this lecture if you are familiar with Jupyter Notebook.

What did we learn? Preview 00:54

After this section you should be ready to use Jupyter Notebook.

Introduction Preview 01:07

In this section we will have a Python crash course.

It will cover all the basics needed to be at the level of Python needed.

This section is ideal for you:

  • If you are new to Python, but have experience from another programming language.

  • If you need a refresher on Python.

If you are new to programming - this is get you an idea about programming. But don't expect to master it after this.

Feel free to skip this section if you are familiar with Python basics.

Variables and types Preview 11:43

In this lecture we will learn about.

  • Variables in Python.

  • The types of variables.

The print statement Preview 02:53

In this lecture you will learn about:

  • How to use print in the most convenient way.

Boolean expressions Preview 06:16

In this lecture we will learn about:

  • Boolean expressions.

  • How they are the most important aspect of programming.

  • Without them, programs would have no real benefits.

  • Understand how they are evaluated by the computer.

  • How everything is either-or for a computer.

If statements Preview 05:03

In this lecture we will learn:

  • That actually, Boolean expressions are useless without if-statements.

  • How they are connected together.

  • How to use if-statements.

Python lists Preview 05:19

In this lecture we will learn:

  • About Python lists, which is a powerful data structure that is easy to use.

  • How to construct lists.

  • How lists are generic.

For-loops Preview 04:38

In this lecture we will learn:

  • How to iterate and do the same task for many items.

  • How to loop over a list.

  • They are used together with Pandas and are important to understand.

While loops Preview 02:32

In this lecture we will learn:

  • How to iterate and have a Boolean expression determine when it is done.

  • How while-loops are different form for-loops.

Python Dictionaries (dict) Preview 04:05

In this lecture we will learn:

  • The dictionary (dict)

  • A powerful data structure in Python.

  • They are used together with Pandas and are important to understand.

Other types Preview 03:45

In this lecture we will learn:

  • About sets and when they are used.

  • Tuples and how we use them implicitly all the time.

Functions Preview 04:19

In this lecture we will learn about:

  • About python functions.

  • A great way to structure code.

Lambda functions Preview 07:41

What is a lambda function?

Exactly.

  • We will learn what a lambda function is.

  • That a lambda function is a nameless function.

  • How to transform a function to a lambda function.

Exercises Preview 05:07

These exercises are good to train and refresh your Python skills.

Solutions Preview 12:49

The solutions to the exercises from last lecture.

New to Python? We have all been there Preview 03:15

My own and others experience with learning to program.

It is often easy to read code, but difficult to write your own code.

What did we learn? Preview 01:13

This section covers the basics of Python programming.

Introduction Preview 01:18

This section will cover the beginning to understand investing.

It will cover the all the core concepts, which are important to understand a company and how to value it.

The story line will be around a Lemonade Stand. This makes it easy to understand, but we will also calculate concrete examples with Python in Jupyter Notebook.

The key concepts covered are:

  • Intrinsic value

  • Market value

  • Book value

  • Shares

  • Dividend

Intrinsic Value Preview 03:35

Short overview of the concepts.

  • Intrinsic value

  • Market value

  • Book value

  • Shares

  • Dividend

Introduction to the Lemonade Stand Preview 05:28

We will be introduced to how the the story of the Lemonade Stand will help us understand the key concepts.

The Lemonade Stand - the easy to understand example Preview 05:01

The story of the Lemonade Stand.

Sets the main question in investing:

  • What is it worth?

This is not simple to answer as it will show.

Jupyter Notebook: The Lemonade Stand Preview 15:58

In this lecture we will calculate in Jupyter Notebook to understand the concepts from last lecture.

Shares Preview 04:35

Understand what Shares are?

  • How shares determine the price - or market value.

  • What shares outstanding are.

Shares a story - Understand what they really are Preview 06:08

In this lecture we will continue the story of the Lemonade Stand.

This will connect it to:

  • Shares

  • Shares outstanding.

  • Market price

  • How shares  affects the market price.

Jupyter Notebook: Shares Preview 13:05

In this lecture we will calculate in Jupyter Notebook to understand the concepts from last lecture.

Dividend Preview 04:16

Dividend connects to more concepts.

  • Earnings per share (EPS)

  • Price/Earnings (PE) ratio

  • Volume

  • Yield

We will cover that along with what dividend is.

Dividend a story - an easy way to understand them Preview 05:36

We will continue the story of the Lemonade Stand to ensure we understand the following concepts.

  • Dividend

  • Earnings per share (EPS)

  • Price/Earnings (PE) ratio

  • Volume

  • Yield

Jupyter Notebook: Dividend Preview 14:13

In this lecture we will calculate in Jupyter Notebook to understand the concepts from last lecture.

What did we learn? Preview 02:30

After this section you should understand the key concept of value investing.

  • Intrinsic value

Also, understand that it is not easy to calculate it - there are no direct financial values determining it.

This understanding is crucial to continue the course and calculate an objective value for the intrinsic value and ensure we do not make wrong investments.

This section included concepts:

  • Intrinsic value

  • Market value

  • Book value

  • Shares

  • Dividend

  • Earnings per share (EPS)

  • Price/Earnings (PE) ratio

  • Volume

  • Yield

Introduction Preview 06:21

Introduction to Pandas - a small demonstration Preview 11:13

Series Preview 12:07

DataFrames - Part I Preview 12:09

DataFrames - Part II Preview 07:13

DataFrames - Part III Preview 07:55

DataFrames - Part IV Preview 07:14

DataFrames - Part V Preview 07:39

Read and Write with Pandas - Part I Preview 11:24

Read and Write with Pandas - Part II Preview 10:56

Read and Write with Pandas - Part III Preview 10:41

Merge - Join - Concatenate - Part I Preview 08:46

Merge - Join - Concatenate - Part II Preview 05:04

Transpose and clean data Preview 07:38

Views Preview 05:47

Useful methods to know Preview 08:33

Apply - an awesome method to master Preview 06:09

Exercises Preview 05:19

Solutions Preview 10:42

What did we learn? Preview 02:07

Introduction Preview 01:13

Outcome of section Preview 06:52

Understand Risk - Part I Preview 04:20

Understand Risk - Part II Preview 03:08

Understand Rik - Part III Preview 02:58

Understand Risk - All put together Preview 02:39

Evaluate Leadership Preview 09:37

Debt-to-Equity ration - Evaluation Preview 04:21

Jupyter Notebook: Debt-to-Equity ratio Preview 19:34

Current ratio - Evaluation Preview 03:25

Jupyter Notebook - Current ratio Preview 10:33

Stable and predictable Preview 08:06

Return of Investment (ROI) - Evaluation Preview 05:04

Jupyter Notebook: Return of Investment Preview 09:39

Revenue - Evaluation Preview 04:38

Jupyter Notebook: Revenue Preview 16:48

Earnings Per Share (EPS) - Evaluation Preview 02:03

Jupyter Notebook: Earnings Per Share (EPS) Preview 09:01

Book Value - Evaluation Preview 03:52

Jupyter Notebook: Book Value Preview 11:43

Free Cash Flow (FCF) - Evaluation Preview 01:47

Jupyter Notebook: Free Cash Flow (FCF) Preview 04:49

Combine All Data Preview 03:11

Jupyter Notebook: Combine All Data Preview 10:46

Calculate a Fair Price (Intrinsic Value) Preview 06:50

Price-to-Earnings (PE) ratio Preview 02:38

Jupyter Notebook: Price-to-Earnings (PE) ratio Preview 05:32

Jupyter Notebook: Calculate a Fair Price (Intrinsic Value) Preview 10:27

Compare it with Current Price Preview 09:38

What did we learn? Preview 04:29

Introduction Preview 00:57

Overview of section Preview 05:06

Jupyter Notebook: Matplotlib basics Preview 08:58

Jupyter Notebook: Work with Axis Preview 09:04

Jupyter Notebook: Title and Labels Preview 09:07

Jupyter Notebook: Matplotlib and Pandas Preview 08:04

Jupyter Notebook: Pandas and data structures Preview 11:42

Jupyter Notebook: Bar plots Preview 10:00

Exercises Preview 05:35

Solutions Preview 14:46

What did we learn? Preview 01:25

Introduction Preview 01:29

Matplotlib - Part I Preview 15:56

Matplotlib - Part II Preview 14:03

Export to Excel - Part I Preview 11:27

Export to Excel - Part II Preview 19:36

Export to Excel - Part III Preview 08:55

What did we learn? Preview 01:59

Introduction Preview 00:55

What will we learn? Preview 03:08

Pandas Datareader - Remote Data Access for Pandas Preview 01:36

Jupyter Notebook: Pandas Datareader - Part I Preview 18:27

Jupyter Notebook: Pandas Datareader - Part II Preview 09:28

The Yahoo! Finance API - read Financial Statements Preview 02:34

Jupyter Notebook: Yahoo! Finance - Financial Statements Preview 13:11

Web Scraping Preview 02:43

Jupyter Notebook: Web Scraping Preview 15:35

Exercises Preview 03:50

Solutions Preview 11:45

What did we learn? Preview 01:08

Introduction Preview 03:34

Rate of Return, Percentage Change, and Normalization Preview 05:55

Jupyter Notebook: Rate of Return, Percentage Change, and Normalization Preview 10:19

CAGR Preview 02:01

Jupyter Notebook: CAGR Preview 08:29

Jupyter Notebook: Multiple Time Frames Preview 07:46

Case Study: DOW Theory Preview 15:26

Jupyter Notebook: Case Study: DOW Theory Preview 14:28

What did we learn? Preview 01:19

Introduction Preview 02:36

What is a Technical Indicator and Types of Indicators Preview 07:09

Indicator: Moving Average Preview 05:01

Jupyter Notebook: Simple Moving Average (MA) Preview 14:31

Jupyter Notebook: Exponential Moving Average (EMA) Preview 07:26

Indicator: MACD Preview 04:25

Jupyter Notebook: MACD Preview 11:56

Indicator: Stochastic Oscillator Preview 03:47

Jupyter Notebook: Stochastic Oscillator Preview 12:46

Jupyter Notebook: Exporting to Excel Preview 17:27

Jupyter Notebook: Using our Excel Sheet Preview 10:27

Exercises Preview 06:03

Solutions Preview 11:02

What did we learn? Preview 00:50

Introduction Preview 05:48

Jupyter Notebook: Introduction to NumPy Preview 13:17

Jupyter Notebook: Index, Slicing, and Views Preview 10:35

Jupyter Notebook: DataFrames and Series with NumPy Preview 13:51

Jupyter Notebook: Vectorization with NumPy Preview 10:46

Jupyter Notebook: Matplotlib and NumPy Preview 09:23

Jupyter Notebook: Dot product and Transpose Preview 11:36

Exercises Preview 06:31

Solutions Preview 11:08

What did we learn? Preview 02:13

Introduction Preview 01:30

Adjusted Close Preview 02:20

Volatility of a Stock Preview 05:13

Jupyter Notebook: Volatility Calculations Preview 20:00

Correlation Between Securities Preview 02:11

Jupyter Notebook: Correlation Calculations Preview 07:54

Linear Regression Preview 03:29

Jupyter Notebook: Linear Regression Preview 14:13

Beta Preview 02:05

Jupyter Notebook: Beta Calculations Preview 08:58

CAPM Preview 04:14

Jupyter Notebook: CAPM Calculations Preview 08:00

Exercises Preview 04:00

Solutions Preview 08:32

What did we learn? Preview 01:47

Introduction Preview 01:28

Portfolios Preview 01:21

Jupyter Notebook: Portfolio Preview 10:40

Sharpe Ratio Preview 02:38

Jupyter Notebook: Sharpe Ratio Calculations Preview 11:05

Monte Carlo Simulations Preview 03:45

Jupyter Notebook: Monte Carlo Simulations - Introduction Preview 13:45

Jupyter Notebook: Portfolios and Monte Carlo Simulations Preview 13:57

Jupyter Notebook: The Efficient Frontier Preview 04:49

Exercises Preview 04:35

Solutions Preview 13:33

What did we learn? Preview 01:28