ExtremeHurst - Extreme Investor Behavior Detector

Quantitative detector of extreme investor behavior signaling trend beginnings and ends. Compression signals mark the end of sideways/mean-reverting periods and onset of a trend. Extension signals mark the end of a trend period and onset of retracement or sideways action. Signals are characterized by discrete scale invariance (DSI), accelerating price (PL), log-periodic cycles (LP), and volume anomalies.

Function Syntax

=PFR.ExtremeHurst(Security, MostRecentDate, LeastRecentDate, Periodicity, Interval, History, Quality, Preferences, ExpirationPeriodicity, MinExpDays, FillWithHeaders, OnlyShowSignals, SpreadSecurity, TargetDateOverride, OnlyShowOneRow, ShowExtraOutputs, UseSyntheticPrices, BarsToMerge, RefreshMode)

Parameters

ParameterDescription
SecurityBloomberg security (e.g., 'IBM US Equity')
MostRecentDateMost recent date (mm/dd/yyyy), blank=now. If earlier than LeastRecentDate, output is reverse date order
LeastRecentDateLeast recent date (mm/dd/yyyy), blank=now
PeriodicityYEARLY, QUARTERLY, MONTHLY, WEEKLY, DAILY, or MINUTE
IntervalBar interval in minutes for MINUTE: 240, 120, 60, 30, 20, 15, 10, 5, 3, 2, or 1
HistoryBars back to first search date (alternate way to set LeastRecentDate)
QualityMin rank: 0=99+, 1=95+, 2=90+, 3=80+, 4=70+, 5=any. For exact rank use negative (e.g., -98 for rank 98+)
Preferences0=Recommended, 1=More signals (adds doubled-bar search and increases sampling)
ExpirationPeriodicityMONTHLY, WEEKLY, HISTORICAL_MONTHLY, or HISTORICAL_WEEKLY
MinExpDaysMin days to option expiration (default=5)
FillWithHeadersLabel non-signal rows with column headers (default=false)
OnlyShowSignalsList only rows with fresh new signals (default=false)
SpreadSecurityOptional ratio spread denominator (e.g., 'SPX Index')
TargetDateOverrideAlternate target date for remaining edge/duration evaluation
OnlyShowOneRowShow only the most recent signal row (default=false unless History < 0)
ShowExtraOutputsAdd LP cycle forecasts, option strike levels, and Trident stops/targets (default=false)
UseSyntheticPricesAllow synthetic weeks/months; also runs all possible end dates when true (default=false)
BarsToMergePrice bars to merge for processing, 1-5 (default=1)
RefreshModeINTERVAL, DAILY, WEEKLY, MONTHLY, or FREEZE (default=FREEZE)

Signal Type Descriptors (Output 7)

Signal types may include a +N suffix = bars elapsed since the signal date (e.g., Bottom Extension+3).

Extension Signals — end of a trend period

Signal TypeMeaning
Bottom ExtensionExtreme downside trend exhaustion — bullish reversal candidate
Bottom Extension MaxBottom Extension with an unusually large price move — stronger exhaustion
Top ExtensionExtreme upside trend exhaustion — bearish reversal candidate
Top Extension MaxTop Extension with an unusually large price move — stronger exhaustion

Compression Signals — end of a sideways/mean-reverting period

Signal TypeMeaning
CompressionSideways compression detected, breakout direction not yet determined
Compression UpTriggered upside within the trigger window
Compression DnTriggered downside within the trigger window
Compression Up SlowTriggered upside outside the trigger window — delayed breakout
Compression Dn SlowTriggered downside outside the trigger window — delayed breakout
Compression rvUpHead-fake move downside first, then reversed upward within window
Compression rvDnHead-fake move upside first, then reversed downward within window
Compression rvUp SlowHead-fake reversal upward, triggered outside the window — delayed
Compression rvDn SlowHead-fake reversal downward, triggered outside the window — delayed

Output Columns

ColumnDescription
Output 1Security Symbol
Output 2Run Date
Output 3Run Time
Output 4Run Price
Output 5Periodicity
Output 6Interval in minutes (intraday only)
Output 7Signal Type (see tables above)
Output 8Signal Date
Output 9Signal Price
Output 10Signal Rank
Output 11Signal Edge% (1% = 51% win rate)
Output 12Signal Duration in bars
Output 13Max Expected Gain%
Output 14Std Dev of Max Expected Gain
Output 15Target Date for edge evaluation
Output 16Remaining Edge% at Target Date
Output 17Remaining Duration at Target Date in bars
Output 18-20Dates of next 3 Log-Periodic Price Cycle peaks/troughs (ShowExtraOutputs=true)
Output 21-23LP Cycle direction: H=expected High, L=expected Low (ShowExtraOutputs=true)
Output 24-26Max LP Cycle price %Change expected (ShowExtraOutputs=true)
Output 27-29Raw option writing strike level and max return date (ShowExtraOutputs=true)
Output 30-32Trident stop price, target price, and time stop date (ShowExtraOutputs=true)
Output 33-34Hurst Band coordinate (HC) at signal bar close and at current bar (ShowExtraOutputs=true)
Output 35Current Signal Status (ShowExtraOutputs=true)
Note: Rank ≥90 is considered superior quality. This function requires Bloomberg Terminal to be running and logged in.