NexusFi: Find Your Edge


Home Menu

 





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 2,316 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
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 200

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?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Quantum physics & Trading dynamics
The Elite Circle
About a successful futures trader who didnt know anythin …
Psychology and Money Management
MC PL editor upgrade
MultiCharts
Better Renko Gaps
The Elite Circle
 
  #3 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824



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
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 200

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
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 200

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
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 200

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
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


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
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
Posts: 235 since Mar 2012
Thanks Given: 113
Thanks Received: 200

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


© 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