Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
824
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 2D Candlestick Chart
--
-- Notes: The query below will work on the following database servers:
-- MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, MySQL, PostreSQL
--
-- ORACLE: To make the query below work in Oracle, add " FROM DUAL" at the end of each SELECT
-- DB2: To make the query below work in DB2, add " FROM SYSIBM.SYSDUMMY1" at the end of each SELECT
-------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT '1', 'BBC' as 'Company',30 as 'high', 10 as 'low',20 as 'open', 27 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '2', 'CBC' as 'Company', 30 as 'high', 15 as 'low', 17 as 'open', 20 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '3', 'ABC' as 'Company', 70 as 'high', 63 as 'low', 64 as 'open', 68 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '4', 'STC' as 'Company', 59 as 'high', 46 as 'low', 50 as 'open', 57 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '5', 'WIP' as 'Company', 9 as 'high', 3 as 'low', 6 as 'open', 5 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '6', 'INF' as 'Company', 23 as 'high', 12 as 'low', 18 as 'open', 22 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '7', 'ADS' as 'Company', 50 as 'high', 38 as 'low', 42 as 'open', 47 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '8', 'TOA' as 'Company', 60 as 'high', 40 as 'low', 50 as 'open', 55 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '9', 'CAA' as 'Company', 55 as 'high', 42 as 'low', 45 as 'open', 48 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '10', 'YAH' as 'Company', 65 as 'high', 54 as 'low', 60 as 'open', 50 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '11', 'MIC' as 'Company', 80 as 'high', 65 as 'low', 70 as 'open', 74 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '12', 'TCS' as 'Company', 65 as 'high', 40 as 'low', 45 as 'open', 55 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '13', 'CRA' as 'Company', 35 as 'high', 10 as 'low', 20 as 'open', 30 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '14', 'TWI' as 'Company', 40 as 'high', 20 as 'low', 23 as 'open', 28 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '15', 'GOO' as 'Company', 76 as 'high', 46 as 'low', 50 as 'open', 65 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '16', 'PLU' as 'Company', 55 as 'high', 32 as 'low', 45 as 'open', 42 as 'close', '20081209 13:12:43.280' as 'date'
GO
.setResultSettings 'Index=1,
CategoryFields="[Company]",
SeriesFields="[high] ASC,[low],[open],[close]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=0,
Chart="{candlestick,candlestick,candlestick,candlestick}",
RotX=324,
RotY=0,
RotZ=0,
ZoomScalar=1.2025924,
ShowLegend=true,
ShowLegendBorder=true,
ShowGrid=true,
FillGrid=true,
GridLineWidth=1.0,
Title="2D Candlestick Chart",
TitlePosition="Bottom Center",
TitleCategory="",
TitleValue="",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
ShowMarkers=true,
MapShowBackground=false,
MapShowDetails=false,
MapRange="",
MapRangeColors="",
Width=16.0,
Height=10.0,
Depth=2.0,
SeriesSpacing=0.5,
CategorySpacing=0.5,
Font=Arial-6,
LegendFontSize=1.0,
SeriesFontSize=1.0,
CategoryFontSize=1.0,
ValueFontSize=1.0,
TitleFontSize=1.75,
AxisTitleFontSize=1.25,
DataLabelFontSize=1.0,
TopColor=#D7DCF5,
BottomColor=#EBF0F5,
PanX=-298.0,
PanY=-153.7,
Lighting=Default,
Opacity=1.0,
View2D=true,
FitChartToImage=false,
StackedPercent=false,
ShowValueAxis=true,
ShowValueAxisTicks=true,
ShowValueAxisLines=true,
ReverseValueAxis=false,
ShowCategoryAxis=true,
ShowCategoryAxisTicks=true,
ShowCategoryAxisLines=true,
ShowSeriesAxis=false,
ShowDataLabels=false,
ValueAxisNumberFormat="###0",
CategoryAxisNumberFormat="#,##0",
CategoryAxisDateFormat="",
CategoryAxisDateTimeFormat="",
CategoryAxisTimeFormat="",
SeriesAxisNumberFormat="",
SeriesAxisDateFormat="",
SeriesAxisDateTimeFormat="",
SeriesAxisTimeFormat="",
NumericCategoryAxis=false,
MergeAxis=true,
SeriesAlias="default,default,default,default",
SeriesSubType="High,Low,Open,Close",
SeriesColumnType="Cube,Cube,Cube,Cube",
SeriesMin="default,default,default,default",
SeriesMax="default,default,default,default",
SeriesColor="#40699d,#9f413e,#809b48,#6a5286",
SeriesFunctionMetaData="true,true,true,true",
ShowSeriesDataLabels="false,false,false,false",
LegendPosition=Top Right,
LegendWidthType=Exact,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=true,
FixedCategoryCount=0'
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017