Exported excel files

[NinjaTrader_AlanP]

Hello misova,

Given the exported format of the file you uploaded on 8-1 gives me no issues when I try summing the column, it could be your version of MS Excel you are using.

What version of MS Excel are you using?

I look forward to your reply.

[akvevo]

Hi Alan,

Micrsoft Office 2016 (365) .

[NinjaTrader_AlanP]

Hello akvevo,

I would like to schedule a support call with you to look into this further.

Please send an email to platformsupport[at]ninjatrader[dot]com with Attn: Alan P in the Subject line. Also within the email please include a link to this thread, a phone number I can reach you at and a time window where I can call you (please include a time zone).

I look forward to our support call.

[ntuser2017]

I am seeing the same inconsistencies here - No matter whether I export from NT in Excel native format or I export in CSV, all the dollar-value columns such as Profit, Cum. net profit,MAE and so on are not seen by Excel as numbers and therefore cannot be used for any calculations.

This is true even when attempting to convert them to numbers with Excel formulae such as VALUE().

I am using Excel 2010 and NT 8.0.17.2.

Was this issue resolved?

[NinjaTrader_PatrickG]

This is a limitation as changes to this cause other problems such as formatting integer values as DateTime. For reference, we're tracking this internally as "10102" and "8376"

[ntuser2017]

I am seeing the same inconsistencies here - No matter whether I export from NT in Excel native format or I export in CSV, all the dollar-value columns such as Profit, Cum. net profit,MAE and so on are not seen by Excel as numbers and therefore cannot be used for any calculations.

This is true even when attempting to convert them to numbers with Excel formulae such as VALUE().

I am using Excel 2010 and NT 8.0.17.2.

Was this issue resolved?

I just run some tests and it turns out, if I switch my Windows Region and Language settings from United Kingdom to United States, I am able to perform calculations on the dollar-value columns on the CSV exported file (but not on the Excel one).


I don't believe non-US users are expected to switch their regional settings to be able to use Excel and NinjaTrader together - am I missing something?

[ntuser2017]

This is a limitation as changes to this cause other problems such as formatting integer values as DateTime. For reference, we're tracking this internally as "10102" and "8376"

Hi Patrick thanks, please see my latest post about Regional Settings.

[NinjaTrader_PatrickG]

It sounds like you're not experiencing the same symptoms this thread was originally referring to if your region switch resolves the symptom. Please send me your log and trace files so that I may look into what occurred.

• You can do this by going to the Control Center-> Help-> Email Support
• Ensuring 'Log and Trace Files' is checked will include these files. This is checked by default.
• Please reference the following ticket number in the body of the email: 2199452 ATTN PatrickG

[ntuser2017]

It sounds like you're not experiencing the same symptoms this thread was originally referring to if your region switch resolves the symptom. Please send me your log and trace files so that I may look into what occurred.

• You can do this by going to the Control Center-> Help-> Email Support
• Ensuring 'Log and Trace Files' is checked will include these files. This is checked by default.
• Please reference the following ticket number in the body of the email: 2199452 ATTN PatrickG

Thanks Patrick,

As far as my issue is concerned, I do have a workaround now, although it would be good if NT could resolve the issue long-term.


Can you confirm that that users misova and akvevo are US-based ? If not (meaning, if they are not US based), it may be that they have not tried to switch settings too.

[NinjaTrader_PatrickG]

Unfortunately I do not have that information, however, I can confirm that we were able to reproduce the symptoms they experienced with US region settings.