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…
these files open and dont have ticker symbol
which file do you download from bse which has ticker to vlookup match? thank again
thank u again.
todays file has that ticker. but i was loking in old file it was not there.
But i created vlookup in todays file n using it pull data from old file. it works.
thenk u very much for details
So can we conclude that ticker symbols on BSE and NSE both are same?then only we can match them!
An alternative to the above approach is to directly use the instrument mapping file available on the BSE website (Under the EQ > COMMON > Latest date > file named EQ_MAP_CC_DDMMYY.csv ). This contains the ISIN as well as the trading symbol on both the exchanges alongside their series information.