メモリストページ

メモ：メモ一覧

-- シミュメモ
-- 出来高が高い3銘柄を取得
-- 寄りから10%上で指値、売れなければ終値
-- ストップ高でも買える金額を枚数とする（なり買い想定）
-- 高値じゃなくて安値の方が良い？

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
	,AAA.START_AMT AS AFT_START_AMT 
        ,AAA.END_AMT AS AFT_END_AMT
        ,AAA.HIGH_AMT AS AFT_HIGH_AMT 
        ,AAA.LOW_AMT AS AFT_LOW_AMT

,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
INNER JOIN EveryDay4Data AAA ON 
	    AAA.TIME_NUM= A.TIME_NUM + 1
	AND AAA.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 BETWEEN '20240201' AND '20240229'
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