{"id":43164,"date":"2026-06-22T21:45:48","date_gmt":"2026-06-23T02:45:48","guid":{"rendered":"https:\/\/library-staging.tradingtechnologies.com\/doc\/using-rtd-and-excel-linking-2\/"},"modified":"2026-06-22T21:45:48","modified_gmt":"2026-06-23T02:45:48","slug":"using-rtd-and-excel-linking-2","status":"publish","type":"doc","link":"https:\/\/library-staging.tradingtechnologies.com\/ja\/using-rtd-and-excel-linking-2\/","title":{"rendered":"Using RTD and Excel Linking"},"content":{"rendered":"<p><iframe id=\"videoPlayer\" frameborder=\"0\" allowfullscreen=\"\" mozallowfullscreen=\"\" webkitallowfullscreen=\"\" src=\"https:\/\/player.vimeo.com\/video\/175614943?texttrack=ja&amp;api=1&amp;autoplay=0&amp;speed=true\"><\/iframe><\/p>\n<p>    <script src=\"https:\/\/player.vimeo.com\/api\/player.js\"><\/script><\/p>\n<p>\t<script>\n\t    var iframe = document.querySelector('iframe');\n\t    var player = new Vimeo.Player(iframe);<\/p>\n<p>\t    var currentURL = document.location.href;\n\t    var requestQueryString = decodeURIComponent(currentURL.split(\"?\")[1]);<\/p>\n<p>\t    var queryStrings = {}<\/p>\n<p>\t    if (requestQueryString !== undefined) { <\/p>\n<p>\t      queryArray = requestQueryString.split(\"&\")<\/p>\n<p>\t      for (i = 0; i < queryArray.length; i++) {  \n\t        currentPair = queryArray[i].split('=');\n\t        keyStr = currentPair[0]\n\t        valueStr = currentPair[1]\n\t        \n\t        if(typeof valueStr !== \"undefined\"){\n\t          queryStrings[keyStr] = valueStr;      \n\t        }\n\n\t      }\n\t    }\n\n\t    timeStamp = queryStrings[\"ts\"];\n\n\t    player.setCurrentTime(timeStamp)\n\t    \n\t<\/script><\/p>\n<h2>\u52d5\u753b\u306e\u6982\u8981<\/h2>\n<p>Use TT\u2019s Microsoft Excel Add-In to pull market data into your spreadsheet and link values from your spreadsheet back into your trading interface to create visual indicators. In this video we will build an RTD spreadsheet.<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p><iframe id=\"videoPlayer\" frameborder=\"0\" allowfullscreen=\"\" mozallowfullscreen=\"\" webkitallowfullscreen=\"\" src=\"https:\/\/player.vimeo.com\/video\/175614943?texttrack=ja&amp;api=1&amp;autoplay=0&amp;speed=true\"><\/iframe><\/p>\n<p>    <script src=\"https:\/\/player.vimeo.com\/api\/player.js\"><\/script><\/p>\n<p>\t<script>\n\t    var iframe = document.querySelector('iframe');\n\t    var player = new Vimeo.Player(iframe);<\/p>\n<p>\t    var currentURL = document.location.href;\n\t    var requestQueryString = decodeURIComponent(currentURL.split(\"?\")[1]);<\/p>\n<p>\t    var queryStrings = {}<\/p>\n<p>\t    if (requestQueryString !== undefined) { <\/p>\n<p>\t      queryArray = requestQueryString.split(\"&#038;\")<\/p>\n<p>\t      for (i = 0; i < queryArray.length; i++) {  \n\t        currentPair = queryArray[i].split('=');\n\t        keyStr = currentPair[0]\n\t        valueStr = currentPair[1]\n\t        \n\t        if(typeof valueStr !== \"undefined\"){\n\t          queryStrings[keyStr] = valueStr;      \n\t        }\n\n\t      }\n\t    }\n\n\t    timeStamp = queryStrings[\"ts\"];\n\n\t    player.setCurrentTime(timeStamp)\n\t    \n\t<\/script><\/p>\n<h2>\u52d5\u753b\u306e\u6982\u8981<\/h2>\n<p>Use TT\u2019s Microsoft Excel Add-In to pull market data into your spreadsheet and link values from your spreadsheet back into your trading interface to create visual indicators. In this video we will build an RTD spreadsheet.<\/p><\/p>\n","protected":false},"author":2,"template":"","meta":{"_acf_changed":false,"footnotes":""},"docs-category":[307],"class_list":["post-43164","doc","type-doc","status-publish","hentry","docs-category-videos-excel-integration-with-tt"],"acf":[],"_links":{"self":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc\/43164","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\/43164\/revisions"}],"wp:attachment":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/media?parent=43164"}],"wp:term":[{"taxonomy":"docs-category","embeddable":true,"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/docs-category?post=43164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}