Plotting Daily Prices#

PyPI Version

In this guide, we will walk you through the steps to retrieve financial data using MoabDB and how to create a basic chart using the matplotlib library.

We’ll be using the get_equity function to retrieve daily-level and show two examples of plotting data:

  • Single Stock with Daily-Level Data

  • Multiple Stocks with Daily-Level Data

Prerequisites#

  • You will need matplotlib installed. If you haven’t already, you can install it with:

    pip install matplotlib
    

Plotting Single Stock with Daily-Level Data#

First, let’s retrieve some financial data. For this example, we’ll fetch historical closing prices for a given stock (e.g., MSFT):

Import MoabDB and fetch data#

import moabdb as mdb
import matplotlib.pyplot as plt

# Constants defined here for flexibility
TIC = 'MSFT'
SAMPLE = '5y'

# Load and Check Data
data_df = mdb.get_equity(tickers=TIC, sample=SAMPLE)
print(data_df.head())

Visualizing Data with Matplotlib#

With our data in hand, we can now plot it:

import moabdb as mdb
import matplotlib.pyplot as plt

# Constants defined here for flexibility
TIC = 'MSFT'
SAMPLE = '5y'

# Load and Check Data
data_df = mdb.get_equity(tickers=TIC, sample=SAMPLE)
print(data_df.head())

# Creating the plot
x = data_df.index
y = data_df['Close']

fig, ax = plt.subplots(figsize=(6,4))
ax.plot(x, y, label=TIC, color='blue')
ax.set_xlabel('Date')
ax.set_ylabel('Closing Price (in $)')
plt.legend()
plt.show()
Single Stock with Daily-Level Data

Plotting Multiple Stocks with Daily-Level Data#

First, let’s retrieve some financial data. For this example, we’ll fetch historical closing prices for a given stock (e.g., AAPL):

Import MoabDB and fetch data#

import moabdb as mdb
import matplotlib.pyplot as plt

# Constants defined here for flexibility
TICS = ['MSFT','GOOG']
SAMPLE = '5y'

# Load and Check Data
data_df = mdb.get_equity(tickers=TIC, sample=SAMPLE)
print(data_df.head())

Visualizing Data with Matplotlib#

With our data in hand, we can now plot it:

import moabdb as mdb
import matplotlib.pyplot as plt

# Constants defined here for flexibility
TICS = ['MSFT','INTC']
SAMPLE = '5y'

# Load and Check Data, Get Prices
data_df = mdb.get_equity(tickers=TICS, sample=SAMPLE)
price_df = data_df['Close']
print(price_df.head())

# Creating the plot
x = price_df.index
y = price_df.values
y_labels = price_df.columns

fig, ax = plt.subplots(figsize=(6,4))
ax.plot(x, y, label=y_labels)
ax.set_xlabel('Date')
ax.set_ylabel('Closing Price (in $)')
plt.legend()
plt.show()
Single Stock with Daily-Level Data

With these simple steps, you’ve fetched financial data using MoabDB and visualized it with a basic chart. Explore more with different stocks, date ranges, or chart types to gain richer insights!