Output Window Excel question - futures io
futures io futures trading



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 1,769 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 8 posts
    2. attach_file 0 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Output Window Excel question

(login for full post details)
  #1 (permalink)
NY, NY
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
 
patbateman's Avatar
 
Posts: 235 since Mar 2012
Thanks: 113 given, 199 received

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

Journal Challenge February 2021 results:
Competing for $1500 in prizes from Topstep
looks_oneSBtrader82 's Trading Journalby SBtrader82
(173 thanks from 31 posts)
looks_twoJust BEING a Trader: Letting Go!!by iqgod
(120 thanks from 33 posts)
looks_3Wisdom is Emptinessby Mtype
(68 thanks from 25 posts)
looks_4Deetee’s DAX Trading Journal (time based)by Deetee
(35 thanks from 17 posts)
looks_5Journal for peanuts1956by peanuts1956
(23 thanks from 13 posts)
 
 
(login for full post details)
  #3 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received



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
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #4 (permalink)
NY, NY
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
 
patbateman's Avatar
 
Posts: 235 since Mar 2012
Thanks: 113 given, 199 received

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
 
(login for full post details)
  #5 (permalink)
NY, NY
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
 
patbateman's Avatar
 
Posts: 235 since Mar 2012
Thanks: 113 given, 199 received

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
 
(login for full post details)
  #6 (permalink)
NY, NY
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
 
patbateman's Avatar
 
Posts: 235 since Mar 2012
Thanks: 113 given, 199 received

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
 
(login for full post details)
  #7 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


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
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #8 (permalink)
Israel
 
Experience: Intermediate
Platform: NinjaTrader
Broker: pfg
Trading: eminis
 
Posts: 323 since Jun 2009
Thanks: 6 given, 207 received

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

Reply With Quote
 
(login for full post details)
  #9 (permalink)
NY, NY
 
Experience: None
Platform: T4, NinjaTrader
Trading: All!
 
patbateman's Avatar
 
Posts: 235 since Mar 2012
Thanks: 113 given, 199 received

I got it to work.

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


futures io Trading Community Platforms and Indicators NinjaTrader > Output Window Excel question


Last Updated on April 23, 2013


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Journal Challenge w/$1500 prizes from Topstep!

February
 

Battlestations! Show us your trading desk - $1,500 in prizes!

March
 

Call Option Buying: The New Pain Trade? w/Carley Garner

Elite only
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts