NexusFi: Find Your Edge


Home Menu

 





Help please - moving spreadsheet values into constant lines indicator


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one redratsal with 11 posts (42 thanks)
    2. looks_two hector24 with 6 posts (1 thanks)
    3. looks_3 jmacn with 4 posts (0 thanks)
    4. looks_4 aquarian1 with 4 posts (0 thanks)
      Best Posters
    1. looks_one redratsal with 3.8 thanks per post
    2. looks_two trendisyourfriend with 1.3 thanks per post
    3. looks_3 sam028 with 0.5 thanks per post
    4. looks_4 hector24 with 0.2 thanks per post
    1. trending_up 15,352 views
    2. thumb_up 50 thanks given
    3. group 14 followers
    1. forum 36 posts
    2. attach_file 15 attachments




 
Search this Thread

Help please - moving spreadsheet values into constant lines indicator

  #1 (permalink)
 
aquarian1's Avatar
 aquarian1 
Point Roberts, WA, USA
 
Experience: Advanced
Platform: IB and free NT
Broker: IB
Trading: ES
Posts: 4,034 since Dec 2010
Thanks Given: 1,509
Thanks Received: 2,593

Hi Everyone.

I compute various values in my spreadsheet (I use lotus 123 but I could move them to Excel or to a csv file).
I would like to be able to move these values into the Ninja indicator automatically (I currently type them in).

I have several ES charts of different time frames and I put some values in one and some in another.

Here is an example of a 3 minute ES chart with the values
1284.50
1282.00
1278.50
1276.00

The dotted lines are these values which I have entered into the Constant Lines indicator (I used Ninja 6.5)

many thanks,

Attached Thumbnails
Click image for larger version

Name:	1.JPG
Views:	298
Size:	62.7 KB
ID:	28376  
Visit my NexusFi Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
Better Renko Gaps
The Elite Circle
ZombieSqueeze
Platforms and Indicators
How to apply profiles
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
29 thanks
Just another trading journal: PA, Wyckoff & Trends
25 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
18 thanks
  #3 (permalink)
 
aquarian1's Avatar
 aquarian1 
Point Roberts, WA, USA
 
Experience: Advanced
Platform: IB and free NT
Broker: IB
Trading: ES
Posts: 4,034 since Dec 2010
Thanks Given: 1,509
Thanks Received: 2,593


screen snap of the indicator

Attached Thumbnails
Click image for larger version

Name:	1A.JPG
Views:	326
Size:	62.1 KB
ID:	28377  
Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #4 (permalink)
 
redratsal's Avatar
 redratsal 
Milan (I)
 
Experience: Advanced
Platform: Ninjatrader
Broker: Kinetick
Trading: FDAX,6E,CL,YM,NQ,ES
Posts: 1,648 since Oct 2010
Thanks Given: 1,215
Thanks Received: 2,090


aquarian1 View Post
Hi Everyone.

I compute various values in my spreadsheet (I use lotus 123 but I could move them to Excel or to a csv file).
I would like to be able to move these values into the Ninja indicator automatically (I currently type them in).

I have several ES charts of different time frames and I put some values in one and some in another.

Here is an example of a 3 minute ES chart with the values
1284.50
1282.00
1278.50
1276.00

The dotted lines are these values which I have entered into the Constant Lines indicator (I used Ninja 6.5)

many thanks,

Hi Aquarian1
Dionysustoast has built a comunication procedure between nt and excel
[COLOR=#800080]https://nexusfi.com/elite-circle/7307-dionysus-xmas-present-ninja-excel.html[/COLOR]
you will have to adapt it to your needs but I think it's managable.

Hope it works

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

I think @trendisyourfriend has hired a professionnal coder to do something similar, you should ask him.

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
  #6 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,175
Thanks Received: 6,020


sam028 View Post
I think @ trendisyourfriend has hired a professionnal coder to do something similar, you should ask him.

Sam, i don't mind if you share it with the community. That would be my gift for all the good things i got from this group of gentlement. So go ahead make a nice package and put it into the download section.

Reply With Quote
Thanked by:
  #7 (permalink)
 
trendisyourfriend's Avatar
 trendisyourfriend 
Quebec Canada
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader
Broker: AMP/CQG
Trading: ES, NQ, YM
Frequency: Daily
Duration: Minutes
Posts: 4,527 since Oct 2009
Thanks Given: 4,175
Thanks Received: 6,020

To define the zones, you use Excel and copy/paste into a text file:

Ex.:



The final result after pasting the above content copied from Excel should look like this :



When you copy/paste lines that comprise many columns, Excel insert a TAB between these columns automatically. This is how the indicator recognises the start of a new column. Here i used a comma for the price level and to define the height but on a US system you use a dot.

P.S. included the Excel template as an example.

Attached Files
Elite Membership required to download: ES-Zone.xls
Reply With Quote
Thanked by:
  #8 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,765 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,629


trendisyourfriend View Post
Sam, i don't mind if you share it with the community. That would be my gift for all the good things i got from this group of gentlement. So go ahead make a nice package and put it into the download section.

Great !!!
I will make a small modification (to avoid warning if the parameter file doesn't exists), and will post it.

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
Thanked by:
  #9 (permalink)
 
aquarian1's Avatar
 aquarian1 
Point Roberts, WA, USA
 
Experience: Advanced
Platform: IB and free NT
Broker: IB
Trading: ES
Posts: 4,034 since Dec 2010
Thanks Given: 1,509
Thanks Received: 2,593


redratsal View Post
Hi Aquarian1
Dionysustoast has built a comunication procedure between nt and excel
[COLOR=#800080]https://nexusfi.com/elite-circle/7307-dionysus-xmas-present-ninja-excel.html[/COLOR]
you will have to adapt it to your needs but I think it's managable.

Hope it works

I'm not in the elite-circle so for me I guess not. Thanks for thinking of it though.

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #10 (permalink)
 
aquarian1's Avatar
 aquarian1 
Point Roberts, WA, USA
 
Experience: Advanced
Platform: IB and free NT
Broker: IB
Trading: ES
Posts: 4,034 since Dec 2010
Thanks Given: 1,509
Thanks Received: 2,593



trendisyourfriend View Post
To define the zones, you use Excel and copy/paste into a text file:

...

thanks TIYF! Very kind of you

So what you have shown is the steps to create the parameters file which is then ready to be read by the indicator that is forthcoming shortly, (correct)?
If you use the indicator on two different charts with two different parameters files does that work?

(I had trouble matching the graph to the parameters file perhaps there are of different days eg. poc 1281.5 versus 1225 see attached)

Attached Thumbnails
Click image for larger version

Name:	TIYF1.JPG
Views:	326
Size:	145.4 KB
ID:	28518  
Visit my NexusFi Trade Journal Started this thread Reply With Quote




Last Updated on September 30, 2018


© 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