メモ：メモ一覧
更新

select A.* from EveryMonth4Data A INNER JOIN MonthMoveAverage B ON A.YM = B.YM AND A.BRAND_CODE = B.BRAND_CODE INNER JOIN EveryDay4Data C ON C.BRAND_CODE = A.BRAND_CODE AND C.YMD = '20210407' INNER JOIN EveryMonth4Data AA ON AA.BRAND_CODE = A.BRAND_CODE AND AA.TIME_NUM = A.TIME_NUM - 1 INNER JOIN MonthMoveAverage AB ON AB.BRAND_CODE = AA.BRAND_CODE AND AB.YM = AA.YM WHERE A.YM = '202103' AND C.LOW_AMT > B.move24 AND AA.LOW_AMT > AB.move24 AND C.LOW_AMT <= B.move24 * 1.02 AND B.move6 > B.move24 AND B.move6 > B.move12 AND B.move12 > B.move24 -- ボリンジャー接触 select A.* from EveryMonth4Data A INNER JOIN EveryMonth4BoriData B ON B.YM = A.YM AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryMonth4Data C ON C.TIME_NUM = A.TIME_NUM - 11 AND C.BRAND_CODE = A.BRAND_CODE WHERE A.YM = '202104' AND A.LOW_AMT < B.move12 - (B.SIGMA * 3) AND B.move12 <> 0 AND A.END_AMT <> 0