TA_MACDFIX

TA_MACDFIX

http://www.QuantTools.com
CapeTools Technical Analysis - Momentum Indicators function list

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

Moving Average Convergence/Divergence Fix 12/26 : This function is contained within the Momentum Indicators set of indicators.

Returns a 3-Column range.

outMACD (Doubles).

outMACDSignal (Doubles).

outMACDHist (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.MACDFIX

High level graphic of TA_MACDFIX() 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?
FieldName parameter

The FieldName within the Historical DB that you wish to apply the analysis upon.
Signal_Period parameter

Smoothing for the signal line (nb of period) (Default=9)

Extended information

Function Syntax

Parameter data types

ArgName	ArgType	IsKey
Key	String	TRUE
withHeaders	Boolean	FALSE
withDates	Boolean	FALSE
withData	Boolean	FALSE
FieldName	String	FALSE
Signal_Period	Long	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
FieldName	FALSE	Open
Signal_Period	TRUE	9

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_MACDFIX() 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_MACDFIX() ( 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_MACDFIX() function call

Example
DATE	OPEN	HIGH	LOW	CLOSE	VOLUME	MACD	MACDSignal	MACDHist
37746	29.375	29.5625	28.8125	29.3125	23570	0	0	0
37747	29.3302	29.3315	29.3217	29.3269	30920	0	0	0
37748	29.3226	29.3298	29.3217	29.3262	25242	0	0	0
37749	29.3149	29.3429	29.3126	29.3269	35845	0	0	0
37750	29.3519	29.3598	29.306	29.309	7130	0	0	0
37753	29.3472	29.3476	29.3419	29.3434	7024	0	0	0
37754	29.3478	29.3879	29.3211	29.3446	22019	0	0	0
37755	29.3517	29.365	29.3236	29.3255	14065	0	0	0
37756	29.3539	29.3548	29.286	29.3424	23185	0	0	0
37757	29.3248	29.3439	29.31	29.3222	10862	0	0	0
37760	29.3118	29.3675	29.2879	29.3108	5649	0	0	0
37761	29.3271	29.3542	29.2903	29.3275	12188	0	0	0
37762	29.3431	29.3617	29.2877	29.3412	22462	0	0	0
37763	29.3446	29.367	29.3067	29.3457	38540	0	0	0
37764	29.3787	29.3826	29.3746	29.3794	23395	0	0	0
37767	29.367	29.3712	29.3656	29.3696	27226	0	0	0
37768	29.37	29.3808	29.3517	29.3546	24624	0	0	0
37769	29.3837	29.3992	29.3288	29.3906	21392	0	0	0
37770	29.4329	29.4382	29.4214	29.4318	6754	0	0	0
37771	29.4226	29.4398	29.4074	29.4125	12474	0	0	0
37774	29.4434	29.4563	29.3732	29.3826	32280	0	0	0
37775	29.3472	29.3671	29.3381	29.348	10281	0	0	0
37776	29.3914	29.3956	29.3898	29.3916	32318	0	0	0
37777	29.4046	29.4281	29.402	29.4128	13685	0	0	0
37778	29.4207	29.447	29.4099	29.4432	16217	0	0	0
37781	29.4139	29.4897	29.3948	29.4589	18640	0	0	0
37782	29.4645	29.4868	29.4287	29.4301	31378	0	0	0
37783	29.4695	29.4746	29.4691	29.4731	33987	0	0	0
37784	29.5003	29.505	29.487	29.5039	14386	0	0	0
37785	29.503	29.5229	29.4721	29.5209	14274	0	0	0
37788	29.5088	29.5705	29.4917	29.5302	33289	0	0	0
37789	29.5324	29.543	29.5078	29.5174	12560	0	0	0
37790	29.5217	29.5488	29.5103	29.5388	29633	0	0	0
37791	29.5454	29.551	29.5264	29.5273	24907	0.0498938	0.0415695	0.00832426
37792	29.5178	29.5722	29.4838	29.494	32575	0.048767	0.043009	0.00575802
37795	29.4761	29.48	29.4756	29.4784	22055	0.044205	0.0432482	0.000956801
37796	29.4432	29.4446	29.443	29.4441	6188	0.0376533	0.0421292	-0.00447592
37797	29.4431	29.475	29.4371	29.4403	7472	0.0320709	0.0401176	-0.00804663
37798	29.4664	29.4858	29.4659	29.4757	39791	0.0290685	0.0379078	-0.00883925
37799	29.5172	29.5252	29.5159	29.5205	19766	0.0301908	0.0363644	-0.00617355
37802	29.4896	29.514	29.4792	29.4854	24897	0.0286636	0.0348242	-0.00616062
37803	29.5327	29.5341	29.5256	29.5295	6168	0.0303728	0.0339339	-0.0035611
37804	29.5635	29.5699	29.5452	29.5489	36132	0.033685	0.0338842	-0.000199113
37805	29.5439	29.5945	29.5314	29.5677	27555	0.0344403	0.0339954	0.000444921
37806	29.5506	29.5719	29.5454	29.5474	17206	0.0351492	0.0342261	0.000923035
37809	29.5165	29.5458	29.5125	29.5372	39247	0.0327536	0.0339316	-0.00117803
37810	29.5413	29.5761	29.5362	29.5595	6792	0.0323616	0.0336176	-0.00125603
37811	29.5801	29.5997	29.5421	29.5918	5518	0.0345993	0.033814	0.000785356
37812	29.6222	29.6249	29.6133	29.6165	12897	0.039127	0.0348766	0.00425042
37813	29.6168	29.6344	29.6005	29.6046	29568	0.0418417	0.0362696	0.00557209
37816	29.5844	29.5933	29.5788	29.5863	18074	0.0410754	0.0372308	0.00384465