Import/Export - NinjaTrader | futures io social day trading
futures io futures trading


Import/Export
Updated: Views / Replies:2,541 / 7
Created: by tom_c Attachments:3

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 
Thread Tools Search this Thread
 

Import/Export

  #1 (permalink)
Trading Apprentice
Los Angeles
 
Futures Experience: Intermediate
Platform: NinjaTrader
Broker/Data: Zen Fire
Favorite Futures: futures
 
Posts: 22 since Dec 2009
Thanks: 0 given, 12 received

Import/Export

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

Reply With Quote
 
  #2 (permalink)
Just starting out...
Moscow
 
Futures Experience: Beginner
Platform: NinjaTrader
Broker/Data: Mirus Futures/Zen-Fire
Favorite Futures: ES
 
Posts: 12 since Jan 2010
Thanks: 1 given, 6 received

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.

Reply With Quote
 
  #3 (permalink)
Trading Apprentice
Los Angeles
 
Futures Experience: Intermediate
Platform: NinjaTrader
Broker/Data: Zen Fire
Favorite Futures: futures
 
Posts: 22 since Dec 2009
Thanks: 0 given, 12 received


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

Reply With Quote
 
  #4 (permalink)
Administrator: Retired Backtester
 Vendor: speedytradingservers.com 
Rennes France
 
Futures Experience: Advanced
Platform: NinjaTrader
Broker/Data: IB/Kinetick
Favorite Futures: Futures
 
sam028's Avatar
 
Posts: 3,366 since Jun 2009
Thanks: 3,572 given, 3,982 received

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

Success requires no deodorant! (Sun Tzu)
Reply With Quote
 
  #5 (permalink)
Just starting out...
Moscow
 
Futures Experience: Beginner
Platform: NinjaTrader
Broker/Data: Mirus Futures/Zen-Fire
Favorite Futures: ES
 
Posts: 12 since Jan 2010
Thanks: 1 given, 6 received

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(instrument0)
    
End If
    
result myClient.UnsubscribeMarketData(instrument)
    
Set myClient Nothing
End 
Function 
Using example: in formula field type: "=GetTick("ES 03-10")".

Attached Files
Register to download File Type: zip NTTick.zip (12.5 KB, 22 views)
Reply With Quote
The following user says Thank You to Eloy for this post:
 
  #6 (permalink)
Elite Member
Neubrandenburg, Germany
 
Futures Experience: Advanced
Platform: R
Favorite Futures: Stocks
 
wh's Avatar
 
Posts: 538 since Jun 2009
Thanks: 297 given, 480 received


Eloy View Post
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(instrument0)
    
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

Causality is the relationship between an event (the cause) and a second event (the effect), where the second event is a consequence of the first.
Reply With Quote
 
  #7 (permalink)
Just starting out...
Moscow
 
Futures Experience: Beginner
Platform: NinjaTrader
Broker/Data: Mirus Futures/Zen-Fire
Favorite Futures: ES
 
Posts: 12 since Jan 2010
Thanks: 1 given, 6 received

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

Attached Files
Register to download File Type: zip NTTick2003.zip (9.5 KB, 21 views)
Reply With Quote
The following user says Thank You to Eloy for this post:
 
  #8 (permalink)
Just starting out...
Moscow
 
Futures Experience: Beginner
Platform: NinjaTrader
Broker/Data: Mirus Futures/Zen-Fire
Favorite Futures: ES
 
Posts: 12 since Jan 2010
Thanks: 1 given, 6 received

Here is a new dynamic version. (Excel 2003 format)
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Attached Files
Register to download File Type: zip NTTick.zip (20.2 KB, 36 views)
Reply With Quote
The following 2 users say Thank You to Eloy for this post:

Reply



futures io > > > > Import/Export

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Linda Bradford Raschke: Reading The Tape

Elite only

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

January

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
data export Mondrakete EasyLanguage Programming 7 April 7th, 2011 09:51 PM
NT7 Auto-Export icehac NinjaTrader 4 November 11th, 2010 12:10 AM
d9ParticleOscillatorWVertLineR export problem foodchain NinjaTrader Programming 3 August 24th, 2010 04:27 PM
How to export a non-indicator from NT aslan Help, Tutorials, and How-Tos 0 July 9th, 2010 11:44 PM
Export Threads to PDF eone Tech Support 4 January 14th, 2010 10:42 PM


All times are GMT -4. The time now is 08:43 AM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts
Page generated 2017-12-12 in 0.14 seconds with 20 queries on phoenix via your IP 54.90.207.75