メモリストページ

メモ：メモ一覧

SELECT *
FROM 
(
SELECT 
	 A.YMD
	,A.BRAND_CODE
	,W.BRAND_NAME
	,A.START_AMT
	,A.END_AMT
	,A.HIGH_AMT
	,A.LOW_AMT
	,A.VOLUME

,B.START_AMT AS PRE_START_AMT
	,B.END_AMT AS PRE_END_AMT
	,B.HIGH_AMT AS PRE_HIGH_AMT
	,B.LOW_AMT AS PRE_LOW_AMT
	,B.VOLUME AS PRE_VOLUME

,D.move5
	,D.move25
	,D.move75

,E.SIGMA

,F.RSI

,(SELECT AVG(Z.VOLUME)
	  FROM EveryDay4Data Z 
	INNER JOIN EigyoCalendar ZZ ON
		    ZZ.YMD = Z.YMD
	  WHERE Z.BRAND_CODE = A.BRAND_CODE 
		    AND ZZ.TEMP_NUM BETWEEN AA.TEMP_NUM - 10 AND AA.TEMP_NUM - 5
	 ) AS BEF5_AVGVOLUME

,(SELECT MIN(Z.VOLUME)
	  FROM EveryDay4Data Z 
	INNER JOIN EigyoCalendar ZZ ON
		    ZZ.YMD = Z.YMD
	  WHERE Z.BRAND_CODE = A.BRAND_CODE 
		    AND ZZ.TEMP_NUM BETWEEN AA.TEMP_NUM - 75 AND AA.TEMP_NUM
	 ) AS BEF25_MAXVOLUME

FROM EveryDay4Data A
INNER JOIN EigyoCalendar AA ON
	    AA.YMD = A.YMD
INNER JOIN EveryDay4Data B ON -- 前日株価
	    B.YMD = AA.BEF_YMD
	AND B.BRAND_CODE = A.BRAND_CODE
INNER JOIN EigyoCalendar BB ON
	    BB.YMD = B.YMD
INNER JOIN EveryDay4Data X ON -- 前前日株価
	    X.YMD = BB.BEF_YMD
	AND X.BRAND_CODE = A.BRAND_CODE
LEFT JOIN MoveAverage D ON -- 移動平均
	    D.YMD = A.YMD
	AND D.BRAND_CODE = A.BRAND_CODE
LEFT JOIN EveryDay4BoriData E ON -- ボリンジャーバンド
	    E.YMD = A.YMD
	AND E.BRAND_CODE = A.BRAND_CODE
LEFT JOIN EveryDay4RsiData F ON -- RSI
	    F.YMD = A.YMD
	AND F.BRAND_CODE = A.BRAND_CODE

LEFT JOIN BrandMaster W ON
    W.BRAND_CODE = A.BRAND_CODE
WHERE
    A.YMD = (select MAX(YMD) from EigyoCalendar)
AND A.END_AMT > A.BEFORE_AMT * 1.15
AND A.END_AMT < A.BEFORE_AMT * 1.45
AND A.END_AMT > 200

) S

WHERE S.BEF5_AVGVOLUME >= 100000000 / S.END_AMT

ORDER BY S.YMD, (S.END_AMT / S.PRE_END_AMT)  DESC