Milosz
Rookie
Posts: 38
Received Likes: 12
|
Post by Milosz on Mar 14, 2016 21:43:04 GMT
Fxshrat, thanks for the clues.
|
|
fxshrat
Private Group
Posts: 566
Received Likes: 211
|
Post by fxshrat on Mar 14, 2016 23:33:00 GMT
. I think that one problem would be performance issues (even more so if you intend to use in realtime intraday) since DDE/OLE are not that fast (and not multi-threading friendly). Btw, just another problem would be synchronisation. How to receive the same data that gets sent to Excel via DDE at same time in AB via OLE (which gets executed at fix auto-repeat interval)? You would defintely receive data being present in Excel cell but would you catch all DDE data (which change in unknown intervals)? I dont think so.
|
|
fxshrat
Private Group
Posts: 566
Received Likes: 211
|
Post by fxshrat on Mar 15, 2016 17:26:07 GMT
. I think that one problem would be performance issues (even more so if you intend to use in realtime intraday) since DDE/OLE are not that fast (and not multi-threading friendly). Btw, just another problem would be synchronisation. How to receive the same data that gets sent to Excel via DDE at same time in AB via OLE (which gets executed at fix auto-repeat interval)? You would defintely receive data being present in Excel cell but would you catch all DDE data (which change in unknown intervals)? I dont think so. One could try to first store DDE data in Excel and send those columns to AB. amibrokerforum.proboards.com/thread/127/excel-thread?page=1&scrollTo=484
|
|
Milosz
Rookie
Posts: 38
Received Likes: 12
|
Post by Milosz on Mar 16, 2016 9:49:39 GMT
Fxshrat, thanks for the links and additional information. In this case, I don't need the data from DDE to be very precise. I would be happy with a snapshot data taken every 15-30 seconds or even once a minute. But in general this task seems to be more challenging than I thought. As I can see, a lot of things must be taken into account for this mechanism to work properly and that requires good knowledge of DDE mechanism, vbscript or jscript and Excel. I may try to cope with it when I have some spare time, but first I need to improve my script languages coding skills. I will study the examples in your links.
Regards.
|
|