Stock Tracking Dashboard and Live Stock Price Quotes Using Excel

Posted on 22 October 2009

Nearly everybody I know uses Excel for tracking the returns in the stock market. Not many however know that Excel can be used for online stock tracking and getting live price information from stock exchanges like NYSE and Nasdaq as well. Here's how.Establishing a connection to the MSN server for Stock Quotes Click on the data tab in the Excel ribbon (in Excel 2007 and later). In Excel 2003 and earlier, ... Continue Reading

Comments     

HTML to Excel using Javascript and Excel to HTML using VBA

Posted on 23 September 2009

This two part article consists of: Part A - Converting HTML to Excel using Javascript Part B - Exporting Excel to HTML using VBAHTML to Excel using javascriptLet’s first take a look at tables in html. Data tables are typically stored in HTML using the <table> tag. Such a table will typically consist of one or more rows (<tr> tag) with each row having one or more cells (<td> tag). To read a table from an HTML document ... Continue Reading

Comments (7)

Chart Label Trick – Converting Chart Axis Labels to Table

Posted on 18 September 2009

The labels used with the chart category axis are probably the most ignored part of the entire chart making process. You see, the labels on the value axis can be modified, the bars, the lines and the plot area - all of them can be embellished - colors added, widths adjusted, descriptions applied - the works you know ! Even the poor little gridlines can afford a makeover. But what about the chart's category axis label - what do ... Continue Reading

Comments (2)

Chart Table – When Chart meets Table

Posted on 15 September 2009

Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ... Continue Reading

Comments (5)

Bar Chart with an Average Line for Each Group in Chart

Posted on 04 September 2009

In our previous article we covered adding an average line to a bar chart. At times, however, it may be useful to show an average line for each period or group when the chart consists of more than one such period or group. The advantage here is apparent - not only can the reader view the data points individually, he/she is also able to build a map of how various groups are placed with in relation to each other.... Continue Reading

Comments     

Interactive Chart in VBA using Mouse Move Event

Posted on 02 September 2009

VBA can be used to make interactive charts that respond to mouse movements. In this article we first start of by making a simple bar chart embedded in a chart sheet and then use the mouse move event of the chart sheet to make it interactive.Create a simple Bar Chart For the purpose of this exercise, we take the list of top 15 billionaires and sort it based on their networth.We ... Continue Reading

Comments (6)