Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 8/11/2005(UTC)
Posts: 104
|
Second Hilbert period
If I compress Daily price bars to produce a weekly Metastock Chart. Then on the weekly chart plot the Hilbert Cycle Period ExtFml("Hilbert.HilbertPeriod");Convert the weekly Hilbert Period into a "second Daily Hilbert period" by multiplying by 4.8155 (the average number of trading days in a week.) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Example: - Gold Bugs Index ^[censored] Weekly Hilbert period = 16.4897 weeks 2nd Hilbert Daily Period = 16.4897 weeks * 4.8155 2nd Hilbert Daily Period = 79 Days ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ My Question is Using PowerPivots Plus or any other method is it possible calculate the above directly in a formula using "data compression" compressing daily data into weekly data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Then on a Daily chart Plot:- {Weekly Hilbert Cycle Period converted into days}=
ExtFml( "Hilbert.HilbertPeriod")*4.8155; And get 2nd Hilbert Period of =79 Days
Hoping you can oblige Derek
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT
Was thanked: 3 time(s) in 3 post(s)
|
Derek,
PowerPivots Plus can create Higher time frame values from Open, High, Low, and Close.
It cannot create Higher Time frame values from somebody elses external function.
I do not know of any such external function that can take the daily value from an unknown external function and create a weekly value
H
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 8/11/2005(UTC)
Posts: 104
|
Henry,
Thank you for your quick and clear answer to my question on “Second Hilbert Period”.
Is it possible have a Hilbert Period formula without a "low cut off value"?
Have a nice weekend.
Derek
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 8/11/2005(UTC)
Posts: 104
|
Hi,
Referring to the previous thread.
Second Hilbert period or Weekly Hilbert Period from Daily data.
Using PowerPivots with the formula below.
HtfData Converts Daily data to Weekly Data.
On the last line Multiplying by 4.8155 converts the Weekly EnhancedHilbert Period
into market days.
----8<-----------------------------------------------------------------------------------------
htfData:=ExtFml("PowerPivots.TDataCreate",3, 2);
pr := htfData;
Hperiod := ExtFml( "EnhancedHilbert.EnhancedHilbertPeriod", pr)* 4.8155 ;
-------8<---------------------------------------------------------------------------------------
The above formula works o.k.
And gives me a Weekly EnhancedHilbert converted into Market days.
-------------------------------------------------------------------------------------------------
How can I to use ExtFml( "Hilbert.HilbertPeriod");
instead of ExtFml( "EnhancedHilbert.EnhancedHilbertPeriod", pr);
in the above formula and get a Weekly Hilbert Period?
-------------------------------------------------------------------------------------------------
Secondly could you tell me
When I should I use the Herbert period?
And when I should I use the Enhanced Herbert period?
Regards.
Derek
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
