Exported excel files

[misova]

Hi guys,

after I export Excel from backtest results
(for example Trades -> Right Mouse button -> Export ... )
I get excel files, that contains values, but these are not parsable by Excel itself because of formatting.

For example Net Profit columns contains values like "173.00 $".
But you can't operate on these values, because Excel treats them like Text.
You can't make sum, add, subtract them... They are not numbers - from Excel point of view.

One has to fix all these column values first - like remove all the currency symbols, then remove spaces. It requires much work, to make the Excel practically usable.

It would be nice to have this fixed. This problems exists from beginning of NT8.

See attached example of exported excel file, so you can check on your own.
Just try to make Sum of NetProfit ...

http://ninjatrader.com/support/forum/attachment.php?attachmentid=44388&stc=1&d=1493578948

Best regards
Misova

[tradesmart]

You need to choose the option to select CSV format for exporting. Then, when you open that exported CSV file in Excel, all numerical values will be numbers without those problematic currency symbols.

[misova]

Thank you - this works as working alternative.

But still - NT guys could fix the Excel too, so it works correctly - otherwise it is unpractical/useless option, when one cannot do any calculations on it

[NinjaTrader_AlanP]

Hello misova,

I repeat your instructions and am unable to replicate, see attached.

What version of NT8 are you using under Control Center>Help>About?

I look forward to your reply.

[tradesmart]

I repeat your instructions and am unable to replicate, see attached.

Check to see what those little green error flags indicate. I believe that you actually have replicated the problem. Those columns do not look to me like they contain numbers since the formula bar displays the dollar sign, which it would not if the cell contained a valid number.

Try calculating a sum of any currency column.

[NinjaTrader_AlanP]

Hello tradesmart,

Good eye, thank you. I initially tested by selecting a cell and subtracting a number and did not see an error, but doing a sum as well as clicking on the green arrow makes it clear these are not being exported as numbers.

I will submit a bug report.

Thank you.

[akvevo]

issue persists

Hi,

I am using 8.0.7.0 64-bit (Standard) and see this is still an issue.
Can you kinldy provide a update on this issue and wehther its being looked into ?

And any possible workaround ?


Thank you
AK

[NinjaTrader_AlanP]

Hello akvevo,

There are no plans to change how these columns are exported however the solution for this issue would be to export as .csv.

An explanation for above can be found at the link below,

http://ninjatrader.com/support/forum/showthread.php?t=74796

Please let us know if you need further assistance.

[akvevo]

I exported results to a CSV files and am still the same issue.
Try doing an =SUM( ) in any of the data points in coloum M or N
Attached spreadsheet

[NinjaTrader_AlanP]

Hello akvevo,

I have no problem getting a sum. What version of NT8 are you using?

See attached screenshot and revised file.

[akvevo]

Interesting, I am using 8.0.7.0 64-bit (Standard)
Microsoft office 365
and I cant sum on your 'I can.csv' file.

[NinjaTrader_AlanP]

Hello misova,

If you upgrade to the next version, are you still unable to run a sum?

Are you perhaps including the header in your sum? What if you try to sum rows 3-10?

Most Recent Version NT8 Current Release.

http://ninjatrader.com/bin/BVD

I look forward to your reply.

[akvevo]

Hi,

I am not including the header in my formula. See attached.
Interesting (and maybe meaningless), but your export has brackets to denote negative numbers. My export doesnt.

As you can see, I export the trades from the Trades($) tab of a Strategy Analyser; Right Click > Export > Save Type As CSV.

I'd prefer not to speculatively upgrade, unless i really have to.
I see you are not able to replicate, but can you confirm that your test is on the same version I am running (8.0.7.0 64-bit (Standard))?

[NinjaTrader_AlanP]

Hello akvevo,

It looks to me that you are using the first file uploaded to this forum post rather than the one you uploaded most recently at the following post,

http://ninjatrader.com/support/forum/showpost.php?p=515389&postcount=9

I put together a video demonstrating there is no issue summing the file you provided on Aug 1.

https://www.screencast.com/t/UK5IeXCpxCn

Please let us know if you need further assistance.

[akvevo]

Thanks Alan,

I am not really sure what you mean, but whether:
- I download the CSV file from this foum which i posted on the 1st
or
- I download a new CSV file from "Strategy Analyser" > "Trades" > Export > save as CSV

I get the same negative result. The screenshot in my last post is my excel spreadsheet which I posted 08-01-2017, and not the 1st one posted on this forum.

Your video clearly shows that my sheet is working on your side, so I have no idea whats going on.