Excel to ninja

[anmir55]

Hello

I have values prices in an excel spreadsheet.

A1=2110,70
B1=2140,70

How Can I move automatically those prices from excel to ninja to lines on a chart?

Is there any indicator?

Thank you

[NinjaTrader_PaulH]

Hello anmir55,

Thanks for your post.

To automate line creation on the chart based on values in excel, you would need to create an indicator that would read the values from a file and then create the lines on the chart. Here is a link to a reference sample on how to read data from a file: http://www.ninjatrader.com/support/f...ead.php?t=3476 In addition you would use the DrawLine() method: http://www.ninjatrader.com/support/h...l?drawline.htm

You might also want to search through the forums file sharing threads to see if there might be another indicator that you could use as a starting point for creating your own.

Alternatively, as that seems like a lot of work for two line, you could use the indicator priceAlert in your ninjaTrader and enter those values into two instances of the indicators to not only draw the lines but to provide automatic alerting ability. Note that if your values change each day, you can simply move the lines directly on the chart to the new values. Moving the priceAlert line will rearm it as well.