BSE ticker symbol NSe ticker symbol mapping

hello, im in search of some mapping to merge bse n nse knowledge downloaded from bseindia n nseindia web site.However each bse n nse use totally different image:like for RELIANCE INDUSTRIES inventory, bse use ‘500325’ n nse use ‘RELIANCE’is a way there to map n merge these knowledge from bse n nse – i must work than 400 stocksthx

ISIN is similar on each exchanges

however solely bse knowledge have isin…nse knowledge haven’t any isin so cant map

All Corporations primarily based on Market Capitalisation

BSE (previously Bombay Inventory Trade) | Fairness-Reside Reviews

Obtain excel file and map the image title do vloockup in excel

thanks…however image title in each of hyperlink information you gave are totally different, so vlookup not workingeven ABB is point out as ABB India Restricted in NSE MCAP file you gave, and it’s point out as ABB LTD. in BSE file you gave, so vlooup not working

Use vlookup on BSE Colom TckrSymb

and NSE Colom Image

NSE Sheet

BSE Sheet

thanks once more…really grateful for ur assist.however when i attempt to get the bse sheet from the next, not one of the 2 information title ‘fairness’ and ‘fairness with isin’ have ticker image…see photographs

these information open as comply with and dont have ticker image
bse fairness file

bse fairness with isin file

which file do you obtain from bse which has ticker to vlookup match? thank once more

thank u once more.todays file has that ticker. however i used to be loking in outdated file of 2020 it was not there.However i created vlookup in todays file n utilizing it pull knowledge from outdated file. it really works.thenk u very a lot for particulars