{"id":2868,"date":"2008-12-26T11:18:34","date_gmt":"2008-12-26T02:18:34","guid":{"rendered":"http:\/\/www.ibi-square.jp\/blog\/?p=121"},"modified":"2023-05-13T16:19:07","modified_gmt":"2023-05-13T07:19:07","slug":"tech-calc-trix","status":"publish","type":"post","link":"https:\/\/atmtech.net\/main\/tech-calc-trix\/","title":{"rendered":"TRIX\uff08\u8a08\u7b97\u5f0f\u3001\u30c1\u30e3\u30fc\u30c8\u3001\u30a8\u30af\u30bb\u30ebVBA\u30b3\u30fc\u30c9\uff09\u30c6\u30af\u30cb\u30ab\u30eb\u6307\u6a19"},"content":{"rendered":"

 <\/p>\n

TRIX\u306b\u3064\u3044\u3066\u3001\u8a08\u7b97\u5f0f\u3001\u30c1\u30e3\u30fc\u30c8\u3001\u30a8\u30af\u30bb\u30ebVBA\u30b3\u30fc\u30c9\u3002<\/h1>\n

 <\/p>\n

TRIX\u306f\u7d42\u5024\u306e\u81ea\u7136\u5bfe\u6570\u3092\u6307\u6570\u79fb\u52d5\u5e73\u5747\uff08EMA\uff09\u30673\u56de\u5e73\u5747\u5316\u3057\u305f\u6570\u5024\u3068\u524d\u65e5\u3068\u306e\u5dee\u304b\u3089\u6c42\u3081\u3089\u308c\u308b\u6307\u6a19\u3067\u3059\u3002<\/p>\n

 <\/p>\n

 <\/p>\n

<\/p>\n

 <\/p>\n

TRIX\u306e\u8a08\u7b97\u5f0f\uff08N\u306f\u8db3\u6570\uff09<\/h2>\n

 <\/p>\n

EMA1 = N(close)\u306eN\u672c\u6307\u6570\u5e73\u6ed1\u79fb\u52d5\u5e73\u5747<\/p>\n

\u203bN(close)=\u7d42\u5024\u306e\u81ea\u7136\u5bfe\u6570<\/p>\n

EMA2 = EMA1\u306eN\u672c\u6307\u6570\u5e73\u6ed1\u79fb\u52d5\u5e73\u5747<\/p>\n

EMA3 = EMA2\u306eN\u672c\u6307\u6570\u5e73\u6ed1\u79fb\u52d5\u5e73\u5747<\/p>\n

TRIX = (EMA3 – \u524d\u65e5\u306eEMA3) \u00d7 10000<\/p>\n

 <\/p>\n

\u6307\u6570\u5e73\u6ed1\u79fb\u52d5\u5e73\u5747\u7dda\u21d2 https:\/\/atmtech.net\/main\/?p=2890<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

TRIX\u306e\u30c1\u30e3\u30fc\u30c8<\/h2>\n

\"\"<\/p>\n

(\u9ec4\u8272\u7ddaTRIX5\u3000\u8d64\u7ddaTRIX30)<\/p>\n

 <\/p>\n

 <\/p>\n

TRIX\u306eVBA\u30b3\u30fc\u30c9<\/h2>\n

‘\u203b\u3000\u30a8\u30af\u30bb\u30eb\u306e1\u5217\u76ee(A\u5217)\u306b\u884c\u756a\u53f7\u30012\u5217\u76ee(B\u5217)\u306b\u65e5\u6642\u3001
\n‘\u203b\u30003\u5217\u76ee(C\u5217)\uff5e6\u5217\u76ee(F\u5217)\u306b\u59cb\u5024\u30fb\u9ad8\u5024\u30fb\u5b89\u5024\u30fb\u7d42\u5024
\n‘********************************
\n‘ n \uff1aTRIX\u306e\u63a1\u7528\u672c\u6570
\n‘ num\uff1a\u73fe\u5728\u306e\u884c
\n‘ r_now\uff1a\u73fe\u5728\u5024
\n‘ cell_ln\uff1a\u7d42\u5024\u81ea\u7136\u5bfe\u6570\u66f8\u8fbc\u307f\u5217
\n‘ cell_ema1\uff1a\u6307\u6570\u5e73\u6ed1\u7dda1\u8a08\u7b97\u5024\u66f8\u8fbc\u307f\u5217
\n‘ cell_ema2\uff1a\u6307\u6570\u5e73\u6ed1\u7dda1\u8a08\u7b97\u5024\u66f8\u8fbc\u307f\u5217
\n‘ cell_ema3\uff1a\u6307\u6570\u5e73\u6ed1\u7dda1\u8a08\u7b97\u5024\u66f8\u8fbc\u307f\u5217
\n‘ cell_trix\uff1a\u6307\u6570\u5e73\u6ed1\u7dda1\u8a08\u7b97\u5024\u66f8\u8fbc\u307f\u5217
\n‘********************************
\n‘*******\u81ea\u7136\u5bfe\u6570
\nIf Cells(num, 6) <> “” Then
\nCells(num, cell_ln) = Application.Ln(Cells(num, 6))
\nEnd If
\n‘*******EMA1
\nIf num – 2 = n Then
\nCells(num, cell_ema1) = Application.WorksheetFunction.Average _
\n(.Range(Cells(num – (n – 1), cell_ln), Cells(num, cell_ln)))
\nEnd If
\nIf num – 2 > n Then
\nCells(num, cell_ema1) = Cells(num – 1, cell_ema1) + _
\n((Cells(num, cell_ln) – Cells(num – 1, cell_ema1)) * 2 \/ (1 + n))
\nEnd If
\n‘*******EMA2
\nIf num – 2 = n + (n – 1) Then
\nCells(num, cell_ema2) = Application.WorksheetFunction.Average _
\n(.Range(Cells(num – (n – 1), cell_ema1), Cells(num, cell_ema1)))
\nEnd If
\nIf num – 2 > n + (n – 1) Then
\nCells(num, cell_ema2) = Cells(num – 1, cell_ema2) + _
\n((Cells(num, cell_ema1) – Cells(num – 1, cell_ema2)) * 2 \/ (1 + n))
\nEnd If
\n‘*******EMA3
\nIf num – 2 = 2 * n + (n – 2) Then
\nCells(num, cell_ema3) = Application.WorksheetFunction.Average _
\n(.Range(Cells(num – (n – 1), cell_ema2), Cells(num, cell_ema2)))
\nEnd If
\nIf num – 2 > 2 * n + (n – 2) Then
\nCells(num, cell_ema3) = Cells(num – 1, cell_ema3) + _
\n((Cells(num, cell_ema2) – Cells(num – 1, cell_ema3)) * 2 \/ (1 + n))
\nEnd If
\n‘*******TRIX
\nIf Cells(num – 1, cell_ema3) <> “” Then
\nCells(num, cell_trix) = (Cells(num, cell_ema3) – _
\nCells(num – 1, cell_ema3)) * 10000
\nEnd If<\/p>\n

 <\/p>\n

 <\/p>\n

\u30c6\u30af\u30cb\u30ab\u30eb\u6307\u6a19\u4e00\u89a7<\/a><\/p>\n

\u7f6b\u7dda\u8ac7\u7fa9\u4e00\u89a7<\/a><\/p>\n

(\u5916\u90e8\u30ea\u30f3\u30af)\u30c6\u30af\u30cb\u30ab\u30eb\u6307\u6a19(Wikipedia)<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

  TRIX\u306b\u3064\u3044\u3066\u3001\u8a08\u7b97\u5f0f\u3001\u30c1\u30e3\u30fc\u30c8\u3001\u30a8\u30af\u30bb\u30ebVBA\u30b3\u30fc\u30c9\u3002   TRIX\u306f\u7d42\u5024\u306e\u81ea\u7136\u5bfe\u6570\u3092\u6307\u6570\u79fb\u52d5\u5e73\u5747\uff08EMA\uff09\u30673\u56de\u5e73\u5747\u5316\u3057\u305f\u6570\u5024\u3068\u524d\u65e5\u3068\u306e\u5dee\u304b\u3089\u6c42\u3081\u3089\u308c\u308b\u6307\u6a19\u3067\u3059\u3002    <\/p>\n","protected":false},"author":1,"featured_media":2869,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30],"tags":[64,65,40,80,36,66],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/posts\/2868"}],"collection":[{"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/comments?post=2868"}],"version-history":[{"count":5,"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/posts\/2868\/revisions"}],"predecessor-version":[{"id":3863,"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/posts\/2868\/revisions\/3863"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/media\/2869"}],"wp:attachment":[{"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/media?parent=2868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/categories?post=2868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atmtech.net\/main\/wp-json\/wp\/v2\/tags?post=2868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}