Example #1
0
        protected override void ReadDataFromFile()
        {
            using (var package = new ExcelPackage(Source))
            {
                var worksheet = package.Workbook.Worksheets[1];
                for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
                {
                    var dateValue  = worksheet.Cells[i, 3].Value;
                    var timeValue  = worksheet.Cells[i, 4].Value;
                    var openValue  = Convert.ToDecimal(worksheet.Cells[i, 5].Value) / 1e5m;
                    var highValue  = Convert.ToDecimal(worksheet.Cells[i, 6].Value) / 1e5m;
                    var lowValue   = Convert.ToDecimal(worksheet.Cells[i, 7].Value) / 1e5m;
                    var closeValue = Convert.ToDecimal(worksheet.Cells[i, 8].Value) / 1e5m;

                    var date   = DateTime.ParseExact($"{dateValue} {timeValue}", "yyyyMMdd HHmmss", CultureInfo.InvariantCulture);
                    var candle = new Candle(highValue, lowValue, openValue, closeValue, date);

                    Candles.Enqueue(candle);
                }
            }
        }
Example #2
0
 protected override void ReadDataFromFile(OpenFileDialog openFileDialog)
 {
     ////Создаем приложение
     //Microsoft.Office.Interop.Excel.Application ObjExcel = new Microsoft.Office.Interop.Excel.Application();
     ////Открываем книгу
     //Microsoft.Office.Interop.Excel.Workbook ObjWorkBook = ObjExcel.Workbooks.Open(openFileDialog.FileName);
     ////Выбираем таблицу лист
     //Microsoft.Office.Interop.Excel.Worksheet WorksheetExcel = (Microsoft.Office.Interop.Excel.Worksheet)ObjWorkBook.Sheets[1];
     //var lastCell = WorksheetExcel.Cells.SpecialCells(Microsoft.Office.Interop.Excel.XlCellType.xlCellTypeLastCell);
     //int k = (int)lastCell.Row;
     //for (int i = 2; i < (int)lastCell.Row; i++)
     //{
     //    var dateValue = WorksheetExcel.Cells[i, 3].Value;
     //    var timeValue = WorksheetExcel.Cells[i, 4].Value;
     //    var openValue = Convert.ToDecimal((WorksheetExcel.Cells[i, 5]).Value) / 1e5m;
     //    var highValue = Convert.ToDecimal((WorksheetExcel.Cells[i, 6]).Value) / 1e5m;
     //    var lowValue = Convert.ToDecimal((WorksheetExcel.Cells[i, 7]).Value) / 1e5m;
     //    var closeValue = Convert.ToDecimal((WorksheetExcel.Cells[i, 8]).Value) / 1e5m;
     //    var date = DateTime.ParseExact($"{dateValue} {timeValue}", "yyyyMMdd HHmmss", CultureInfo.InvariantCulture);
     //    Candle candle = new Candle(highValue, lowValue, openValue, closeValue, date);
     //    Candles.Enqueue(candle);
     //}
     using (var package = new ExcelPackage(new FileInfo(openFileDialog.FileName)))
     {
         var worksheet = package.Workbook.Worksheets[1];
         for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
         {
             var    dateValue  = worksheet.Cells[i, 3].Value;
             var    timeValue  = worksheet.Cells[i, 4].Value;
             var    openValue  = Convert.ToDecimal((worksheet.Cells[i, 5]).Value) / 1e5m;
             var    highValue  = Convert.ToDecimal((worksheet.Cells[i, 6]).Value) / 1e5m;
             var    lowValue   = Convert.ToDecimal((worksheet.Cells[i, 7]).Value) / 1e5m;
             var    closeValue = Convert.ToDecimal((worksheet.Cells[i, 8]).Value) / 1e5m;
             var    date       = DateTime.ParseExact($"{dateValue} {timeValue}", "yyyyMMdd HHmmss", CultureInfo.InvariantCulture);
             Candle candle     = new Candle(highValue, lowValue, openValue, closeValue, date);
             Candles.Enqueue(candle);
         }
     }
 }
Example #3
0
        protected override void ReadDataFromFile(OpenFileDialog openFileDialog)
        {
            using (var stream = new StreamReader(new FileStream(openFileDialog.FileName, FileMode.Open)))
            {
                var content = stream.ReadToEnd();
                var data    = JsonConvert.DeserializeObject <Dictionary <string, object> >(content);
                var t       = ((JArray)data["t"]).ToObject <List <long> >();
                var o       = ((JArray)data["o"]).ToObject <List <decimal> >();
                var c       = ((JArray)data["o"]).ToObject <List <decimal> >();
                var h       = ((JArray)data["o"]).ToObject <List <decimal> >();
                var l       = ((JArray)data["o"]).ToObject <List <decimal> >();

                for (int i = 0; i < t.Count; i++)
                {
                    var tValue = t[i];
                    var oValue = o[i];
                    var cValue = o[i];
                    var hValue = o[i];
                    var lValue = o[i];

                    Candles.Enqueue(new Candle(tValue, hValue, lValue, oValue, cValue));
                }
            }
        }