Export daily and weekly data to Excel

[U0000999]

Hello, I need to export daily and weekly candles to microsoft Excel, how to do this in Ninja?

Thanks

[NinjaTrader_Kate]

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:

• https://ninjatraderecosystem.com/use...wnload/excel8/

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:

1. Download the NinjaScripts to your desktop, keep them in the compressed .zip file.
2. From the Control Center window select the menu Tools > Import > NinjaScript Add-on...
3. Select the downloaded .zip file
4. 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.

[U0000999]

How it's called, I cannot find it and how to use it?

[U0000999]

I've added this add on, but I don't know how to use it

[NinjaTrader_Kate]

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.

[U0000999]

It opens xlsx file, but no values there, just empty xls sheet

[NinjaTrader_Kate]

Hello U0000999,

Thank you for your reply.

I've created a quick video showing how to properly set up and use the Excel8 indicator.

https://www.screencast.com/t/r0aUtuYYUYM

Please let us know if we may be of further assistance to you.

[U0000999]

Thanks. Kate)))

[kv712]

Hi Kate,
I added this indicator to a 60 min. ES chart as shown in your video but it is not calculating/exporting any data

[NinjaTrader_Kate]

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.

[kv712]

Hi Kate,

See attached errors I am getting as soon as I import the indicator. Let me know why I am seeing these errors.
TIA.

[kv712]

One possible reason I could think of is I don't have MS Office. I am using Libre office. Would this cause the error I am seeing ?

[NinjaTrader_Kate]

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.

[Monares]

is it possible to add the Delta data?

[NinjaTrader_Kate]

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.