-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathexcel_doc.html
250 lines (235 loc) · 9.88 KB
/
excel_doc.html
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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- #BeginTemplate "master.dwt" -->
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<meta name="Author" content="TA-LIB.org">
<meta name="description" content="Technical analysis open-source software library to process financial data. Provides RSI, MACD, Stochastic, moving average... Works with Excel, C/C++, Java, Perl, Python and .NET">
<meta name="keywords" content="technical analysis, Technical Analysis, developer, trading, invest, stock market, commodity market,futures market,indicators,fibonnacci,fibonacci,source code,C Library,C++ Library,freeware,open-source,finance software,trading software,excel,add-ins">
<!-- #BeginEditable "doctitle" -->
<title>TA-Lib : Technical Analysis Library - Pro excel</title>
<style type="text/css">
.style1 {
font-weight: normal;
}
.style9 {
border-left-width: 0px;
border-bottom-width: 0px;
}
.style10 {
border-bottom-style: solid;
border-bottom-width: 1px;
}
.style8 {
border-style: solid;
border-width: 1px;
text-align: center;
}
.style11 {
border-style: solid;
border-width: 1px;
text-align: center;
background-color: #00FF00;
}
</style>
<!-- #EndEditable -->
<link rel="stylesheet" type="text/css" href="css/main.css">
<link rel="stylesheet" type="text/css" href="css/gray.css" title="gray">
<style type="text/css">
p { margin: 0px 0px 4px 0px;
text-align: left;
}
</style></head>
<body>
<div id="title">
<h1>TA-Lib : Technical Analysis Library</h1>
</div>
<div id="icon"></div>
<div id="content">
<!-- #BeginEditable "Region1" -->
<h2>TA-Lib Pro Excel Features</h2>
<ul>
<li>Includes all the technical analysis functions implemented in the open
source version in an easy to install Excel add-ins.</li>
<li>Control the calculation order, "top to bottom" or "bottom to top" rows.</li>
<li>Provides easy setup for unstable period minimization.</li>
</ul>
<p> Click <a href="hdr_dw.html">here</a> to try
for free</p>
<h2>Installation</h2>
<p>Click <a href="hdr_dw.html">here</a> to download the MSI installation
file. Run it on your system.<br>
</p>
<p>After the installation is completed, launch Excel. You will be prompt to enter the License on the first
calculation or when changing the TA-Lib options. Enter your license
key to enable full functionality. Trial will work for 30 days. </p>
<h2>Upgrade</h2>
Installation will overwrite previous version. Launch Excel and
recalculate your spreadsheets. For licensed user, there is no need to
re-enter the License Key.<h2> </h2>
<!-- #EndEditable -->
</div>
<div id="nav">
<ul id="navlist">
<li><a href="https://ta-lib.org/index.html">Home</a></li>
<li> </li>
<li><a href="hdr_doc.html">Products</a></li>
<li><a href="hdr_dw.html">Downloads</a></li>
<li><a href="excel.html">Purchase</a></li>
<li><a href="support.html">Support</a></li>
<li> </li>
<li><a href="function.html">Function List</a></li>
<li> </li>
<li><a href="hdr_dev.html">Source Code</a> </li>
<li><a href="http://tadoc.org/forum">Community Forum</a></li>
<li><a href="hdr_lnk.html">Useful Links</a></li>
<li> </li>
<li><a href="about.html">About Us</a></li>
</ul>
<div id="notice">
TA-Lib websites, products and trademarks are owned by TicTacTec LLC.</div>
</div>
<div id="contentLarge">
<!-- #BeginEditable "Region2" -->
<h2>Using TA-Lib</h2><p>Here is a step-by-step example for adding a 5 days Simple Moving Average (SMA)
of the open price of a stock.</p>
<h4>
<table style="width: 100%">
<tr>
<td style="width: 125px" rowspan="2">
<a href="images/DemoStep1.jpg">
<img alt="Demo Step 1" height="114" src="images/DemoStep1_small.jpg" style="border-style: solid; border-width: 2px" width="100" xthumbnail-orig-image="images/DemoStep1.jpg"></a></td>
<td style="height: 4px">
<p>Step 1 - Select Output Location</p>
</td>
</tr>
<tr>
<td class="style1" valign="top">
All TA functions are array formula. You must first select where the
output is to be placed. In this example, we want the function to be
located at F2 to F30. Once you select the output range, either start
typing the formula or start the function wizard.</td>
</tr>
<tr>
<td style="width: 125px" rowspan="2"><a href="images/DemoStep2.jpg">
<img alt="Demo Step 2" height="114" src="images/DemoStep2_small.jpg" style="border-style: solid; border-width: 2px" width="100" xthumbnail-orig-image="images/DemoStep2.jpg"></a></td>
<td>Step 2 - Select TA-Lib Function</td>
</tr>
<tr>
<td class="style1" valign="top">Start the function wizard (press the
'Fx' icon by the formula edit box). Select the function category
[TA-Lib Overlap Studies], and then select TA_SMA. Press OK.</td>
</tr>
<tr>
<td style="width: 125px" rowspan="2"><a href="images/DemoStep3.jpg">
<img alt="Demo Step 3" height="114" src="images/DemoStep3_small.jpg" style="border-style: solid; border-width: 2px" width="100" xthumbnail-orig-image="images/DemoStep3.jpg"></a></td>
<td>Step 3 - Specify Function Arguments</td>
</tr>
<tr>
<td class="style1" valign="top">Click on 'InputRange'. Select the
open prices located at B2 to B30. The input size must match the
output size you did in Step 1. Click on 'TimePeriod'. Type '5'.<br>
Press OK.</td>
</tr>
<tr>
<td style="width: 125px" rowspan="2"><a href="images/DemoStep4.jpg">
<img alt="Demo Step 4" height="114" src="images/DemoStep4_small.jpg" style="border-style: solid; border-width: 2px" width="100" xthumbnail-orig-image="images/DemoStep4.jpg"></a></td>
<td>Step 4 - Transform to {Array Formula}</td>
</tr>
<tr>
<td class="style1" valign="top">This step is very important. Before
doing anything else, click on the formula in the edit box and press
CTRL-SHIFT-ENTER. This will add braces '{}' around the formula and
make it an "array formula". As needed, read the Excel Help for how
to enter or modify Array Formula.<br><br>You now have the SMA
function completed in column F.</td>
</tr>
<tr>
<td style="width: 125px"> </td>
<td> </td>
</tr>
</table>
</h4>
<h3><strong>What are the differences between the open-source and pro version?</strong></h3>
<p>Both share the same source code for the technical analysis function. The Pro versions integrates
better with Excel to allow more compatibility, features and a simpler installation.</p>
<p> </p>
<table style="width: 499px" cellspacing="0" cellpadding="0" class="style9">
<tr>
<td style="width: 279px" class="style10"> </td>
<td class="style8" style="width: 182px"><strong>Ta-Lib Pro Excel</strong></td>
<td class="style8" style="width: 214px"><strong>TA-Lib Open-Source</strong></td>
</tr>
<tr>
<td style="width: 279px" class="style1">Easy Windows Installer</td>
<td class="style11" style="width: 182px"><strong>Yes</strong></td>
<td class="style8" style="width: 214px">No</td>
</tr>
<tr>
<td style="width: 279px" class="style1">Excel Integrated Option
Dialog</td>
<td class="style11" style="width: 182px"><strong>Yes</strong></td>
<td class="style8" style="width: 214px">No</td>
</tr>
<tr>
<td style="width: 279px" class="style1">Excel 2007 Large Grid
Support</td>
<td class="style11" style="width: 182px"><strong>Yes</strong></td>
<td class="style8" style="width: 214px">No</td>
</tr>
<tr>
<td style="width: 279px" class="style1">Calculation order option</td>
<td class="style11" style="width: 182px"><strong>Yes</strong></td>
<td class="style8" style="width: 214px">No</td>
</tr>
<tr>
<td style="width: 279px" class="style1">Unstable Period Minimization</td>
<td class="style11" style="width: 182px"><strong>Yes</strong></td>
<td class="style8" style="width: 214px">No</td>
</tr>
<tr>
<td style="width: 279px" class="style1">E-mail support</td>
<td class="style11" style="width: 182px"><strong>Yes</strong></td>
<td class="style8" style="width: 214px">No</td>
</tr>
<tr>
<td style="width: 279px" class="style1">Source Code</td>
<td class="style8" style="width: 182px">No</td>
<td class="style11" style="width: 214px"><strong>Yes</strong></td>
</tr>
<tr>
<td style="width: 279px" class="style1">Free</td>
<td class="style8" style="width: 182px">No</td>
<td class="style11" style="width: 214px"><strong>Yes</strong></td>
</tr>
</table>
<p> </p>
TA-Lib open-source requires Visual Studio or additional Microsoft
Redistributable to be installed on the end-user machine and is not suitable to
non-developers.<table style="width: 100%">
<tr>
<td><h3>
Option Dialog</h3>
TA-Lib pro is configurable directly from the Excel interface from a
convenient single dialog (See on the left). The
settings are automatically preserved between Excel sessions.<h3>How to open the Option Dialog</h3>
<p>For Excel 2007 and newer, select the "Add-Ins" Ribbon and the TA-Lib
button to open the option dialog.</p>
<p>For older Excel version, you can select the "TA-Lib Options..." from the tools menu.</p>
</td>
<td><img src="img10.gif"></td>
</tr>
</table>
<p> </p>
<h2>How To Uninstall</h2>
<p>Activate the Control Panel, double click <b>Add/Remove Programs </b>(for
Vista users click <b>Uninstall a program)</b>,
click the "TA-Lib Pro Excel" entry in the list of programs, and click <b>
Remove or Uninstall</b>.<br><a href="images/Uninstall.jpg">
<img alt="Vista Uninstall" height="65" src="images/Uninstall_small.jpg" style="border-style: solid; border-width: 2px" width="100" xthumbnail-orig-image="images/Uninstall.jpg"></a></p>
<p> </p>
<!-- #EndEditable -->
</div>
</body>
<!-- #EndTemplate -->
</html>