alpha_vantage_upcoming_earnings_df.py

from io import BytesIO
import requests
import time
import pandas as pd

def earnings_calendar_api(api_key, horizon, symbol=None):
    if symbol is not None:
        url = f'{BASE_URL}function=EARNINGS_CALENDAR&symbol={symbol}&horizon={horizon}&apikey={api_key}'
        response = requests.get(url)
    else:
        url = f"{BASE_URL}function=EARNINGS_CALENDAR&horizon={horizon}&apikey={api_key}"
        response = requests.get(url)

    return pd.read_csv(BytesIO(response.content))

API_KEY = "INSERT_YOUR_API_KEY_HERE"
horizon=["3month","6month","12month"]
earnings_calendar_api(API_KEY,horizon[0])