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 minute chart, a choice of day charts, price compare 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 1 Year Day Chart, which will plot the daily closing price of the stocks for the past 1 year. The chart is shown below:
Features of Quick Stock and Currency Charts in Excel
MarketXLS Quick charts are very powerful with many in-built features that make them better than native charts in excel:
- You can zoom in and zoom out of charts with dynamic dates handling
- The charts can be exports in multiple formats
- You can annotate Candlestick patterns on chart
- The charts functionality auto-identifies data series. You don’t need to provide any settings.
- You can maximize chart windows without distortion of clarity
- You can open multiple charts in Excel at a time
You can view the quick chart in action in the below animated gif:
Apart from quick charts, MarketXLS also provides the ability to build custom charts based on your own data. You can learn about custom charts in this article.