Pivot code needed

APIs, Automation, Algos & Code
1

@Tradehull_Imran Sir, can you please provide me with the pivot point code, including P, R1, R2, R3, S1, S2, and S3, so that I can print the data?

I’ve tried many times but haven’t been able to find the correct code and keep failing.

I want the P, R1, R2, R3 support and resistance levels for Nifty and Bank Nifty in a 5-minute time frame. Can you please help me with this? I’ve searched the internet and checked other sources, but I’m not getting any output; it keeps saying ‘no data found’. Please help me with this.

Preformatted text# Retry mechanism to fetch data
def fetch_data():
for attempt in range(3): # Try 3 times
index_chart = tsl.get_historical_data(tradingsymbol=“NIFTY MAR FUT”, exchange=“NFO”, timeframe=“5”)

    print(f"Attempt {attempt + 1}: Checking API response...")
    
    # Debugging: Print Data Structure
    if isinstance(index_chart, dict):
        print("Response Keys:", index_chart.keys())
    elif isinstance(index_chart, pd.DataFrame):
        print("Received DataFrame with", index_chart.shape[0], "rows")
    
    # Check if data is valid
    if isinstance(index_chart, dict) and 'candles' in index_chart and len(index_chart['candles']) > 2:
        return pd.DataFrame(index_chart['candles'], columns=["TIMESTAMP", "OPEN", "HIGH", "LOW", "CLOSE", "VOLUME"])
    
    print("Warning: No candle data found, retrying...")
    time.sleep(2)  # Wait before retrying

return None  # Return None if all attempts fail

Fetch candle data

index_chart = fetch_data()

If data is successfully fetched, process it

if index_chart is not None and not index_chart.empty:
# Convert timestamp
index_chart[“TIMESTAMP”] = pd.to_datetime(index_chart[“TIMESTAMP”], unit=‘s’)

# Extract the last three candles
first_candle = index_chart.iloc[-3]
second_candle = index_chart.iloc[-2]
running_candle = index_chart.iloc[-1]

print("\nExtracted Candles:")
print("First Candle:", first_candle.to_dict())
print("Second Candle:", second_candle.to_dict())
print("Running Candle:", running_candle.to_dict())

# Calculate Pivot Points
index_chart['Pivot'] = (index_chart['HIGH'] + index_chart['LOW'] + index_chart['CLOSE']) / 3
index_chart['R1'] = (2 * index_chart['Pivot']) - index_chart['LOW']
index_chart['S1'] = (2 * index_chart['Pivot']) - index_chart['HIGH']
index_chart['R2'] = index_chart['Pivot'] + (index_chart['HIGH'] - index_chart['LOW'])
index_chart['S2'] = index_chart['Pivot'] - (index_chart['HIGH'] - index_chart['LOW'])
index_chart['R3'] = index_chart['R1'] + (index_chart['HIGH'] - index_chart['LOW'])
index_chart['S3'] = index_chart['S1'] - (index_chart['HIGH'] - index_chart['LOW'])

# Print the latest pivot levels
latest_pivot = index_chart.iloc[-1]
print("\nPivot Points for:", "NIFTY MAR FUT (5-Min Timeframe)")
print("Pivot:", latest_pivot['Pivot'])
print("R1:", latest_pivot['R1'])
print("S1:", latest_pivot['S1'])
print("R2:", latest_pivot['R2'])
print("S2:", latest_pivot['S2'])
print("R3:", latest_pivot['R3'])
print("S3:", latest_pivot['S3'])

else:
print(“\n❌ ERROR: No sufficient candle data found in the response after retries.”)

this is the error which i am getting it

Attempt 1: Checking API response…
Received DataFrame with 225 rows
Warning: No candle data found, retrying…
Attempt 2: Checking API response…
Received DataFrame with 225 rows
Warning: No candle data found, retrying…
Attempt 3: Checking API response…
Received DataFrame with 225 rows
Warning: No candle data found, retrying…

:x: ERROR: No sufficient candle data found in the response after retries.Preformatted text

2

try claude… i can’t check issues by myself cause i don’t have dhan api access (i mostly use yfinance data to trade stocks ) but one things that mostly happens in frequently handling and updating data frames is when your are trying to update the dataframe the code can’t find the consistency in data like let’s say you fetched the data on df and than updated the pivots using the same df than it causes that issue… you can use other dataframe like copy the original data to the new df and perform operation on it also you need to consider there are network inconsistencies even on broadband networks hence do try sleep function after every instance of fetch … also you are trying to handle the running candle data it has some issues though let’s say the candle formed in your chart is showing a 5 pts gap but same isn’t actually true when you will refresh the page it will form the candle like there wasn’t any gap and this happens due to client network issues causing inconsistency in data also back test your strategy (use pine code) whatever you are planning in live market use paper trades… whatever appears visibly easier on charts already isn’t worth it practically options isn’t consistent if you plan to do it regularly

3

@Tradehull_Imran please give me pivot code

4

Hi @Rahul_singh1 ,

Use the below code for Pivot:

def get_pivot_point(chart_data):
    PP = (chart_data['high'].max() + chart_data['low'].min() + chart_data["close"].iloc[-1])/3 
    R1 = 2 * PP - chart_data['low'].min()
    R2 = PP + (chart_data['high'].max() - chart_data['low'].min())         
    R3 = PP + 2 * (chart_data['high'].max() - chart_data['low'].min())          
    S1 = 2 * PP - chart_data['high'].max()          
    S2 = PP - (chart_data['high'].max() - chart_data['low'].min())
    S3 = PP - 2 * (chart_data['high'].max() - chart_data['low'].min()) 

    return PP, R1, R2, R3, S1, S2, S3
1 Like