NexusFi: Find Your Edge


Home Menu

 





How to Export DataSeries from NT to Excel?


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one MXASJ with 13 posts (28 thanks)
    2. looks_two Fat Tails with 9 posts (6 thanks)
    3. looks_3 Big Mike with 5 posts (0 thanks)
    4. looks_4 Stem1 with 4 posts (0 thanks)
      Best Posters
    1. looks_one MXASJ with 2.2 thanks per post
    2. looks_two baruchs with 1 thanks per post
    3. looks_3 DaveTrading with 1 thanks per post
    4. looks_4 Fat Tails with 0.7 thanks per post
    1. trending_up 41,367 views
    2. thumb_up 43 thanks given
    3. group 27 followers
    1. forum 65 posts
    2. attach_file 20 attachments




 
Search this Thread

How to Export DataSeries from NT to Excel?

  #21 (permalink)
 gunsnmoney 
Santa Clara, CA
 
Experience: Intermediate
Platform: NT8,
Broker: Tradier, TastyTrade
Trading: ES, Fx
Posts: 19 since Jul 2010
Thanks Given: 13
Thanks Received: 18

I used this stategy (Export Data.zip) to export hour data from NT to a csv file and wanted to see how it would handle the transition from one contract to another for NQ (mergebackadjusted). I was looking to see if it really exported the data "back adjusted". But what I found I think may be a bug. There are 3 hours missing in the data at the end of the old contract (see attachment). From 0021 to 0100 the next day (first hour of rollover contract). Can someone explain this to me? I hope this is not what NT means by "merge back adjusted" - just lop off a few hours.

Attached Thumbnails
How to Export DataSeries from NT to Excel?-nq_12_09_nov09_60_minute.csv.pdf  
Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
ZombieSqueeze
Platforms and Indicators
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Deepmoney LLM
Elite Quantitative GenAI/LLM
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
60 thanks
Funded Trader platforms
43 thanks
NexusFi site changelog and issues/problem reporting
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #22 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541


gunsnmoney View Post
I used this stategy (Export Data.zip) to export hour data from NT to a csv file and wanted to see how it would handle the transition from one contract to another for NQ (mergebackadjusted). I was looking to see if it really exported the data "back adjusted". But what I found I think may be a bug. There are 3 hours missing in the data at the end of the old contract (see attachment). From 0021 to 0100 the next day (first hour of rollover contract). Can someone explain this to me? I hope this is not what NT means by "merge back adjusted" - just lop off a few hours.

@Fat Tails is a master at how NT handles back adjusted/rollover. So I've shouted at him to come take a look, he probably knows the answer and can help you.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #23 (permalink)
 
Jigsaw Trading's Avatar
 Jigsaw Trading  Jigsaw Trading is an official Site Sponsor
 
Posts: 2,988 since Nov 2010
Thanks Given: 831
Thanks Received: 10,393


You could join the elite section & then read up this thread on how to fully integrate Ninja & Excel using Microsoft Interop...



Visit my NexusFi Trade Journal Reply With Quote
  #24 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102


gunsnmoney View Post
I used this stategy (Export Data.zip) to export hour data from NT to a csv file and wanted to see how it would handle the transition from one contract to another for NQ (mergebackadjusted). I was looking to see if it really exported the data "back adjusted". But what I found I think may be a bug. There are 3 hours missing in the data at the end of the old contract (see attachment). From 0021 to 0100 the next day (first hour of rollover contract). Can someone explain this to me? I hope this is not what NT means by "merge back adjusted" - just lop off a few hours.


This is a difficult subject. I have exported my backadjusted data for NQ 03-11 from 01-01-2009 up to now. So here are the results.

First of all, the export strategy works well, you can easily export a text file and convert it to Excel. Thank you @MXASJ for this tool.

-> I have different values for Dec 10 2009 compared to those shown above. I do not have any value above 1,800. This points to different offsets or a different backadjustment method.

-> I use a session template, which is in line with market hours. My trading session starts at 3:30 PM CT (night session) and 8:30 AM CT (real trading hours). You obviously did not use a session template adapted to NQ, but something else.

If we really want to compare our results, we will first have to agree on identical market hours and offsets. I do not pretend that my data is clean, as I am not trading NQ. I simply exported what I had in my data base without checking any details.

Bugs

-> The data export only started on January 5, 2009. The data for January 2, 2009 and for part of January 5, 2009 is missing. In practice you would need to export the data starting somewhere from December 2008 and then delete the data for December manually.

-> The last candle of my database is missing, that is the closing candle of last Friday. I have seen things like this before with NinjaTrader. You need to add the last candle manually.


Rollover Dates

I have found that the exported data series correctly reflects the mergebackadjusted data in my data base.

I attach the exported data, so that you can compare the values.

Attached Thumbnails
How to Export DataSeries from NT to Excel?-nq_03_11_60_minute.pdf  
Started this thread Reply With Quote
Thanked by:
  #25 (permalink)
 MXASJ 
Asia
 
Experience: Beginner
Platform: NinjaTrader, TOS
Posts: 796 since Jun 2009
Thanks Given: 109
Thanks Received: 800


Fat Tails View Post
First of all, the export strategy works well, you can easily export a text file and convert it to Excel. Thank you @ MXASJ for this tool.

Thanks for the kind words. It has been through a major refactor and the latest version (3.35) was posted yesterday here:


Reply With Quote
Thanked by:
  #26 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102


MXASJ View Post
Thanks for the kind words. It has been through a major refactor and the latest version (3.35) was posted yesterday here:


Thanks a lot, I have made the test above with the new version, which I had downloaded today.

Started this thread Reply With Quote
  #27 (permalink)
 Stem1 
Cairns Australia
 
Experience: Beginner
Platform: MC,NT7
Broker: Dukascopy
Trading: FX
Posts: 51 since Dec 2009
Thanks Given: 96
Thanks Received: 9

Hi, I posted this problem in the "multicharts" thread but I've been searching for a solution and this thread seems to be the closest fit.
When using the Export data strategy I get the message "Invalid path. Please check your Path and Filename variables". I've tried changing the path to "C:\Documents" but that didn't help. I left eveything else as default.
Do I change session template to "forex"?
Thanks

Reply With Quote
  #28 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541


Stem1 View Post
Hi, I posted this problem in the "multicharts" thread but I've been searching for a solution and this thread seems to be the closest fit.
When using the Export data strategy I get the message "Invalid path. Please check your Path and Filename variables". I've tried changing the path to "C:\Documents" but that didn't help. I left eveything else as default.
Do I change session template to "forex"?
Thanks

Are you running Windows Vista or higher? Or XP?

Modify the cs file so the path is correct. It will be different depending on your username and operating system.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #29 (permalink)
 Stem1 
Cairns Australia
 
Experience: Beginner
Platform: MC,NT7
Broker: Dukascopy
Trading: FX
Posts: 51 since Dec 2009
Thanks Given: 96
Thanks Received: 9

I'm using W7.
I'm not sure how to modify it.
Thanks

Reply With Quote
  #30 (permalink)
 MXASJ 
Asia
 
Experience: Beginner
Platform: NinjaTrader, TOS
Posts: 796 since Jun 2009
Thanks Given: 109
Thanks Received: 800



Stem1 View Post
Hi, I posted this problem in the "multicharts" thread but I've been searching for a solution and this thread seems to be the closest fit.
When using the Export data strategy I get the message "Invalid path. Please check your Path and Filename variables". I've tried changing the path to "C:\Documents" but that didn't help. I left eveything else as default.
Do I change session template to "forex"?
Thanks

Do you have a folder named "Documents" at the root of your C drive? That error usually indicates the path or destination folder is not valid, and if you have an Output window open you should see the full error message.

If you were looking to save it to your "My Documents" folder, the path should be C:\Users\<user name>\My Documents or C:\\Users\<user name>\My Documents. Both will work.


Reply With Quote




Last Updated on April 28, 2014


© 2024 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 - Privacy Policy - Downloads - Top
no new posts