{"id":43124,"date":"2026-06-22T21:45:09","date_gmt":"2026-06-23T02:45:09","guid":{"rendered":"https:\/\/library-staging.tradingtechnologies.com\/doc\/connecting-tt-to-excel-spreadsheets-2\/"},"modified":"2026-06-22T21:45:10","modified_gmt":"2026-06-23T02:45:10","slug":"connecting-tt-to-excel-spreadsheets-2","status":"publish","type":"doc","link":"https:\/\/library-staging.tradingtechnologies.com\/ja\/connecting-tt-to-excel-spreadsheets-2\/","title":{"rendered":"TT \u3068 Excel \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u63a5\u7d9a"},"content":{"rendered":"<div><!-- \n\n<h3 id=\"connect\">Connecting TT to Excel spreadsheets<\/h3>\n\n --><\/p>\n<p>TT \u3068 Excel \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u63a5\u7d9a\u3055\u305b\u308b\u306b\u306f<\/p>\n<ol>\n<li>\n<p>TT \u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3001TT \u30ef\u30fc\u30af\u30b9\u30da\u30fc\u30b9\u3092\u958b\u304d\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p>Excel \u3092\u307e\u3060\u8d77\u52d5\u3055\u305b\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001Excel \u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p>[<b>File<\/b>] \u30e1\u30cb\u30e5\u30fc\u304b\u3089 [<b>Excel linking<\/b>] \u30b5\u30d6\u30e1\u30cb\u30e5\u30fc\u3092\u958b\u304d\u3001[<b>Connect to Excel<\/b>] \u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p>Excel \u306b\u521d\u3081\u3066\u63a5\u7d9a\u3059\u308b\u5834\u5408\u306f\u3001TT \u3067\u4ee5\u4e0b\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3 \u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-staging.tradingtechnologies.com\/wp-content\/uploads\/2026\/06\/excel-allow-user-dialog-1.png\"><\/p>\n<p><b>\u6ce8<\/b>: Excel \u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u305f\u3081\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u660e\u78ba\u306b\u8868\u793a\u3055\u308c\u306a\u3044\u5834\u5408\u306f\u3001Excel \u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u7e2e\u5c0f\u3059\u308b\u304b\u79fb\u52d5\u3055\u305b\u308b\u3068\u3001\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p>[<b>Yes<\/b>] \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p>Excel \u306b\u6b63\u5e38\u306b\u63a5\u7d9a\u3067\u304d\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u65b0\u898f\u306e Excel \u30a2\u30a4\u30b3\u30f3\u304c\u30e1\u30cb\u30e5\u30fc \u30d0\u30fc\u306b\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-staging.tradingtechnologies.com\/wp-content\/uploads\/2026\/06\/excel-enable-icon-1.png\"><\/p>\n<\/li>\n<\/ol>\n<p><b>\u30d2\u30f3\u30c8<\/b>: \u521d\u56de\u306e\u63a5\u7d9a\u5f8c\u3001\u30e1\u30cb\u30e5\u30fc \u30d0\u30fc\u306e Excel \u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066 Excel \u3078\u306e\u63a5\u7d9a\u3092\u6709\u52b9\u5316\u307e\u305f\u306f\u7121\u52b9\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<p><!--\n  Instrument section\n  \n\n<div>\n    \n\n<h3 id=\"instruments\">Identifying instruments in your spreadsheet<\/h3>\n\n\n    \n\n<p>When you reference instruments in your spreadsheet, you must use what is commonly called the short name to identify the instrument. For example, if you want to reference the CME September 2016 E-mini futures instrument, you cannot put <b>ES Sep16<\/b> in the spreadsheet cell; you must use <b>ESU6<\/b>. As different exchanges use different conventions to identify their contracts, TT provides an easy way for you to get the required instrument name to use in your spreadsheet. The ICE naming convention, for example, uses the short name, <b>BRN FMM0016!<\/b>, for the Brent Futures September 2016 contract.<\/p>\n\n\n    \n\n<p>To get the short name for an instrument, open a Market Grid, select the desired instrument and type <b>Shift+Ctrl+X<\/b> to display the instrument data. You can then see the value in the instrument's <b>name<\/b> field.<\/p>\n\n\n    \n\n<p><img decoding=\"async\" class=\"img-responsive\" src=\"Content\/excel-get-instr-name.png\"><\/p>\n\n\n  <\/div>\n\n\n  --> <!--\n  Unlinking section\n  \n\n<div>\n    \n\n<h3 id=\"unlink\">Unlinking from Excel<\/h3>\n\n\n    \n\n<p>To remove the link from Excel in the widget:<\/p>\n\n\n    \n\n<ol>\n      \n\n<li>\n        \n\n<p>In the widget field linked to Excel, right-click to display the context menu.<\/p>\n\n\n      <\/li>\n\n\n      \n\n<li>\n        \n\n<p>Select <b>Unlink from Excel<\/b>.<\/p>\n\n\n      <\/li>\n\n\n    <\/ol>\n\n\n  <\/div>\n\n\n  --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>TT \u3068 Excel \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u63a5\u7d9a\u3055\u305b\u308b\u306b\u306f TT \u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3001TT \u30ef\u30fc\u30af\u30b9\u30da\u30fc\u30b9\u3092\u958b\u304d\u307e\u3059\u3002 Excel \u3092\u307e\u3060\u8d77\u52d5\u3055\u305b\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001Excel \u3092\u5b9f\u884c\u3057\u307e\u3059\u3002 [File] \u30e1\u30cb\u30e5\u30fc\u304b\u3089 [Exce [&hellip;]<\/p>\n","protected":false},"author":2,"template":"","meta":{"_acf_changed":false,"footnotes":""},"docs-category":[274],"class_list":["post-43124","doc","type-doc","status-publish","hentry","docs-category-task-excel-integration-with-tt"],"acf":[],"_links":{"self":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc\/43124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc"}],"about":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/types\/doc"}],"author":[{"embeddable":true,"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":0,"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc\/43124\/revisions"}],"wp:attachment":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/media?parent=43124"}],"wp:term":[{"taxonomy":"docs-category","embeddable":true,"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/docs-category?post=43124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}