Stock Market Real time dashboard in Google sheet

By
Image
Here’s the step-by-step process for creating a Google Sheets dashboard for real-time stock market data in a point-by-point format: --- Step 1: Setup the Google Sheet 1. Open a new Google Sheet. 2. Rename the sheet to something like "Stock Dashboard." --- Step 2: Enable Real-Time Data with GOOGLEFINANCE 1. Use the GOOGLEFINANCE function to fetch stock data. 2. Example formulas: Current Price: =GOOGLEFINANCE("TICKER_SYMBOL", "price") Opening Price: =GOOGLEFINANCE("TICKER_SYMBOL", "open") 52-Week High: =GOOGLEFINANCE("TICKER_SYMBOL", "high52") 52-Week Low: =GOOGLEFINANCE("TICKER_SYMBOL", "low52") Market Cap: =GOOGLEFINANCE("TICKER_SYMBOL", "marketcap") --- Step 3: Create Columns for Data 1. Add headers in Row 1: Stock Symbol Current Price Open Price 52W High 52W Low Market Cap 2. Enter stock symbols (e.g., "GOOG", "AAPL") in Column A. 3. Use the GOO
Post a Comment

Getting Distance and Traveling Time (Bus Mode) Details from Google Maps in ASP.NET C# using Google Maps API XML & XPath Webservice

By
Description:

1. In Design View Coding, add the Javascript Code in Head section to make an integration with Google Maps API Script.

    <script src="https://maps.googleapis.com/maps/api/js?sensor=false&libraries=places"
        type="text/javascript"></script>


2. Add the Source and Destination functions inside script tags, which is indicating the locations

function Source() {
            try {
                var input = document.getElementById('TextBox1');
                var autocomplete = new google.maps.places.Autocomplete(input);
                autocomplete.setTypes('changetype-geocode');
            }
            catch (err) {
                // exception catching here
            }
        }

        
        function Destination() {
            try {
                var input = document.getElementById('TextBox2');
                var autocomplete = new google.maps.places.Autocomplete(input);
                autocomplete.setTypes('changetype-geocode');
            }
            catch (err) {
                // exception catching here;
            }
        }


3. Add dom event Listner Load function in window
        
        google.maps.event.addDomListener(window, 'load', Source);
        google.maps.event.addDomListener(window, 'load', Destination);  
        
4. Finally add these codes, in thecode behind page of Default.aspx.cs which uses Google Maps distancematrix webservice api to get the distance between the two or more Address, city Locations as well as Travelling Time of the two end points in different mode, Here I have used Vehicle Type mode as Bus;


    //Travel mode as Bus
    public void google_Distance_TravelTime_BusMode()
    {
        //Declare variable to store XML result
        string xmlResult = null;

        //Pass request to google api with orgin and destination details
        HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://maps.googleapis.com/maps/api/distancematrix/xml?origins=" + TextBox1.Text + "&destinations=" + TextBox2.Text + "&mode=Bus&language=us-en&sensor=false");

        HttpWebResponse response = (HttpWebResponse)request.GetResponse();

        //Get response as stream from httpwebresponse
        StreamReader resStream = new StreamReader(response.GetResponseStream());

        //Create instance for xml document

        XmlDocument doc = new XmlDocument();

        //Load response stream in to xml result
        xmlResult = resStream.ReadToEnd();

        //Load xmlResult variable value into xml documnet
        doc.LoadXml(xmlResult);

        string output = "";

        try
        {
            //Get specified element value using select single node method and verify it return OK (success ) or failed
            if (doc.DocumentElement.SelectSingleNode("/DistanceMatrixResponse/row/element/status").InnerText.ToString().ToUpper() != "OK")
            {
                Label2.ForeColor = System.Drawing.Color.Red;

                Label2.Text = "Invalid City Name please try again";
                
                return;
            }

            //Get DistanceMatrixResponse element and its values
            XmlNodeList xnList = doc.SelectNodes("/DistanceMatrixResponse");
            foreach (XmlNode xn in xnList)
            {
                if (xn["status"].InnerText.ToString() == "OK")
                {
                    //Form a table and bind it orgin, destination place and return distance value, approximate duration
                    output = "<table align='center' width='600' cellpadding='0' cellspacing='0'>";
                    output += "<tr><td height='60' colspan='2' align='center'><b>Travel Details</b></td>";
                    output += "<tr><td height='40' width='30%' align='left'>Source</td><td align='left'>" + xn["origin_address"].InnerText.ToString() + "</td></tr>";
                    output += "<tr><td height='40' align='left'>Destination</td><td align='left'>" + xn["destination_address"].InnerText.ToString() + "</td></tr>";
                    output += "<tr><td height='40' align='left'>Travel Duration(apprx.) </td><td align='left'>" + doc.DocumentElement.SelectSingleNode("/DistanceMatrixResponse/row/element/duration/text").InnerText + "</td></tr>";
                    output += "<tr><td height='40' align='left'>Distance</td><td align='left'>" + doc.DocumentElement.SelectSingleNode("/DistanceMatrixResponse/row/element/distance/text").InnerText + "</td></tr>";
                    output += "</table>";

                    //finally bind it in the result label control

                    Label1.ForeColor = System.Drawing.Color.Green;
                    Label1.Text = doc.DocumentElement.SelectSingleNode("/DistanceMatrixResponse/row/element/distance/text").InnerText;
                    Label2.ForeColor = System.Drawing.Color.Green;
                    Label2.Text = doc.DocumentElement.SelectSingleNode("/DistanceMatrixResponse/row/element/duration/text").InnerText;
                    Label3.ForeColor = System.Drawing.Color.Green;
                    Label3.Text = output;
                }
            }
        }
        catch (Exception ex)
        {
            Label2.ForeColor = System.Drawing.Color.Red;
            Label2.Text = "Error during processing";
            return;
        }
    }



Screen Shots

1. Normal View



















2. Enter Source Location: 



3. Enter Destination Location
























4. Results : Distance  and Travelling  Time



5. Reset 























Design View Coding



Code Behind Coding



Happy Coding,
Regards,
Kumaran K.

Comments

Post a Comment

Share this to your friends

Popular posts from this blog

"How to maintain or retain tabs in same tab after button click events or postback?" using JQuery in ASP.NET C#

By
Image
In this post I'll share an details about " How to maintain or retain tabs in same tab after button click events or postback? " Step 1: you need to download Jquery and JQueryUI Javascript libraries from this site http://jqueryui.com/ Step 2: As usually you can create ASP.NET website from Visual Studio IDE and add Jquery and JqueryUI plugins in the header section of aspx page. Step 3: Add HiddenField control inside aspx page which is very useful to retain tab in same page Step 4: Use the HiddenField ID in Jquery code to indicate that CurrentTab Index Step 5: In code Behind, using Enumerations concept give the tab index values as user defined variable  Step 6: Use the Enum values in every Button click events on different tabs to check that tab could be retained in the same tab Further, Here I'll give the code details and snap shot pictures, 1. Default.aspx: Design Page <%@ Page Language="C#" AutoEventWireup="true" CodeFile="
Read more

Login and Registration forms in C# windows application with Back end Microsoft SQL Server for data access

By
Image
In this article, I'm gonna share about how to make login and register form with MS SQL database; 1. Flow Chart Logic 2. Normal Features 3. Form Designs Login Form Design Sign in Form Design Password Retrieve Form 4. Database Design and SQL queries and Stored Procedure Create new Database as "schooldata" create table registerdata (  ID int identity,  Username nvarchar(100),  Password nvarchar(100),  Fullname  nvarchar(100),  MobileNO nvarchar(100),  EmailID nvarchar(100)  ) select * from registerdata create procedure regis (  @Username as nvarchar(100),  @Password as nvarchar(100),  @Fullname as nvarchar(100),  @MobileNO as nvarchar(100),  @EmailID as nvarchar(100)  ) as begin insert into registerdata (Username, Password, Fullname, MobileNO,EmailID) values (@Username, @Password, @Fullname, @MobileNO, @EmailID) end 5. App.config Settings <?xml versio
Read more

JSP and Servlet Form Submission without page refresh show results on the same page using Jquery AJAX

By
Image
Code Snippet HTML Form  <form id='ajaxform' name='ajaxform' action='ajaxformexample' method='post'>  First Name: <input type='text' id='firstname' name='firstname' size='30' required/><br/>  Last Name: <input type='text' id='lastname' name='lastname' size='30'required/><br/>  Email:  <input type='email' id='emailid' name='emailid' size='30'required/><br/>  Password:  <input type='password' id='pwd' name='pwd' size='30'required/><br/>  <input type='Submit'/>   <div id='content'> </div> </form> the above HTML Form uses post method and url servlet redirect to " ajaxformexample " Javascript Code  var form = $('#ajaxform'); // id of form tag  form.submit(function () {  $.ajax({  
Read more