• If this is your first visit, you will have to register before you can post. To view messages, please scroll below and select the forum that you would like to visits. Questions? Be sure to check out the Forum FAQ.

Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Exporting Strategy Performance to Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Exporting Strategy Performance to Excel

    I have been performing on-screen back tests via Strategy Performance. I have a question about exporting the results to Excel.

    I displayed Trades ($). Then I right-clicked the first column of Trade 1, then selected Export... Using this method, I exported the data to Excel, but when I attempted to change the number format of the Profit column via clicking the column heading, then right-clicking format cells, then clicking on number to change the color of the negative numbers, I get an error message on each cell which says "Number Stored as Text". I can click on "Convert to Number", but I would have to do this for every cell.

    Is there any way to convert all the text within a column to numbers without having to do it for each cell?

    Thanks-
    Rick

    #2
    Hello Bionian,

    Thank you for your note.

    If you highlight all the cells containing a number in the column then click "Convert to Number" it will convert all cells in the column at once.

    Please let us know if we may be of further assistance to you.
    Kate W.NinjaTrader Customer Service

    Comment


      #3
      Thanks, Kate. It's been awhile since we communicated. I hope you are doing well and staying safe.

      Yes, this worked. I thought that was what I was doing when I clicked on the column header, but i guess there is a difference. Thanks.

      Rick

      Comment

      Latest Posts

      Collapse

      Topics Statistics Last Post
      Started by jeronymite, Today, 09:26 PM
      0 responses
      6 views
      0 likes
      Last Post jeronymite  
      Started by ttodua, Yesterday, 06:45 AM
      2 responses
      17 views
      0 likes
      Last Post NinjaTrader_ChelseaB  
      Started by franco12364, Today, 08:08 PM
      2 responses
      11 views
      0 likes
      Last Post franco12364  
      Started by smcllr, Today, 06:10 PM
      1 response
      16 views
      0 likes
      Last Post NinjaTrader_ChelseaB  
      Started by lupearadu, Today, 01:58 PM
      7 responses
      38 views
      0 likes
      Last Post NinjaTrader_ChelseaB  
      Working...
      X