[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