Пример #1
0
        //private bool StockPriceExists(string id, DateTime date)
        //{
        //    return _context.StockPrice.Any(e => e.StockID == id && e.Date == date);
        //}

        #region "FORMULA"
        //private async Task<bool> InitIndicator()
        //{

        //    foreach (Stock stock in await _context.Stock.Where(s=>s.StockID == "AALI").ToListAsync())
        //    //foreach (Stock stock in _context.Stock.Where(m => m.StockID == "AALI" || m.StockID == "BBCA" || m.StockID == "PTBA"))

        //    {
        //        //Console.Write("TEST " + stock.StockID);
        //        System.Diagnostics.Debug.WriteLine("TEST " + stock.StockID);

        //        //*cari semua histori harga
        //        var data = _context.StockPrice.Where(c => c.StockID == stock.StockID).OrderBy(c => c.Date).ToList();
        //        var count = data.Count();
        //        if (count > 0)
        //        {

        //            for(int i=0; i<count-1; i++)
        //            {
        //                var price = data[0];
        //                var counter = i;
        //                //foreach (StockPrice price in data.ToList().Last())
        //                //{
        //                price.MA20 = Calculation.MA(counter, data.ToArray(), 20);
        //                price.MA60 = Calculation.MA(counter, data.ToArray(), 60);
        //                price.Support = Calculation.Support(counter, data.ToArray());
        //                price.Resistance = Calculation.Resistance(counter, data.ToArray());


        //                dynamic t3 = Calculation.HighestLowest(counter, data.ToArray(), 3);
        //                price.Highest3Months = (t3 == null ? null : t3.Highest);
        //                price.Lowest3Months = (t3 == null ? null : t3.Lowest);

        //                dynamic t6 = Calculation.HighestLowest(counter, data.ToArray(), 6);
        //                price.Highest6Months = (t6 == null ? null : t6.Highest);
        //                price.Lowest6Months = (t6 == null ? null : t6.Lowest);

        //                dynamic t12 = Calculation.HighestLowest(counter, data.ToArray(), 12);
        //                price.Highest12Months = (t12 == null ? null : t12.Highest);
        //                price.Lowest12Months = (t12 == null ? null : t12.Lowest);

        //                price.TrendHigh = Calculation.TrendHigh(counter, data.ToArray(), price.Highest3Months, price.Highest6Months, price.Highest12Months);
        //                price.TrendLow = Calculation.TrendLow(counter, data.ToArray(), price.Lowest3Months, price.Lowest6Months, price.Lowest12Months);

        //                //dynamic highlow = BreakHighLowCalc(counter, data.ToArray());
        //                //price.TrendHigh = highlow.TrendHigh;
        //                //price.TrendLow = highlow.TrendLow;

        //                price.EMA12 = Calculation.EMA(counter, data.ToArray(), 12);
        //                price.EMA26 = Calculation.EMA(counter, data.ToArray(), 26);
        //                if (price.EMA12 == null || price.EMA26 == null)
        //                    price.MACD = null;
        //                else
        //                    price.MACD = price.EMA12 - price.EMA26;
        //                price.SignalLine = Calculation.SignalLine(counter, data.ToArray(), 9);

        //                if (price.MACD == null || price.SignalLine == null)
        //                    price.GSLine = null;
        //                else
        //                    price.GSLine = (Decimal)(price.MACD + price.SignalLine) / 2;

        //                price.SD20 = Calculation.SD(counter, data.ToArray(), 20);

        //                price.BBUpper = price.MA20 + 2 * price.SD20;
        //                price.BBLower = price.MA20 - 2 * price.SD20;
        //            }

        //            //*ambil tanggal terbaru
        //            //var price = await data.LastAsync();


        //            //counter++;
        //            //}
        //        }

        //    }
        //    await _context.SaveChangesAsync();
        //    return true;

        //}
        private async Task <bool> CalculateIndicator2(string stockID, StockPrice price)
        {
            //foreach (Stock stock in await _context.Stock.ToListAsync())
            //foreach (Stock stock in _context.Stock.Where(m => m.StockID == "AALI" || m.StockID == "BBCA" || m.StockID == "PTBA"))

            {
                //Console.Write("TEST " + stock.StockID);
                System.Diagnostics.Debug.WriteLine("TEST " + stockID);


                var      prices = _context.StockPrice.Where(c => c.StockID == stockID).AsNoTracking();
                DateTime last_date;
                if (prices.Count() > 0)
                {
                    last_date = prices.Max(m => m.Date);
                }
                else
                {
                    last_date = price.Date;
                }


                //*cari semua histori harga
                StockPrice[] data = prices.Where(c => c.Date >= last_date.AddMonths(-13)).OrderBy(c => c.Date).AsNoTracking().ToArray();

                //*tambahkan data terbaru dalam memory
                data = data.Append(price).ToArray();



                var countx = data.Count();

                //StockPrice dataPrev = null;
                //var indexPrev = 0;
                if (countx >= 5)
                {
                    //*Update harga 3 hari sebelumnya
                    for (int i = countx - 4; i <= countx - 2; i++)
                    {
                        //dataPrev = data[i];
                        StockPrice dataPrev = await _context.StockPrice.SingleOrDefaultAsync(m => m.Date == data[i].Date && m.StockID == stockID);

                        //indexPrev = countx - 3;


                        dataPrev.Support    = Calculation.Support(i, data);
                        data[i].Support     = dataPrev.Support;
                        dataPrev.Resistance = Calculation.Resistance(i, data);
                        data[i].Resistance  = dataPrev.Resistance;
                        //dataPrev.Support = 60;
                        //dataPrev.Resistance = 28000;
                        await _context.SaveChangesAsync();
                    }
                }
                var count = data.Count();
                if (count > 0)
                {
                    //for(int i=0; i<data.Length-1; i++)

                    //*ambil tanggal terbaru
                    //var price = data.Last();
                    var counter = count - 1;
                    //foreach (StockPrice price in data.ToList().Last())
                    //{
                    price.MA20       = Calculation.MA(counter, data, 20);
                    price.MA60       = Calculation.MA(counter, data, 60);
                    price.Support    = Calculation.Support(counter, data);
                    price.Resistance = Calculation.Resistance(counter, data);


                    dynamic t3 = Calculation.HighestLowest(counter, data, 3);
                    price.Highest3Months = (t3 == null ? null : t3.Highest);
                    price.Lowest3Months  = (t3 == null ? null : t3.Lowest);

                    dynamic t6 = Calculation.HighestLowest(counter, data, 6);
                    price.Highest6Months = (t6 == null ? null : t6.Highest);
                    price.Lowest6Months  = (t6 == null ? null : t6.Lowest);

                    dynamic t12 = Calculation.HighestLowest(counter, data, 12);
                    price.Highest12Months = (t12 == null ? null : t12.Highest);
                    price.Lowest12Months  = (t12 == null ? null : t12.Lowest);

                    price.TrendHigh = Calculation.TrendHigh(counter, data, price.Highest3Months, price.Highest6Months, price.Highest12Months);
                    price.TrendLow  = Calculation.TrendLow(counter, data, price.Lowest3Months, price.Lowest6Months, price.Lowest12Months);

                    //dynamic highlow = BreakHighLowCalc(counter, data);
                    //price.TrendHigh = highlow.TrendHigh;
                    //price.TrendLow = highlow.TrendLow;

                    price.EMA12 = Calculation.EMA(counter, data, 12);
                    price.EMA26 = Calculation.EMA(counter, data, 26);
                    if (price.EMA12 == null || price.EMA26 == null)
                    {
                        price.MACD = null;
                    }
                    else
                    {
                        price.MACD = price.EMA12 - price.EMA26;
                    }
                    price.SignalLine = Calculation.SignalLine(counter, data, 9);

                    if (price.MACD == null || price.SignalLine == null)
                    {
                        price.GSLine = null;
                    }
                    else
                    {
                        price.GSLine = (Decimal)(price.MACD + price.SignalLine) / 2;
                    }


                    if (counter >= 1)
                    {
                        if (price.GSLine != null && data[counter - 1].GSLine != null)
                        {
                            if (price.GSLine > data[counter - 1].GSLine)
                            {
                                price.GSLineDirection = "U";
                            }
                            else if (price.GSLine < data[counter - 1].GSLine)
                            {
                                price.GSLineDirection = "D";
                            }
                            else
                            {
                                price.GSLineDirection = "N";
                            }
                        }
                        else
                        {
                            price.GSLineDirection = "";
                        }
                    }
                    else
                    {
                        price.GSLineDirection = "";
                    }


                    price.SD20 = Calculation.SD(counter, data, 20);

                    price.BBUpper = price.MA20 + 2 * price.SD20;
                    price.BBLower = price.MA20 - 2 * price.SD20;

                    if (price.Frequency > 0)
                    {
                        price.BigWave = (Decimal)price.Volume / (Decimal)(price.Frequency * price.Frequency * price.Frequency);
                    }
                    else
                    {
                        price.BigWave = 0;
                    }

                    price.AverageBigWave = Calculation.AverageBigWave(counter, data, 3);

                    //counter++;
                    //}
                }
            }
            //await _context.SaveChangesAsync();
            return(true);
        }
        public async Task <bool> InitIndicator(string stockID)
        {
            //*cari semua histori harga
            var allData = await _context.StockPrice.Where(c => c.StockID == stockID).OrderBy(c => c.Date).ToListAsync();

            var data = await _context.StockPrice.Where(c => c.StockID == stockID).OrderBy(c => c.Date).AsNoTracking().ToArrayAsync();

            int counter = 0;

            foreach (var price in allData)
            {
                //var data = _context.StockPrice.Where(c => c.StockID == stock.StockID && c.Date >= price.Date.AddMonths(-13)).OrderBy(c => c.Date).AsNoTracking();

                System.Diagnostics.Debug.WriteLine("TEST " + stockID + " " + counter.ToString());

                price.MA20         = Calculation.MA(counter, data, 20);
                data[counter].MA20 = price.MA20;

                price.MA60         = Calculation.MA(counter, data, 60);
                data[counter].MA60 = price.MA60;

                price.Support         = Calculation.Support(counter, data);
                data[counter].Support = price.Support;

                price.Resistance         = Calculation.Resistance(counter, data);
                data[counter].Resistance = price.Resistance;

                dynamic t3 = Calculation.HighestLowest(counter, data, 3);
                price.Highest3Months         = (t3 == null ? null : t3.Highest);
                data[counter].Highest3Months = price.Highest3Months;

                price.Lowest3Months         = (t3 == null ? null : t3.Lowest);
                data[counter].Lowest3Months = price.Lowest3Months;

                dynamic t6 = Calculation.HighestLowest(counter, data, 6);
                price.Highest6Months         = (t6 == null ? null : t6.Highest);
                data[counter].Highest6Months = price.Highest6Months;

                price.Lowest6Months         = (t6 == null ? null : t6.Lowest);
                data[counter].Lowest6Months = price.Lowest6Months;

                dynamic t12 = Calculation.HighestLowest(counter, data, 12);
                price.Highest12Months         = (t12 == null ? null : t12.Highest);
                data[counter].Highest12Months = price.Highest12Months;

                price.Lowest12Months         = (t12 == null ? null : t12.Lowest);
                data[counter].Lowest12Months = price.Lowest12Months;

                price.TrendHigh         = Calculation.TrendHigh(counter, data, price.Highest3Months, price.Highest6Months, price.Highest12Months);
                data[counter].TrendHigh = price.TrendHigh;

                price.TrendLow         = Calculation.TrendLow(counter, data, price.Lowest3Months, price.Lowest6Months, price.Lowest12Months);
                data[counter].TrendLow = price.TrendLow;

                price.EMA12         = Calculation.EMA(counter, data, 12);
                data[counter].EMA12 = price.EMA12;

                price.EMA26         = Calculation.EMA(counter, data, 26);
                data[counter].EMA26 = price.EMA26;


                if (price.EMA12 == null || price.EMA26 == null)
                {
                    price.MACD = null;
                }
                else
                {
                    price.MACD = price.EMA12 - price.EMA26;
                }

                data[counter].MACD = price.MACD;

                price.SignalLine         = Calculation.SignalLine(counter, data, 9);
                data[counter].SignalLine = price.SignalLine;

                if (price.MACD == null || price.SignalLine == null)
                {
                    price.GSLine = null;
                }
                else
                {
                    price.GSLine = (Decimal)(price.MACD + price.SignalLine) / 2;
                }
                data[counter].GSLine = price.GSLine;


                if (counter >= 1)
                {
                    if (price.GSLine != null && data[counter - 1].GSLine != null)
                    {
                        if (price.GSLine > data[counter - 1].GSLine)
                        {
                            price.GSLineDirection = "U";
                        }
                        else if (price.GSLine < data[counter - 1].GSLine)
                        {
                            price.GSLineDirection = "D";
                        }
                        else
                        {
                            price.GSLineDirection = "N";
                        }
                    }
                    else
                    {
                        price.GSLineDirection = "";
                    }
                }
                else
                {
                    price.GSLineDirection = "";
                }

                price.SD20         = Calculation.SD(counter, data, 20);
                data[counter].SD20 = price.SD20;

                if (price.Frequency > 0)
                {
                    price.BigWave = (Decimal)price.Volume / (Decimal)(price.Frequency * price.Frequency * price.Frequency);
                }
                else
                {
                    price.BigWave = 0;
                }

                data[counter].BigWave = price.BigWave;

                price.AverageBigWave         = Calculation.AverageBigWave(counter, data, 3);
                data[counter].AverageBigWave = price.AverageBigWave;


                price.BBUpper         = price.MA20 + 2 * price.SD20;
                data[counter].BBUpper = price.BBUpper;

                price.BBLower         = price.MA20 - 2 * price.SD20;
                data[counter].BBLower = price.BBLower;

                counter++;
            }
            await _context.SaveChangesAsync();

            return(true);
        }