1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: type_stock.xhp,v $
* $Revision: 1.7 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<helpdocument version="1.0">
<meta>
<topic id="textschart01type_stockxhp" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Chart Type Stock</title>
<filename>/text/schart/01/type_stock.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id2959990"><bookmark_value>stock charts</bookmark_value>
<bookmark_value>chart types;stock</bookmark_value>
<bookmark_value>data sources;setting for stock charts</bookmark_value>
</bookmark><comment>mw added one entry</comment><paragraph role="heading" id="hd_id966216" xml-lang="en-US" level="1" l10n="NEW"><variable id="type_stock"><link href="text/schart/01/type_stock.xhp">Chart Type Stock</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3516953" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
<paragraph role="heading" id="hd_id5268410" xml-lang="en-US" level="2" l10n="NEW">Stock</paragraph>
<paragraph role="paragraph" id="par_id61342" xml-lang="en-US" l10n="NEW">A Stock chart illustrates the market trend given by opening price, bottom price, top price and closing price. The transaction volume can also be shown.<comment>UFI: should we show example charts for every type?</comment></paragraph>
<paragraph role="paragraph" id="par_id2131412" xml-lang="en-US" l10n="NEW">For a Stock chart the order of the data series is important. The data should be arranged as shown in the example table below.</paragraph>
<table id="tbl_id1370586">
<tablerow>
<tablecell colspan="" rowspan=""/>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id1022064" xml-lang="en-US" l10n="NEW">A</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id1924192" xml-lang="en-US" l10n="NEW">B</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id3258156" xml-lang="en-US" l10n="NEW">C</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id3161412" xml-lang="en-US" l10n="NEW">D</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id5619373" xml-lang="en-US" l10n="NEW">E</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablehead" id="par_id6474501" xml-lang="en-US" l10n="NEW">F</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7411725" xml-lang="en-US" l10n="NEW">1</paragraph>
</tablecell>
<tablecell colspan="" rowspan=""/>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id1933957" xml-lang="en-US" l10n="NEW">Transaction volume</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id1274452" xml-lang="en-US" l10n="NEW">Opening price</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id5044404" xml-lang="en-US" l10n="NEW">Low (bottom price)</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id3892635" xml-lang="en-US" l10n="NEW">High (top price)</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id4641865" xml-lang="en-US" l10n="NEW">Closing price</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7684560" xml-lang="en-US" l10n="NEW">2</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id3998840" xml-lang="en-US" l10n="NEW">Monday</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7675099" xml-lang="en-US" l10n="NEW">2500</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7806329" xml-lang="en-US" l10n="NEW">20</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id5589159" xml-lang="en-US" l10n="NEW">15</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id9936216" xml-lang="en-US" l10n="NEW">25</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7953123" xml-lang="en-US" l10n="NEW">17</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id4013794" xml-lang="en-US" l10n="NEW">3</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id1631824" xml-lang="en-US" l10n="NEW">Tuesday</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7271645" xml-lang="en-US" l10n="NEW">3500</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id2136295" xml-lang="en-US" l10n="NEW">32</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id4186223" xml-lang="en-US" l10n="NEW">22</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id1491134" xml-lang="en-US" l10n="NEW">37</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id2873622" xml-lang="en-US" l10n="NEW">30</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id2374034" xml-lang="en-US" l10n="NEW">4</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id1687063" xml-lang="en-US" l10n="NEW">Wednesday</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id8982207" xml-lang="en-US" l10n="NEW">1000</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7074190" xml-lang="en-US" l10n="NEW">15</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id5452436" xml-lang="en-US" l10n="NEW">15</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id9527878" xml-lang="en-US" l10n="NEW">17</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id6342356" xml-lang="en-US" l10n="NEW">17</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id166936" xml-lang="en-US" l10n="NEW">5</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id6826990" xml-lang="en-US" l10n="NEW">Thursday</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id6897183" xml-lang="en-US" l10n="NEW">2200</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7003387" xml-lang="en-US" l10n="NEW">40</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id4897915" xml-lang="en-US" l10n="NEW">30</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id3105868" xml-lang="en-US" l10n="NEW">47</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id3908810" xml-lang="en-US" l10n="NEW">35</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id9461653" xml-lang="en-US" l10n="NEW">6</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id9239173" xml-lang="en-US" l10n="NEW">Friday</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id2656941" xml-lang="en-US" l10n="NEW">4600</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id1481063" xml-lang="en-US" l10n="NEW">27</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id7921079" xml-lang="en-US" l10n="NEW">20</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id636921" xml-lang="en-US" l10n="NEW">32</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
<paragraph role="tablecontent" id="par_id2799157" xml-lang="en-US" l10n="NEW">31</paragraph>
</tablecell>
</tablerow>
</table>
<paragraph role="paragraph" id="par_id3004547" xml-lang="en-US" l10n="NEW">The open, low, high, and closing values of a row build together one data unit in the chart. A stock price data series consists of several rows containing such data units. The column containing the transaction volume builds an optional second data series.</paragraph>
<paragraph role="paragraph" id="par_id6401867" xml-lang="en-US" l10n="NEW">Depending on the chosen variant, you do not need all columns.</paragraph>
<paragraph role="heading" id="hd_id18616" xml-lang="en-US" level="2" l10n="NEW">Stock Chart Variants</paragraph>
<paragraph role="paragraph" id="par_id6138492" xml-lang="en-US" l10n="NEW">Choose the <emph>Stock</emph> chart type on the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart wizard</link>. Then select one of the four variants.</paragraph>
<paragraph role="heading" id="hd_id4569231" xml-lang="en-US" level="3" l10n="NEW">Type 1</paragraph>
<paragraph role="paragraph" id="par_id291451" xml-lang="en-US" l10n="NEW">Based on<emph> low</emph>
<emph>and high </emph>column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line.</paragraph>
<paragraph role="paragraph" id="par_id3341776" xml-lang="en-US" l10n="NEW">Based on<emph> low, high,</emph> and <emph>close</emph> column Type 1 shows an additional horizontal mark <emph>for</emph> the closing price.</paragraph>
<paragraph role="heading" id="hd_id5947141" xml-lang="en-US" level="3" l10n="NEW">Type 2</paragraph>
<paragraph role="paragraph" id="par_id1911679" xml-lang="en-US" l10n="CHG">Based on <emph>open, low, high</emph>, and <emph>close</emph> column Type 2 generates the traditional "candle stick" chart. Type 2 draws the vertical line between the bottom and top price and adds a rectangle in front, which visualizes the range between the opening and closing price. If you click on the rectangle you see more information in the status bar. %PRODUCTNAME uses different fill colors for rising values (the opening price is lower than the closing price) and falling values.</paragraph>
<paragraph role="heading" id="hd_id9364909" xml-lang="en-US" level="3" l10n="NEW">Type 3</paragraph>
<paragraph role="paragraph" id="par_id4473403" xml-lang="en-US" l10n="CHG">Based on <emph>volume, low, high</emph>, and <emph>close</emph> column chart Type 3 draws a chart like Type 1, with additional columns for the transaction volume.<comment>i80596</comment></paragraph>
<paragraph role="heading" id="hd_id4313791" xml-lang="en-US" level="3" l10n="NEW">Type 4</paragraph>
<paragraph role="paragraph" id="par_id4331797" xml-lang="en-US" l10n="CHG">Based on all five data columns <emph>volume, open, low, high</emph>, and <emph>close</emph>, Type 4 combines a chart of Type 2 with a column chart for the transaction volume.</paragraph>
<paragraph role="paragraph" id="par_id4191717" xml-lang="en-US" l10n="NEW">Because measurement for transaction volume might be "units", a second y axis is introduced in chart Type 3 and Type 4. The price axis is shown on the right side and the volume axis on the left side.</paragraph>
<paragraph role="heading" id="hd_id2318796" xml-lang="en-US" level="2" l10n="NEW">Setting the Data Source</paragraph>
<paragraph role="heading" id="hd_id399182" xml-lang="en-US" level="3" l10n="NEW">Charts based on its own data</paragraph>
<paragraph role="paragraph" id="par_id5298318" xml-lang="en-US" l10n="NEW">To change the data series of a chart having its own data, choose <link href="text/schart/01/03010000.xhp">Chart Data Table</link> from the View menu or from the context menu of the chart in edit mode.</paragraph>
<paragraph role="paragraph" id="par_id7588732" xml-lang="en-US" l10n="NEW">In an embedded chart data table, the data series are always organized in columns.</paragraph>
<paragraph role="paragraph" id="par_id95828" xml-lang="en-US" l10n="CHG">For a new stock chart first use a column chart. Add the columns you need and enter your data in the order which is shown in the example, omitting any columns not required for the desired variant. Use Move Series Right to change the column order. Close the chart data table. Now use the Chart Type dialog to change to the stock chart variant. </paragraph>
<paragraph role="paragraph" id="par_id6182744" xml-lang="en-US" l10n="NEW">If you have already got a stock chart and you want to change the variant, then first change the chart type to a column chart, add or remove columns so that it fits to the variant, and then change the chart type back to a stock chart.<comment>Watch issue 72433 to see whether a change in the handling is done.</comment></paragraph>
<paragraph role="paragraph" id="par_id3496200" xml-lang="en-US" l10n="NEW">Do not write the name of a data series in a row. Write the name into the field above the role name.</paragraph>
<paragraph role="paragraph" id="par_id7599108" xml-lang="en-US" l10n="CHG">The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order.</paragraph>
<paragraph role="heading" id="hd_id888698" xml-lang="en-US" level="3" l10n="NEW">Charts based on Calc or Writer tables</paragraph>
<paragraph role="paragraph" id="par_id3394573" xml-lang="en-US" l10n="NEW">You can choose or alter a data range on the second page of the Chart wizard or in the <link href="text/schart/01/wiz_data_range.xhp">Data Range</link> dialog. For fine tuning use the <link href="text/schart/01/wiz_data_series.xhp">Data Series</link> dialog.</paragraph>
<paragraph role="paragraph" id="par_id7594225" xml-lang="en-US" l10n="NEW">To specify a data range do one of the following:</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id5081637" xml-lang="en-US" l10n="NEW">Enter the data range in the text box.</paragraph>
<paragraph role="paragraph" id="par_id9759514" xml-lang="en-US" l10n="NEW">In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4".</paragraph>
<paragraph role="paragraph" id="par_id1614429" xml-lang="en-US" l10n="NEW">As long as the syntax is not correct, %PRODUCTNAME shows the text in red.</paragraph>
</listitem>
</list>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id1589098" xml-lang="en-US" l10n="NEW">In Calc, click <emph>Select data range</emph> to minimize the dialog, then drag to select the data range. When you release the mouse, the data are entered. Click <emph>Select data range</emph> again to add a data range. In the input field of the minimized dialog, click after the entry and type a semicolon. Then drag to select the next range.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id8746910" xml-lang="en-US" l10n="NEW">Click one of the options for data series in rows or in columns. </paragraph>
<paragraph role="paragraph" id="par_id9636524" xml-lang="en-US" l10n="NEW">Your stock chart data are "in columns", if the information in a row belongs to the same "candle stick".<comment>I don't know whether copying a table based chart to draw or impress needs chart data arranged in columns, and I cannot test it, because the clipboard is broken.</comment></paragraph>
<paragraph role="heading" id="hd_id5675527" xml-lang="en-US" level="2" l10n="NEW">Fine Tuning the Data Ranges of Table Based Stock Charts</paragraph>
<paragraph role="paragraph" id="par_id3486434" xml-lang="en-US" l10n="NEW">You can organize data series and edit the source for parts of single data series on the third page of the Chart wizard or on the page Data Series in the Data Range dialog.</paragraph>
<paragraph role="heading" id="hd_id3068636" xml-lang="en-US" level="3" l10n="NEW">Organize Data Series</paragraph>
<paragraph role="paragraph" id="par_id2480849" xml-lang="en-US" l10n="NEW">In the <emph>data series</emph> area on the left side of the dialog, you can organize the data series of the actual chart. A stock chart has at least one data series containing the prices. It might have a second data series for transaction volume.</paragraph>
<paragraph role="paragraph" id="par_id4181951" xml-lang="en-US" l10n="CHG">If you have got more than one price data series, use the Up and Down arrow buttons to order them. The order determines the arrangement in the chart. Do the same for volume data series. You cannot switch price and volume data series.</paragraph>
<paragraph role="paragraph" id="par_id2927335" xml-lang="en-US" l10n="NEW">To remove a data series, select the data series in the list and click <emph>Remove</emph>.</paragraph>
<paragraph role="paragraph" id="par_id2107303" xml-lang="en-US" l10n="NEW">To add a data series, select one of the existing data series and click <emph>Add</emph>. You get an empty entry below the selected one, which has the same type. If you have no price data series or no volume data series, you must first select a range for these series in the <emph>Data Range</emph> dialog.<comment>Regina: The behavior is odd, but I don't know a better solution. Therefore I have not written an issue.</comment></paragraph>
<paragraph role="heading" id="hd_id4071779" xml-lang="en-US" level="3" l10n="NEW">Setting Data Ranges</paragraph>
<paragraph role="paragraph" id="par_id7844477" xml-lang="en-US" l10n="NEW">In the <emph>Data Ranges</emph> dialog you can set or change the data range of each component of the selected data series.</paragraph>
<paragraph role="paragraph" id="par_id6478469" xml-lang="en-US" l10n="NEW">In the upper list you see the role name of the components and the current values. When you have selected a role, you can change the value in the text box below the list. The label shows the selected role.</paragraph><comment>deleted a para, see i80596</comment><paragraph role="paragraph" id="par_id9038972" xml-lang="en-US" l10n="NEW">Enter the range into the text box or click on <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph>
<paragraph role="paragraph" id="par_id7985168" xml-lang="en-US" l10n="NEW">Select Open Values, Close Values, High Values, and Low Values in any order. Specify only the ranges for those roles which you need for the chosen variant of the stock chart. The ranges need not be next to each other in the table.</paragraph>
<paragraph role="heading" id="hd_id876186" xml-lang="en-US" level="3" l10n="NEW">Legend</paragraph>
<paragraph role="paragraph" id="par_id3939634" xml-lang="en-US" l10n="NEW">The legend displays the labels from the first row or column or from the special range that you have set in the <emph>Data Series</emph> dialog. If your chart does not contain labels, the legend displays text like "Row 1, Row 2, ...", or "Column A, Column B, ..." according to the row number or column letter of the chart data.</paragraph><comment>deleted 3 paras</comment><paragraph role="paragraph" id="par_id2377697" xml-lang="en-US" l10n="NEW">The legend shows the value from the range, which you entered in the <emph>Range for Name</emph> field in the <emph>Data Range</emph> dialog. The default entry is the column header of the closing price column.</paragraph>
<paragraph role="paragraph" id="par_id2188787" xml-lang="en-US" l10n="NEW">Select one of the position options. When the chart is finished, you can specify other positions using the Format menu.</paragraph>
<section id="relatedtopics">
<embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
<embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
<embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/>
<embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/>
<embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/>
</section>
</body>
</helpdocument>
|
