hi, im looking for some mapping to merge bse n nse data downloaded from bseindia n nseindia website.
But both bse n nse use different symbol:
like for RELIANCE INDUSTRIES stock, bse use ‘500325’ n nse use ‘RELIANCE’
is some way there to map n merge these data from bse n nse - i need to work than 400 stocks
thx
ISIN is same on both exchanges
but only bse data have isin…nse data have no isin so cant map
All Companies based on Market Capitalisation
BSE (formerly Bombay Stock Exchange) | Equity-Live Reports
Download excel file and map the symbol name do vloockup in excel
thank you…but symbol name in both of link files you gave are different, so vlookup not working
even ABB is mention as ABB India Limited in NSE MCAP file you gave, and it is mention as ABB LTD. in BSE file you gave, so vlooup not working
thank you again…truly thankful for ur help.
but when i try to get the bse sheet from the following, none of the 2 files name ‘equity’ and ‘equity with isin’ have ticker symbol…see images
these files open as follow and dont have ticker symbol
bse equity file
bse equity with isin file
which file do you download from bse which has ticker to vlookup match? thank again
