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)
Not sure if this is the place to ask the following question or not but here it goes: I want to know if there is anyway of importing NT tick data into MS Excel or not?
Any help on this would be much appreciated.
Thanks
Can you help answer these questions from other members on NexusFi?
For import historical ticks:
NT - Control Center - Tools - Historical Data - Export - result will be in txt format file wich you can open from Excel.
For import realtime ticks:
There is no standart functionality but maybe somebody can write an indicator or a strategy wich can export realtime tick value into an Excel application. Or you can write a macro in Excel to receive tick data throw NT COM API.
Thanks for the reply and input. Yeah, I was in a trading room a while ago and remember someone mentioning that they were able to import real time tick data from ninja into excel. i think he wrote an api for it.
anyway, thanks for the feedback. i'm sure one of these days someone is going to be generous enough to share their code with the rest of the community
This VBA code works! Open a code module in the workbook in which you want to use the function then go to Tools > References to open the References dialog where you will see a list of all the libraries and other objects to which you can set a reference. Select NinjaTrader Client and press the "OK" button.
Then inset a new module and copy a code below.
Using example: in formula field type: "=GetTick("ES 03-10")".