<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">About the second point, here is a screenshot, which may calm your headache (or not).<br>This stock is in the french SBF market, you may not have the rights to see contracts of this market. <br>For the "Problem: 550 ice: req wire-level...", the problem might be between the 20080828 release and the 20080825, because I don't have the same problem with the 20080822.<br>I'll check for Graphviz and my Debian (Ubuntu in fact...) later.<br>Just about testing, I found that TS is not very happy with combo options in portolio, "...418 cannot post ambigous order message", comething like that.<br><br>Thx for answers.<br><br>Sam.<br>--- En date de : <b>Ven 29.8.08, R P Herrold <i><herrold@owlriver.com></i></b> a écrit :<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">De: R P Herrold
<herrold@owlriver.com><br>Objet: How symbols and contracts are defined during database creation<br>À: sam_backtester@yahoo.fr, "trading-shim general mailing list" <ts-general@trading-shim.org><br>Date: Vendredi 29 Août 2008, 20h09<br><br><pre>On Fri, 29 Aug 2008, sam wrote:<br><br>> Thanks for the answer.<br>><br>> The db structure is more clear for me now, and I know now <br>> what was wrong for me, when I was trying to get historical <br>> data for some of my european stocks.<br><br> ;)<br><br>> First, one stock name change its symbol/name these last <br>> months, but keep the same ibc (it's the stock named now GSZ <br>> instead of GAZ, ibid 35052259). So sym/A0Stk05.sql might be <br>> changed or re-generated for this stock.<br><br>darn ;( We hoped IB would assign a new ibid in such cases <br>[there are reasons to do so and reasons not to do so, I know].<br><br>This to some degree is something we need to
design for in <br>holding lot specification markers on orders (under some tax <br>lawd, one can specify that one is selling from part of a <br>holding which one bought, say, 18 months ago, rather than say <br>1 month ago, and get differing tax treatment -- long term <br>'investor' vs. short term 'trader' treatments.)<br><br>Thank you for this report.<br><br>> Second, I still have a strange issue with a french stock, <br>> TFI, ibid 29612096. I'm unable to get any data for this <br>> stock, it's maybe an IB issue, because I've found a strange <br>> thing, when I get a chart in TWS for this stock, the symbol <br>> name is FSE instead of TFI...<br><br>Researching TFI here comes up in the TWS GUI with:<br> a US SPDR stock, which invests in muni bonds<br> (probably a closed end?) mutual fund traded on<br> the AMEX (closed end mutuals look and<br> trade like stocks) in USD<br> 'Transforce' a stock, on the Toronto SE, one assumes<br>
in CAD<br> 'TFI', a media company Listing trading on Exchange SBF<br> in EUR, in Region: Europe *AND* having Fut and<br> Opt derivatives<br> A stock I do not have rights enabled to trade:<br> BEST STK/Top TFI "TREVI FINANZIARIA SPA", in<br> EUR, in Region: Europe<br> Another stock I do not have rights enabled to trade:<br> BM STK/Top TFI "TABLEROS DE FIBRA", in EUR, in<br> Region: Europe<br><br>... my head hurts ;)<br><br><br>> Third point, I tried to add some E-Mini contracts, which <br>> don't seems to be here in sym/*.sql. I thought I was just <br>> need to add the correct entries in, for example, <br>> sym/A0Fut00.sql, and in Expiry.sql. But I don't get the <br>> newly added contracts with a get_id.sql, maybe i'll need to <br>> change the where clauses in this script ?<br><br>We have usually just populated the YM for the next few Front <br>Month and back Expirations in the emini's for the
tarballs we <br>ship, as it took up space and caused load times to be longer, <br>and presented a maintenance load in the past. As we have <br>made some changes 'under the hood' and have more planned for <br>database loads, we will revist this in planning Monday.<br><br>Bill may well have a short term workaround on this, but this <br>is the first time anyone has asked for them in the mailing <br>list community. ;)<br><br>> Unfortunately, I was forced to stop my tests, I have a <br>> strange issue, with the lastest tarball, a fresh database, <br>> when I try to get historical data (here example with AIG):<br>> ------------------------<br>> select past 6 5 Ymd_T(20080801 23:00:00)<br>><br>> Problem: 550 ice: req wire-level format typecheck error<br>> Exiting<br>> ------------------------<br>> I've restarted few times my TWS, but still got this error for.<br><br>I have brought your email to Bill's attention. We are
quite <br>interested, and he will probably have more to offer.<br><br>> About Warrants, I'm not so big fan of these products, but I <br>> can help if needed.<br><br>We want and NEED people _testing_ a feature, before expending <br>the effort to support it. When we do not test, we may miss a <br>function loss in a refactoring. As the trading shim homepage <br>notes (and has noted from day one):<br><br> ... [in part] we are exploring software engineering<br> issues related to ... test-driven development.<br><br>> It's a good idea to include th .ps file in the tarball, I <br>> had some issues for generate the file with Graphviz on my <br>> Debian based distribution.<br><br>It is not unusual for recent Debian 'testing' to not be able <br>to rebuild the documentation -- they seem to have lost a <br>required package. It _is_ unusual to get a Graphviz <br>complaint. I'll test it ... more later. As to the LaTeX <br>rebuild of the manual, I
get this error on a ** new ** Debian <br>'testing' installation [from the netiso earlier this week]:<br><br>Package latex2html is not available, but is referred to by another package.<br>This may mean that the package is missing, has been obsoleted, or<br>is only available from another source<br>E: Package latex2html has no installation candidate<br><br>------------------------------------<br><br>which builds the HTML version of the documentation.<br><br>'latex2html' is needed by a Makefile target:<br><br>online: manual ; latex2html -debug $(L2H_CA) manual<br><br>and in the TeX as well [it provides 'html.sty']. We have a <br>documentation re-write on the horizon, and rather than do a <br>poor fix now, let's wait to see if Debian has the package <br>return, and not do doco rebuilds on Debian.<br><br>As to Graphviz, Bill mentioned earlier in the week:<br><br>> The postscript files above were produced using the graphviz <br>> dot
program via the script bin/fkey.rb . If you lack the <br>> tools to produce the graphs, and one or more is missing from <br>> your tarball, I've just pushed another release that has all <br>> three of the above postscript files in the sql directory<br><br>hmmm ... But there ** is ** something wrong as to the <br>[re-]generation of 'foreign.ps' -- we will look into that.<br><br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$ find -name '*.ps'<br>./syms.ps<br>./foreign.ps<br>./xact.ps<br>./subs.ps<br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$ rm -rf \<br> ./syms.ps ./foreign.ps ./xact.ps ./subs.ps<br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$ find -name '*.ps'<br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$ bin/fkey.rb<br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$ find -name '*.ps'<br>./syms.ps<br>./xact.ps<br>./subs.ps<br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$<br><br><br>This is
our Debian 'testing' environment:<br><br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$ sudo apt-get install lsb<br> ... snip much ...<br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$ lsb_release -a<br>LSB Version: core-2.0-ia32:core-2.0-noarch:core-3.0-ia32:<br> core-3.0-noarch:core-3.1-ia32:core-3.1-noarch:core-3.2-ia32:<br> core-3.2-noarch:cxx-3.0-ia32:cxx-3.0-noarch:cxx-3.1-ia32:<br> cxx-3.1-noarch:cxx-3.2-ia32:cxx-3.2-noarch:desktop-3.1-ia32:<br> desktop-3.1-noarch:desktop-3.2-ia32:desktop-3.2-noarch:<br> graphics-2.0-ia32:graphics-2.0-noarch:graphics-3.0-ia32:<br> graphics-3.0-noarch:graphics-3.1-ia32:graphics-3.1-noarch:<br> graphics-3.2-ia32:graphics-3.2-noarch:qt4-3.1-ia32:qt4-3.1-noarch<br>Distributor ID: Debian<br>Description: Debian GNU/Linux testing (lenny)<br>Release: testing<br>Codename: lenny<br>herrold@dhcp-232:~/shim/shim-builder/shim-080828/sql$<br><br>I have pushed a freshly updated copy of
my Debian environment <br>setup and building script to:<br><br> ftp://ftp.owlriver.com/pub/local/COLUG/shim-debian.sh<br><br>You should get identical results after running that <br>environment setup. If not, I am VERY interested in a report.<br><br>-- Russ herrold<br></pre></blockquote></td></tr></table><br>
<hr size="1">
Envoyé avec <a href="http://us.rd.yahoo.com/mailuk/taglines/isp/control/*http://us.rd.yahoo.com/evt=52423/*http://fr.docs.yahoo.com/mail/overview/index.html">Yahoo! Mail</a>.<br>Une boite mail plus intelligente. </a>