PDA

View Full Version : Export data problem


SUTHERLAND
26th January 2010, 05:55 AM
Hi Dave,

I am having trouble with "Number of Trade Positions". First when I run a simulation with the compressed option checked the "Number of Trade Positions" charts fine. However when I export to Excel the data is corrputed. I've pasted an example from Excel below. The true Number is 18 which you'll find in the middle, all the numbers that seem to ascend and descend from 18 are arbitary.

22/01/2010 1
22/01/2010 2
22/01/2010 3
22/01/2010 4
22/01/2010 5
22/01/2010 6
22/01/2010 7
22/01/2010 8
22/01/2010 9
22/01/2010 10
22/01/2010 11
22/01/2010 12
22/01/2010 13
22/01/2010 14
22/01/2010 15
22/01/2010 16
22/01/2010 17
22/01/2010 18
22/01/2010 17
22/01/2010 16
22/01/2010 15
22/01/2010 14
22/01/2010 13
22/01/2010 12
22/01/2010 11
22/01/2010 10
22/01/2010 9
22/01/2010 8
22/01/2010 7
22/01/2010 6
22/01/2010 5
22/01/2010 4
22/01/2010 3
22/01/2010 2
22/01/2010 1
22/01/2010 0

Second, if I run a simulation with the Linear option checked the "Number of Trade Positions" does not chart and only returns zero for all days.If I export the data to Excel I get the same result.

I haven't had trouble with this in the past. The system that I'm testing enters and exits trades on the same day, would this perhaps be the cuase of the errors? Anyway, tried a couple of things and don't get any results. I've tried exporting in other formats, but get the same results.

Look forward to hearing from you.

Kind Regards,

PJ Sutherland

David Samborsky
26th January 2010, 01:06 PM
Can you send me your trade database (trb) and session (ses) file and I will investigate.

regards
david

SUTHERLAND
27th January 2010, 07:37 AM
Hi Dave,

I've uploaded the trb and ses files, hope they come through. If not send me your e-mail.

Thanks,

PJ

SUTHERLAND
27th January 2010, 07:46 AM
Don't see my attachments, please send me your e-mail add

Thanks

David Samborsky
27th January 2010, 09:45 AM
best to send them to me a support@compuvision.com.au

regards
david