Go Back   NinjaTrader Support Forum > NinjaTrader 7 > Platform Technical Support

Platform Technical Support General platform technical support for NinjaTrader 7.

Reply
 
Thread Tools Display Modes
Old 05-03-2010, 02:26 PM   #1
tonynt
Senior Member
 
Join Date: Jun 2009
Posts: 1,271
Thanks: 119
Thanked 31 times in 18 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_RyanM1
NinjaTrader Customer Service
 
NinjaTrader_RyanM1's Avatar
 
Join Date: Sep 2009
Location: Denver, CO
Posts: 8,127
Thanks: 249
Thanked 434 times in 427 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_RyanM1 is offline  
Reply With Quote
Old 05-03-2010, 02:38 PM   #3
tonynt
Senior Member
 
Join Date: Jun 2009
Posts: 1,271
Thanks: 119
Thanked 31 times in 18 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: 215
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 1 time in 1 post
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, 49 views)
NinjaTrader_Chip is offline  
Reply With Quote
Old 06-28-2010, 02:49 AM   #6
laredo
Senior Member
 
Join Date: May 2008
Posts: 215
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_RyanM1
NinjaTrader Customer Service
 
NinjaTrader_RyanM1's Avatar
 
Join Date: Sep 2009
Location: Denver, CO
Posts: 8,127
Thanks: 249
Thanked 434 times in 427 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_RyanM1; 06-28-2010 at 12:44 PM.
NinjaTrader_RyanM1 is offline  
Reply With Quote
Old 06-28-2010, 11:14 AM   #8
laredo
Senior Member
 
Join Date: May 2008
Posts: 215
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_RyanM1
NinjaTrader Customer Service
 
NinjaTrader_RyanM1's Avatar
 
Join Date: Sep 2009
Location: Denver, CO
Posts: 8,127
Thanks: 249
Thanked 434 times in 427 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_RyanM1 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
Export to excel is broken heech Platform Technical Support 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 Platform Technical Support 1 05-28-2008 03:00 PM


All times are GMT -6. The time now is 02:15 AM.

Futures, foreign currency and options 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.

CFTC Rules 4.41 - Hypothetical or Simulated performance results have certain limitations, unlike an actual performance record, simulated results do not represent actual trading. Also, since the trades have not been executed, the results may have under-or-over compensated for the impact, if any, of certain market factors, such as lack of liquidity. Simulated trading programs in general are also subject to the fact that they are designed with the benefit of hindsight. No representation is being made that any account will or is likely to achieve profit or losses similar to those shown.

This website is hosted and operated by NinjaTrader, LLC (“NT”), a software development company which owns and supports all proprietary technology relating to and including the NinjaTrader trading platform. NT is an affiliated company to NinjaTrader Brokerage (“NTB”), which is a NFA registered introducing broker (NFA #0339976) providing brokerage services to traders of futures and foreign exchange products. This website is intended for educational and informational purposes only and should not be viewed as a solicitation or recommendation of any product, service or trading strategy. No offer or solicitation to buy or sell securities, securities derivative or futures products of any kind, or any type of trading or investment advice, recommendation or strategy, is made, given, or in any manner endorsed by any NT affiliate and the information made available on this Web site is not an offer or solicitation of any kind. Specific questions related to a brokerage account should be sent to your broker directly. The content and opinions expressed on this website are those of the authors and do not necessarily reflect the official policy or position of NT or any of its affiliates. 

Vendors along with their websites, products and services, collectively referred to as (“Vendor Content”), are independent persons or companies that are in no manner affiliated with NT or any if its affiliates. NT or any of its affiliates are not responsible for, do not approve, recommend or endorse any Vendor Content referenced on this website and it’s your sole responsibility to evaluate Vendor Content. Please be aware that any performance information provided by a vendor should be considered hypothetical and must contain the disclosures required by NFA Rule 2-29(c). If you are interested in learning more about, or investigating the quality of, any such Vendor Content you must contact the vendor, provider or seller of such Vendor Content. No person employed by, or associated with, NT or any of its affiliates is authorized to provide any information about any such Vendor Content. Visit the CFTC resources for education regarding the industry and signs of fraud.