Toast's been holding out on us!

[Hotch]

Don't want to share with your old buddies on T2W?

Dionysus New Year Present – Ninja & Excel - NinjaTrader Support Forum

Good stuff.

 

[the hare]

already posted at the zoo

http://www.trade2win.com/boards/gen...78-dionysus-new-year-present-ninja-excel.html

 

[DionysusToast]

lol - had to give something back...

... although half the people that tried it couldn't get the DLL from Microsoft for some reason.

I keep meaning to fix that but I don't know why it works for some & not for others.

Is there a friendly C# head on here that could help clear that up?

It's this bit...

Microsoft Interop

This is a pre-requisite. It allows communications between Ninja & Excel. Microsoft has 2 versions:

Office 2003
Download details: Office 2003 Update: Redistributable Primary Interop Assemblies

Office 2007
Download details: 2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies

The particular dll we are interested from is: Interop.Microsoft.Office.Interop.Excel.dll
The target directory for this dll should be: <My Documents>\NinjaTrader 7\bin\Custom

You can either install the Interop Assemblies into this directory or just move the dll file there.

Referencing the DLL in Ninja

Next you need to create a reference to the Interop DLL in Ninja. To do this, you need to get to the references window which is available when editing an indicator. Just choose any indicator for this.

For some reason for many people they don't get the dll created from the interop install. I think it's going somewhere, just not where they expect it.

 

[wackypete2]

If you are using office 2003 & 2007 make sure you select "Complete Install" and NOT "Typical Install". This should solve the problem.

Peter

 

[DionysusToast]

actually Pete - it's a separate install:

Download: Office 2003 Update: Redistributable Primary Interop Assemblies - Microsoft Download Center - Download Details
Download: 2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies - Microsoft Download Center - Download Details

There's no options for complete or otherwise.

The DLL that gets created (if you are lucky) needs to be moved to one of the Ninja folders.

 

[Hotch]

already posted at the zoo

http://www.trade2win.com/boards/gen...78-dionysus-new-year-present-ninja-excel.html

I missed it, obviously didn't get the attention it deserved.

 

[wackypete2]

actually Pete - it's a separate install:

Download: Office 2003 Update: Redistributable Primary Interop Assemblies - Microsoft Download Center - Download Details
Download: 2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies - Microsoft Download Center - Download Details

There's no options for complete or otherwise.

The DLL that gets created (if you are lucky) needs to be moved to one of the Ninja folders.

I missed that it was a separate install but I still think it has to do with the original install of office 2003. My suggestion is to completely uninstall 2003, reinstall it using the Complete option, then following your instructions.

I could never understand why MS has to make things so difficult and their own support forums are very cryptic.

Peter

 

[wackypete2]

This may be some help: Installing and Using the Office 2003 Primary Interop Assemblies

To get the Office PIAs along with your installation of Microsoft Office 2003, you must first install Microsoft .NET Framework version 1.1. If you do not install .NET Framework 1.1 before you install Office 2003, the PIAs are not installed with your Office 2003 installation

If you install Microsoft .NET Framework version 1.1 after you install Microsoft Office 2003, to get the PIAs, you must modify your Office setup.

Most people who have installed 2003 long long ago will have done so before the .net framework installation, so the 2003 install must be modified or uninstall/reinstall BEFORE following your instructions.

See my comment above about Microsoft

Peter

 

[Liquid validity]

I'd go with what pete said, make sure excel is fully updated.
First though I would add instructions to fully update the OS and .net 3.5. V4 doesn't seem to like ninja...not the problem though, NT won't even start with V4 standalone, but corruption, or filesystem changes with V4 installed after 3.5 may result.

Maybe add links for the full .net versions instead of the painfully slow bootstrapper
After that, other things to try are:
control panel > add remove programs > find .NET framework 3.5 SP1 in list > click change / remove > select repair option.

Still no joy after that, uninstall NT .NET and excel.
Reinstall .NET NT and excel from scratch.
NT does store and reference files in the .NET architecture - so the above eliminates
any corruption from other programs that have modified .NET

Really a dedicated rig or at least a dual boot is best for any critical work to avoid this kind of crap in the first place

Full .NET link:
http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe