pip install yfinance pandas openpyxl

 import yfinance as yf

 import pandas as pd



 # Fetch Nifty 50 tickers (replace with actual tickers if needed)

 nifty50_tickers = [

 "RELIANCE.NS", "TCS.NS", "HDFCBANK.NS", "INFY.NS", "HINDUNILVR.NS",

 "ICICIBANK.NS", "HDFC.NS", "SBIN.NS", "KOTAKBANK.NS", "BHARTIARTL.NS",

 # Add all other tickers here

 ]



 # Fetch data and create a DataFrame

 data = {ticker: yf.Ticker(ticker).info for ticker in nifty50_tickers}

 df = pd.DataFrame(data).T # Transpose for a better view

# Select and clean the columns as needed

 df = df[['symbol', 'longName', 'sector', 'marketCap']]

 # Save to Excel

 df.to_excel("Nifty50_Stocks.xlsx", index=False)

 print("Data saved to Nifty50_Stocks.xlsx")