Yahoo .NS and .BO Stock code list - need help

#13
Hi everyone,

I am trying to use yahoo finance data for BSE and NSE into my application but I have observed that when the stock symbol goes beyond 9 characters, yahoo finance does not return the data.

As an example, the stock symbol for GlaxoSmithKline Pharmaceuticals Ltd. is as follows :

BSE = GLAXOPHARMA
NSE = GLAXO

Following is the Yahoo Finance call (using YQL)

http://query.yahooapis.com/v1/publi...://download.finance.yahoo.com/d/quotes.csv?s={stock_quote_symbol}%2C%26f%3Dsl1d1t1c1ohgv%26e%3D.csv%27%20and%20columns%3D%27symbol%2Cprice%2Cdate%2Ctime%2Cchange%2Ccol1%2Chigh%2Clow%2Ccol2%27&diagnostics=true

If you want the NSE data for GlaxoSmithKline Pharmaceuticals Ltd., In the above url replace {stock_quote_symbol} with GLAXO.NS

Doing so will pull the data in the XML format. However, if I want the data of the same company (which is GlaxoSmithKline Pharmaceuticals Ltd. in our case) from BSE stock symbol would become GLAXOPHARMA.BO
Now since the stock symbol is more than 9 characters (it is 11 to be precise), yahoo finance does not return the data. So the following URL will return you wrong data :

http://query.yahooapis.com/v1/publi...://download.finance.yahoo.com/d/quotes.csv?s=GLAXOPHARMA.BO%2C%26f%3Dsl1d1t1c1ohgv%26e%3D.csv%27%20and%20columns%3D%27symbol%2Cprice%2Cdate%2Ctime%2Cchange%2Ccol1%2Chigh%2Clow%2Ccol2%27&diagnostics=true

Can somebody help me here????

Thanks in advance.
Jameel
 

mastermind007

Well-Known Member
#14
Hi everyone,

I am trying to use yahoo finance data for BSE and NSE into my application but I have observed that when the stock symbol goes beyond 9 characters, yahoo finance does not return the data.

As an example, the stock symbol for GlaxoSmithKline Pharmaceuticals Ltd. is as follows :

BSE = GLAXOPHARMA
NSE = GLAXO

Following is the Yahoo Finance call (using YQL)

http://query.yahooapis.com/v1/publi...://download.finance.yahoo.com/d/quotes.csv?s={stock_quote_symbol}%2C%26f%3Dsl1d1t1c1ohgv%26e%3D.csv%27%20and%20columns%3D%27symbol%2Cprice%2Cdate%2Ctime%2Cchange%2Ccol1%2Chigh%2Clow%2Ccol2%27&diagnostics=true

If you want the NSE data for GlaxoSmithKline Pharmaceuticals Ltd., In the above url replace {stock_quote_symbol} with GLAXO.NS

Doing so will pull the data in the XML format. However, if I want the data of the same company (which is GlaxoSmithKline Pharmaceuticals Ltd. in our case) from BSE stock symbol would become GLAXOPHARMA.BO
Now since the stock symbol is more than 9 characters (it is 11 to be precise), yahoo finance does not return the data. So the following URL will return you wrong data :

http://query.yahooapis.com/v1/publi...://download.finance.yahoo.com/d/quotes.csv?s=GLAXOPHARMA.BO%2C%26f%3Dsl1d1t1c1ohgv%26e%3D.csv%27%20and%20columns%3D%27symbol%2Cprice%2Cdate%2Ctime%2Cchange%2Ccol1%2Chigh%2Clow%2Ccol2%27&diagnostics=true

Can somebody help me here????

Thanks in advance.
Jameel
You explained something that had been puzzling me.

Yahoo Datafeeder that I use added duplicate symbols in amibroker every time I used it. For instance, it would create ADANIPOWE (I had been manually merging it into ADANIPOWER and added alias too) but it kept creating new one. Same was the case with BALRAMCHI/ BALRAMCHIN

I was unable to understand the logic until you posted this. Only one correction, Limit seems to be 9 characters and not 8.