Working on cool project - NinjaTrader Programming | futures io social day trading
futures io futures trading


Working on cool project
Updated: Views / Replies:463 / 7
Created: by davethetrade Attachments:1

Welcome to futures io.

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

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you dont need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

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

Reply
 
Thread Tools Search this Thread
 

Working on cool project

  #1 (permalink)
Elite Member
Gothenburg
 
Futures Experience: Advanced
Platform: ninjatrader
Favorite Futures: 6E, 6B, 6C, 6A, 6S, 6J
 
Posts: 27 since Mar 2016
Thanks: 13 given, 8 received

Working on cool project

Hey traders,

Im trying to make a spreadsheet in excel for Ninjatrader and i would be beyond happy if someone
could help me with a small problem ive got that is taking over my life.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


When it turns midnight i want the date to jump forward with one day so we get 4/19/2017 for this example

and when it does i want the open and close to change aswell to show open and close for 11:34PM 4/19/2017

How can i do this, it must be possible somehow.

Thanks in advance, i hope someone can put me in the right direction
Dave.

Reply With Quote
 
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

 
  #3 (permalink)
Elite Member
Omer עומר / Israel י
 
Futures Experience: Master
Platform: NinjaTrader, Proprietary,
Broker/Data: Ninjabrokerage/IQfeed + Synthetic datafeed
Favorite Futures: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 2,376 since Sep 2013
Thanks: 1,649 given, 3,520 received
Forum Reputation: Legendary


Can you explain your problem in other words ?

I don't understand what you are trying to do, but i know how to update an excel sheet from a c# program
you can use a free library called EPPlus.

 
Code
FileInfo existingFile = new FileInfo("myexcel-file.xlsx");
using (ExcelPackage package = new ExcelPackage(existingFile))
     {
      ExcelWorksheet worksheet1 = package.Workbook.Worksheets[1];
      worksheet1.Cells[8, 3].Value = "example";

      package.Save();
}

Reply With Quote
The following user says Thank You to rleplae for this post:
 
  #4 (permalink)
Elite Member
Gothenburg
 
Futures Experience: Advanced
Platform: ninjatrader
Favorite Futures: 6E, 6B, 6C, 6A, 6S, 6J
 
Posts: 27 since Mar 2016
Thanks: 13 given, 8 received

Hey i just sent you a pm about another thing, so embarrassing im sorry

So basicly what im trying to do is to make a time spreadsheet. Time is very important in trading i believe and
i think i have an ida that can show us already before the day starts what times in the day market is most likely
to trend and in what direction and when the market is most likely to go sideways.

So when trading session starts we can already see that it is most likely going to start sideways and then start an uptrend
at 11:23 then we just wait until 11:23 and buys at that time if our other setup also agree on that.

Im not an elite member so i can only send one pm per hour and i just wasted it but if you send me your email i will gladly tell you more about this interesting ida which i know how to make but need help.

Happy trading!!
David.

Reply With Quote
 
  #5 (permalink)
Elite Member
Omer עומר / Israel י
 
Futures Experience: Master
Platform: NinjaTrader, Proprietary,
Broker/Data: Ninjabrokerage/IQfeed + Synthetic datafeed
Favorite Futures: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 2,376 since Sep 2013
Thanks: 1,649 given, 3,520 received
Forum Reputation: Legendary


davethetrade View Post
Hey i just sent you a pm about another thing, so embarrassing im sorry

So basicly what im trying to do is to make a time spreadsheet. Time is very important in trading i believe and
i think i have an ida that can show us already before the day starts what times in the day market is most likely
to trend and in what direction and when the market is most likely to go sideways.

So when trading session starts we can already see that it is most likely going to start sideways and then start an uptrend
at 11:23 then we just wait until 11:23 and buys at that time if our other setup also agree on that.

Im not an elite member so i can only send one pm per hour and i just wasted it but if you send me your email i will gladly tell you more about this interesting ida which i know how to make but need help.

Happy trading!!
David.

Where will that information come from ?

Reply With Quote
 
  #6 (permalink)
Elite Member
Fort Lauderdale, Florida, USA
 
Futures Experience: Beginner
Platform: NT8 and MT4/5
Favorite Futures: NQ
 
Posts: 60 since Feb 2017
Thanks: 27 given, 22 received


davethetrade View Post
When it turns midnight i want the date to jump forward with one day so we get 4/19/2017 for this example



and when it does i want the open and close to change aswell to show open and close for 11:34PM 4/19/2017


Does the date have to change at midnight or when you next open the spreadsheet?

Also, what exactly do you mean by "open and close for 11:34PM"? I'm not sure what that means. Daily open/close? Why 11:34?

Do you have an app or trading platform feeding the open and close data you need?

Reply With Quote
 
  #7 (permalink)
Elite Member
Gothenburg
 
Futures Experience: Advanced
Platform: ninjatrader
Favorite Futures: 6E, 6B, 6C, 6A, 6S, 6J
 
Posts: 27 since Mar 2016
Thanks: 13 given, 8 received

Hey fivewhy,

11:34 was just an example, i want to measure the open and close for all 1 minute bars on the whole day.

so if i measure open and close for 18 April 11:34 bar. Lets say i put the Date in cell A1 in my spreadsheet
time in B1, open in C1, and close in D1.

When it become midnight i want the date to still be in cell A1 but change to 19 April and when it do i want to get the open and close for that days (19 April) 11:34 bar in C1 and D1 instead of open and close for the 18 of April.

Does that make sense?

sometime i have for example 11 April in my spreadsheet when it turns 19 April those should change to 12 April and so on.

Is it a way of doing this automaticly in Ninjatrader?
Thanks in Advance
Dave.

Reply With Quote
 
  #8 (permalink)
Elite Member
Omer עומר / Israel י
 
Futures Experience: Master
Platform: NinjaTrader, Proprietary,
Broker/Data: Ninjabrokerage/IQfeed + Synthetic datafeed
Favorite Futures: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 2,376 since Sep 2013
Thanks: 1,649 given, 3,520 received
Forum Reputation: Legendary

I'm just trying to challenge the problem you are trying to solve.

What will be the end-result ?

Why choose excel ?
And if you make it in excell, why you need ninjatrader for ?



davethetrade View Post
Hey fivewhy,

11:34 was just an example, i want to measure the open and close for all 1 minute bars on the whole day.

so if i measure open and close for 18 April 11:34 bar. Lets say i put the Date in cell A1 in my spreadsheet
time in B1, open in C1, and close in D1.

When it become midnight i want the date to still be in cell A1 but change to 19 April and when it do i want to get the open and close for that days (19 April) 11:34 bar in C1 and D1 instead of open and close for the 18 of April.

Does that make sense?

sometime i have for example 11 April in my spreadsheet when it turns 19 April those should change to 12 April and so on.

Is it a way of doing this automaticly in Ninjatrader?
Thanks in Advance
Dave.


Reply With Quote

Reply



futures io > > > > > Working on cool project

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)
 

RandBots: AutoTrading Bots to diversify your trading

Oct 24
 

TopstepTrader: Profiting Without Risking Your Own Money

Oct 26

Building Open Source Indicators for NT8 w/Fat Tails @ Lizard Indicators

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cool Recipes For the Food Lovers Here xiaosi Off-Topic 5 July 5th, 2014 06:39 PM
Cool Apps redratsal Off-Topic 3 July 2nd, 2014 03:41 PM
Cool Multitimeframe Chart MWinfrey NinjaTrader 45 February 20th, 2012 10:44 PM
MC v7 Cool things diverdan MultiCharts 24 July 23rd, 2011 02:02 AM
C# available in Android : how cool is that ? gomi Off-Topic 4 January 8th, 2011 11:47 PM


All times are GMT -4. The time now is 08:56 PM.

Copyright © 2017 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
Page generated 2017-10-21 in 0.12 seconds with 20 queries on phoenix via your IP 54.224.197.251