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

LaissezFaire 

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.

NTDeveloper 

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.

sam028 

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

So with UIAutomation it's working:

Amazing!