メモ：メモ一覧
更新

-- 1か月以上前の安値付近 -- 前回：移動平均下がり気味、今回：移動平均上がり気味 SELECT A.* FROM TestEveryDay4Data04 A INNER JOIN TestEveryDay4Data04 B ON B.BRAND_CODE = A.BRAND_CODE AND B.NUM = A.NUM - 1 AND B.YMD < (SELECT Z.BEF_25YMD FROM EigyoCalendar Z WHERE Z.YMD = A.YMD) INNER JOIN EveryDay4Data AA ON AA.YMD = A.YMD AND AA.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data BB ON BB.YMD = B.YMD AND BB.BRAND_CODE = B.BRAND_CODE where A.YMD = '20210115' AND A.HIGH_AMT BETWEEN B.HIGH_AMT * 0.98 AND B.HIGH_AMT * 1.02 AND AA.move25 > AA.move75 AND BB.move25 < BB.move75