C#

1. Read the question carefully
   
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
   
3. If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
   
4. If the question is inappropriate then click the 'vote to remove message' button
   

1. Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
   
   
2. Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
   
   
3. Keep the subject line brief, but descriptive. eg "File Serialization problem"
   
   
4. Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
   
   
5. Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
   
   
6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
   
   
7. If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
   
   
8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
   
   
9. Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
   
   
10. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
    
    
11. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
    
    
12. No advertising or soliciting.
    
    
13. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.

namespace ATAS.Indicators.Technical
{
	using System;
	using System.ComponentModel;
	using System.ComponentModel.DataAnnotations;
	using System.Windows.Media;

	using ATAS.Indicators.Technical.Properties;

	using OFT.Attributes;

	[DisplayName("5.Heiken Ashi Z")]
    [Category("# 1234")]
    public class HeikenAshiz : Indicator
	{
		private readonly CandleDataSeries _candles = new CandleDataSeries("Heiken Ashi Z"){ Visible = true };
		private readonly PaintbarsDataSeries _bars= new PaintbarsDataSeries("Bars Z"){ Visible = false };
		public HeikenAshiz()
		{	
			Panel = IndicatorDataProvider.NewPanel;
			DataSeries[0]= _bars;
			DataSeries.Add(_candles);
		}

		protected override void OnCalculate(int bar, decimal value)
		{
			var candle = GetCandle(bar);
			_bars[bar] = Colors.Transparent;
			if (bar == 0)
			{
				_candles[bar] = new Candle()
				{
					Close = candle.Close,
					High = candle.High,
					Low = candle.Low,
					Open = candle.Open
				};
			}
			else
			{
				var prevCandle = _candles[bar - 1];
				_candles[bar] = new Candle()
				{
					Close = (candle.Open+candle.Close+candle.High+candle.Low)*0.25m,
					High = candle.High,
					Low = candle.Low,
					Open = (prevCandle.Open+ prevCandle.Close)*0.5m,
				};
			}
			
		}
        protected override void OnApplyDefaultColors()
        {
            if (ChartInfo is null)
                return;

            _candles.UpCandleColor = Color.FromRgb(14, 203, 129);
            _candles.DownCandleColor = Color.FromRgb(246, 70, 93);
            _candles.BorderColor = Color.FromRgb(127, 127, 127);
        }
    }
}

void PlotChart()
        {
            try
            {
                // Clear existing series
                chart1.Series.Clear();

                // Create new series
                Series First = new Series("Series11");
                Series Second = new Series("Series12");

                // Set chart type
                First.ChartType = SeriesChartType.Spline;
                Second.ChartType = SeriesChartType.Spline;

                // Set custom colors for each series
                First.Color = Color.Blue; // Set the color for First series
                Second.Color = Color.Orange; // Set the color for Second series


                // Connect to the database and retrieve data
                using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True"))
                {
                    if(connection.State == ConnectionState.Closed)
                    {
                        connection.Open();
                    }
                    

                    // Select only rows where RawDataOrder is equal to label86 text
                    string query = $"SELECT * FROM Data WHERE RawDataOrder = {Convert.ToInt32(label86.Text.Trim())}";
                    using (SqlCommand command = new SqlCommand(query, connection))
                    {
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                // Assuming the first column is 'ID', the second is '11', and the third is '12'
                                int id = reader.GetInt32(0);
                                int value11 = reader.GetInt32(1);
                                int value12 = reader.GetInt32(8);

                                // Add data points to the series
                                First.Points.AddXY(id, value11);
                                Second.Points.AddXY(id, value12);
                            }
                        }
                    }
                }

                // Add the series to the chart
                chart1.Series.Add(First);
                chart1.Series.Add(Second);

                // Set chart title
                chart1.Titles.Clear();
                chart1.Titles.Add(new Title("Channel 1"));

                // Refresh the chart to update the display
                chart1.Update();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error PlotChart", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

private decimal Lowest(int bar, ValueDataSeries src, int length)
        {
            if (bar < length)
                return (0.0m);
            decimal res = decimal.MaxValue;

            for (int index = bar; index >= bar - (length - 1); index--)
            {
                if (src[index] < res)
                    res = src[index];
            }

            return (res);
        }