Can-WL7-backtest-SQL-databases

QUOTE:
If I want to achieve the goal, do I need to use the relevant extension API ?

QUOTE:

Yes, using this API:
https://www.wealth-lab.com/Support/ExtensionApi/HistoricalDataProvider

QUOTE:

Don't forget to upvote the feature request topic linked in Post #1, if you haven't done so already.

CODE:
using WealthLab.Core;
using System;
using WealthLab.Data;

namespace WealthLab.Changhengyiu
{
    public class ChangProvider : DataProviderBase
    {
        public ChangProvider() : base()
        {
            //this loads the saved configuration, and will assign the Parameters instances if they were already defined
            LoadConfig();

            //if the parameter instances aren't there, it is a new install, so add them now
            if (Parameters.Count == 0)
            {
                Parameters.Add(new Parameter("Connection string", ParameterTypes.String, "Server=127.0.0.1;Database=myDataBase;User Id=username;Password=password;"));
                Configuration = Parameters.Persist();
            }
        }

        //it's considered configured if "connection string" has a value
        public override bool IsConfigured
        {
            get
            {
                return Parameters[0].AsString.Trim() != "";
            }
        }

        //return a page for the custom settings panel, use the built-in Parameters editor page class (ucDataProviderParameters)
        public override CustomSettingsPanel GetCustomSettingsPage()
        {
            if (_settingsPage == null)
                _settingsPage = new ucDataProviderParameters();
            return _settingsPage;
        }

        //any required initialization would go here
        public override void Initialize()
        {
            base.Initialize();
        }

        //provider friendly name
        public override string Name => "ChangProvider";

        //TODO create your own provider glyph!
        public override System.Drawing.Bitmap Glyph => new Bitmap(10,10);

        public override string HelpDescription => "Returns historical data from SQL database for backtesting.";

        public override bool UsesPersistentStorage => true;

        //TODO adjust to your requirements
        public override bool SupportsScale(HistoryScale scale)
        {
            if (scale.Scale == HistoryScales.Daily || scale.Scale == HistoryScales.Minute || scale.Scale == HistoryScales.Hour)
                return true;
            return false;
        }

        //get history from SQL...
        protected override BarHistory GetHistoryInternal(string symbol, HistoryScale scale, DateTime startDate, DateTime endDate, int maxBars)
        {
            //supports daily and several intraday scales
            bool scaleSupported = false;
            if (scale.Scale == HistoryScales.Daily || scale.Scale == HistoryScales.Minute || scale.Scale == HistoryScales.Hour)
                scaleSupported = true;
            if (!scaleSupported)
                return null;

         //TODO your database reading logic
            BarHistory bh = ...

            return bh;
        }

        //private variables
        private ucDataProviderParameters _settingsPage = null; 
    }
}

QUOTE:
Here's a skeleton code of the data provider:

CODE:

public override Bitmap Glyph => new Bitmap(10, 10);

CODE:
using System.Drawing;

QUOTE:
public override Bitmap Glyph => new Bitmap(10, 10);