hello, im on the lookout for some mapping to merge bse n nse information downloaded from bseindia n nseindia web site.However each bse n nse use completely different image:like for RELIANCE INDUSTRIES inventory, bse use ‘500325’ n nse use ‘RELIANCE’is a way there to map n merge these information from bse n nse – i have to work than 400 stocksthx
ISIN is similar on each exchanges
however solely bse information have isin…nse information don’t have any isin so cant map
All Firms based mostly on Market Capitalisation
BSE (previously Bombay Inventory Trade) | Fairness-Stay 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 completely 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 photos
these information open as observe 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 information from outdated file. it really works.thenk u very a lot for particulars
