How to Export DataSeries from NT to Excel?

March 13th, 2011, 03:34 AM

I was trying to save it to "My Documents" folder (picture 1) but I still get the same error message. Picture 2 is the output window. I tried both C:\Users\dyno\My Documents and C:\\Users\dyno\My Documents.
Thanks

March 13th, 2011, 04:17 AM

Stem1

I was trying to save it to "My Documents" folder (picture 1) but I still get the same error message. Picture 2 is the output window. I tried both C:\Users\dyno\My Documents and C:\\Users\dyno\My Documents.
Thanks

Most likely that path does not exist. Take out the word "My", is my guess, based on you using Windows 7.

Launch Windows Explorer (not Internet Explorer), and see if you can browse to the path. You need to use a valid path. This is just Windows stuff, nothing to do with this tool or NinjaTrader.

Mike

March 13th, 2011, 04:27 AM

Stem1 - Give me a second to change some code and I'll post it back here for you to test. Leading a Filename with a '$' is a no-no I believe, so I'll change that to a lower case 'c'. It currently does a similar thing for indexes where the default '^' is changed to an 'i' automatically.

EDIT: Added attachement.

March 13th, 2011, 07:18 AM

Found the problem- its "C:\Users\win7\Documents". I re-imported the original Export data strat and tested it, they both work. I have $AUDJPY_1_Minute and cAUDJPY_1_Minute in my Documents folder. Thanks guys.

March 27th, 2011, 04:13 AM

Minor bug fix and feature addition as follows:

Code

                            
// 13 March 2011 ver 3.36b Test if leading '$' in file name is a problem
// 14 March 2011 ver 3.37 Adds '$' to characters not used in Filenames and some code comments reflecting that
// 27 March 2011 ver 3.38 Adds FileInfo.Exists logic for a feature and a bug fix. OnStartUp() will now print
// if it is CREATING file at: <filename> or APPENDING file at: <filename>.
// It will also ONLY print FirstRowIsColumnNames if !FileInfo.Exists i.e. it won't print
// column names when appending an existing file.

Not significant enough to warrant an update in the Downloads section, but here you go in case you want to stay on the bleeding edge of my code development

.

April 10th, 2011, 03:45 AM

Code

                            
// 27 March 2011 ver 3.39 Minor refactor.
// 10 April 2010 ver 3.40 Add TimeAndSales output option, new examples in CustomCode1 and 2 for outputting both
// indicator values and trade state logic.

Minor update adding T&S export option, etc.

June 18th, 2011, 08:26 AM

I import your strategy, apply it to a chart (while confirming the correct dir), then see the strategy at the top of the chart BUT I can never find a file. I disable the strategy and then look for a file but NOTHING. What am I not doing correctly? I've spent hours on this.

June 18th, 2011, 08:16 PM

agostini

I import your strategy, apply it to a chart (while confirming the correct dir), then see the strategy at the top of the chart BUT I can never find a file. I disable the strategy and then look for a file but NOTHING. What am I not doing correctly? I've spent hours on this.

Did you open the source and look at the path of the file, and perhaps modify it accordingly for your file system?

Mike

June 19th, 2011, 11:55 AM

I opened an output window. I have a four day 1-minute chart of ES open. I apply the strategy. Nothing happens in the window. What are the steps you take to get a CSV file from a chart?

Thanks very much
Alan

July 24th, 2011, 11:17 AM

I second this request...can't seem to get it working, don't know why...

Thank you.

agostini

I opened an output window. I have a four day 1-minute chart of ES open. I apply the strategy. Nothing happens in the window. What are the steps you take to get a CSV file from a chart?

Thanks very much
Alan

How to Export DataSeries from NT to Excel?

Discussion in NinjaTrader

How to Export DataSeries from NT to Excel?