DownLoading Complete Symbol List From Yahoo Finance Website

[sunnydell44]

The list is too big and takes an hour to update so thought about it and came up with this small list which is used by invesbulls as well however you will not be able to get nifty futures mininifty futures and bankindex futures. In case if you forget to update the data you can check with invest bullls web site

http://www.investbulls.com/download.php however you have to register to download the data you can even download past data as well.

you can download the data directly form this tool available at the following link
http://www.volumedigger.com/Software/Data_Downloader_Help.aspx

You can click on the following link for Investbulls yahoo symbol list

http://www.4shared.com/file/AMELphKU/INVEST_BULLS_YAHOO_SYMBOL_LIST.html

might be of any help you can ping me at [email protected]

Regards
[email protected]

 

[mvl.hanumantharao]

Hi, You can download,

All NSE Symbols,
All BSE Symbols,
All ICICIDIRECT Symbols,
All Yahoo Symbols

And all mappings at www.highdeliveries.com

Thanks,
:thumb:

 

[saivenkat]

Hi, You can download,

All NSE Symbols,
All BSE Symbols,
All ICICIDIRECT Symbols,
All Yahoo Symbols

And all mappings at www.highdeliveries.com

Thanks,
:thumb:

But then you are compelled to get yourself registered, and more over we are charged.. Its not free..

 

[murthymsr]

I need yahoo symbol list of all exchanges in 1 xl file ,can anybody help me

Hi,
1) Download Bhav copy from NSEINDIA.
2) Take the first 9 characters of the NSE symbol.
3) add ".NS" for Yahoo symbol (NSE).
4) Add ".BO" for Yahoo symbol (BSE).

This can easily be done with Excel sheet and is fairly accurate, but for some exceptions.

murthymsr

 

[tkamal]

Friends,
LittLe contribution from me,
Attached fiLes:
(1) BSE YAHOO SYMBOLS.CSV
(2) NSE YAHOO SYMBOLS.csv

BSE YAHOO SYMBOLS.CSV
NSE YAHOO SYMBOLS.csv


Regards,
-tkamal

 

[rahul_chauhan]

Thanks a lot dear...this code is very helpfl 4 me...thanks a lot again....

 

[bharodiya]

This is a solution for NSE symbol list for yahoo finance.
New company comes and some old companies vanish from the list.
We have to update list time to time. NSE bhavcopy is only source to know which symbols are currently working.
To get latest symbol list use NSE bhavcopy and to convert it for yahoo, use this excel file.
File name is YsymbMaker.xlsm
Link is
http://www.4shared.com/dir/-P7kfEeH/ForShare.html
I am sorry this file is for ms office 2007 only.
If you dont have office 7 then follow me, make it yourself.
Open a new excel file, name it and save.
In sheet 1, from cell A5 to A8 put these 4 lines. Make 1st line red in colour.
( (1) Close all excel files. Only open NSE bhavcopy.
(2)If you do not have bhacopy and have only symbol list then put a value "TIMESTAMP" in cell K1
(3)This is a filter to recognize bhavcopy. This filter is added to make safe another excel files.
(4)Symbol list should be original as bhavcopy.)

Add a textbox between cell A8 and A12.
Add this line into textbox Click for make symbol list
This is a button. You can format that for colour and style in your way.

Add these remaining lines after button.

( (5) Wait for complete, bhavcopy is now symbol list.
(6)In col 2 symbol is with "&" character
(7)In col 3 "&" is replaced.
(8)Issue of "&" will end now. I have checked M&M in yahoo.
(9) RT data is available with "&". EOD data totally not available. Means they are updating their system.
(10) If you want use another way, formuala is given in next 3 sheets.)

Now add a module and paste these mecro codes. Link start mecro with button.


Sub Start()
Bhavcopy
Application.ScreenUpdating = False
If Range("K1").Value = "TIMESTAMP" Then
Range("A1").EntireRow.Delete
Range("B1:L1").EntireColumn.Delete
Gadhekipunchh
ANDkoBadalo
Else
End If
Application.ScreenUpdating = True
End Sub
Private Sub Bhavcopy()
Dim w As Workbook
Dim x As String
For Each w In Workbooks
If w.Name <> ThisWorkbook.Name Then x = w.Name
Next w
Workbooks(x).Activate
End Sub
Private Sub Gadhekipunchh()
Dim j As Integer
j = 1
Do Until IsEmpty(Cells(j, 1))
Cells(j, 2).FormulaR1C1 = "=IF(RC[-1]="""","""",IF(LEFT(RC[-1])=""^"",RC[-1],LEFT(RC[-1],9)&"".NS""))"
Cells(j, 2) = Cells(j, 2).Value
j = j + 1
Loop
End Sub

Private Sub ANDkoBadalo()
Dim j As Integer
Dim myval As String
j = 1
Do Until IsEmpty(Cells(j, 1))
If Mid(Cells(j, 2), 2, 1) = "&" Then
Cells(j, 3).FormulaR1C1 = "=REPLACE(RC[-1],2,1,""%26"")"
ElseIf Mid(Cells(j, 2), 3, 1) = "&" Then
Cells(j, 3).FormulaR1C1 = "=REPLACE(RC[-1],3,1,""%26"")"
ElseIf Mid(Cells(j, 2), 4, 1) = "&" Then
Cells(j, 3).FormulaR1C1 = "=REPLACE(RC[-1],4,1,""%26"")"
ElseIf Mid(Cells(j, 2), 5, 1) = "&" Then
Cells(j, 3).FormulaR1C1 = "=REPLACE(RC[-1],5,1,""%26"")"
ElseIf Mid(Cells(j, 2), 6, 1) = "&" Then
Cells(j, 3).FormulaR1C1 = "=REPLACE(RC[-1],6,1,""%26"")"
ElseIf Mid(Cells(j, 2), 7, 1) = "&" Then
Cells(j, 3).FormulaR1C1 = "=REPLACE(RC[-1],7,1,""%26"")"
ElseIf Mid(Cells(j, 2), 8, 1) = "&" Then
Cells(j, 3).FormulaR1C1 = "=REPLACE(RC[-1],8,1,""%26"")"
Else
Cells(j, 3) = Cells(j, 2).Value
End If
Cells(j, 3) = Cells(j, 3).Value
j = j + 1
Loop
Columns("A:C").ColumnWidth = 20
End Sub
As I put a line in sheet 1 (If you want use another way, formuala is given in next 3 sheets.)
Formula 1
Used for edit length of symbol and adds .NS ext.

=IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS"))
Place it in column B in next sheet. In column A put pure bhavcopys symbol.

Formula 2
Used for replace & character.

=IF(MID(A1,2,1)="&",REPLACE(A1,2,1,"%26"),IF(MID(A1,3,1)="&",REPLACE(A1,3,1,"%26"),IF(MID(A1,4,1)="&",REPLACE(A1,4,1,"%26"),IF(MID(A1,5,1)="&",REPLACE(A1,5,1,"%26"),IF(MID(A1,6,1)="&",REPLACE(A1,6,1,"%26"),IF(MID(A1,7,1)="&",REPLACE(A1,7,1,"%26"),IF(MID(A1,8,1)="&",REPLACE(A1,8,1,"%26"),A1)))))))
Place it in column B in next sheet. In column A put symbols processed by formula 1 .

Formula 3
Does everything.

=IF(MID(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),2,1)="&",REPLACE(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),2,1,"%26"),IF(MID(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),3,1)="&",REPLACE(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),3,1,"%26"),IF(MID(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),4,1)="&",REPLACE(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),4,1,"%26"),IF(MID(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),5,1)="&",REPLACE(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),5,1,"%26"),IF(MID(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),6,1)="&",REPLACE(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),6,1,"%26"),IF(MID(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),7,1)="&",REPLACE(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),7,1,"%26"),IF(MID(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),8,1)="&",REPLACE(IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")),8,1,"%26"),IF(A1="","",IF(LEFT(A1)="^",A1,LEFT(A1,9)&".NS")))))))))
Place it in column B in next sheet. In column A put pure bhavcopys symbol.

I request you, every one can not make this. If you have made this in office 2002-3 then upload for others.

SB

 

[suresvelan]

I need all the possible symbols list for each stock market.
Is there any free websites to have all the symbols data.
I tried in Yahoo and Google Finance but there is no way get all the details of the symbol.

Help me! if there is a way..

 

[Gundam]

Thanks a lot for the complete symbol list, this is very useful for me (new comer, first reply : ) )

 

[hv2289]

Hello vishalsjain,

As I monitor only a few active counters I normally go to the following page http://in.finance.yahoo.com/mnvl?e=BO and copy the symbols from there.

On this page you can get the most actives, top gainers and top losers on both the NSE & BSE.

BTW can you tell me which download software do you use?

Thanx Anil your link so quite helpful for downloding symbol data from "R" software