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,858 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?

  #61 (permalink)
 
YertleTurtle's Avatar
 YertleTurtle 
Portland, USA
 
Experience: Intermediate
Platform: Ninjatrader
Trading: ZS
Posts: 215 since May 2011
Thanks Given: 42
Thanks Received: 362

Baruchs - I used your strategy and it works great. Do you think you can post a version that doesn't output two indicators. I know this is the power of this method but I just need OHLC data and I imagine all of the MACD and EMA stuff is slowing it down.

Not a big deal either way as I can always delete the additional columns. I wish I had a better understanding of programming so I could make simple changes myself.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trade idea based off three indicators.
Traders Hideout
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
How to apply profiles
Traders Hideout
MC PL editor upgrade
MultiCharts
Better Renko Gaps
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
29 thanks
Just another trading journal: PA, Wyckoff & Trends
25 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
22 thanks
GFIs1 1 DAX trade per day journal
17 thanks
  #62 (permalink)
 
edassery's Avatar
 edassery 
chicago. IL , USA
 
Experience: Intermediate
Platform: IB
Trading: oil
Posts: 31 since Dec 2012
Thanks Given: 64
Thanks Received: 41

Hi

Can any one tell me how can I export values from each bar , OHLC with exact time for, opening, high,low and close of every bar ..is it possible ? for example if i load a daily chart It should export 8 values , Opening value, time of opening, high of the day , time when it happens , low of the day , time when it happens, close of the day and time it happens..
Can any one help me on this
Thanks for your help
Edassery

Reply With Quote
  #63 (permalink)
 baruchs 
Israel
 
Experience: Intermediate
Platform: NinjaTrader
Broker: pfg
Trading: eminis
Posts: 323 since Jun 2009


I can help you with two out of 4. The opening and closing times.

Reply With Quote
  #64 (permalink)
 
edassery's Avatar
 edassery 
chicago. IL , USA
 
Experience: Intermediate
Platform: IB
Trading: oil
Posts: 31 since Dec 2012
Thanks Given: 64
Thanks Received: 41

Thanks for that,,its easy to get opening price, closing price and of course the times for that ..but can any one help me on the other half of the problem..
Thanks

Reply With Quote
  #65 (permalink)
 
Zondor's Avatar
 Zondor 
Portland Oregon, United States
 
Experience: Beginner
Platform: Ninjatrader®
Broker: CQG, Kinetick
Trading: Gameplay Klownbine® Trading of Globex
Posts: 1,333 since Jul 2009
Thanks Given: 1,246
Thanks Received: 2,731

There is only one BarUpdate event for each historical bar. So there is only one time value, which is the time that bar CLOSED, ie LAST TICK OF BAR.

To get the times of occurrence of the high and low for historical bars you need to check every price level in an added one tick dataseries, using Math.Min and Math.Max to see if the previous intrabar highs and lows are being exceeded.

Then when a new intrabar high or low happens, you save the time value in a dataseries.

"If we don't loosen up some money, this sucker is going down." -GW Bush, 2008
“Lack of proof that something is true does not prove that it is not true - when you want to believe.” -Humpty Dumpty, 2014
“The greatest shortcoming of the human race is our inability to understand the exponential function.”
Prof. Albert Bartlett
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #66 (permalink)
 
YertleTurtle's Avatar
 YertleTurtle 
Portland, USA
 
Experience: Intermediate
Platform: Ninjatrader
Trading: ZS
Posts: 215 since May 2011
Thanks Given: 42
Thanks Received: 362


baruchs View Post
or you can use thus

I've been trying to use this to export the VPOC of overnight sessions plus OHLC. I'm only getting OHLC - anyone know how to use this properly?

Thanks,

YT

Attached Thumbnails
Click image for larger version

Name:	export.png
Views:	269
Size:	46.2 KB
ID:	145078  
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