TA_SAR

TA_SAR

http://www.QuantTools.com
CapeTools Technical Analysis - Overlap Studies function list

Welcome | Documentation format | QuantTools Groups | QuantTools Categories | Licence

Parabolic SAR : This function is contained within the Overlap Studies set of indicators.

Returns a 1-Column range.

outReal (Doubles).

(Reference - http://www.tadoc.org, http://www.ta-lib.org).

This function requires the input of a Technical Analysis memory data table object key, which must have been produced via a call to MakeHistoricalDB(). This function would have returned a string 'KEY' which is to be passed to the 'Key' parameter of this function.

Note: Within Excel, the function is named - CT.TA.SAR

High level graphic of TA_SAR() function with parameters. Blue square node is the actual function with the parameters ordered.

Parameter Description

Key parameter

Key to an already created HistoricalDB object
withHeaders parameter

Display header information with the output range?
withDates parameter

Display the Dates column along with the output range?
withData parameter

Display the 'Open', 'High', 'Low', 'Close' and 'Volume' columns along with the output range?
HighField parameter

The 'High' Field name within the Historical DB that you wish to apply the analysis upon.
LowField parameter

The 'Low' Field name within the Historical DB that you wish to apply the analysis upon.
Acceleration_Factor parameter

Acceleration Factor used up to the Maximum value (Default=0.02)
AF_Maximum parameter

Acceleration Factor Maximum value (Default=0.2)

Extended information

Function Syntax

Parameter data types

ArgName	ArgType	IsKey
Key	String	TRUE
withHeaders	Boolean	FALSE
withDates	Boolean	FALSE
withData	Boolean	FALSE
HighField	String	FALSE
LowField	String	FALSE
Acceleration_Factor	Double	FALSE
AF_Maximum	Double	FALSE

Example Inputs

ArgName	IsOptional (Excel only)	Example
Key	FALSE	KeyNAME.EXTTAG.TICKER (from a function call)
withHeaders	FALSE	true
withDates	FALSE	true
withData	FALSE	true
HighField	FALSE	High
LowField	FALSE	Low
Acceleration_Factor	TRUE	0.02
AF_Maximum	TRUE	0.2

Example function usage

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.

If you are accessing this functrion via the MiniXL libraries, this function is present within the CT.QL.TechnicalAnalysis20 MiniXL Excel Addin.

Within our Excel Example Addin Generator, we have used the following QuantTools sub-functions in order to prepare the arguments needed to call the TA_SAR() function. If you are executing this function via the MiniXL libraries, the module addin name, (in brackets, to the right of the sub-functions listed below), indicates the MiniXL library in which the sub-function is held. You will need to load this library into your Excel session (along with any other libraries that the sub-function call within the addin requires (ie - CT.QT.Utils20 addin in almost all cases) in order for the example to compute successfully.

These are the financial QuantTools sub-function calls that are used within the examples :

MakeHistoricalDB() ( CT.QL.TechnicalAnalysis20 )
TA_SAR() ( CT.QL.TechnicalAnalysis20 )

The objects generated by these sub-functions are inter-connected in the following way :

The following four examples demostrate calling this function within a Microsoft .NET environment

The following four examples demostrate calling this function within a non .NET environment

The following is a sample output from executing the TA_SAR() function call

Example
DATE	OPEN	HIGH	LOW	CLOSE	VOLUME	SAR
37746	29.375	29.5625	28.8125	29.3125	23570	0
37747	29.3302	29.3315	29.3217	29.3269	30920	28.8125
37748	29.3226	29.3298	29.3217	29.3262	25242	28.8229
37749	29.3149	29.3429	29.3126	29.3269	35845	28.8331
37750	29.3519	29.3598	29.306	29.309	7130	28.8534
37753	29.3472	29.3476	29.3419	29.3434	7024	28.8838
37754	29.3478	29.3879	29.3211	29.3446	22019	28.9124
37755	29.3517	29.365	29.3236	29.3255	14065	28.9504
37756	29.3539	29.3548	29.286	29.3424	23185	28.9854
37757	29.3248	29.3439	29.31	29.3222	10862	29.0176
37760	29.3118	29.3675	29.2879	29.3108	5649	29.0472
37761	29.3271	29.3542	29.2903	29.3275	12188	29.0745
37762	29.3431	29.3617	29.2877	29.3412	22462	29.0996
37763	29.3446	29.367	29.3067	29.3457	38540	29.1226
37764	29.3787	29.3826	29.3746	29.3794	23395	29.1439
37767	29.367	29.3712	29.3656	29.3696	27226	29.1634
37768	29.37	29.3808	29.3517	29.3546	24624	29.1813
37769	29.3837	29.3992	29.3288	29.3906	21392	29.1979
37770	29.4329	29.4382	29.4214	29.4318	6754	29.218
37771	29.4226	29.4398	29.4074	29.4125	12474	29.2444
37774	29.4434	29.4563	29.3732	29.3826	32280	29.2718
37775	29.3472	29.3671	29.3381	29.348	10281	29.3013
37776	29.3914	29.3956	29.3898	29.3916	32318	29.3261
37777	29.4046	29.4281	29.402	29.4128	13685	29.3381
37778	29.4207	29.447	29.4099	29.4432	16217	29.357
37781	29.4139	29.4897	29.3948	29.4589	18640	29.3729
37782	29.4645	29.4868	29.4287	29.4301	31378	29.3939
37783	29.4695	29.4746	29.4691	29.4731	33987	29.3948
37784	29.5003	29.505	29.487	29.5039	14386	29.4119
37785	29.503	29.5229	29.4721	29.5209	14274	29.4305
37788	29.5088	29.5705	29.4917	29.5302	33289	29.449
37789	29.5324	29.543	29.5078	29.5174	12560	29.4721
37790	29.5217	29.5488	29.5103	29.5388	29633	29.4917
37791	29.5454	29.551	29.5264	29.5273	24907	29.5075
37792	29.5178	29.5722	29.4838	29.494	32575	29.5722
37795	29.4761	29.48	29.4756	29.4784	22055	29.5722
37796	29.4432	29.4446	29.443	29.4441	6188	29.5722
37797	29.4431	29.475	29.4371	29.4403	7472	29.5644
37798	29.4664	29.4858	29.4659	29.4757	39791	29.5543
37799	29.5172	29.5252	29.5159	29.5205	19766	29.5449
37802	29.4896	29.514	29.4792	29.4854	24897	29.5363
37803	29.5327	29.5341	29.5256	29.5295	6168	29.4371
37804	29.5635	29.5699	29.5452	29.5489	36132	29.439
37805	29.5439	29.5945	29.5314	29.5677	27555	29.4443
37806	29.5506	29.5719	29.5454	29.5474	17206	29.4533
37809	29.5165	29.5458	29.5125	29.5372	39247	29.4618
37810	29.5413	29.5761	29.5362	29.5595	6792	29.4697
37811	29.5801	29.5997	29.5421	29.5918	5518	29.4772
37812	29.6222	29.6249	29.6133	29.6165	12897	29.487
37813	29.6168	29.6344	29.6005	29.6046	29568	29.5008
37816	29.5844	29.5933	29.5788	29.5863	18074	29.5168