Trade Performance exporting Excel file.....Numbers Stored as Text

[llanqui]

Hello,

https://drive.proton.me/urls/K8117JZJ4C#KKYjaQ5sOtyV

This is a link to download a video, will explain better than text...the video is in MKV format, but you probably have a video player that will play it? (VLC Player)

Also, the sound is a bit low...am using a new recording tool..

The problem is the Trade Performance export is creating excel output that requires several manual steps in order for it to be usable.

That is, all the number cells are stored at "number stored as text", which means they have to be manually converted before being used in calculations.

I can't imagine this is your intention?

Please, what is the purpose of storing the numbers as text?

[NinjaTrader_ChristopherJ]

Hello llanqui,

Thank you for posting.

I have submitted your suggestion to our Development Team and will follow up as soon as a tracking number has been assigned.

Let me know if I may be of further assistance.

[llanqui]

hope it will get a high priority...very easy to fix

[jeronymite]

llanqui This may be helpful: https://ninjatrader.com/support/foru...sx-do-not-work

Thanks.

[llanqui]

well, I wish Ninja would fix it because it is totally non-standard, it just doesn't make sense

otherwise I'll try to make an Excel macro to convert the entire spreadsheet at once

[llanqui]

ok, well this xcel macro appears to convert all the "numbers as text" in each worksheet in a file to numbers, which than can be used for math functions

just run the macro, then you don't have to mess with the manual column conversion

test it and see if it works for you

though, I don't see any sense that Ninja would output a spreadsheet with "numbers as text"


================================================== ===============================================

Sub ConvertTextNumberToNumber()

For Each WS In Sheets

On Error Resume Next

For Each r In WS.UsedRange.SpecialCells(xlCellTypeConstants)

If IsNumeric(r) Then r.Value = (r.Value) * 1

Next r

Next WS

End Sub