TA_MEDPRICE

TA_MEDPRICE

http://www.QuantTools.com
CapeTools Technical Analysis - Price Transform function list

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

Median Price : This function is contained within the Price Transform 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.MEDPRICE

High level graphic of TA_MEDPRICE() 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.

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

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

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

Example
DATE	OPEN	HIGH	LOW	CLOSE	VOLUME	MEDPRICE
37746	29.375	29.5625	28.8125	29.3125	23570	29.1875
37747	29.3302	29.3315	29.3217	29.3269	30920	29.3266
37748	29.3226	29.3298	29.3217	29.3262	25242	29.3257
37749	29.3149	29.3429	29.3126	29.3269	35845	29.3278
37750	29.3519	29.3598	29.306	29.309	7130	29.3329
37753	29.3472	29.3476	29.3419	29.3434	7024	29.3447
37754	29.3478	29.3879	29.3211	29.3446	22019	29.3545
37755	29.3517	29.365	29.3236	29.3255	14065	29.3443
37756	29.3539	29.3548	29.286	29.3424	23185	29.3204
37757	29.3248	29.3439	29.31	29.3222	10862	29.327
37760	29.3118	29.3675	29.2879	29.3108	5649	29.3277
37761	29.3271	29.3542	29.2903	29.3275	12188	29.3222
37762	29.3431	29.3617	29.2877	29.3412	22462	29.3247
37763	29.3446	29.367	29.3067	29.3457	38540	29.3368
37764	29.3787	29.3826	29.3746	29.3794	23395	29.3786
37767	29.367	29.3712	29.3656	29.3696	27226	29.3684
37768	29.37	29.3808	29.3517	29.3546	24624	29.3663
37769	29.3837	29.3992	29.3288	29.3906	21392	29.364
37770	29.4329	29.4382	29.4214	29.4318	6754	29.4298
37771	29.4226	29.4398	29.4074	29.4125	12474	29.4236
37774	29.4434	29.4563	29.3732	29.3826	32280	29.4147
37775	29.3472	29.3671	29.3381	29.348	10281	29.3526
37776	29.3914	29.3956	29.3898	29.3916	32318	29.3927
37777	29.4046	29.4281	29.402	29.4128	13685	29.4151
37778	29.4207	29.447	29.4099	29.4432	16217	29.4284
37781	29.4139	29.4897	29.3948	29.4589	18640	29.4423
37782	29.4645	29.4868	29.4287	29.4301	31378	29.4577
37783	29.4695	29.4746	29.4691	29.4731	33987	29.4719
37784	29.5003	29.505	29.487	29.5039	14386	29.496
37785	29.503	29.5229	29.4721	29.5209	14274	29.4975
37788	29.5088	29.5705	29.4917	29.5302	33289	29.5311
37789	29.5324	29.543	29.5078	29.5174	12560	29.5254
37790	29.5217	29.5488	29.5103	29.5388	29633	29.5296
37791	29.5454	29.551	29.5264	29.5273	24907	29.5387
37792	29.5178	29.5722	29.4838	29.494	32575	29.528
37795	29.4761	29.48	29.4756	29.4784	22055	29.4778
37796	29.4432	29.4446	29.443	29.4441	6188	29.4438
37797	29.4431	29.475	29.4371	29.4403	7472	29.4561
37798	29.4664	29.4858	29.4659	29.4757	39791	29.4759
37799	29.5172	29.5252	29.5159	29.5205	19766	29.5206
37802	29.4896	29.514	29.4792	29.4854	24897	29.4966
37803	29.5327	29.5341	29.5256	29.5295	6168	29.5299
37804	29.5635	29.5699	29.5452	29.5489	36132	29.5575
37805	29.5439	29.5945	29.5314	29.5677	27555	29.563
37806	29.5506	29.5719	29.5454	29.5474	17206	29.5587
37809	29.5165	29.5458	29.5125	29.5372	39247	29.5292
37810	29.5413	29.5761	29.5362	29.5595	6792	29.5562
37811	29.5801	29.5997	29.5421	29.5918	5518	29.5709
37812	29.6222	29.6249	29.6133	29.6165	12897	29.6191
37813	29.6168	29.6344	29.6005	29.6046	29568	29.6174
37816	29.5844	29.5933	29.5788	29.5863	18074	29.5861