Go Back   NinjaTrader Support Forum > Application Technical Support > Miscellaneous Support

Miscellaneous Support Miscellaneous support issues.

Reply
 
Thread Tools Display Modes
Old 05-03-2010, 02:26 PM   #1
tonynt
Senior Member
 
Join Date: Jun 2009
Posts: 901
Thanks: 28
Thanked 24 times in 11 posts
Default Export to Excel

Hello,

I want to export the trades from account performance to Excel. But when doing this there appears "Unable to start Excel or any other application to view a *.csv file."

Can you please help me where to change settings so that the export can be done.

Thanks and best regards
Tony
tonynt is offline  
Reply With Quote
Old 05-03-2010, 02:36 PM   #2
NinjaTrader_RyanM
NinjaTrader Customer Service
 
NinjaTrader_RyanM's Avatar
 
Join Date: Sep 2009
Location: Denver, CO
Posts: 8,128
Thanks: 249
Thanked 427 times in 423 posts
Default

Hello Tonynt,

Thank you for your post.

You can likely get the same results by right clicking and selecting Save As...

The file format for the next screen will be .csv files. You can then open up the files in excel.
NinjaTrader_RyanM is offline  
Reply With Quote
Old 05-03-2010, 02:38 PM   #3
tonynt
Senior Member
 
Join Date: Jun 2009
Posts: 901
Thanks: 28
Thanked 24 times in 11 posts
Default Export to Excel

Thank you!
tonynt is offline  
Reply With Quote
Old 05-10-2010, 10:52 AM   #4
laredo
Senior Member
 
Join Date: May 2008
Posts: 216
Thanks: 1
Thanked 1 time in 1 post
Default

Will you review precisely the protocol in exporting trade log into Excel.

Also is there a free version of Excel made available at the moment.Have heard there is
Thank you
laredo is offline  
Reply With Quote
Old 05-10-2010, 11:03 AM   #5
NinjaTrader_Chip
NinjaTrader Customer Service
 
NinjaTrader_Chip's Avatar
 
Join Date: Dec 2009
Location: Denver, CO
Posts: 1,422
Thanks: 0
Thanked 0 times in 0 posts
Default

Hello Laredo,

Once you have a compiled set of Order records & or Trade history you would like to export:
1. Right-click (will bring up the options menu)
2. Select “Export to Excel…”
3. This will paste the orders/executions data into MS Excel

I have also included a screenshot of the menu item discussed.

Google & OpenOffice are a couple of the “free” spreadsheet programs. However, these are not configured to trigger with the NinjaTrader export command.
Attached Images
File Type: jpg 5733jh2559.jpg (140.7 KB, 41 views)
NinjaTrader_Chip is offline  
Reply With Quote
Old 06-28-2010, 02:49 AM   #6
laredo
Senior Member
 
Join Date: May 2008
Posts: 216
Thanks: 1
Thanked 1 time in 1 post
Default exporting to Excel

Is it possible to export trades to Open Office with NT?
laredo is offline  
Reply With Quote
Old 06-28-2010, 07:59 AM   #7
NinjaTrader_RyanM
NinjaTrader Customer Service
 
NinjaTrader_RyanM's Avatar
 
Join Date: Sep 2009
Location: Denver, CO
Posts: 8,128
Thanks: 249
Thanked 427 times in 423 posts
Default

Hello Laredo,

Thank you for your post.

NinjaTrader can export trade information in .csv format, which you should be able to open with open office. You would use Right Click > Save As > Save to disk, and then use Open Office to view.
Last edited by NinjaTrader_RyanM; 06-28-2010 at 12:44 PM.
NinjaTrader_RyanM is offline  
Reply With Quote
Old 06-28-2010, 11:14 AM   #8
laredo
Senior Member
 
Join Date: May 2008
Posts: 216
Thanks: 1
Thanked 1 time in 1 post
Default excel

I dont happen to have excel,if I download Open Office and right click and export to Excel,then I will get a file that I then need to "save as" or do U know what happens at that point in time?
laredo is offline  
Reply With Quote
Old 06-28-2010, 12:45 PM   #9
NinjaTrader_RyanM
NinjaTrader Customer Service
 
NinjaTrader_RyanM's Avatar
 
Join Date: Sep 2009
Location: Denver, CO
Posts: 8,128
Thanks: 249
Thanked 427 times in 423 posts
Default

Hi Laredo,

Thanks for the reply. Yes, you will have to save to disk first and then open that file in Open Office.
NinjaTrader_RyanM is offline  
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
CCi value export to excel Tatanka1 Strategy Development 7 02-11-2010 07:54 AM
NT7 Excel export suggestion oclop Version 7 Beta General Questions & Bug Reports 1 10-25-2009 12:01 PM
Export to excel is broken heech Strategy Analyzer 1 11-30-2008 04:29 AM
Export To Excel Function mrlogik Suggestions And Feedback 2 08-07-2008 07:30 AM
Export Log to Excel? mgbloomfield Miscellaneous Support 1 05-28-2008 03:00 PM


All times are GMT -6. The time now is 06:10 AM.

FULL RISK DISCLOSURE: Futures trading contains substantial risk and is not for every investor. An investor could potentially lose all or more than the initial investment. Risk capital is money that can be lost without jeopardizing ones financial security or lifestyle. Only risk capital should be used for trading and only those with sufficient risk capital should consider trading. Past performance is not necessarily indicative of future results. View Full Risk Disclosure.