Thanks
Announcement
Collapse
No announcement yet.
Partner 728x90
Collapse
NinjaTrader
Export daily and weekly data to Excel
Collapse
X
-
Hello U0000999,
Thank you for your note.
While it wouldn't technically be supported, there's an indicator on the User App Share that can accomplish this for you. This indicator is publicly available on our NinjaTrader Ecosystem website:A note with this one that you do need to physically create the excel file for the indicator to write to prior to running the indicator.
Here is a basic guideline of how to import NinjaScript add-ons in NinjaTrader 8:
Note — To import NinjaScripts you will need the original .zip file.
To Import:- Download the NinjaScripts to your desktop, keep them in the compressed .zip file.
- From the Control Center window select the menu Tools > Import > NinjaScript Add-on...
- Select the downloaded .zip file
- NinjaTrader will then confirm if the import has been successful.
Critical - Specifically for some NinjaScripts, it will prompt that you are running newer versions of @SMA, @EMA, etc. and ask if you want to replace, press 'No'
Once installed, you may add the indicator to a chart by:- Right click your chart > Indicators... > Select the Indicator from the 'Available' list on the left > Add > OK
Please let me know if I can be of further assistance.
The NinjaTrader Ecosystem website is for educational and informational purposes only and should not be considered a solicitation to buy or sell a futures contract or make any other type of investment decision. The add-ons listed on this website are not to be considered a recommendation and it is the reader's responsibility to evaluate any product, service, or company. NinjaTrader Ecosystem LLC is not responsible for the accuracy or content of any product, service or company linked to on this website.
Kate W.NinjaTrader Customer Service
-
Hello U0000999,
Thank you for your reply.
With that indicator, you need to create an Excel file for the indicator to write to. By default, it looks for an excel file called DTTest.xlsx in the root of your C:\ drive. You can name the Excel file and place it whereever you like on your PC, but you'll need to fill the entire path to the file in the ExcelFile field in the indicator Parameters. Once you've created that file, apply the indicator to the chart, fill in the path to the file in the indicator properties, and it should automatically write to that file.
Please let us know if we may be of further assistance to you.Kate W.NinjaTrader Customer Service
Comment
-
Hello kv712,
Thank you for your reply.
I understand you may have been working with my colleague Spencer earlier today on something related to the Excel8 indicator. Our support for this indicator is very limited as it uses unsupported code. When you attempt to use the indicator, do any error messages appear in the log? Are you closing the Excel file you created to hold the data before running the indicator? Have you double checked that the path to the Excel file is correct and the Sheet Name matches the name of the first sheet in the workbook?
I've just tested and I was able to install a fresh copy of Excel8, create an Excel file and export data from an ES 12-21 chart, so it wouldn't be the indicator itself, most likely.
Thanks in advance; I look forward to assisting you further.Kate W.NinjaTrader Customer Service
Comment
-
Hello kv712,
Thank you for your reply.
As far as I am aware this indicator is only compatible with Microsoft Excel and this would have to be installed on your system in order to use this particular indicator. As this contains unsupported code we would not be able to troubleshoot issues with it when trying to use other spreadsheet software with it.
Please let us know if we may be of further assistance to you.Kate W.NinjaTrader Customer Service
Comment
-
Hello Monares,
Thank you for your reply.
You could modify the exported data to contain indicator data, yes. For example, if we take a look at where the data gets assigned:
excelSheet.Cells[rowCount,1] = ToDay(Time[0]);
excelSheet.Cells[rowCount,2] = ToTime(Time[0]);
excelSheet.Cells[rowCount,3] = Open[0];
excelSheet.Cells[rowCount,4] = High[0];
excelSheet.Cells[rowCount,5] = Low[0];
excelSheet.Cells[rowCount,6] = Close[0];
excelSheet.Cells[rowCount,7] = Volume[0];
If we wanted to add a new cell for CumulativeDelta's DeltaClose value, for example, we could add a new line:
excelSheet.Cells[rowCount,8] = OrderFlowCumulativeDelta(BarsArray[0], CumulativeDeltaType.BidAsk, CumulativeDeltaPeriod.Session, 0).DeltaClose[0];
Please let us know if we may be of further assistance to you.Kate W.NinjaTrader Customer Service
Comment
Latest Posts
Collapse
Topics | Statistics | Last Post | ||
---|---|---|---|---|
Started by GussJ, 03-04-2020, 03:11 PM
|
16 responses
3,280 views
0 likes
|
Last Post
by Leafcutter
Today, 04:14 PM
|
||
Started by WHICKED, Today, 12:45 PM
|
2 responses
19 views
0 likes
|
Last Post
by WHICKED
Today, 03:36 PM
|
||
Started by Tim-c, Today, 02:10 PM
|
1 response
9 views
0 likes
|
Last Post Today, 02:52 PM | ||
Started by Taddypole, Today, 02:47 PM
|
0 responses
5 views
0 likes
|
Last Post
by Taddypole
Today, 02:47 PM
|
||
Started by chbruno, 04-24-2024, 04:10 PM
|
4 responses
52 views
0 likes
|
Last Post
by chbruno
Today, 02:38 PM
|
Comment