{"id":42916,"date":"2026-06-18T12:32:37","date_gmt":"2026-06-18T17:32:37","guid":{"rendered":"https:\/\/library-test.tradingtechnologies.com\/doc\/rtd-retrieving-instrument-ids-and-properties-2\/"},"modified":"2026-06-18T12:32:40","modified_gmt":"2026-06-18T17:32:40","slug":"rtd-retrieving-instrument-ids-and-properties-2-2","status":"publish","type":"doc","link":"https:\/\/library-test.tradingtechnologies.com\/ja\/rtd-retrieving-instrument-ids-and-properties-2-2\/","title":{"rendered":"RTD &#8211; \u9298\u67c4 ID \u3068\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u53d6\u5f97"},"content":{"rendered":"<div>\n<p>RTD \u3092\u4f7f\u7528\u3057\u3066\u9650\u6708\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u969b\u3001\u53d6\u5f97\u3057\u3088\u3046\u3068\u3059\u308b\u9650\u6708\u306e ID \u3068\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>TT RTD \u6570\u5f0f\u306f\u3001\u4ee5\u4e0b\u306e\u57fa\u672c\u69cb\u9020\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,\"Topic1\",...,\"Topic<em>N<\/em>\")<\/pre>\n<\/blockquote>\n<p><strong>\u6ce8<\/strong>: 2\u756a\u76ee\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u3001RTD Server \u304c\u5b9f\u884c\u3055\u308c\u3066\u3044\u308b\u5916\u90e8\u30b5\u30fc\u30d0\u30fc\u306e\u540d\u524d\u306b\u306a\u308a\u307e\u3059\u3002TT RTD Server \u306f\u5e38\u306b\u30ed\u30fc\u30ab\u30eb\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u30012\u756a\u76ee\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u5024\u3092\u9664\u5916\u3059\u308b\u304b\u7a7a\u767d\u306e\u6587\u5b57 (&#8220;&#8221;\u009d) \u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u6570\u5f0f\u3067\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u69cb\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/div>\n<div>\n<h2>\u9298\u67c4 ID \u306e\u53d6\u5f97<\/h2>\n<p>\u9650\u6708\u306b\u95a2\u3059\u308b\u60c5\u5831\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u524d\u306b\u3001\u307e\u305a\u4ee5\u4e0b\u306e\u3044\u305a\u308c\u304b\u306e\u65b9\u6cd5\u3067 ID \u3092\u62bd\u51fa\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li><a href=\"#by-name\">\u540d\u524d\u5225<\/a><\/li>\n<li><a href=\"#by-details\">\u9650\u6708\u306e\u8a73\u7d30\u5225<\/a><\/li>\n<li><a href=\"#by-name\">\u7d04\u5b9a\u5225<\/a><\/li>\n<\/ul>\n<p><!-- By name --><\/p>\n<div>\n<h3 id=\"by-name\">\u540d\u524d\u5225\u306e\u65b9\u6cd5<\/h3>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,\"Inst\",\"<em>exchangeName<\/em>\",\"<em>instrName<\/em>\")<\/pre>\n<\/blockquote>\n<p><em>instrName<\/em> \u5f15\u6570\u306f\u3001\u4e00\u822c\u7684\u306b\u9650\u6708\u306e<a href=\"xl-using-instruments-and-accounts-in-your-spreadsheet.html\">\u30b7\u30e7\u30fc\u30c8\u30cd\u30fc\u30e0<\/a>\u3068\u547c\u3070\u308c\u308b\u3082\u306e\u306b\u5bfe\u5fdc\u3057\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001CME \u53d6\u5f15\u6240\u304b\u3089 Jun16 GE \u5148\u7269\u9650\u6708\u306e ID \u3092\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u3001\u30bb\u30eb\u306b\u6b21\u306e\u6570\u5f0f\u3092\u5165\u529b\u3059\u308b\u3060\u3051\u3067\u7d50\u69cb\u3067\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,\"Inst\",\"CME\",\"GEM6\")<\/pre>\n<\/blockquote>\n<p>\u6570\u5f0f\u3092\u51e6\u7406\u3057\u305f\u5f8c\u3001Excel \u306f\u6b21\u306e\u3088\u3046\u306a\u7d50\u679c\u3092\u30bb\u30eb\u306b\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-test.tradingtechnologies.com\/wp-content\/uploads\/2026\/06\/rtd-instr-id-1.png\"><\/p>\n<p>\u3053\u308c\u3067\u3001\u30bb\u30eb\u306b\u8868\u793a\u3055\u308c\u305f\u7d50\u679c\u3092\u4f7f\u7528\u3057\u3066\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u4ed6\u306e\u6570\u5f0f\u3067\u9650\u6708\u3092\u8b58\u5225\u3067\u304d\u307e\u3059\u3002\u901a\u5e38\u3001\u30bb\u30eb\u3092\u53c2\u7167\u3057\u3066 (\u3053\u306e\u5834\u5408\u306f<strong>B3<\/strong>)\u3001\u4ed6\u306e\u6570\u5f0f\u3067\u9650\u6708\u3092\u8b58\u5225\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<p><!-- By details --><\/p>\n<div>\n<h3 id=\"by-details\">\u9650\u6708\u306e\u8a73\u7d30\u5225\u306e\u65b9\u6cd5<\/h3>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,\"Instr\",\"<em>exchangeName<\/em>\",\"<em>instrSymbol<\/em>\",\"<em>productType<\/em>\",\"<em>expiry<\/em>\"\")<\/pre>\n<\/blockquote>\n<p><strong>\u6ce8<\/strong>: \u9650\u6708\u306e\u8a73\u7d30\u306e\u65b9\u6cd5\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u3001\u6570\u5f0f\u3067\u306f\u300cInst\u300d\u3067\u306f\u306a\u304f\u300cInstr\u300d\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p>TT \u306f\u4ee5\u4e0b\u306e\u9298\u67c4\u30bf\u30a4\u30d7\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059 (\u5168\u89d2\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044)\u3002<\/p>\n<ul>\n<li>\u5148\u7269<\/li>\n<li>\u30b9\u30d7\u30ec\u30c3\u30c9<\/li>\n<li>\u30aa\u30d7\u30b7\u30e7\u30f3<\/li>\n<li>\u30b9\u30c8\u30e9\u30c6\u30b8\u30fc<\/li>\n<li>\u50b5\u5238<\/li>\n<li>\u30a8\u30cd\u30eb\u30ae\u30fc<\/li>\n<li>\u8a3c\u5238<\/li>\n<li>\u6307\u6570<\/li>\n<\/ul>\n<p>\u4f8b\u3048\u3070\u3001CME \u53d6\u5f15\u6240\u304b\u3089 Jun19 ES \u5148\u7269\u9650\u6708\u306e ID \u3092\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u3001\u30bb\u30eb\u306b\u4ee5\u4e0b\u306e\u6570\u5f0f\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,\"Instr\",\"CME\",\"ES\",\"FUTURE\",\"Jun19\")<\/pre>\n<\/blockquote>\n<p><!-- By fills --><\/p>\n<div>\n<h3 id=\"by-fills\">\u7d04\u5b9a\u5225\u306e\u65b9\u6cd5<\/h3>\n<p>\u6b21\u306e\u5f0f\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u5c11\u306a\u304f\u3068\u3082 1\u3064\u306e\u9650\u6708\u3092\u53d6\u5f15\u3057\u305f\u3059\u3079\u3066\u306e\u9298\u67c4\u306e ID \u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,\"Inst\",\"FILLS\",CELL(\"Address\",<em>cell-reference<\/em>))<\/pre>\n<\/blockquote>\n<p hidden><strong>\u6ce8<\/strong>: 2\u756a\u76ee\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u3001RTD Server \u304c\u5b9f\u884c\u3055\u308c\u3066\u3044\u308b\u5916\u90e8\u30b5\u30fc\u30d0\u30fc\u306e\u540d\u524d\u306b\u306a\u308a\u307e\u3059\u3002TT RTD Server \u306f\u5e38\u306b\u30ed\u30fc\u30ab\u30eb\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u30012\u756a\u76ee\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u5024\u3092\u9664\u5916\u3059\u308b\u304b\u7a7a\u767d\u306e\u6587\u5b57 (&#8220;&#8221;) \u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u6570\u5f0f\u3067\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u69cb\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u6570\u5f0f\u306f\u3001\u9650\u6708 ID \u30921\u6b21\u5143\u306e\u7e26\u914d\u5217\u3067\u8fd4\u3057\u307e\u3059\u3002\u3053\u306e\u914d\u5217\u5168\u4f53\u3092\u8868\u793a\u3059\u308b\u306b\u306f\u3001Excel \u306e\u4e00\u9023\u306e\u30bb\u30eb\u306b\u3053\u306e\u540c\u3058\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u3001<em>cell-reference<\/em> (\u30bb\u30eb\u53c2\u7167) \u5f15\u6570\u306e\u5024\u3092\u305d\u308c\u305e\u308c\u7570\u306a\u308b\u3082\u306e\u306b\u3057\u307e\u3059\u3002\u3053\u306e\u914d\u5217\u306e\u3046\u3061\u3001\u5024\u306e\u306a\u3044\u30e1\u30f3\u30d0\u30fc\u3092\u53c2\u7167\u3057\u305f\u5834\u5408\u306f\u3001\u7a7a\u767d\u6587\u5b57\u5217\u304c\u8fd4\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><em>cell-reference<\/em> \u5024\u306f\u3001 &#8220;<em>column<\/em>,<em>row<\/em>&#8221; \u306e\u5f62\u5f0f\u3092\u3068\u308a\u307e\u3059\u3002\u4f8b:<\/p>\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-test.tradingtechnologies.com\/wp-content\/uploads\/2026\/06\/rtd-instr-ids-by-fills-1.png\" alt=\"\"><\/p>\n<p>\u3053\u308c\u3067\u3001\u30bb\u30eb\u306b\u8868\u793a\u3055\u308c\u305f\u7d50\u679c\u3092\u4f7f\u7528\u3057\u3066\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u4ed6\u306e\u6570\u5f0f\u3067\u9650\u6708\u3092\u8b58\u5225\u3067\u304d\u307e\u3059\u3002\u901a\u5e38\u3001\u30bb\u30eb\u3092\u53c2\u7167\u3057\u3066\u3001\u4ed6\u306e\u6570\u5f0f\u3067\u9650\u6708\u3092\u8b58\u5225\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<div>\n<h2 id=\"retrieve-properties\">\u9298\u67c4\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u53d6\u5f97<\/h2>\n<p>\u9650\u6708 ID \u3092\u53d6\u5f97\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u6570\u5f0f\u3067\u305d\u306e\u9650\u6708\u306b\u95a2\u9023\u3059\u308b\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,<em>inst-id<\/em>,<em>property<\/em>,<em>filter1<\/em>,<em>filter<\/em><strong>N<\/strong>)<\/pre>\n<\/blockquote>\n<p>TT RTD Server \u3067\u306f\u3001TT \u304b\u3089\u53d6\u5f97\u3067\u304d\u308b\u30d7\u30ed\u30d1\u30c6\u30a3\u3068\u3057\u30662\u3064\u306e\u30bf\u30a4\u30d7\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<ul>\n<li><a href=\"xl-rtd-properties.html#type1\">\u30bf\u30a4\u30d7 1 \u30d7\u30ed\u30d1\u30c6\u30a3<\/a>\u306f\u3001\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u306a\u3044 1\u3064\u306e\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/li>\n<li><a href=\"xl-rtd-properties.html#type2\">\u30bf\u30a4\u30d7 2 \u30d7\u30ed\u30d1\u30c6\u30a3<\/a>\u306f\u30011\u3064\u306e\u5024\u3092\u8fd4\u3057\u307e\u3059\u304c\u3001\u7d50\u679c\u306b\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u9069\u7528\u3067\u304d\u307e\u3059\u3002<\/li>\n<\/ul><\/div>\n<div>\n<h3>\u9298\u67c4\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u53d6\u5f97: \u30bf\u30a4\u30d7 1<\/h3>\n<p>\u9650\u6708\u306e\u30bf\u30a4\u30d71\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u3001\u5358\u4e00\u306e\u5024\u3092\u8fd4\u3059\u3082\u306e\u3067\u3001\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u3053\u308c\u3089\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u3001\u4ee5\u4e0b\u306e\u5f62\u5f0f\u306e RTD \u5f0f\u3067\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,<em>inst-id<\/em>,<em>property<\/em>)<\/pre>\n<\/blockquote>\n<p>\u4f8b\u3048\u3070\u3001\u30bb\u30eb <strong>A13<\/strong> \u306b\u6587\u5b57\u5217\u300cLast\u300d\u3001\u30bb\u30eb <strong>B3<\/strong> \u306b\u9650\u6708 ID \u3092\u4fdd\u5b58\u3057\u305f\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b TT \u8868\u793a\u5f62\u5f0f\u3067\u76f4\u8fd1\u5024\u3092\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,B3,A13)<\/pre>\n<\/blockquote>\n<p>\u6570\u5f0f\u3092\u51e6\u7406\u3057\u305f\u5f8c\u3001Excel \u306f\u6b21\u306e\u3088\u3046\u306a\u7d50\u679c\u3092\u30bb\u30eb\u306b\u8868\u793a\u3057\u307e\u3059\u3002\u30bb\u30eb\u53c2\u7167\u306e\u300c$\u300d\u306f\u3001Excel \u6df7\u5408\u53c2\u7167\u8868\u8a18\u3067\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-test.tradingtechnologies.com\/wp-content\/uploads\/2026\/06\/rtd-type1-1.png\"><\/p>\n<h4>\u677f\u60c5\u5831\u306e\u53d6\u5f97<\/h4>\n<p id=\"depth-properties\">RTD\u306f\u3001\u677f\u60c5\u5831 (TTDepth) \u3068\u8a73\u7d30\u677f\u60c5\u5831 (TTDetailedDepth) \u3092\u8fd4\u3059\u30d7\u30ed\u30d1\u30c6\u30a3\u3082\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u677f\u60c5\u5831\u679a\u6570\u306f\u3001\u5404\u4fa1\u683c\u5e2f\u306b\u304a\u3051\u308b\u30c0\u30a4\u30ec\u30af\u30c8\u679a\u6570\u3068\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u679a\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u3082\u306e\u3067\u3059\u3002\u3053\u308c\u3089\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u3001\u4ee5\u4e0b\u306e\u5f62\u5f0f\u3067\u6570\u5f0f\u3092\u4f7f\u3063\u3066\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,<em>inst-id<\/em>,<em>depth-property<\/em>,<em>num-levels<\/em>,<em>cell-reference<\/em>)<\/pre>\n<\/blockquote>\n<p><strong>\u6ce8<\/strong>: 2\u756a\u76ee\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u3001RTD Server \u304c\u5b9f\u884c\u3055\u308c\u3066\u3044\u308b\u5916\u90e8\u30b5\u30fc\u30d0\u30fc\u306e\u540d\u524d\u306b\u306a\u308a\u307e\u3059\u3002TT RTD Server \u306f\u5e38\u306b\u30ed\u30fc\u30ab\u30eb\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u30012\u756a\u76ee\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u5024\u3092\u9664\u5916\u3059\u308b\u304b\u7a7a\u767d\u306e\u6587\u5b57 (&#8220;&#8221;\u009d) \u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u6570\u5f0f\u3067\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u69cb\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>TTDepth \u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u3001\u6b21\u306e\u3088\u3046\u306a 4x<em>num-levels<\/em> \u30e1\u30e2\u30ea\u5185\u914d\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>A1..A<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u8cb7\u679a\u6570<\/li>\n<li>B1..B<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u8cb7\u5024<\/li>\n<li>C1..C<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u58f2\u5024<\/li>\n<li>D1..D<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u58f2\u679a\u6570<\/li>\n<\/ul>\n<p>TTDetailedDepth \u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u3001\u6b21\u306e\u3088\u3046\u306a 6x<em>num-levels<\/em> \u30e1\u30e2\u30ea\u5185\u914d\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>A1..A<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u8cb7\u679a\u6570<\/li>\n<li>B1..B<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u8cb7\u5024<\/li>\n<li>C1..C<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u58f2\u5024<\/li>\n<li>D1..D<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u58f2\u679a\u6570<\/li>\n<li>E1..E<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u8cb7\u53d6\u5f15\u76f8\u624b ID<\/li>\n<li>F1..F<sub><em>num-levels<\/em><\/sub> : \u5404\u4fa1\u683c\u5e2f\u306e\u58f2\u53d6\u5f15\u76f8\u624b ID<\/li>\n<\/ul>\n<p><strong>\u6ce8<\/strong>: \u8a73\u7d30\u677f\u60c5\u5831\u306b\u3064\u3044\u3066\u306f\u3001\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u6ce8\u6587\u306b\u5bfe\u3057\u3066\u53d6\u5f15\u76f8\u624b ID \u306f\u8fd4\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>\u305f\u3068\u3048\u3070\u3001\u30bb\u30eb <strong>G4<\/strong> \u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u9650\u6708 ID \u306b\u5bfe\u3057\u3066\u677f\u60c5\u5831\u306e 10\u4fa1\u683c\u5e2f\u3092\u8fd4\u3059\u306b\u306f\u3001\u6b21\u306e\u3088\u3046\u306b\u6df1\u5ea6\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",, $G$4, \"TTDepth\", \"10\", CELL(\"Address\", A1)\")<\/pre>\n<\/blockquote>\n<p>\u6570\u5f0f\u3092\u51e6\u7406\u3057\u305f\u5f8c\u3001Excel \u3092\u8a2d\u5b9a\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u677f\u60c5\u5831\u306b\u4f3c\u305f\u7d50\u679c\u3092\u8868\u793a\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-test.tradingtechnologies.com\/wp-content\/uploads\/2026\/06\/rtd-type1-depth-1.png\"><\/p>\n<ol>\n<li>CELL(&#8220;Address&#8221;,A1)<\/li>\n<li>CELL(&#8220;Address&#8221;,B1)<\/li>\n<li>CELL(&#8220;Address&#8221;,C1)<\/li>\n<li>CELL(&#8220;Address&#8221;,D1)<\/li>\n<\/ol>\n<p><em>num-levels<\/em> \u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u3001\u8fd4\u3059\u914d\u5217\u306e\u30b5\u30a4\u30ba\u3092\u793a\u3057\u3066\u3044\u3066\u3001\u5fc5\u305a\u3057\u3082\u4fa1\u683c\u5e2f\u306e\u6570\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<ul>\n<li>\u677f\u60c5\u5831 (<em>depth-property<\/em> = <strong>TTDepth<\/strong>) \u306e\u5834\u5408\u3001\u6570\u5f0f\u306f\u3001\u6ce8\u6587\u679a\u6570\u3092\u542b\u3080\u5e02\u5834\u306e\u58f2\u8cb7\u5074\u306e\u6700\u521d\u306e <em>num-levels<\/em> \u4fa1\u683c\u5e2f\u3092\u8fd4\u3057\u307e\u3059\u3002\u30c0\u30a4\u30ec\u30af\u30c8\u679a\u6570\u3084\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u679a\u6570\u3092\u542b\u3093\u3060\u4fa1\u683c\u5e2f\u306f\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u307e\u3059\u3002<\/li>\n<li>\u8a73\u7d30\u677f\u60c5\u5831 (<em>depth-property<\/em> = <strong>TTDetailedDepth<\/strong>) \u306e\u5834\u5408\u3001\u4fa1\u683c\u5e2f\u306b\u304b\u304b\u308f\u3089\u305a\u3001\u5e02\u5834\u306e\u5404\u58f2\u8cb7\u5074\u306e\u6700\u521d\u306e <em>num-levels<\/em> \u6ce8\u6587\u3092\u8fd4\u3057\u307e\u3059\u3002\u4fa1\u683c\u5e2f\u306b\u30c0\u30a4\u30ec\u30af\u30c8\u679a\u6570\u3068\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u679a\u6570\u306e\u4e21\u65b9\u304c\u542b\u307e\u308c\u308b\u5834\u5408\u3001\u500b\u3005\u306e\u30c0\u30a4\u30ec\u30af\u30c8\u679a\u6570\u304c\u6700\u521d\u306b\u8fd4\u3055\u308c\u3001\u305d\u306e\u5f8c\u306b\u96c6\u7d04\u3055\u308c\u305f\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u679a\u6570\u304c\u7d9a\u304d\u307e\u3059\u3002\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u679a\u6570\u306b\u306f\u30a2\u30b9\u30bf\u30ea\u30b9\u30af (*) \u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\n<\/p>\n<p>\u8981\u6c42\u3055\u308c\u305f <em>num-levels<\/em> \u306b\u57fa\u3065\u3044\u3066\u3001\u8a73\u7d30\u677f\u60c5\u5831\u306e\u7d50\u679c\u306f1\u3064\u4ee5\u4e0a\u306e\u4fa1\u683c\u5e2f\u306e\u6ce8\u6587\u3092\u8fd4\u3057\u3001\u5916\u5074\u306e\u4fa1\u683c\u5e2f\u306e\u6ce8\u6587\u306e\u30b5\u30d6\u30bb\u30c3\u30c8\u306e\u307f\u8fd4\u3059\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u4f8b\u3048\u3070\u30015\u3064\u306e\u4fa1\u683c\u5e2f\u3092\u6307\u5b9a\u3057\u3001\u8cb7\u5074\u306b\u6700\u521d\u306e\u4fa1\u683c\u5e2f (100) \u30673\u3064\u306e\u6ce8\u6587 (1\u3064\u306e\u30c0\u30a4\u30ec\u30af\u30c8\u6ce8\u6587\u30682\u3064\u306e\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u6ce8\u6587)\u3001\u307e\u305f\u6b21\u306e\u4fa1\u683c\u5e2f (99) \u30676\u3064\u306e\u6ce8\u6587 (4\u3064\u306e\u30c0\u30a4\u30ec\u30af\u30c8\u6ce8\u6587\u30682\u3064\u306e\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u6ce8\u6587) \u304c\u542b\u307e\u308c\u3066\u3044\u308b\u3068\u3057\u307e\u3059\u3002\u8fd4\u3055\u308c\u308b\u914d\u5217\u306b\u306f\u3001\u6b21\u306e\u3088\u3046\u306a\u5185\u5bb9\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<ul>\n<li>2 at 100 (\u6700\u521d\u306e\u6ce8\u6587)<\/li>\n<li>4* at 100 (\u3053\u306e\u4fa1\u683c\u5e2f\u30672\u3064\u306e\u6ce8\u6587\u306e\u96c6\u7d04\u30a4\u30f3\u30d7\u30e9\u30a4\u30c9\u679a\u6570)<\/li>\n<li>50 at 99 (\u65b0\u4fa1\u683c\u5e2f\u3067\u306e\u6700\u521d\u306e\u6ce8\u6587)<\/li>\n<li>10 at 99 (\u3053\u306e\u4fa1\u683c\u5e2f\u3067\u306e2\u756a\u76ee\u306e\u6ce8\u6587)<\/li>\n<li>5 at 99 (\u3053\u306e\u4fa1\u683c\u5e2f\u3067\u306e3\u756a\u76ee\u306e\u6ce8\u6587)<\/li>\n<\/ul>\n<p>99 \u306e\u4fa1\u683c\u3067\u306e\u6b8b\u308a\u306e\u6ce8\u6587\u679a\u6570\u306f\u3001\u8fd4\u3055\u308c\u307e\u305b\u3093\u3002\u3053\u306e\u3088\u3046\u306b\u3001\u8981\u6c42\u3055\u308c\u305f\u6b63\u3057\u3044\u4fa1\u683c\u5e2f\u6570\u306b\u671f\u5f85\u3059\u308b\u5185\u5bb9\u304c\u3059\u3079\u3066\u542b\u307e\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/li>\n<\/ul><\/div>\n<div>\n<h3>\u9298\u67c4\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u53d6\u5f97: \u30bf\u30a4\u30d7 2<\/h3>\n<p>\u9650\u6708\u306e\u30bf\u30a4\u30d7 2 \u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u3001\u5358\u4e00\u306e\u5024\u3092\u8fd4\u3059\u3082\u306e\u3067\u3001\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u3053\u308c\u3089\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u3001\u4ee5\u4e0b\u306e\u5f62\u5f0f\u306e RTD \u5f0f\u3067\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,<em>inst-id<\/em>,<em>property<\/em>,<em>filter1<\/em>,<em>filter2<\/em>,<em>filter<\/em><strong>N<\/strong>)<\/pre>\n<\/blockquote>\n<p><strong>Account<\/strong> \u5c5e\u6027\u3092\u30d5\u30a3\u30eb\u30bf\u30fc\u3068\u3057\u3066\u4f7f\u7528\u3057\u3066\u3001TT RTD Server \u304c\u5024\u3092\u8a08\u7b97\u3059\u308b\u7d04\u5b9a\u3092\u5236\u9650\u3067\u304d\u307e\u3059\u3002For example, you might want the quantity of sell orders (<strong>SellQty<\/strong> property) of an instrument only if it was submitted \u305f\u3068\u3048\u3070\u3001\u7279\u5b9a\u306e\u53e3\u5ea7 (<strong>Account<\/strong> \u5c5e\u6027) \u3092\u901a\u3058\u3066\u9001\u4fe1\u3055\u308c\u305f\u5834\u5408\u306e\u307f\u3001\u3042\u308b\u9650\u6708\u306e\u58f2\u6ce8\u6587\u306e\u679a\u6570 (<strong>SellQty<\/strong> \u30d7\u30ed\u30d1\u30c6\u30a3) \u3092\u53d6\u5f97\u3057\u305f\u3044\u3068\u3057\u307e\u3059\u3002<\/p>\n<p><strong>\u6ce8<\/strong>: \u524d\u8ff0\u3057\u305f\u3088\u3046\u306b\u3001\u3044\u304f\u3064\u304b\u306e\u30bf\u30a4\u30d7 2 \u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u5bfe\u3057\u3066\u3001\u5c11\u306a\u304f\u3068\u3082 1\u3064\u306e <strong>\u53e3\u5ea7<\/strong> \u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u6570\u5f0f\u5185\u306e\u30d5\u30a3\u30eb\u30bf\u30fc \u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u5f62\u5f0f\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<\/p>\n<pre>&lt;property&gt;&lt;operator&gt;&lt;value&gt;<\/pre>\n<p>\u4f8b\u3048\u3070\u3001\u30bb\u30eb <strong>A33<\/strong> \u306b\u6587\u5b57\u5217\u300cAvgOpenPrice#\u300d\u3001\u30bb\u30eb<strong>A31<\/strong> \u306b\u6587\u5b57\u5217\u300cAccount=ATRSim\u300d\u3001\u30bb\u30eb <strong>B3<\/strong> \u306b\u9650\u6708 ID \u3092\u4fdd\u5b58\u3057\u305f\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5c0f\u6570\u70b9\u3067\u5e73\u5747\u306e\u59cb\u5024\u3092\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n<blockquote>\n<pre>=RTD(\"tt.rtd\",,B3,A33,A31)<\/pre>\n<\/blockquote>\n<p>\u6570\u5f0f\u3092\u51e6\u7406\u3057\u305f\u5f8c\u3001Excel \u306f\u6b21\u306e\u3088\u3046\u306a\u7d50\u679c\u3092\u30bb\u30eb\u306b\u8868\u793a\u3057\u307e\u3059\u3002\u30bb\u30eb\u53c2\u7167\u306e\u300c$\u300d\u306f\u3001Excel \u6df7\u5408\u53c2\u7167\u8868\u8a18\u3067\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-test.tradingtechnologies.com\/wp-content\/uploads\/2026\/06\/rtd-type2-single-filter-1.png\"><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p> <!-- \/fullarticle ttdoc-article-wrapper--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>RTD \u3092\u4f7f\u7528\u3057\u3066\u9650\u6708\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u969b\u3001\u53d6\u5f97\u3057\u3088\u3046\u3068\u3059\u308b\u9650\u6708\u306e ID \u3068\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 TT RTD \u6570\u5f0f\u306f\u3001\u4ee5\u4e0b\u306e\u57fa\u672c\u69cb\u9020\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002 =RTD(&#8220;tt.rtd&#8221;,,&#8221;Topic1&#8243;,&#8230;, [&hellip;]<\/p>\n","protected":false},"author":2,"template":"","meta":{"_acf_changed":false,"footnotes":""},"docs-category":[1275],"class_list":["post-42916","doc","type-doc","status-publish","hentry","docs-category-task-excel-integration-with-tt"],"acf":[],"_links":{"self":[{"href":"https:\/\/library-test.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc\/42916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/library-test.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc"}],"about":[{"href":"https:\/\/library-test.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/types\/doc"}],"author":[{"embeddable":true,"href":"https:\/\/library-test.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":0,"href":"https:\/\/library-test.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc\/42916\/revisions"}],"wp:attachment":[{"href":"https:\/\/library-test.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/media?parent=42916"}],"wp:term":[{"taxonomy":"docs-category","embeddable":true,"href":"https:\/\/library-test.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/docs-category?post=42916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}