Quick Stock and Currency Charts in Excel with MarketXLS

MarketXLS allows you to build stunning, interactive charts for stock and currency data. For ease of use, we’ve categorized the charts as quick charts and custom charts. In this article, we will look at how to make use of the quick stock and currency charts in excel.

The quick charts allow you to create interactive charts in excel by just knowing the symbol of the stock or the currency. Let’s learn how to create a quick chart in excel using MarketXLS:

Step 1: Select your Stocks

Let’s say you want to plot the chart for these four stocks: MSFT, GE, XOM, and YHOO. The first thing you need to do is enter these stock symbols in an excel column, as shown below:

Step 2: Select the Chart Type

To plot the charts, select all the cells for which you want to plot the stock data, and then select the appropriate chart type from MarketXLS > Charts > Quick Charts. You can select from the minute chart, a choice of day charts, price comparison chart, and quick candlestick chart.

Step 3: View the Chart

Once you select a chart type, the desired chart will open in a new window within seconds. In our example, I chose to select the 1 Year Day Chart, which will plot the daily closing price of the stocks for the past 1 year. The chart is shown below: