メモ：メモ一覧
更新

-- 安値トレンドライン INSERT INTO Test5mHLData select C.YMD ,C.TIME ,C.BRAND_CODE ,A.KBN ,TRUNCATE(((B.AMT - A.AMT) / (B.TIME_NUM - A.TIME_NUM)) * (C.TIME_NUM - A.TIME_NUM ) + A.AMT,2) AS AMT ,C.TIME_NUM from EveryDay5mHLData A INNER JOIN EveryDay5mHLData B ON B.TIME_NUM = (select MIN(Z.TIME_NUM) from EveryDay5mHLData Z where Z.TIME_NUM > A.TIME_NUM AND Z.KBN = A.KBN) AND B.AMT > A.AMT AND B.KBN = A.KBN INNER JOIN EveryDay5mHLData D ON D.TIME_NUM = (select MIN(Z.TIME_NUM) from EveryDay5mHLData Z where Z.TIME_NUM > B.TIME_NUM AND Z.KBN = B.KBN) AND D.KBN = B.KBN INNER JOIN EveryDay5mData C ON C.TIME_NUM BETWEEN A.TIME_NUM AND D.TIME_NUM - 1 INNER JOIN EveryDay5mHLData X ON X.TIME_NUM = (select MAX(Z.TIME_NUM) from EveryDay5mHLData Z where Z.TIME_NUM < A.TIME_NUM AND Z.KBN = A.KBN) AND X.AMT >= A.AMT AND X.KBN = A.KBN WHERE A.KBN = '0' -- 高値トレンドライン INSERT INTO Test5mHLData select C.YMD ,C.TIME ,C.BRAND_CODE ,A.KBN ,TRUNCATE(((B.AMT - A.AMT) / (B.TIME_NUM - A.TIME_NUM)) * (C.TIME_NUM - A.TIME_NUM ) + A.AMT,2) AS AMT ,C.TIME_NUM from EveryDay5mHLData A INNER JOIN EveryDay5mHLData B ON B.TIME_NUM = (select MIN(Z.TIME_NUM) from EveryDay5mHLData Z where Z.TIME_NUM > A.TIME_NUM AND Z.KBN = A.KBN) AND B.AMT < A.AMT AND B.KBN = A.KBN INNER JOIN EveryDay5mHLData D ON D.TIME_NUM = (select MIN(Z.TIME_NUM) from EveryDay5mHLData Z where Z.TIME_NUM > B.TIME_NUM AND Z.KBN = B.KBN) AND D.KBN = B.KBN INNER JOIN EveryDay5mData C ON C.TIME_NUM BETWEEN A.TIME_NUM AND D.TIME_NUM - 1 INNER JOIN EveryDay5mHLData X ON X.TIME_NUM = (select MAX(Z.TIME_NUM) from EveryDay5mHLData Z where Z.TIME_NUM < A.TIME_NUM AND Z.KBN = A.KBN) AND X.AMT <= A.AMT AND X.KBN = A.KBN WHERE A.KBN = '1'