Master Stock Market Data Analysis with Python: Moving Averages Explained

Introduction

The article is the first part of a two‑part series on Python stock market data analysis, based on a lecture from a Data Mining course. It introduces basic financial data concepts, such as obtaining data from Yahoo Finance with pandas, visualizing stock prices, and focusing on moving averages.

Fetching and Visualizing Stock Data

Stock data can be retrieved from sources like Yahoo Finance or Google Finance; pandas provides convenient functions to download the data into a DataFrame. The tutorial explains key fields—open, high, low, close, volume, and adjusted close—and notes corporate actions such as splits and dividends that affect prices.

Visualization is demonstrated with matplotlib . A simple line plot of the Apple stock DataFrame is shown, followed by a discussion of Japanese candlestick (K‑line) charts, which display open, high, low, and close in a single visual. The author provides a custom function to generate candlestick charts from pandas data.

Multiple stocks can be plotted together; the tutorial shows how to overlay adjusted close prices for Apple, Microsoft, and Google, and discusses the issue of differing price scales. A dual‑axis solution is presented, followed by a recommendation to plot returns instead of raw prices, using formulas for simple and logarithmic returns.

Moving Averages

Moving averages smooth a price series to reveal trends. The q‑day moving average is defined as the mean of the past q prices. Short‑term averages (small q) follow price closely, while long‑term averages (large q) filter out short‑term noise.

Pandas makes calculating moving averages easy with the rolling method. The tutorial creates a 20‑day moving average for Apple stock and plots it alongside the raw price series.

The article notes that a moving average can only be computed after enough data points are available (e.g., 20 days for a 20‑day average). It also shows 50‑day and 200‑day averages, illustrating how longer averages indicate broader market trends (e.g., a bearish trend when the price stays below the 200‑day average).

Crossovers between short‑ and long‑term moving averages are highlighted as potential trading signals. The tutorial concludes by stating that the next article will cover how to design and back‑test a moving‑average‑based trading strategy.

Disclaimer: The content is for educational purposes only and does not constitute financial or investment advice.