Excel to NT8 interface possibilities

[MBScalper]

Welcome to the forums!

I use and highly recommend EPPlus.

The last free version 4.5.3.3 should work fine for your needs.

bltdavid,

Have you managed to link NinjaTrader 8 to EPPlus 7?

Ninja produces an error when loading if I dump the EPPlus 7 dll in the bin\custom directory.
I understand that I should be able to specify a non-commercial licence somewhere but I have no idea where or if this will remove the error I am getting.

Regards,

[bltdavid]

Have you managed to link NinjaTrader 8 to EPPlus 7?

No, I have not, but I've never tried.

Ninja produces an error when loading if I dump the EPPlus 7 dll in the bin\custom directory.

Have you added the DLL as a reference using the NinjaScript Editor?

If not, try this Google search.

Make sure the DLL you downloaded is targeted for .NET Framework 4.8,
and not NetStandard, NetCore, etc.

I understand that I should be able to specify a non-commercial licence somewhere but I have no idea where or if this will remove the error I am getting.

I'm still using the last free version, which is 4.5.3.3.

I thought everything after this version required you
to actually purchase it -- whether or not they also
offer a non-commercial license I have no idea.

The free version works great to create a basic
spreadsheet, which is all I ever needed, so I
never bothered to upgrade.

[MBScalper]

Thanks bltdavid,

I did start to sign up for the latest version on the EPPlus site but it looked solely for the purpose of buying a commercial licence so I abandoned that process.

I was able to download the correct 4.5.3.3 DLL, copy it to the correct bin\custom folder and add a reference from the editor.
That produced no error when NT is loading so I think EPPlus is now installed correctly.

The question I have is whether there is any sample code or reference manual out there for this version.
Version 7 is nicely documented online of course but this I am sure is different than the one I have installed.

I basically want to write a load of data to excel as my indicator runs as I don't want to keep any of this in memory as far as NT is concerned.
I ideally want to be able to read some of this historical data from excel when scrolling back in the chart and will display some of it on screen using OnRender.

So in essence, I want to
- write some values to Excel on close of each bar
- read these values when scrolling back in the chart.

I can handle the chart navigation stuff, it is just the excel stuff that I am currently blind to.

I just don't know where to find the syntax for doing what should be quite a simple task.

Are you able to point me at a syntax reference or should I get Visual studio and interrogate the DLL code?

Thanks for commenting earlier, I am one step further on

___

note: This was the previous error when placing the EPPlus version 7 DLL in the bin\custom folder. This went away when I used the version 4.5.3.3

[Askinator]

While there isn’t a straightforward Excel library for NT8, you might want to look into using the System.IO library in C# or the NinjaTrader API to interact with Excel. I’ve worked on a similar project where I needed to integrate Excel with another platform, and I found using Excel.Application in C# worked well for reading and writing data. It’s not too complicated, but you’ll need to deal with a bit of setup for smooth integration.By the way, if you're into understanding Excel formulas better, I recently found a guide on Turbo Trace https://sheetcast.com/turbotools/tur...mulas-in-excel that helped me with formula auditing in Excel, which might also help you when dealing with Excel data manipulation.