Direct Excel Connection Problems

[suprsnipes]

Firstly I have Vista and Excel 2000.

I am using the trial. I have set up a TCP/IP Client and succesfully used the Parser, which only the data that meets my filter is in the display window. I am having problems getting the Direct Excel Connection to work.

Notifications are not showing any problems. I'm getting 'Direct Excel Connection. Data have been processed successful'. I have read the instructions a number of times.

Excel opens but no data is displayed, in fact the screen is black. Which is odd.

Do you have any advice so that I may get this up and running. If I can get this to work I'll be purchasing this software.

Appreciate the reply.
Thanks.

[Arthur Grasin]

Please, verify, that you've bound your parser items (I hope you created it) with corresponding columns of an Excel file. Open the Direct Excel Connection settings and go to the "Binding" page. If the navigation button for this page isn't visible, then use the scroll button on the navigation pane or maximize the window.

[suprsnipes]

Thank you, that's exactly what I needed to do. Appreciate the quick reply also.

[suprsnipes]

I have got the DDE Excel export feature to work, by that I mean it can send the whole data packet without a problem after parsing (besides the fact that I haven't learned how I to have the current data move down a row each time new data comes in, but that's another problem).

Preferably I would like to use the Direct Excel Connection and I have looked at the tutorial about sending data via this method. So far I believe I have set this up correctly but the data simply won't fill in Excel using this method.

I have attached a screen shot of the DDE server's active items to show you where I am at. The names of the active items I want to use are the SYMBOL, DATE, TIME, TYPE, PRICE and SIZE.

I have set up Bindings to reflect this also (screen shot attached). The odd thing is when I add the 'FULL_DATA_PACKET' to the Bindings it works as expected.

I'm so close to getting this to work.

Thanks for your help.

[Arthur Grasin]

Please, create the backup copy of your configuration and attach it to your post with your data example. I'll verify it on my PC.

[suprsnipes]

Do you need data before or after it has been parsed?

By the way I have changed the IP and Port settings for security.

There also seems to be a problem with the program hanging up when opening when the DDE Link and Direct Excel connection export options are selected.

It opens Excel but as explained previously there is no data exported. I have to close Excel, then the program commences again. After which I have tried to go to the export options and selecting setup for the Direct Excel connection which opens Excel again, but no data is exported, yet the program doesn't freeze on this occasion.

[Arthur Grasin]

I need data before parsing. Few lines, just for testing.

[suprsnipes]

Please see attached.

[Arthur Grasin]

Please see attached.

Unfortunately, MS Word damages this data (removes all non-printable characters). Could you capture data to a file, ZIP it and attach the zip archive.

[suprsnipes]

I hope this ok.

[Arthur Grasin]

The program exports somethings to an excel file. I've deleted all filter rules from the parser, otherwise the parser doesn't work with your data example. Also I've set the "Device->Additional->Send client information" option to "Disabled". Is it possible something wrong with your XLS file template? The DDE server isn't required in your case. Now, it works for debug purposes only.

Please, activate program messages logging from "Main menu->Options->Program options->Protocol and errors handling". Activate all message types for all categories. It is possible, the program will show any error message at the bottom of the main window.