{"id":418,"date":"2010-11-17T06:04:33","date_gmt":"2010-11-17T13:04:33","guid":{"rendered":"http:\/\/qclsolutions.com\/home\/?p=418"},"modified":"2010-11-18T06:56:01","modified_gmt":"2010-11-18T13:56:01","slug":"xlinputs-%e2%80%93-how-is-it-different-from-free-excel-dlls","status":"publish","type":"post","link":"https:\/\/qclsolutions.com\/home\/?p=418","title":{"rendered":"XLInputs \u2013 How is it different from Free Excel dlls?"},"content":{"rendered":"<p>XLInputs can replace the free ELExcel.dll in the TradeStation forums, but the free dll does not replace XLInputs. XLInputs was designed to make working with Excel from EasyLanguage, very easy. Without any special code in your EasyLanguage indicator or strategy, using an XLI function, EasyLanguage can reference inputs in Excel even if you don\u2019t know the exact row or column.<\/p>\n<p>With the free dll, you would need header lines in your code. Then\u00a0your custom code\u00a0would need to loop\u00a0through\u00a0cells in an open workbook to find an identifier that locates your specific input. This is extremely process intensive since the most expensive operation when interacting with Excel is to read from it. (Writing is faster.)<\/p>\n<p>XLInputs streamlines such processes by taking advantage of Excel functionality. It has Excel perform the search; making what would otherwise be a CPU intensive process, light and efficient. And the language to accomplish this in an\u00a0EasyLanguage input is as simple as the following numeric example: <strong>XLI.Num(\u201cBook1\u201d, \u201cSheet1\u201d, \u201cIdentifier\u201d, 0)<\/strong>. Note that\u00a00 is a default return value if the identifier is not found in Excel.<\/p>\n<p>Further XLInputs is not limited to reading from Excel. It writes to Excel with ease. It can:<\/p>\n<ul>\n<li>read and write comments<\/li>\n<li>get and set font colors<\/li>\n<li>get and set background colors<\/li>\n<li>read and write times, converting to EL format\u00a0when reading any Excel date or time value<\/li>\n<li>read and write dates, converting to EL format\u00a0when reading any Excel date or time value<\/li>\n<li>read and write text<\/li>\n<li>read and write True\/False values<\/li>\n<li>identify the location of\u00a0specific cells\u00a0returning\u00a0row, column and A1-address information<\/li>\n<li>determine the used range<\/li>\n<li>clear cell formats, delete comments, etc.<\/li>\n<\/ul>\n<p>And there are many custom application of the technology like placing a list of dates and times in Excel; using that as a list of valid trading session times to be honored by Strategies. It can be\u00a0leveraged for custom optimizations, other tuning processes, and many other operations imminently useful to serious traders.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>XLInputs can replace the free ELExcel.dll in the TradeStation forums, but the free dll does not replace XLInputs. XLInputs was designed to make working with Excel from EasyLanguage, very easy. Without any special code in your EasyLanguage indicator or strategy, using an XLI function, EasyLanguage can reference inputs in Excel even if you don\u2019t know [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=\/wp\/v2\/posts\/418"}],"collection":[{"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=418"}],"version-history":[{"count":9,"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=\/wp\/v2\/posts\/418\/revisions"}],"predecessor-version":[{"id":436,"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=\/wp\/v2\/posts\/418\/revisions\/436"}],"wp:attachment":[{"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qclsolutions.com\/home\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}