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


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

Welcome to futures io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • 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, and we will never resell your private information.

-- Big Mike

Reply
 
Thread Tools Search this Thread
 

Working on cool project

  #1 (permalink)
Trading Apprentice
Gothenburg
 
Futures Experience: Advanced
Platform: ninjatrader
Favorite Futures: currency
 
Posts: 24 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: 1,916 since Sep 2013
Thanks: 1,362 given, 2,878 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)
Trading Apprentice
Gothenburg
 
Futures Experience: Advanced
Platform: ninjatrader
Favorite Futures: currency
 
Posts: 24 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: 1,916 since Sep 2013
Thanks: 1,362 given, 2,878 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: 10oz Gold (MGC) and Micro Currencies
 
Posts: 45 since Feb 2017
Thanks: 12 given, 11 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)
Trading Apprentice
Gothenburg
 
Futures Experience: Advanced
Platform: ninjatrader
Favorite Futures: currency
 
Posts: 24 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: 1,916 since Sep 2013
Thanks: 1,362 given, 2,878 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)
 

Introducing iSystems with Stage 5 Trading

Apr 27

FIO Journal Challenge featuring NinjaTrader ($2,000+ of prizes)

May

Prototyping Python Strategies (part 2) w/Ran Aroussi

Elite only

Ask Me Anything w/Raymond Deux @ NinjaTrader

May 3

An Afternoon with FIO member Softsoap

Elite only
 

Machine Learning & Data Mining Bias w/Kris Longmore @ Robot Wealth

Elite only

Brannigan Barrett (TBA)

Elite only

FIO member Gomi (TBA)

Elite only

FuturesTrader71 (TBA)

Elite only

EasyLanguage Programming w/Chris @ ABC Trading Group

Elite only

Portfolio Diversification w/Brendon Delate

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 10:03 AM.

no new posts
Page generated 2017-04-28 in 0.12 seconds with 21 queries on phoenix via your IP 54.158.30.143