メモリストページ

メモ：メモ一覧

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

SELECT *
FROM 
(
	SELECT 
		 A.YMD
		,A.BRAND_CODE
		,W.BRAND_NAME
		,A.END_AMT
		,(FLOOR (1000000 / (A.END_AMT * 1.3) / 100) * 100) AS NUM

,((FLOOR (1000000 / (A.END_AMT * 1.3) / 100) * 100) * AAA.END_AMT)  - ((FLOOR (1000000 / (A.END_AMT * 1.3) / 100) * 100) * AAA.START_AMT) AS TOTAL

,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

,A.BEFORE_AMT AS PRE_END_AMT

,(SELECT AVG(Z.VOLUME)
		  FROM EveryDay4Data Z 
		  WHERE Z.BRAND_CODE = A.BRAND_CODE 
			    AND Z.TIME_NUM BETWEEN A.TIME_NUM - 10 AND A.TIME_NUM - 5
		 ) AS BEF5_AVGVOLUME

FROM EveryDay4Data A
	INNER JOIN EveryDay4Data AAA ON 
	    AAA.TIME_NUM= A.TIME_NUM + 1
	AND AAA.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.BEFORE_AMT > A.END_AMT * 1.15
	AND A.BEFORE_AMT < A.END_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