Stock Market Ticker For Website

Stock Market Ticker For Website

In this article we shall work out on Live stock market ticker for website. To develop live stock market ticker for website the basic requirement is to have live data. Free live data is available at some cost, but to display tickers on website we can always go for two to three minutes delayed data, which we can download from Yahoo Finance. Yahoo Finance is giving enable use to download CSV file in the manner we want. Once we get the CSV file logic which remains is to display data and Polling of data at certain interval

Check out folder structure of our Demo Code

(Note: Demo contains Cross Currency Data as well; which will be same as Stock market data.)

In this article we shall be considering major stock exchanges, and in demo code we shall see updates related to stock exchanges.

• DOW (Symbol: ^DJI)
• Nasdaq (Symbol: ^IXIC)
• S&P 500 (Symbol: ^GSPC)
• FTSE 100 (Symbol: ^FTSE)
• DAX (Symbol: ^GDAXI)
• CAC 40 (Symbol: ^FCHI)
• Hang Seng (Symbol: ^HSI)
• NIKKEI 225 (Symbol: ^N225)
• Straits Times (Symbol: ^STI)
• BSE India (Symbol: ^BSESN)
• NSE India (Symbol: ^NSEI)

If you go to Yahoo Finance and put any of the Symbol you can check all related data. Also that data is allowed to download, we are going to use this downloaded data to display live (little delayed) data to develop Stock Market Ticker for Website. (Note: If you are not aware about ICALLBack Event handler, please refer this article ---> ICallback Event Handler Article

We are going to get data from Yahoo Finance in CSV format. So we shall write logic accordingly. Following is the function to convert CSV in to Data Table.

view plainprint?

1. public static DataTable csvToDataTable(string strData, bool isRowOneHeader)  
2.     {  
3.         DataTable csvDataTable = new DataTable();  
4.         //no try/catch - add these in yourselfs or let exception happen  
5.         String[] csvData = strData.Replace("\r", "").Replace("=X", "").Split('\n');  
6.         //if no data in file ‘manually’ throw an exception  
7.         if (csvData.Length == 0)  
8.         {  
9.             throw new Exception("CSV File Appears to be Empty");  
10.         }  
11.   
12.         String[] headings = csvData[0].Split(',');  
13.         int index = 0; //will be zero or one depending on isRowOneHeader  
14.         if (isRowOneHeader) //if first record lists headers  
15.         {  
16.             index = 1; //so we won’t take headings as data  
17.             //for each heading  
18.             for (int i = 0; i < headings.Length; i++)  
19.             {  
20.                 //replace spaces with underscores for column names  
21.                 headings[i] = headings[i].Replace("", "_");  
22.                 //add a column for each heading  
23.                 csvDataTable.Columns.Add(headings[i], typeof(string));  
24.             }  
25.         }  
26.         else //if no headers just go for col1, col2 etc.  
27.         {  
28.             for (int i = 0; i < headings.Length; i++)  
29.             {  
30.                 //create arbitary column names  
31.                 csvDataTable.Columns.Add("col" + (i + 1).ToString(), typeof(string));  
32.             }  
33.         }  
34.         //populate the DataTable  
35.         for (int i = index; i < csvData.Length - 1; i++)  
36.         {  
37.             //create new rows  
38.             DataRow row = csvDataTable.NewRow();  
39.             for (int j = 0; j < headings.Length; j++)  
40.             {  
41.                 //fill them  
42.                 row[j] = csvData[i].Split(',')[j];  
43.             }  
44.             //add rows to over DataTable  
45.             csvDataTable.Rows.Add(row);  
46.         }  
47.   
48.         //return the CSV DataTable  
49.         return csvDataTable;  
50.     }  

Another Important Function for our development of Stock Market Ticker for website is, the function which will call Yahoo Finance to fetch desired data.

We shall user WebRequest Class to call remove CSV file i.e. Read a downloadable CSV file from remote server. Check out following function.

view plainprint?

1.  public DataTable CallYahooFinance()  
2.     {  
3.         WebRequest req = WebRequest.Create(StaticVariables.Markets);  
4.         WebResponse result = req.GetResponse();  
5.         Stream ReceiveStream = result.GetResponseStream();  
6.         Encoding encode = System.Text.Encoding.GetEncoding("utf-8");  
7.         StreamReader sr = new StreamReader(ReceiveStream, encode);  
8.         string output = string.Empty;  
9.         Char[] read = new Char[256];  
10.         int count = sr.Read(read, 0, read.Length);  
11.         while (count > 0)  
12.         {  
13.             String str = new String(read, 0, count);  
14.             output += str;  
15.             count = sr.Read(read, 0, read.Length);  
16.         }  
17.         output = output.Replace("^DJI", "DOW").Replace("^IXIC", "NASDAQ").Replace("^GSPC", "S&P500");  
18.         output = output.Replace("^FTSE", "FTSE 100").Replace("^GDAXI", "DAX").Replace("^FCHI", "CAC 40");  
19.         output = output.Replace("^HSI", "HANG SENG").Replace("^N225", "NIKKEI 225").Replace("^STI", "STRAITS TIMES");  
20.         output = output.Replace("^BSESN", "SENSEX").Replace("^NSEI", "NIFTY");  
21.         DataTable DT = csvToDataTable(output, false);  
22.         DT.Columns[0].ColumnName = "Market";  
23.         DT.Columns[1].ColumnName = "Last Trade";  
24.         DT.Columns[2].ColumnName = "Change (in %)";  
25.         return DT;  
26.     }   

In above code "output" is the string i.e. CSV string and we have replaced Yahoo Finance Symbols with the Name of the Stock Index.

If you check above function Webrequest.Create Methodcontains URL. To get CSV File we are using following URL, if you simple copy paste the URL you can download CSV file. URL for Stock Market Ticker is set into Static variable.

view plainprint?

1. public static class StaticVariables  
2. {  
3. public static string Markets = "http://download.finance.yahoo.com/d/quotes.csv?s=%5EDJI,%5EIXIC,%5EGSPC,%5EFTSE,%5EGDAXI,%5EFCHI,%5EN225,%5EHSI,%5ESTI,%5EBSESN,%5ENSEI&f=sl1c1&e=.csv";  
4. }  

Thats it now we got the relevant data from yahoo financewhich we can display the way we want. We are using ICallback Event handler to poll data from Yahoo Server. Now if you are aware about ICallback Simply check out following functions. Where we are not doing anything special.

view plainprint?

1. protected void Page_Load(object sender, EventArgs e)  
2.     {  
3.         if (!IsPostBack)  
4.         {  
5.             String cbReference =  
6.                 Page.ClientScript.GetCallbackEventReference(this, "arg", "ReceiveServerData", "context");  
7.             String callbackScript;  
8.             callbackScript = "function CallServer(arg, context)" +  
9.                 "{ " + cbReference + ";}";  
10.             Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "CallServer", callbackScript, true);  
11.         }  
12.     }  

Also check Region for ICallback Implementation

view plainprint?

1. public void RaiseCallbackEvent(String eventArgument)  
2.     {  
3.       
4.     }  
5.     public String GetCallbackResult()  
6.     {  
7.         GridView GridView1 = new GridView();  
8.         GridView1.DataSource = CallYahooFinance();  
9.         GridView1.DataBind();  
10.   
11.         return getHTML(GridView1);  
12.     }  
13.   
14.   
15. public string getHTML(GridView _grid)  
16.     {  
17.         string result = string.Empty;  
18.         using (StringWriter sw = new StringWriter())  
19.         {  
20.             HtmlTextWriter htw = new HtmlTextWriter(sw);  
21.             _grid.RenderControl(htw);  
22.             htw.Flush();  
23.              result = sw.ToString();  
24.         }  
25.         return result;  
26.     }  
27. //getHTML returns HTMLString for GRIDView  

Now in the HTML of our page we have only following tags.

view plainprint?

1. <div id="result"></div><div id="_polling" style="background-color: #66ffff; color: #000066; display: none; width: 192px;">Polling from server...  
2.         </div>  

We use following JavaScript to Fetch live data from server side at the interval of 1000mili second.

view plainprint?

1. function call()  
2.     {  
3.     window.document.getElementById('_polling').style.display="";  
4.     CallServer("", "");  
5.     }  
6.       
7.      function ReceiveServerData(retValue)  
8.     {     
9.         document.getElementById("result").innerHTML = retValue;  
10.         window.document.getElementById('_polling').style.display="none";  
11.         setTimeout("call()",1000); //Set polling to 1000mili second  
12.     }  

Implementation of above code is very simple check out Demo code for the same.
Download Demo Code here --> Stock Market Ticker For Website.zip