NexusFi: Find Your Edge


Home Menu

 





Indicator/script in NT8 which opens charts based on set of dates from Excel?


Discussion in NinjaTrader

Updated
    1. trending_up 1,437 views
    2. thumb_up 4 thanks given
    3. group 3 followers
    1. forum 5 posts
    2. attach_file 1 attachments




 
Search this Thread

Indicator/script in NT8 which opens charts based on set of dates from Excel?

  #1 (permalink)
LaissezFaire
Oslo + Norway
 
Posts: 224 since May 2016
Thanks Given: 224
Thanks Received: 104

Hello everyone,

I'm sorting some statistical data in Excel throughout the trading day and end up finding a resulting set of dates. It might look like this:



What I then like to do is to view these selected dates/charts in NT8. Typically, I have 8 windows/tabs already open for this and manually one-by-one open it by copy and pasting dates, i.e., copy 11.03.2019 from Excel cell --> Paste into selected date in NT8. Copy 25.02.2019 -> Paste. Etc., for all 8 dates (could be more, could be less).

While this works, it would be a lot easier if it could be automated.

Would there be a way to automate this process in NT8? Somehow how NT8 read this date column and open charts with each date? Or copy and paste the date range into an indicator which opens these charts?

I already talked to a guy who have done some programming for me in NT8 and he was at a loss for how to accomplish this.

Finally, this does NOT need to happen in NT8. If there's some other software which lets me to this, I suppose I can use that also. The main idea is to quickly being able to visualize/watch this data.

Thanks in advance.

Laissez Faire

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trade idea based off three indicators.
Traders Hideout
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
Quant vue
Trading Reviews and Vendors
MC PL editor upgrade
MultiCharts
Cheap historycal L1 data for stocks
Stocks and ETFs
 
  #2 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,765 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,629


LaissezFaire View Post
Hello everyone,

I'm sorting some statistical data in Excel throughout the trading day and end up finding a resulting set of dates. It might look like this:



What I then like to do is to view these selected dates/charts in NT8. Typically, I have 8 windows/tabs already open for this and manually one-by-one open it by copy and pasting dates, i.e., copy 11.03.2019 from Excel cell --> Paste into selected date in NT8. Copy 25.02.2019 -> Paste. Etc., for all 8 dates (could be more, could be less).

While this works, it would be a lot easier if it could be automated.

Would there be a way to automate this process in NT8? Somehow how NT8 read this date column and open charts with each date? Or copy and paste the date range into an indicator which opens these charts?

I already talked to a guy who have done some programming for me in NT8 and he was at a loss for how to accomplish this.

Finally, this does NOT need to happen in NT8. If there's some other software which lets me to this, I suppose I can use that also. The main idea is to quickly being able to visualize/watch this data.

Thanks in advance.

Laissez Faire

Use AutoIt or AutoHotkey with Ninja 7, that's the simplest solution.
This will be much much easier than using UIAutomation with NT8.

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
Thanked by:
  #3 (permalink)
LaissezFaire
Oslo + Norway
 
Posts: 224 since May 2016
Thanks Given: 224
Thanks Received: 104



NTDeveloper View Post
It's possible. Using UIAutomation, for example.

Thanks.

Care to elaborate how?

I'm no coder, so would probably have to hire someone to do this anyway. Question is how advanced/difficult it is to achive.

Reply With Quote
  #4 (permalink)
LaissezFaire
Oslo + Norway
 
Posts: 224 since May 2016
Thanks Given: 224
Thanks Received: 104


sam028 View Post
Use AutoIt or AutoHotkey with Ninja 7, that's the simplest solution.
This will be much much easier than using UIAutomation with NT8.

Thank you!

Any chance you could help me a bit further along the way?

If using NT7 then - how will running both NT7/NT8 at the same time affect performance? Obviously, the best would perhaps be to use 2 computers...

I guess best would be to accomplish it in NT8, but I'm open to every solution.

An advantage with NT8, and assuming it's possible, would be that I could have one window for this with every dated tiled chronologically as tabs. This have not been possible with NT7. At least not without some customization.

Thanks in advance.

Laissez Faire

Reply With Quote
  #5 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,765 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,629

So with UIAutomation it's working:


Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
Thanked by:
  #6 (permalink)
LaissezFaire
Oslo + Norway
 
Posts: 224 since May 2016
Thanks Given: 224
Thanks Received: 104

Amazing!

Reply With Quote




Last Updated on March 18, 2019


© 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