Starting your first Data Visualisation with Yahoo Finance

Data visualization is the process of transforming data into a visual format that makes it easier to understand and interpret. This can be a powerful tool for financial analysis, as it can help to identify patterns, trends, and outliers that might not be apparent from looking at raw data.

Yahoo Finance is a great source of financial data, and it offers a variety of tools for data visualization. In this article, we will show you how to use Yahoo Finance data to create a simple line chart. We will be using Yahoo Finance to collect the financial data, matplotlib, and Seaborn for visualizing the data in the form of a plot and generating the correlation matrix to understand the relationship between different financial instruments.

Understanding the requirement for data visualization in finance

Data visualization with the financial data will help you with the following:

  • Identify patterns and trends: By visually representing the identification of the recurring patterns, cycles, and trends in stock prices, market indices, or economic indicators which help in risk management and decision-making.

  • Communication and Reach: Visualizing the data helps in reaching a broader audience and makes complex finance information accessible.

  • Performance and reporting: Visualizations enable the monitoring and reporting of financial performance. Key performance indicators (KPIs), such as portfolio returns, asset allocation, or risk-adjusted measures, can be visually represented over time to track performance and identify areas for improvement.

Prerequisites

  • A basic understanding of Python: The code examples in this article are written in Python. If you are not familiar with Python, you can still follow the article, but you may need to do some additional research to understand the code.

  • Some familiarity with data visualization: This article will not teach you everything you need to know about data visualization, but it will assume that you have some basic familiarity with the concepts.

  • Basic finance knowledge: This article assumes that you have some basic knowledge of finance, such as the terms "stock price" and "market capitalization."

Getting started with your first visualization

Unleash the Power of Visuals: Decode Financial Data with Eye-Catching Precision

We will explore the power of data visualization using Yahoo Finance data. By combining the extensive financial data available on Yahoo Finance with the code snippets provided, we will embark on a fascinating journey to uncover meaningful patterns, trends, and relationships. Head over to your favorite code editor and follow the mentioned steps. In this article, we are using Google Code Colaboratory

Step 1: Gather the data

To proceed further with the visualization we need to collect the relevant financial data to perform our operation. To collect the right data set, we will use the 'yfinance' library to enable us to download historical market data. Here is a code snippet for the same:

pip install yfinance, matplotlib, seaborn

Once you have installed the libraries import yfinance and download the data for Reliance and insert the start and end date for the amount of data you need in "YYYY-MM-DD" format, we will be taking the data from 2010-01 till 2023-07.

import yfinance as yf

data = yf.download("RELIANCE.NS", start="2010-01-01", end="2023-07-01")

Step 2: Plotting the time series

One typical visualization technique for financial data is time series plotting. By plotting historical prices or other metrics against time, we can identify trends and patterns. We will be plotting this data using a matplotlib plot chart in the x:y format where the x represents the Date and y represents the Price of the stock. We will be considering the 'Close' price here. Let's import the library and import:

import matplotlib.pyplot as plt

plt.plot(data['Close'])
plt.title('Stock Closing Prices')
plt.xlabel('Date')
plt.ylabel('Price')
plt.show()

When you execute the above code in a cell you will find a pyplot for Date: Price as below:

Step 3: Financial Indicators

Financial indicators are important tools for understanding how the market behaves. They provide insights into the performance of stocks and help us make informed decisions. One such indicator is moving averages, which show the average price of a stock over a specific period. Here is an example for the same that showcases how to plot the 50-day and 200-day moving averages for a given stock:

# Calculate the moving averages
data['MA50'] = data['Close'].rolling(window=50).mean()
data['MA200'] = data['Close'].rolling(window=200).mean()

plt.plot(data['Close'], label='Close')
plt.plot(data['MA50'], label='MA50')
plt.plot(data['MA200'], label='MA200')
plt.title('Moving Averages')
plt.xlabel('Date')
plt.ylabel('Price')
plt.legend()
plt.show()

On the successful execution of the above code, you will get a plot for Close:50:200 to get the average in the following manner:

Step 4: Understanding the correlation heatmap

To identify relationships between different financial instruments, we can create a correlation heatmap. This visualization technique helps us understand how changes in one asset affect another. We will be using the 'seaborn' library here to plot our correlation relationship.

import seaborn as sns
corr_matrix = data.corr()

plt.figure(figsize=(10, 8))
sns.heatmap(corr_matrix, annot=True, cmap='coolwarm')
plt.title('Correlation Heatmap')
plt.show()

This will generate a correlation between the variables in the financial dataset and will get you a similar output as shown below:

Conclusion

Data visualization plays a crucial role in unraveling valuable insights from financial data. By leveraging Yahoo Finance data and the code snippets provided in this article, you can embark on your data visualization journey. From time series plots to moving averages and correlation heatmaps, the possibilities are endless.

ACCESS THE CODE

💻 Ayush