NexusFi: Find Your Edge


Home Menu

 





Exporting from NT7 to Excel : Examples


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one sam028 with 3 posts (0 thanks)
    2. looks_two Fat Tails with 3 posts (0 thanks)
    3. looks_3 sudhiravi with 2 posts (0 thanks)
    4. looks_4 ctaggart878 with 2 posts (0 thanks)
    1. trending_up 12,170 views
    2. thumb_up 0 thanks given
    3. group 9 followers
    1. forum 14 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Legendary Market Wizard
 
Experience: Advanced
Platform: NinjaTrader
Broker: Interactive Brokers
Trading: Futures & Stocks
Posts: 9,887 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,117

I am looking to export data from NinjaTrader 7 to Excel. I do not intend to do this online, but I want to run indicators or strategies on NinjaTrader and then export the results.

I must admit that I am not a programmer and do not fully understand yet, how to use Microsoft.Office.Interop.Excel or the NinjaDDE utility.

Does anybody have a coded example, how to transfer data from NinjaTrader to Excel, so that I can copy parts of it to speed up the learning process?


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Hormuz Normalization Collapses to 19.5% -- Iran Regime F …
Prediction Markets & Event Contracts
CME Launches Bitcoin Volatility Futures June 1 -- First …
Cryptocurrency
Roland Garros Final Day: $3M on Zverev at 80.5% -- Leban …
Prediction Markets & Event Contracts
Irans Answer Due Today: Peace Surges to 33.5%, Invasion …
Prediction Markets & Event Contracts
CME Expands 24/7 Trading to WTI Crude Oil and Gold -- We …
Commodities
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
10 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #3 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,759 since Jun 2009
Thanks Given: 3,828
Thanks Received: 4,645


Do you mean a "live" export, or a static one, using a formatted .csv/.txt ?


Success requires no deodorant! (Sun Tzu)
Reply With Quote
  #4 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Legendary Market Wizard
 
Experience: Advanced
Platform: NinjaTrader
Broker: Interactive Brokers
Trading: Futures & Stocks
Posts: 9,887 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,117

Not sure whether I understand this question.

I do not want to export the OHLC of my data base, but some results, and the indicator or strategy would be required to write those directly to an Excel sheet. I do not need to access that Excel sheet in real-time.


sam028 View Post
Do you mean a "live" export, or a static one, using a formatted .csv/.txt ?


Started this thread Reply With Quote
  #5 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,759 since Jun 2009
Thanks Given: 3,828
Thanks Received: 4,645


Fat Tails View Post
Not sure whether I understand this question.

I do not want to export the OHLC of my data base, but some results, and the indicator or strategy would be required to write those directly to an Excel sheet.

I'm not sure whether I understand your first question or not .
What I've done before is indicators which were computing things, and were writing (or not) some of these results in a .csv file. I think I have an example here on NexusFi (formerly BMT), a ZigZag indicator which was writing the date, the lo/hi of the wave, and the length of the swing in the appropriate column.
But this is just writing in a file, with the appropriate format, I don't think it's what you're looking for, too simple.


Success requires no deodorant! (Sun Tzu)
Reply With Quote
  #6 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Legendary Market Wizard
 
Experience: Advanced
Platform: NinjaTrader
Broker: Interactive Brokers
Trading: Futures & Stocks
Posts: 9,887 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,117

If you show me the example, I can check, whether it does, what I am looking for.


sam028 View Post
I'm not sure whether I understand your first question or not .
What I've done before is indicators which were computing things, and were writing (or not) some of these results in a .csv file. I think I have an example here on NexusFi (formerly BMT), a ZigZag indicator which was writing the date, the lo/hi of the wave, and the length of the swing in the appropriate column.
But this is just writing in a file, with the appropriate format, I don't think it's what you're looking for, too simple.


Started this thread Reply With Quote
  #7 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,759 since Jun 2009
Thanks Given: 3,828
Thanks Received: 4,645


Fat Tails View Post
If you show me the example, I can check, whether it does, what I am looking for.

That was something posted in the Elite forum, so file sent using PM.


Success requires no deodorant! (Sun Tzu)
Reply With Quote
  #8 (permalink)
sudhiravi
Herndon, va, usa
 
Posts: 5 since Aug 2011
Thanks Given: 0
Thanks Received: 0

Hi,

Can you pls reply if you have done this or still looking for?

Ravi


Reply With Quote
  #9 (permalink)
 
martin19's Avatar
 martin19 
prague
 
Experience: Intermediate
Platform: ninja,multicharts
Trading: eu,e mini
Posts: 8 since Jan 2011
Thanks Given: 0
Thanks Received: 0


Fat Tails View Post
I am looking to export data from NinjaTrader 7 to Excel. I do not intend to do this online, but I want to run indicators or strategies on NinjaTrader and then export the results.

I must admit that I am not a programmer and do not fully understand yet, how to use Microsoft.Office.Interop.Excel or the NinjaDDE utility.

Does anybody have a coded example, how to transfer data from NinjaTrader to Excel, so that I can copy parts of it to speed up the learning process?


i use this NinjaTrader DDE Connection


Reply With Quote
  #10 (permalink)
sudhiravi
Herndon, va, usa
 
Posts: 5 since Aug 2011
Thanks Given: 0
Thanks Received: 0


If you need any customized automated export from Ninjatrader to Excel , pls let me know, I can do it for you

regards
Ravi


Reply With Quote




Last Updated on March 10, 2012


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts