Pandas: Create a plot of Open, High, Low, Close, Adjusted Closing prices and Volume
13. Plot of OHLC and Volume
Write a Pandas program to create a plot of Open, High, Low, Close, Adjusted Closing prices and Volume of Alphabet Inc. between two specific dates.
Use the alphabet_stock_data.csv file to extract data.
alphabet_stock_data:
alphabet_stock_data Table
Date | Open | High | Low | Close | Adj Close | Volume |
---|---|---|---|---|---|---|
2020-04-01 | 1122 | 1129.689941 | 1097.449951 | 1105.619995 | 1105.619995 | 2343100 |
2020-04-02 | 1098.26001 | 1126.859985 | 1096.400024 | 1120.839966 | 1120.839966 | 1964900 |
2020-04-03 | 1119.015015 | 1123.540039 | 1079.810059 | 1097.880005 | 1097.880005 | 2313400 |
2020-04-06 | 1138 | 1194.660034 | 1130.939941 | 1186.920044 | 1186.920044 | 2664700 |
... | ... | ... | ... | ... | ... | ... |
... | ... | ... | ... | ... | ... | ... |
2020-09-29 | 1470.390015 | 1476.662964 | 1458.805054 | 1469.329956 | 1469.329956 | 978200 |
2020-09-30 | 1466.800049 | 1489.75 | 1459.880005 | 1469.599976 | 1469.599976 | 1700600 |
Sample Solution:
Python Code :
import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_csv("alphabet_stock_data.csv")
start_date = pd.to_datetime('2020-4-1')
end_date = pd.to_datetime('2020-9-30')
df['Date'] = pd.to_datetime(df['Date'])
new_df = (df['Date']>= start_date) & (df['Date']<= end_date)
df1 = df.loc[new_df]
stock_data = df1.set_index('Date')
stock_data.plot(subplots = True, figsize = (8, 8));
plt.legend(loc = 'best')
plt.suptitle('Open,High,Low,Close,Adj Close prices & Volume of Alphabet Inc., From 01-04-2020 to 30-09-2020', fontsize=12, color='black')
plt.show()
Sample Output:
Click for download alphabet_stock_data.csv
For more Practice: Solve these Related Problems:
- Write a Pandas program to create a multi-line plot that displays open, high, low, close, adjusted close prices and trading volume on separate subplots.
- Write a Pandas program to generate a combined plot where the stock price metrics are on the primary axis and volume is on the secondary axis.
- Write a Pandas program to build a plot that integrates OHLC data and volume data, using different chart types for clarity.
- Write a Pandas program to create a composite plot of Alphabet’s OHLC prices and volume, ensuring clear differentiation between the metrics.
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to create a plot of stock price and trading volume of Alphabet Inc. between two specific dates.
Next: Write a Pandas program to create a plot of adjusted closing prices, thirty days and forty days simple moving average of Alphabet Inc. between two specific dates.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.