Vamsi Krishna

Import the libraries

import pandas as pd

Load the data

# read the data
stock = pd.read_csv("stock.csv")
# display the first 5 rows data
stock.head()

We can see that we have the Daily Stock Price Closing Data.

Calculate the return

To calculate the 1-day returns, we need the previous closing price.

# shift the close prices by 1 position since we need 1-day previous close.
stock['previous_close'] = stock['close'].shift(1)
# display the data
stock.head()

Now that we have the Data in required format, we can calculate the daily returns.

# 1-day returns
stock['return'] = (stock['close'] / stock['previous_close']) - 1
# % return
stock['% return'] = stock['return'] * 100
# display the data
stock.head()