=TEXTJOIN(“,”,,A3:A52)
Download and paste the list of stocks into the Excel sheet and apply above formula on column where list has been pasted.
https://www.nseindia.com/products-services/indices-broad-market
Step 1: Copy the entire column from the Excel sheet, including stocks, after applying the above formula.
click the “+” symbol to add stocks.
Step 2: Copy the entire paragraph below as it is with all the symbols. Shortcut “Ctrl + C”
NSE:ADANIPORTS, NSE:ASIANPAINT, NSE:AXISBANK, NSE:BAJAJ_AUTO, NSE:BAJAJFINSV, NSE:BAJFINANCE, NSE:BHARTIARTL, NSE:BPCL, NSE:BRITANNIA, NSE:CIPLA, NSE:COALINDIA, NSE:DIVISLAB, NSE:DRREDDY, NSE:EICHERMOT, NSE:GAIL, NSE:GRASIM, NSE:HCLTECH, NSE:HDFC, NSE:HDFCBANK, NSE:HDFCLIFE, NSE:HEROMOTOCO, NSE:HINDALCO, NSE:HINDUNILVR, NSE:ICICIBANK, NSE:INDUSINDBK, NSE:INFY, NSE:IOC, NSE:ITC, NSE:JSWSTEEL, NSE:KOTAKBANK, NSE:LT, NSE:M_M, NSE:MARUTI, NSE:NESTLEIND, NSE:NTPC, NSE:ONGC, NSE:POWERGRID, NSE:RELIANCE, NSE:SBILIFE, NSE:SBIN, NSE:SHREECEM, NSE:SUNPHARMA, NSE:TATAMOTORS, NSE:TATASTEEL, NSE:TCS, NSE:TECHM, NSE:TITAN, NSE:ULTRACEMCO, NSE:UPL, NSE:WIPRO,
NSE:ACC,
NSE:ABBOTINDIA,
NSE:ADANIGREEN,
NSE:ADANIPORTS,
NSE:ADANITRANS,
NSE:ALKEM,
NSE:AMBUJACEM,
NSE:ASIANPAINT,
NSE:AUROPHARMA,
NSE:DMART,
NSE:AXISBANK,
NSE:BAJAJ_AUTO,
NSE:BAJFINANCE,
NSE:BAJAJFINSV,
NSE:BAJAJHLDNG,
NSE:BANDHANBNK,
NSE:BANKBARODA,
NSE:BERGEPAINT,
NSE:BPCL,
NSE:BHARTIARTL,
NSE:BIOCON,
NSE:BOSCHLTD,
NSE:BRITANNIA,
NSE:CADILAHC,
NSE:CIPLA,
NSE:COALINDIA,
NSE:COLPAL,
NSE:CONCOR,
NSE:DLF,
NSE:DABUR,
NSE:DIVISLAB,
NSE:DRREDDY,
NSE:EICHERMOT,
NSE:GAIL,
NSE:GICRE,
NSE:GODREJCP,
NSE:GRASIM,
NSE:HCLTECH,
NSE:HDFCAMC,
NSE:HDFCBANK,
NSE:HDFCLIFE,
NSE:HAVELLS,
NSE:HEROMOTOCO,
NSE:HINDALCO,
NSE:HINDPETRO,
NSE:HINDUNILVR,
NSE:HINDZINC,
NSE:HDFC,
NSE:ICICIBANK,
NSE:ICICIGI,
NSE:ICICIPRULI,
NSE:ITC,
NSE:IOC,
NSE:IGL,
NSE:INDUSTOWER,
NSE:INDUSINDBK,
NSE:NAUKRI,
NSE:INFY,
NSE:INDIGO,
NSE:JSWSTEEL,
NSE:KOTAKBANK,
NSE:LTI,
NSE:LT,
NSE:LUPIN,
NSE:M_M,
NSE:MARICO,
NSE:MARUTI,
NSE:MOTHERSUMI,
NSE:MUTHOOTFIN,
NSE:NMDC,
NSE:NTPC,
NSE:NESTLEIND,
NSE:ONGC,
NSE:OFSS,
NSE:PETRONET,
NSE:PIDILITIND,
NSE:PEL,
NSE:PFC,
NSE:POWERGRID,
NSE:PGHH,
NSE:PNB,
NSE:RELIANCE,
NSE:SBICARD,
NSE:SBILIFE,
NSE:SHREECEM,
NSE:SIEMENS,
NSE:SBIN,
NSE:SUNPHARMA,
NSE:TCS,
NSE:TATACONSUM,
NSE:TATAMOTORS,
NSE:TATASTEEL,
NSE:TECHM,
NSE:TITAN,
NSE:TORNTPHARM,
NSE:UPL,
NSE:ULTRACEMCO,
NSE:UBL,
NSE:MCDOWELL_N,
NSE:WIPRO,
NSE:AARTIIND,
NSE:ABBOTINDIA,
NSE:ABCAPITAL,
NSE:ABFRL,
NSE:ACC,
NSE:ADANIENT,
NSE:ADANIGAS,
NSE:ADANIGREEN,
NSE:ADANIPORTS,
NSE:ADANITRANS,
NSE:AJANTPHARM,
NSE:ALKEM,
NSE:AMARAJABAT,
NSE:AMBUJACEM,
NSE:APLLTD,
NSE:APOLLOHOSP,
NSE:APOLLOTYRE,
NSE:ASHOKLEY,
NSE:ASIANPAINT,
NSE:AUBANK,
NSE:AUROPHARMA,
NSE:AXISBANK,
NSE:BAJAJ_AUTO,
NSE:BAJAJFINSV,
NSE:BAJAJHLDNG,
NSE:BAJFINANCE,
NSE:BALKRISIND,
NSE:BANDHANBNK,
NSE:BANKBARODA,
NSE:BANKINDIA,
NSE:BATAINDIA,
NSE:BBTC,
NSE:BEL,
NSE:BERGEPAINT,
NSE:BHARATFORG,
NSE:BHARTIARTL,
NSE:BHEL,
NSE:BIOCON,
NSE:BOSCHLTD,
NSE:BPCL,
NSE:BRITANNIA,
NSE:CADILAHC,
NSE:CANBK,
NSE:CASTROLIND,
NSE:CESC,
NSE:CHOLAFIN,
NSE:CIPLA,
NSE:COALINDIA,
NSE:COFORGE,
NSE:COLPAL,
NSE:CONCOR,
NSE:COROMANDEL,
NSE:CROMPTON,
NSE:CUB,
NSE:CUMMINSIND,
NSE:DABUR,
NSE:DALBHARAT,
NSE:DHANI,
NSE:DIVISLAB,
NSE:DLF,
NSE:DMART,
NSE:DRREDDY,
NSE:EDELWEISS,
NSE:EICHERMOT,
NSE:EMAMILTD,
NSE:ENDURANCE,
NSE:ESCORTS,
NSE:EXIDEIND,
NSE:FEDERALBNK,
NSE:FORTIS,
NSE:FRETAIL,
NSE:GAIL,
NSE:GICRE,
NSE:GLENMARK,
NSE:GMRINFRA,
NSE:GODREJAGRO,
NSE:GODREJCP,
NSE:GODREJIND,
NSE:GODREJPROP,
NSE:GRASIM,
NSE:GSPL,
NSE:GUJGASLTD,
NSE:HAVELLS,
NSE:HCLTECH,
NSE:HDFC,
NSE:HDFCAMC,
NSE:HDFCBANK,
NSE:HDFCLIFE,
NSE:HEROMOTOCO,
NSE:HINDALCO,
NSE:HINDPETRO,
NSE:HINDUNILVR,
NSE:HINDZINC,
NSE:HUDCO,
NSE:IBULHSGFIN,
NSE:ICICIBANK,
NSE:ICICIGI,
NSE:ICICIPRULI,
NSE:IDEA,
NSE:IDFCFIRSTB,
NSE:IGL,
NSE:INDHOTEL,
NSE:INDIGO,
NSE:INDUSINDBK,
NSE:INFRATEL,
NSE:INFY,
NSE:IOC,
NSE:IPCALAB,
NSE:IRCTC,
NSE:ISEC,
NSE:ITC,
NSE:JINDALSTEL,
NSE:JSWENERGY,
NSE:JSWSTEEL,
NSE:JUBLFOOD,
NSE:KOTAKBANK,
NSE:L&TFH,
NSE:LALPATHLAB,
NSE:LICHSGFIN,
NSE:LT,
NSE:LTI,
NSE:LTTS,
NSE:LUPIN,
NSE:M_M,
NSE:M_MFIN,
NSE:MANAPPURAM,
NSE:MARICO,
NSE:MARUTI,
NSE:MCDOWELL_N,
NSE:MFSL,
NSE:MGL,
NSE:MINDTREE,
NSE:MOTHERSUMI,
NSE:MPHASIS,
NSE:MRF,
NSE:MUTHOOTFIN,
NSE:NAM_INDIA,
NSE:NATCOPHARM,
NSE:NATIONALUM,
NSE:NAUKRI,
NSE:NAVINFLUOR,
NSE:NESTLEIND,
NSE:NMDC,
NSE:NTPC,
NSE:OBEROIRLTY,
NSE:OFSS,
NSE:OIL,
NSE:ONGC,
NSE:PAGEIND,
NSE:PEL,
NSE:PETRONET,
NSE:PFC,
NSE:PFIZER,
NSE:PGHH,
NSE:PIDILITIND,
NSE:PIIND,
NSE:PNB,
NSE:POLYCAB,
NSE:POWERGRID,
NSE:PRESTIGE,
NSE:RAJESHEXPO,
NSE:RAMCOCEM,
NSE:RBLBANK,
NSE:RECLTD,
NSE:RELIANCE,
NSE:SAIL,
NSE:SANOFI,
NSE:SBICARD,
NSE:SBILIFE,
NSE:SBIN,
NSE:SHREECEM,
NSE:SIEMENS,
NSE:SRF,
NSE:SRTRANSFIN,
NSE:SUNPHARMA,
NSE:SUNTV,
NSE:SYNGENE,
NSE:TATACHEM,
NSE:TATACONSUM,
NSE:TATAMOTORS,
NSE:TATAPOWER,
NSE:TATASTEEL,
NSE:TCS,
NSE:TECHM,
NSE:TITAN,
NSE:TORNTPHARM,
NSE:TORNTPOWER,
NSE:TRENT,
NSE:TVSMOTOR,
NSE:UBL,
NSE:ULTRACEMCO,
NSE:UNIONBANK,
NSE:UPL,
NSE:VBL,
NSE:VGUARD,
NSE:VOLTAS,
NSE:WHIRLPOOL,
NSE:WIPRO,
NSE:YESBANK,
NSE:ZEEL,