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)
Broker: Tradestation/Tradestation, NinjaTrader, FXCM and Tallinex
Trading: ES, CL, EUR/USD, TF
Posts: 173 since Aug 2009
Thanks Given: 105
Thanks Received: 61
Hello
I was wondering if anybody could help with some code to do the following:
I have some values I store in excel like VAH, POC, and VAL for market profile as well as others.
I would like to be able to create an indicator in NinjaTrader that when applied to a chart I can call all of the values from the excel spreadsheet and plot as horizontal lines.
The next step for this code would be to have an option to only call the last _____ number of values. I might want to plot only the last 6 values or the last 60 values. If I have a chart that is full of 1000 values, this would be the only reason to not call all of them--otherwise I would have to create multiple database of excel spreadsheets.
any ideas for coding would be much appreciated. I have some c++, and java experience and went through a few tutorials from Scott and Big Mike which were very helpful. This code would be most helpful as a lot of the work is putting lines on the chart.
thanks
Spencer
Can you help answer these questions from other members on NexusFi?
All – I got a bunch of data off this forum yesterday which I will be using to do some probability analysis of some of the setups I use. This is excellent stuff and in return I would like to give something back.
i made a ninja to client (like excel) dde connector. the reverse is also possible. i did a basic framework for fellow member PrTester. you can contact him for an upgraded version, if he has any. the basic code which i did was is presented below.
the code will connect excel and nt. write anything in cell A1 or A2, B2 a msg box will pop up.
you need the necessary dll, search the download section for NinjaDDE.
Find attached the indicator you were looking for. I modified the Chartnote indicator from monpere, it is in the regular download section so no problems if you are not elite.
Instructions
From your excel or any editor you …
Broker: Tradestation/Tradestation, NinjaTrader, FXCM and Tallinex
Trading: ES, CL, EUR/USD, TF
Posts: 173 since Aug 2009
Thanks Given: 105
Thanks Received: 61
thanks redratsal, bukkan, and DionysusToast for contributing. I will definitely take a look at those links and the code. I think this will help get me started:-)
All – I got a bunch of data off this forum yesterday which I will be using to do some probability analysis of some of the setups I use. This is excellent stuff and in return I would like to give something back.
There's a pay-for product out there called XLSgate. They offer a free-trial version and then a lite version if you don't want to purchase that has much of the same write functionality but without the read functionality. I needed to get data back and forth to Excel throughout the trading day and XLSgate worked. Just an FYI - I don't work for these guys or have any stake in their activities.
I tried this solution but am not a good programmer - still working on it - so the pay-for solution helped me out.
All – I got a bunch of data off this forum yesterday which I will be using to do some probability analysis of some of the setups I use. This is excellent stuff and in return I would like to give something back.