주 콘텐츠로 건너뛰기

Stock Candlestick Chart

Garden City Consultants

a tool in Excel to visualize price movement in securities market

Description:

Candle Stick Chart add-in is a tool in Excel to visualize the price movement of securities by days, weeks, months. One candle stick represent 1 unit of movement of high, low, open, close. The stick represents the high/low.

The bar represent the open/close. The color of the bar represents the up (green) or down (red).

This add-in is typically used by financial professional to do the technical analysis of the security market. The bar, stick show the daily, weekly, monthly market movement - high/low/open/close.

This add-in is easy to use that it allows user to use sample data as the template format to build his own chart by pasting the data into the sample data table.

Features:

  • The user can use the GCC Historical Security Price Add-in to collect security data for this add-in that has the required data format in place.

  • Sample data can be the template to build the chart.

  • Easy to use and user friendly.

  • Change the chart title by clicking the title area and enter the text as needed.

Instruction:

  • Download this add in and start Excel 2013 SP1 or later Add in.

  • Click Insert Sample Data button to insert the sample data.

  • Paste own data into the sample data table and click binding the existing table button to draw the chart.

  • Change colors in Setting screen as needed.

  • Click in the title area in chart to enter desired title.

Version 1.0.0.2 Release Notes:

  • Setting Window updated to GCC setting standard format.

  • Title can be updated and saved automatically in the chart window.
추가 기능의 기능
이 추가 기능을 사용하는 경우
  • 문서를 읽거나 변경할 수 있음
  • 인터넷을 통해 데이터를 보낼 수 있음
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679545/Asset_719b80b9-1194-45e3-b328-396950291ed3/CandleStickChart.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679545/Asset_719b80b9-1194-45e3-b328-396950291ed3/CandleStickChart.png