Import/Export

tom_c · (login for full post details)

Hi,

Not sure if this is the place to ask the following question or not but here it goes: I want to know if there is anyway of importing NT tick data into MS Excel or not?

Any help on this would be much appreciated.

Thanks

Eloy · (login for full post details)

For import historical ticks:
NT - Control Center - Tools - Historical Data - Export - result will be in txt format file wich you can open from Excel.

For import realtime ticks:
There is no standart functionality but maybe somebody can write an indicator or a strategy wich can export realtime tick value into an Excel application. Or you can write a macro in Excel to receive tick data throw NT COM API.

tom_c · (login for full post details)

Thanks for the reply and input. Yeah, I was in a trading room a while ago and remember someone mentioning that they were able to import real time tick data from ninja into excel. i think he wrote an api for it.

anyway, thanks for the feedback. i'm sure one of these days someone is going to be generous enough to share their code with the rest of the community

stay sharp

sam028 · (login for full post details)

I'm not sure it can help, but you can the code inside this indicator.

Eloy · (login for full post details)

This VBA code works! Open a code module in the workbook in which you want to use the function then go to Tools > References to open the References dialog where you will see a list of all the libraries and other objects to which you can set a reference. Select NinjaTrader Client and press the "OK" button.
Then inset a new module and copy a code below.

Code

                            
Public Function GetTick(instrument As String) As Double
    'Declare and instantiate object
    Dim myClient As NinjaTrader_Client.Client
    Dim result As Long
    Set myClient = New NinjaTrader_Client.Client 'GetObject("NinjaTrader_Client", "IClient")
    result = myClient.SubscribeMarketData(instrument)
    If result = 0 Then
        GetTick = myClient.MarketData(instrument, 0)
    End If
    result = myClient.UnsubscribeMarketData(instrument)
    Set myClient = Nothing
End Function

Using example: in formula field type: "=GetTick("ES 03-10")".

wh · (login for full post details)

Eloy

This VBA code works! Open a code module in the workbook in which you want to use the function then go to Tools > References to open the References dialog where you will see a list of all the libraries and other objects to which you can set a reference. Select NinjaTrader Client and press the "OK" button.
Then inset a new module and copy a code below.

Code

                            
Public Function GetTick(instrument As String) As Double
    'Declare and instantiate object
    Dim myClient As NinjaTrader_Client.Client
    Dim result As Long
    Set myClient = New NinjaTrader_Client.Client 'GetObject("NinjaTrader_Client", "IClient")
    result = myClient.SubscribeMarketData(instrument)
    If result = 0 Then
        GetTick = myClient.MarketData(instrument, 0)
    End If
    result = myClient.UnsubscribeMarketData(instrument)
    Set myClient = Nothing
End Function

Using example: in formula field type: "=GetTick("ES 03-10")".

please can you downgrate to 2003. i can not import and vba is long time ago.
thanx and best regards

Eloy · (login for full post details)

MS Excel 2003 format. It's just an example. I think one can write something more useful)

Eloy · (login for full post details)

Here is a new dynamic version. (Excel 2003 format)

Import/Export

Discussion in NinjaTrader

Import/Export

NinjaTrader Indicator Challenge!

Journal Challenge w/$1500 prizes from Topstep!

Battlestations! Show us your trading desk - $1,500 in prizes!

Call Option Buying: The New Pain Trade? w/Carley Garner