[ts-gen] Unable to retrieve historical data for german stocks

Paolo Volpato dormilon at web.de
Tue Oct 7 11:36:13 EDT 2008


Hello,

running TWS version 886.5 + shim-081003 I'm able to connect to the TWS 
and to execute  "wild" commands as seen in some older postings 
(september) in search for the desired
"contract record unique id numbers".
However, when I try to do "past" requests (within the same session)  
based upon  those supposed  contract numbers  (german stocks / IBIS 
exchange) all I get  is a bunch of complaints  about "Grammar rule" and 
"Syntax error"...
Did I choose the wrong contract numbers or is the command syntax (simply 
copied from previuos posting) wrong ?

Any hints are welcome !

Best regards,

Paolo


./shim --data cout

          The trading shim has connected to the database server
          and loaded 51649 products; connected to the IB tws as
          client id  1; and queried for the account code, which
          seems to be DU52366.  Program initialization has been
          completed.

12322|62048|  34024502|4|100| 0|# |4|100|0|****************|
12322|62048|  34024529|4|101| 0|# |4|101|0|0.85|081003|data|
12322|62048|  34024540|4|100| 0|# |4|100|0|****************|
12322|62048|  33984558|4|102| 0|# |4|102|0|23|1|40|20081007 17:14:06 
CET|Connect with: cv 23, id 1, sv 40|
12322|62048|  33984474|3| 9| 1|1|
12322|62048|  34121743|3| 4| 2|      -1|2104|Market data farm connection 
is OK:eurofarm|
12322|62048|  34121825|3| 4| 2|      -1|2106|HMDS data farm connection 
is OK:euhmds2|
12322|62048|  34121896|3| 4| 2|      -1|2106|HMDS data farm connection 
is OK:ushmds2a|
...
...
select wild STK DBK  all;    wait 1;
12322|62138| 124539394|1| 9| 0|select wild STK DBK  all;    |
12322|62138| 124539463|1| 2| 0|wait 1;|
12322|62138| 124539595|2| 9| 3|9|3|DBK|STK||1.00||||||1|
...
...
...
12322|62139| 125071870|3|10| 
4|DBK|STK||0.0||IBIS|EUR|DBK|XETRA|XETRA|14121|0.0050||ADJUST,ALERT,...
...
...
...
select past 62139 d1   1  2w Ymd_T(20081001  9:00:00); wait 10;
Scan: 12 17 62139 <62139>
Term: past ConI       (nil)
Grammar rule: Terminal (ConI)
Grammar rule: Compound (past)
Syntax error:
Cursor state: match; text is:
select past 62139 d1select past 62139 d1   1  2w Ymd_T(20081001  9:00:00);
-----------------^--------------------------------------------------------
Terminal tag: name:ConI index:1
Drop:  d1select past 62139 d1   1  2w Ymd_T(20081001  
9:00:00);12322|62822| 808260926|1| 0| 0| |
12322|62822| 808260997|1| 2| 0|wait 10;|
...
...
...
select past 125071870 d1   1  2w Ymd_T(20081001  9:00:00); wait 10;
For type target <    ConI> and token text: <select>
predicted token type:  pos, scanner saw:  sym
Problem: 401 unexpected token text: syntax error
Scan: 12 18 0 <select>
Term: past ConI       (nil)
Grammar rule: Terminal (ConI)
Grammar rule: Compound (past)
Syntax error:
Cursor state: match; text is:
select past select past 125071870 d1   1  2w Ymd_T(20081001  9:00:00);
------------------^---------------------------------------------------
Terminal tag: name:ConI index:1
Drop:  past 125071870 d1   1  2w Ymd_T(20081001  9:00:00);12322|62948| 
934280606|1| 0| 0| |
12322|62948| 934280676|1| 2| 0|wait 10;|
...
...
...
select past 14121  d1   1  2w Ymd_T(20081001  9:00:00);
12322|63253|1238575943|1|12| 0|select past 14121  d1   1  2w (20081001  
9:00:00);|
12322|63253|1238576157|2|20| 
3|20|3|3|A7A|STK||0.00||1|SMART||EUR||20081001  09:00:00|11|2 w|0|TRADES|1|
12322|63253|1238879666|3|17| 3|         3|10|
12322|63253|1238878878|3| 1| 1|20080917|23.5|23.5|21.18|22.2|  
1572|22.27|false|STK:SMART:A7A:
12322|63253|1238878956|3| 1| 1|20080918|21.55|21.9|21.18|21.9|    
13|21.82|false|STK:SMART:A7A:
12322|63253|1238879056|3| 1| 1|20080919|22.15|22.33|21.18|22.0|    
96|22.03|false|STK:SMART:A7A:
12322|63253|1238879128|3| 1| 1|20080922|22.2|22.2|21.16|22.2|    
30|21.95|false|STK:SMART:A7A:
12322|63253|1238879200|3| 1| 1|20080923|22.2|22.44|21.18|22.1|   
433|21.88|false|STK:SMART:A7A:
12322|63253|1238879272|3| 1| 1|20080924|22.4|22.4|21.37|22.4|   
107|22.39|false|STK:SMART:A7A:
12322|63253|1238879344|3| 1| 1|20080925|22.0|22.5|21.45|22.5|   
335|22.49|false|STK:SMART:A7A:
12322|63253|1238879428|3| 1| 1|20080926|22.6|22.6|21.55|22.0|   
383|21.94|false|STK:SMART:A7A:
12322|63253|1238879501|3| 1| 1|20080929|22.23|22.23|21.2|22.1|    
38|22.09|false|STK:SMART:A7A:
12322|63253|1238879631|3| 1| 1|20080930|21.05|22.2|19.01|22.0|  
1145|19.82|false|STK:SMART:A7A:
12322|63253|1239004400|4|110| 0|# |4|110|0|event: history insert|(14112, 
11, 20080917 -- 20080930)|
...
...
...
quit;






More information about the ts-general mailing list