Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
My goal is to export entire DataSeries from NinjaTrader to Excel, because I want to do further analysis, basically correlation and distribution analysis.
Searching this and the NinjaTrader forum, I found two potential solutions. I would like to know, whether anybody a bit more advanced in coding than myself has tested this and found it useful. Also I am a bit reluctant to install any unknown DLL's, so would like to hear your comments.
NinjaTrader DDE
(1) There is a NinjaTrader DDE in the download section from bukkan. Has anybody tested this? How do I install it and how can I use it to export DataSeries?
The library can be addressed by a simple NinjaTrader indicator. This was tested by Roonius in 2009, and it seems to work, although there may be issues with memory leakage and country settings. Files attached below.
Other solutions
I have come across code snippets that either use XML or OLEDB. I s there anybody out there who could give me some detailed hints to follow. I am not an expert, just trying to retrieve the data I need.
Try this. More importantly, help make it better! I use it with R but as it does OHLC CSVs its easy to import into Excel, and as it is a Stratgey you can use it on a basket of instruments.
I think it is in non-Elite NT7 downloads on this site.
If it is not for live data than a CSV file is a CSV file. I use it for Excel as well. If you need live data then one thing to keep in mind is that DDE has been deprecated.
No, I do not need it for live data. Basically, I want to run an indicator on a chart during the week-end, and export the results to an excel file, so I can further use the results for analysis.
If you use it for Excel as well, how is this done?
Here is DBA Daily. Not that exciting as-is but when you think it is a part of Ninja Instrument List I apply the Strategy to... one can get creative. Any Instrument List you can create in Ninja, any time frame (down to the tick if you are paying for that data)>Stratgey Enable/Disable and you have a CSV file (if you chose @"," as a seperator) that you can open in Excel, R, Matlab, or whatever and play with.
The programming isn't brilliant (I wrote it six months ago ) and there is room to make it better, but it does what it does well.
If you have a particular Instrument/Timeframe you want Excel OHLC data for let me know (I'm on IQFeed). Its only a few mouse clicks away.
Excel can open .csv files directly. Since the solution creates .csv files, you simply open these files with excel. Then you can save them in native .xls format.
currently the ninjascript make a dde connection and is designed to pass double value to the client application (like excel). for example Close[0] or SMA(14)[0] etc.
but i suppose theoretically the entire data series (i.e. Close or SMA(14) etc) too can be exported but for that one has to edit the dll. though i have not done that so cant say for sure.
I have imported the indicator ExportChartData, replaced the path with my folder own documents, and these are the error messages, which I get when running the indicator on a 15 min ES chart: