請教如何在explorer寫創52週新高股票之formula??

kiwi7777

本人是ms新手,,用的是eod版....
想請教如何寫formula,可在explorer scan出創52週新高之股票呢?
謝謝!!

admin

你可以利用 HHV()  & LLV()
去做條式找出幾多週期的最高位,
及最低位數值,
你於 Explorer 內:
設定為 weekly -> 便返回週結果報告
設定為 Daily -> 便返回日結果報告


SYNTAX      hhv( DATA ARRAY, PERIODS )
FUNCTION      Calculates the highest value in the DATA ARRAY over the preceding PERIODS (PERIODS includes the current day).
EXAMPLE      The formula "hhv( CLOSE, 5 )" returns the highest closing price over the preceding five periods; "hhv(H,7)" returns the highest high price over the preceding seven periods.



SYNTAX      llv( DATA ARRAY, PERIODS )
FUNCTION      Calculates the lowest value in the DATA ARRAY over the preceding PERIODS (PERIODS includes the current day).
EXAMPLE      The formula "llv( CLOSE, 14 )" returns the lowest closing price over the preceding 14 periods.



給你例子如下:

Exploration notes  
  
Col A: Close      CLOSE
Col B: High        HIGH
Col C: Low         Low
Col D: 52High    HHV(H,52)
Col E: 52Low     LLV(L,52)
  
Filter enabled Yes
Periodicity Weekly
Records required 4000

kiwi7777

首長多謝賜覆,,而且十分詳細,,感激!!
但小弟已照足閣下指示輸入各項,
然後開始scan,,平時scan要load一陣,,約十秒左右,,
但今次沒有出現平時scan的跳動方格,,直接出report..
report沒有出現任何股,,
之後我另寫以下formula作測試,,

colA:Close   CLOSE
colB:Open   OPEN
Filter:colA>colB
Filter enabled:   Yes

結果一樣,,Results: No securities to report.
              Rejects: No securities were rejected.
原有的explorer就scan到...請問邊道出問題呢 ??

kiwi7777

問題已解決了,,謝謝~!