Quick Stock and Currency Charts in Excel with MarketXLS

Discussion in 'Charting' started by marketxls, Apr 11, 2017.

Quick Stock and Currency Charts in Excel with MarketXLS

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    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:

    quick-charts1.png


    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.

    quick-charts2.png


    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:

    quick-charts3.png

    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:

    [​IMG]

    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.
     
    #1 marketxls, Apr 11, 2017
    Last edited: Apr 11, 2017

Share This Page