Fundamental / Technical Analysis - List of all BSE & NSE Stock Codes in Yahoo (.BO & .NS) in STRATEGIES & PLANS - I was trying extract list of all NSE and BSE Stock codes in Yahoo. It was a very tedious job ...
07-19-2012 09:02 PM
List of all BSE & NSE Stock Codes in Yahoo (.BO & .NS)
I was trying extract list of all NSE and BSE Stock codes in Yahoo. It was a very tedious job to extract from Yahoo Finance.
Then i came across an easy way to generate the stock code list in a fast and easy way. Below's the step by step procedure.
- Download the latest Bhavcopy from NSE and BSE sites.
- Apply the XL sheet formula (=TRIM(LEFT(A2,9)) & ".NS") to generate NSE Code list for yahoo, assuming column A has NSE code list
- Similarly use the formula (=TRIM(LEFT(A2,9)) & ".BO") to generate BSE Code list for Yahoo, assuming column A has BSE code list
Below's the attached XL sheet containing both BSE and NSE Stock list with respective Yahoo codes.
Yahoo Finance Stock Codes.zip --> Last updated 19th July 2012
If you need me to generate the latest list for you, you can ask in this thread and i will keep updating the attachment
Visitors found this page by searching for:
nse code list,
bse code list,
yahoo finance nse stock list,
bse symbol list,
nse stock code list,
yahoo bse symbol list,
list of stocks CODE IN NSE AND BSE,
yahoo list of bse companies,
bse nse code list,
bse stock code list,
list of all stocks in nse,
nses stock code,
nse bse codes,
nse yahoo symbol list,
bse codes of stocks,
bse nse quote code ine,
all stocks nsc code,
stock list with nse and bse code,
list of all shares in nse
Tags for this Thread