Field-Specific Charts (Revision #25)

Aqua Data Studio 7.5 has an enhanced Charting Toolkit. The following new Chart Types are introduced in this version:

• Scatter chart - You can now display values for two variables for a set of data as a collection of points. This enhancement in ADS 7.5 displays each point, having the value of one variable determining the position on the horizontal axis and the value of the other variable determining the position on the vertical axis
• Bubble chart - A bubble chart displays a set of numeric values as a circles. It is especially useful when the values differ by several orders of magnitude. ADS 7.5 displays data values that differ by a ratio of 100,000 and can display hundreds of individual values at once
• Open-high-low-close chart - Stock market users will find this type of chart useful to depict prices with a open-high-low-close chart. This takes a 3 data series (High, Low, Close)
• Candlestick chart - You can now use a variation of bar chart to describe price movements of an equity over time. This type of chart plots a 5 series data (Open, Close, Low, High and a relative plot to the prior periods' prices)

Feature Overview

•    Chart Types - You can now use ADS 7.5 to plot Scatter, Bubble, Open-high-low-close and Candlestick Charts
•    Column Shape Type - Support for Cylinder, Cone & Pyramid versions of all Column & Bar charts is added
•    Chart Functions - Support for Add, Subtract, Scalar, Power, Log, Moving Average and Linear Regression

Working with Candlestick Charts

The basics

To give you a brief idea about the candlestick chart, create the table and use the sample test data given towards the end of this page. Open a Query Window and type the query Select * from [dbo].[Stock] and enable Charting Tool. Select the Candlestick Chart Type.

Candle Definition

1. Candlesticks are used to show stock price
2. Each candlestick shows the stock's high, low, opening and closing prices. The wick shows the stock's high and low prices
3. The body of a candlestick shows the stock's opening and closing prices
4. A day is an up day if the closing price is greater than the opening price
5. The body color is used to flag if it is an up day (GREEN) or down day (RED)

Working with Open-high-low-close Chart

The basics

Run a query in Query Analyzer and enable Charting Tools. Select Open High Low Close Chart. High-Low-Close plots are used to show stock prices.

Open-high-close Chart

1. In a high-low-close plot the vertical line represents the high and low values over one unit of time.
2. The close value is represented by a "tick" to the right. The open value, if present, is represented by a tick to the left.
3. If today's close is higher than yesterday's close - the bar is colored green/blue.
4. If today's close is lower than yesterday's close - the bar is colored red.
5. If today's close is equal to yesterday's close - the bar is colored the same as yesterday.

Working with Bubble Charts

The basics

Run a query in Query Analyzer and enable Charting Tools. Select Bubble Chart.

Bubble Chart

A bubble chart is a two-dimensional scatterplot where a third variable is represented by the size of the points.

1. In a high-low-close plot the vertical line represents the high and low values over one unit of time.
2. The close value is represented by a "tick" to the right. The open value, if present, is represented by a tick to the left.
3. If today's close is higher than yesterday's close - the bar is colored green/blue.
4. If today's close is lower than yesterday's close - the bar is colored red.
5. If today's close is equal to yesterday's close - the bar is colored the same as yesterday.

Working with Scatter Charts

candlestick chart is a style of bar-chart. Candlesticks are used to show stock price. Each candlestick shows the stock's high, low, opening and closing prices. an overview of open, high, low, and close market prices. ability to display five data points instead of one

/* Sample Table and Data created in SQL Server 2000 for visualizing the Field-specific Charts */

CREATE TABLE [dbo].[Stock] (
    [Stock_ID]       varchar(25) NOT NULL,
    [Company]        varchar(25) NULL,
    [Stock_Open]     int NULL,
    [Stock_High]     int NULL,
    [Stock_Low]      int NULL,
    [Stock_Close]    int NULL,
    [Trans_Date]     datetime NULL
    )
GO
INSERT INTO [dbo].[Stock] VALUES ('1', 'microsoft', 25, 30, 20, 30, '20081209 13:12:43.280')
GO
INSERT INTO [dbo].[Stock] VALUES ('10', 'yahoo', 80, 100, 75, 100, '20081207 00:00:00.0')
GO
INSERT INTO [dbo].[Stock]  VALUES ('11', 'microsoft', 30, 55, 20, 45, '20081206 00:00:00.0')
GO
INSERT INTO [dbo].[Stock]  VALUES ('12', 'google', 55, 70, 50, 60, '20081206 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('13', 'facebook', 40, 80, 20, 50, '20081206 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('14', 'aquafold', 50, 100, 44, 100, '20081206 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('15', 'yahoo', 50, 80, 20, 60, '20081206 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('2', 'google', 55, 100, 50, 75, '20081208 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('3', 'facebook', 76, 80, 75, 75, '20081208 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('4', 'aquafold', 55, 100, 50, 100, '20081208 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('5', 'yahoo', 30, 50, 20, 22, '20081208 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('6', 'microsoft', 23, 30, 20, 25, '20081207 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('7', 'google', 52, 100, 50, 75, '20081207 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('8', 'facebook', 15, 25, 10, 15, '20081207 00:00:00.0')
GO
INSERT INTO [dbo].[Stock] VALUES ('9', 'aquafold', 55, 100, 49, 100, '20081207 00:00:00.0')
GO