Dionysus New Year Present – Ninja & Excel

[NinjaTrader_Matthew]

The following link will demonstrate "How to add a reference"

http://www.ninjatrader.com/support/helpGuides/nt7/using_3rd_party_indicators.htm

[efeuvejota01]

Bertrand:
I am almost at the end of the process... but i have "Error on calling 'OnBarUpdate' method for indicator 'BigMikeExcel' on bar 0: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"

Do you have any idea how to solve it??
Thank you very much!!
FVJ

[Baruch]

What exactly are you trying to export?
I wrote an export strategy (its on BMT), maybe its good enoth for you.

[efeuvejota01]

Thank you let me look for it at BTM...

[efeuvejota01]

Did you find the way to insert rows in the excel sheet? I want also the latest data at the top of the sheet...

[nTupLe]

Nest2nt7

hi

is there any possibilities form NEST to NT7 using RTD ??

can any one share the setup procedure ?

[mmilan]

Import data from Excel

First of all, a big thank you to BigMike, the original poster of the scripts back in 2009 that allows NT to export data to Excel. Once you find the elusive Microsoft.Office.Iteropt.Exel.dll file it all works fine. By the way, probably everybody knows by now, but the easiest way to find this file is to use command line or 'cmd', no hidden files there.

My question now is how to do the reverse, import similar data from Excel to NT. Has anyone done this before with Excel? I know you can do this with .txt file, but it is an extra step to convert from Excel to .txt and add the semicolon in each field, especially when all I want to import is already in Excel.

Mmilan

[sledge]

My question now is how to do the reverse, import similar data from Excel to NT. Has anyone done this before with Excel? I know you can do this with .txt file, but it is an extra step to convert from Excel to .txt and add the semicolon in each field, especially when all I want to import is already in Excel.

Mmilan

Find the file import specs in the NT help.
Move the columns around.
I'm not sure which version of Excel you have. . But you can change the delimiter. You'll have to Google that. It's more complicated in the recent versions.

You could always convert coma delimited in note pad afterwards.

[mmilan]

Thanks for your response sledge. My Excel version is 2007. Looking at NT help for importing specs I only find how to import historical data from .txt and from TradeStation, nothing related to .xls, that's why I started looking into the BigMike's exporting script to see if I can use Excel workbook to import data into NT.

Mmilan

[sledge]

Thanks for your response sledge. My Excel version is 2007. Looking at NT help for importing specs I only find how to import historical data from .txt and from TradeStation, nothing related to .xls, that's why I started looking into the BigMike's exporting script to see if I can use Excel workbook to import data into NT.

Mmilan

Export from excel as a .CSV (comma separated file)

it'll make everything in a .csv

column1,column2,column3
column1,column2,column3
column1,column2,column3
column1,column2,column3

just rename it to .txt

[mmilan]

sledge,
That worked. Requires a few extra steps than a load directly from Excel but it works. Thank you for your help.

Mmilan.

[efeuvejota01]

Did you get your answer? I am in the same step...
If so... please share...
Best regards

[thomaskrawczyk]

Indicator not showing in "indicator box" but the script is there...

The script is in the custom indicators folder and the file was copied and pasted in .cs format (BigMike.cs) - However, the custom indicator does not load as an option in the selection box (all the preloaded indicators are there) . Any help would be greatly appreciated, (cheers to an easy fix). Thanks in advance...

[thomaskrawczyk]

I will reply to my own post, as I have figured out the problem.. Turns out if any indicators in the custom folder have complile errors none of the indicators will be able to open. I deleted the files that contained the errors. The file BigMike.cs was then in the indicator box AND worked perfectly as it updated Excel with live quotes. Over and out...

[Tdschulz]

Read from Excel

I have the data streaming to excel via "BigMikeExcel" indicator posted in this thread but I can't figure out how to simply read a cell from excel into a strategy. I couldn't find an example anywhere so please let me know if anyone has changed the code from writing to reading.