NexusFi: Find Your Edge


Home Menu

 





Working on cool project


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one davethetrade with 4 posts (0 thanks)
    2. looks_two rleplae with 3 posts (1 thanks)
    3. looks_3 EgoRisk with 1 posts (0 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 1,391 views
    2. thumb_up 1 thanks given
    3. group 2 followers
    1. forum 7 posts
    2. attach_file 1 attachments




 
Search this Thread

Working on cool project

  #1 (permalink)
 davethetrade 
Gothenburg
 
Experience: Advanced
Platform: DAS Trader Pro
Trading: Nasdaq Stocks, no futures
Posts: 52 since Mar 2016
Thanks Given: 31
Thanks Received: 18

Hey traders,

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



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.

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
ZombieSqueeze
Platforms and Indicators
Are there any eval firms that allow you to sink to your …
Traders Hideout
Futures True Range Report
The Elite Circle
Exit Strategy
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
18 thanks
  #3 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863


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();
}

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #4 (permalink)
 davethetrade 
Gothenburg
 
Experience: Advanced
Platform: DAS Trader Pro
Trading: Nasdaq Stocks, no futures
Posts: 52 since Mar 2016
Thanks Given: 31
Thanks Received: 18

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

So basicly what i´m trying to do is to make a time spreadsheet. Time is very important in trading i believe and
i think i have an idéa 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.

I´m 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 idéa which i know how to make but need help.

Happy trading!!
David.

Started this thread Reply With Quote
  #5 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863


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

So basicly what i´m trying to do is to make a time spreadsheet. Time is very important in trading i believe and
i think i have an idéa 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.

I´m 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 idéa which i know how to make but need help.

Happy trading!!
David.

Where will that information come from ?

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #6 (permalink)
 EgoRisk 
Fort Lauderdale, Florida, USA
 
Experience: Beginner
Platform: NT8, Bookmap
Trading: ES, MES
Posts: 189 since Feb 2017
Thanks Given: 78
Thanks Received: 198


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)
 davethetrade 
Gothenburg
 
Experience: Advanced
Platform: DAS Trader Pro
Trading: Nasdaq Stocks, no futures
Posts: 52 since Mar 2016
Thanks Given: 31
Thanks Received: 18

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.

Started this thread Reply With Quote
  #8 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863

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.


Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote




Last Updated on April 20, 2017


© 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