Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
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 for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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.
Can you help answer these questions from other members on NexusFi?
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.
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.