How To Compute Commodity Channel Index (CCI) in Python?

1
2

import pandas as pd
import numpy as np

1
2
3
4
5
6
7
8
9

def compute_CCI(data, period):
    typical_price = (data['High'] + data['Low'] + data['Close']) / 3
    moving_average = typical_price.rolling(window=period).mean()
    
    mean_deviation = typical_price.rolling(window=period).apply(lambda x: np.mean(np.abs(x - x.mean())))
    
    CCI = (typical_price - moving_average) / (0.015 * mean_deviation)
    
    return CCI

1

data = pd.read_csv('stock_data.csv')

1

data['CCI'] = compute_CCI(data, 20)

1

data.plot(y='CCI')