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 maman with 1 thanks per post
    4. looks_4 ceramictilepro with 0.5 thanks per post
    1. trending_up 15,417 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

  #11 (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,

@ aquarian1

Hi aquariun1,

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 copy and paste your s/r levels (you must use ctrl+c ctrl+v) into the indicator's editor (it will not work if you use the right mouse). A max of 10 lines can be edited (you can add or change the color of lines by editing the indicator).

Hope it makes your life easier

Attached Thumbnails
Click image for larger version

Name:	2011-01-17_1041.png
Views:	568
Size:	22.0 KB
ID:	28637   Click image for larger version

Name:	2011-01-17_1043.png
Views:	668
Size:	145.4 KB
ID:	28638   Click image for larger version

Name:	2011-01-17_1044.png
Views:	619
Size:	47.3 KB
ID:	28639  
Attached Files
Elite Membership required to download: ChartNotes.zip
Visit my NexusFi Trade Journal Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Better Renko Gaps
The Elite Circle
Trade idea based off three indicators.
Traders Hideout
About a successful futures trader who didnt know anythin …
Psychology and Money Management
What broker to use for trading palladium futures
Commodities
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
  #12 (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,176
Thanks Received: 6,020


redratsal View Post
@ aquarian1

Hi aquariun1,

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 copy and paste your s/r levels (you must use ctrl+c ctrl+v) into the indicator's editor (it will not work if you use the right mouse). A max of 10 lines can be edited (you can add or change the color of lines by editing the indicator).

Hope it makes your life easier

redratsal, could you add the possibility to paste two columns of data so that the second column would contain a comment like Y-VAH. I know when you copy/paste two columns or more, Excel insert a TAB between them so this could be used as column separator. The commentary could be placed directly on the line at the right or left side (user definable). Also, is it possible to add an option in the parameters to replicate all these lines to all charts that have the same data series. And why not adding some parameters to control the color and opacity of the lines.

Reply With Quote
  #13 (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


Find attached a revised version with descriptions included. A max of 10 lines can be imported from excel, if you need more you will have to add for each new line the following instructions:

script lines 80-112


result = Convert.ToDouble(notes1[0]);
DrawHorizontalLine(
"tag1", result, Color.Blue);
DrawText(
"MyText", notes2[0], 0, result + 4 * TickSize,Color.Aqua);

Updated download section https://nexusfi.com/free_downloads/ninjatrader-7/indicators/page-4.html

Just copy from excel and paste in the editor and the S/R with descriptions will plot on the chart

Attached Thumbnails
Click image for larger version

Name:	2011-03-10_1107.png
Views:	424
Size:	116.1 KB
ID:	33302   Click image for larger version

Name:	2011-03-10_1104.png
Views:	434
Size:	67.9 KB
ID:	33303  
Attached Files
Elite Membership required to download: LevelsChartNotes.zip
Visit my NexusFi Trade Journal Reply With Quote
  #14 (permalink)
 hector24 
austin, texas
 
Experience: Intermediate
Platform: ninja trader
Trading: currency futures
Posts: 506 since Jan 2011
Thanks Given: 14
Thanks Received: 234

Redratsal,
How do you impliment your indicator from the excell spreadsheet. Is there a way to copy and paste the numbers from the site because I have to enter them into excell first then copy and paste into the indicator. If there was a way to just copy and paste from lets say Bugs numbers provided that would be nice. This would eliminate having to input the numbers. Not being lazy but the shorter I can make the time frame the better.
Great indicator by the way.

Thanks
Hector

Reply With Quote
  #15 (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


hector24 View Post
Redratsal,
How do you impliment your indicator from the excell spreadsheet. Is there a way to copy and paste the numbers from the site because I have to enter them into excell first then copy and paste into the indicator. If there was a way to just copy and paste from lets say Bugs numbers provided that would be nice. This would eliminate having to input the numbers. Not being lazy but the shorter I can make the time frame the better.
Great indicator by the way.

Thanks
Hector

You can copy and paste from any place as long as you use one line for each # .

Visit my NexusFi Trade Journal Reply With Quote
  #16 (permalink)
 hector24 
austin, texas
 
Experience: Intermediate
Platform: ninja trader
Trading: currency futures
Posts: 506 since Jan 2011
Thanks Given: 14
Thanks Received: 234

Redratsal, I am sorry but I have tried copying and pasting into the window of the indicator and it does not allow me to paste. Is there a step I may be missing. I tried to copy and paste Bugs numbers.

Thanks
Hector

Reply With Quote
  #17 (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


hector24 View Post
Redratsal, I am sorry but I have tried copying and pasting into the window of the indicator and it does not allow me to paste. Is there a step I may be missing. I tried to copy and paste Bugs numbers.

Thanks
Hector

you need to use the commands ctrl+c and ctrl+v

Visit my NexusFi Trade Journal Reply With Quote
  #18 (permalink)
 hector24 
austin, texas
 
Experience: Intermediate
Platform: ninja trader
Trading: currency futures
Posts: 506 since Jan 2011
Thanks Given: 14
Thanks Received: 234

Redratsal,
Your direction worked like a champ.
Have a qucik question. Is there anyway to change the line color and lengh.

Thanks
Hector

Reply With Quote
  #19 (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


hector24 View Post
Redratsal,
Your direction worked like a champ.
Have a qucik question. Is there anyway to change the line color and lengh.

Thanks
Hector

@hector24

Now you can personalize the colors

Attached Files
Elite Membership required to download: Hector24.zip
Visit my NexusFi Trade Journal Reply With Quote
  #20 (permalink)
 hector24 
austin, texas
 
Experience: Intermediate
Platform: ninja trader
Trading: currency futures
Posts: 506 since Jan 2011
Thanks Given: 14
Thanks Received: 234


Redratsal,
Thanks a lot, worked like a champ! I really appreciate your help.
Good luck on your trading, seems your doing pretty well.

Thanks Again,
Hector

Reply With Quote
Thanked by:




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