Dionysus New Year Present – Ninja & Excel

[Espartano]

Hi, vlaladim.

perhaps I can help you. But, first of all, I’d to know which are are you looking for, and what kind of sw has you develop.
you can contact me in this email: [email protected]

Best Regards

[barcelinho]

Hey guys,
I'm a newbie to Ninja Trader and programming (basically I don't have any expierence in programming and I did not understand very much from all the posts before). Maybe you guys can help me with that and hopefully there is already an existing answer to that.

So here's what I'm looking for:
I need a solution to export these facts from a chart: Open, High, Low, Close, Date, Time, (Volume Data would be nice to have, but that's not a must). Therefore the BigMikeSolution looked great to me.

That's what I did:

1. So I downloaded the file here: https://ninjatraderecosystem.com/use...wnload/excel8/
2. Afterwards I went to the controlcenter and imported the script via tools-import-ninjascript...
3. Next step was, that I opened a new chart. I went to indicators on that chart and selected BigMikeExcel and applied it to the chart (see screenshot attached).
   

What do I need to do next? How do I get an Excel file with the data I'm looking for? Does anyone know what I'm missing and how I can get the data easily?

I hope someone can help me on this - I'd really appreciate it

Cheers!

[NinjaTrader_Kate]

Hello barcelinho,

Thank you for your post.

The tricky thing with that particular add-on is that it doesn't automatically create an Excel file for you. You have to have a blank workbook created somewhere on your PC, and the ExcelFile input needs to have the correct path to that file so it can open it and write to it before the indicator is applied to the chart.

By default it looks for a file called DTTest.xlsx in your C:\ drive:

C:\DTTest.xlsx

If there's not an Excel file there by that name, or you haven't created a file named something else and filled that field in the Indicator settings with its file path on your PC, it won't do anything.

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

[barcelinho]

Hey Kate
thank you so much for your fast reply. It worked perfectly after I created the file.

Just one more thing I want to add for anyone who will read this in the future. You also need to rename the ExcelSheetName to the one which is mentioned in the indicator settings - otherwise it wont work (thats probably only important if your selected language is not english ).

Cheers
Michael

[KingCAMBO]

I just imported this today. I am doing event-based backtesting in python and I need to export volume bars as opposed to time series bars. The addon works nicely but will only spit out 200 bars. I need LOTS of data. Is there a way to export a larger sample size? Thanks for any help with this.

[rene69851]

I am not a programmer but can someone add the , ask and bid volume on this excel program. It will help a lot.and from there I could do what I want for this program, right now those volume doesn't tell anything.

[larkmail]

Jessica,
I'm receiving the following error on NT startup after installing the attached files from post #128:

Unable to retrieve type info for 'NinjaTrader.NinjaScript.AddOnBase' from assembly 'Microsoft.Office.Interop.Excel': Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

I realize that this is out of the scope of support but just thought i's ask in the event that had an easy fix.

Thanks either way,

LM

[NinjaTrader_Kate]

Hello larkmail,

Thank you for your reply.

Jessica is no longer with NinjaTrader, unfortunately. That version of the script is several years old and may be out of date. I suggest trying this version from our publicly available User App Share - I have this installed and can confirm it should work for you.

https://ninjatraderecosystem.com/user-app-share-download/excel8/

Set up and usage can be a bit complicated, so here's a video showing how to use it:

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

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


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.

[noy_cabildo]

Is it possible this indicator can export into csv instead of an excel file ?
Please advise

Thanks

[NinjaTrader_BrandonH]

Hello noy_cabildo,

Thanks for your note.

This indicator would need to export values into an excel file (.xlsx) as seen in the script.

That said, this thread will be open for other community members to share their insights on how it might be possible to have the script export values into a .csv file.

Let me know if I may assist further.

[RAFAEL_ROLDAN]

Hi!

Thanks a lot you all for your efforts to improve BigMike
I would like to know how to get all data from any indicator (not only Open, High, Low, Close, Date, Time and Volume).

Best regards

[NinjaTrader_BrandonH]

Hello RAFAEL_ROLDAN,

Thanks for your notes.

You could get information from indicators by calling the indicator's method. For example, SMA() would be used to get information from the SMA indicator.

See this help guide documentation for more information about getting data from an indicator: https://ninjatrader.com/support/help...indicators.htm

[GeeWee]

Hello.

I'm having trouble setting this up. Here are the steps I've taken:

1. I've downloaded indicator from the ecosystem: https://ninjatraderecosystem.com/use...wnload/excel8/
2. I've imported the script.
3. I've created an excel file .xlsx
4. I've put the pathway to the excel in the indicator

According to the video Kate posted, now the excel file should be opened by the indicator ...but nothing happens.

Did I miss a step? Is there anything else I should have done? (apart from learning how to program)

Thanks

[NinjaTrader_BrandonH]

Hello GeeWee,

Thanks for your notes.

First, you would need to create an Excel file named something like ES.xlsx.

After creating the file, locate the Excel file in the Windows File Explorer window, right-click on the file, select Properties, highlight the Location of the file, right click on the highlighted location and select 'Copy'.

Then, make sure to close the Excel application.

Add the indicator to the chart window, paste the file location in the 'ExcelFile' property, add the name of the file to the end of the file path.

Click OK to add the indicator to the chart window. Allow the indicator to start calculating and you should see the Excel file open automatically.

Here is a demonstration video: https://brandonh-ninjatrader.tinytak...MF8yMjM5MzI2NA

[GeeWee]

Hi Brandon

thank you for your instructions.

However, the results are the same. For some reason, excel file isn't open automatically. Any ideas where I might be making a mistake?

Thanks