NexusFi: Find Your Edge


Home Menu

 


Quotes by TradingView
Go Back   >  Platforms and Indicators >  NinjaTrader  > 


⚡ FLASH SALE: Save $50 using coupon "UPGRADE" on Elite Lifetime Access $149 $99 - Expires in



Output Window Excel question


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one patbateman with 5 posts (0 thanks)
    2. looks_two vvhg with 2 posts (2 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 baruchs with 1 posts (0 thanks)
    1. trending_up 3,079 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 8 posts
    2. attach_file 0 attachments




 
Search this Thread

Output Window Excel question

  #1 (permalink)
 
patbateman's Avatar
 patbateman 
NY, NY
Elite Member
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 202

Is it possible to write a Ninjascript that lists all of the opening (8:30 central) prices of the ES, and then copy and paste the output window into excel?

"A Jedi's strength flows from the force."
-Yoda
Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Iran Lebanon Problem Kills Switzerland Talks, Brent at $ …
Prediction Markets & Event Contracts
Kalshi Sets $4.13B All-Time Weekly Record as Polymarket …
Prediction Markets & Event Contracts
El Clasico Draws $9.2M in Prediction Market Action -- Bi …
Prediction Markets & Event Contracts
Iran Peace Expired NO: Ceasefire on Life Support, OPEC a …
Prediction Markets & Event Contracts
April Jobs Beat Flips Fed Hike Odds Past 52% for First T …
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
13 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #3 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
Elite Member
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,580 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,826



patbateman View Post
Is it possible to write a Ninjascript that lists all of the opening (8:30 central) prices of the ES, and then copy and paste the output window into excel?

Yes, that's pretty easy, just do sth along the lines of if(FirstBarOfSession && FirstTickOfBar) Print ("Date ; "+this.Date+" ; Price ; "+ Close); just writing some pseudo code from the top of my head here, but it should be reasonably close to the real stuff...

Vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #4 (permalink)
 
patbateman's Avatar
 patbateman 
NY, NY
Elite Member
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 202

Ok-I'll put this in a strategy ninjascript, backtest the strategy, and it should run on the output window?

"A Jedi's strength flows from the force."
-Yoda
Started this thread Reply With Quote
  #5 (permalink)
 
patbateman's Avatar
 patbateman 
NY, NY
Elite Member
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 202

Ok I got it to work. Now, an excel question I have two "columns" in the output window - how do I paste them into two excel columns?

"A Jedi's strength flows from the force."
-Yoda
Started this thread Reply With Quote
  #6 (permalink)
 
patbateman's Avatar
 patbateman 
NY, NY
Elite Member
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 202

In other words I have the date and then the price printed on one line: 20121103 1428.25. Can I split this into two cells? Thanks.


"A Jedi's strength flows from the force."
-Yoda
Started this thread Reply With Quote
  #7 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
Elite Member
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,580 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,826


patbateman View Post
Ok-I'll put this in a strategy ninjascript, backtest the strategy, and it should run on the output window?


patbateman View Post
Ok I got it to work. Now, an excel question I have two "columns" in the output window - how do I paste them into two excel columns?

It should work as an indicator too, to get it into excel import it as csv, it has got options where to split the lines.

Vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #8 (permalink)
 baruchs 
Israel
 
Experience: Intermediate
Platform: NinjaTrader
Broker: pfg
Trading: eminis
Posts: 323 since Jun 2009

Why do you need to invent a wheel?
There are many exporters in download.

Reply With Quote
  #9 (permalink)
 
patbateman's Avatar
 patbateman 
NY, NY
Elite Member
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 202

I got it to work.

"A Jedi's strength flows from the force."
-Yoda
Started this thread Reply With Quote




Last Updated on April 23, 2013


© 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