Esempio n. 1
0
        public static HistoricalDataBlock[] GetHistoricalDataBlock(string symbol, int window = 0)
        {
            HistoricalDataBlock[] historicalDataBlock = null;

            using (InvestmentAnalysisContext context = new InvestmentAnalysisContext())
            {
                if (0 == window)
                {
                    historicalDataBlock = context.HistoricalDataBlocks
                                          .Where(q => q.Symbol.Equals(symbol))
                                          .OrderByDescending(q => q.RecordDate)
                                          .ToArray();
                }
                else
                {
                    historicalDataBlock = context.HistoricalDataBlocks
                                          .Where(q => q.Symbol.Equals(symbol))
                                          .OrderByDescending(q => q.RecordDate)
                                          .Take(window)
                                          .ToArray();
                }
            }

            return(historicalDataBlock.Reverse().ToArray());
        }
Esempio n. 2
0
        public static ProfitGainLoss GetProfitGainLossInfo()
        {
            using (InvestmentAnalysisContext context = new InvestmentAnalysisContext())
            {
                context.Database.Initialize(false);
            }


            HistoricalDataBlock[] historicalData = HelperMethods.GetHistoricalDataBlock("GARAN");

            PeriodInfo _maxProfitPeriodInfo = new PeriodInfo {
                ProfitOrLoss = 0.00
            };
            PeriodInfo _maxLossPeriodInfo = new PeriodInfo {
                ProfitOrLoss = 0.00
            };

            double safe = 0.00;

            for (int fasterPeriod = 5; fasterPeriod < 31; fasterPeriod++)
            {
                for (int slowerPeriod = 8; slowerPeriod < 61; slowerPeriod++)
                {
                    if (fasterPeriod + 2 > slowerPeriod)
                    {
                        continue;
                    }
                    TotalTransactionInfo _totalTransactionInfo = GetTotalTransactionInfo("GARAN", historicalData, fasterPeriod, slowerPeriod);
                    safe = _totalTransactionInfo.safe;

                    if (safe > _maxProfitPeriodInfo.ProfitOrLoss)
                    {
                        _maxProfitPeriodInfo.FasterPeriod         = fasterPeriod;
                        _maxProfitPeriodInfo.SlowerPeriod         = slowerPeriod;
                        _maxProfitPeriodInfo.ProfitOrLoss         = safe;
                        _maxProfitPeriodInfo.totalTransactionInfo = _totalTransactionInfo;
                    }

                    if (safe < _maxLossPeriodInfo.ProfitOrLoss)
                    {
                        _maxLossPeriodInfo.FasterPeriod         = fasterPeriod;
                        _maxLossPeriodInfo.SlowerPeriod         = slowerPeriod;
                        _maxLossPeriodInfo.ProfitOrLoss         = safe;
                        _maxLossPeriodInfo.totalTransactionInfo = _totalTransactionInfo;
                    }
                }
            }

            Console.WriteLine(_maxLossPeriodInfo.ToString());
            Console.WriteLine(_maxLossPeriodInfo.ToString());

            return(new ProfitGainLoss {
                maxProfitPeriodInfo = _maxLossPeriodInfo, maxLossPeriodInfo = _maxLossPeriodInfo
            });
        }
Esempio n. 3
0
        /// <summary>
        /// FetchHistoricalData
        /// </summary>
        /// <param name="symbol">Financial Instrument Symbol</param>
        /// <param name="startDate">Format: YYYY.MM.dd</param>
        public static void FetchHistoricalData(DateTime startDate, DateTime endDate, string symbol, string name, string sector)
        {
            string date = endDate.ToString("yyyy.MM.dd");

            JArray dataArray = JArray.Parse(getData(symbol, date));

            DateTime controlDate = DateTime.MinValue;

            using (InvestmentAnalysisContext context = new InvestmentAnalysisContext())
            {
                context.Configuration.AutoDetectChangesEnabled = false;
                context.Configuration.ValidateOnSaveEnabled    = false;

                foreach (JToken data in dataArray.Children())
                {
                    controlDate = DateTime.Parse(data[5].Value <String>());

                    if (!(controlDate > startDate))
                    {
                        break;
                    }

                    HistoricalDataBlock historicalDataBlock = context.HistoricalDataBlocks.Where(q => q.Symbol.Equals(symbol) && q.RecordDate == controlDate).SingleOrDefault();

                    if (null == historicalDataBlock)
                    {
                        historicalDataBlock = new HistoricalDataBlock();

                        historicalDataBlock.Symbol     = symbol;
                        historicalDataBlock.Name       = name;
                        historicalDataBlock.Sector     = sector;
                        historicalDataBlock.MinPrice   = decimal.Parse(data[1].Value <string>());
                        historicalDataBlock.MaxPrice   = decimal.Parse(data[2].Value <string>());
                        historicalDataBlock.LastPrice  = decimal.Parse(data[3].Value <string>());
                        historicalDataBlock.Volume     = long.Parse(data[4].Value <String>().Remove(data[4].Value <String>().IndexOf(',')).Replace(".", ""));
                        historicalDataBlock.RecordDate = DateTime.Parse(data[5].Value <String>());

                        context.Entry(historicalDataBlock).State = System.Data.Entity.EntityState.Added;
                    }
                }

                context.SaveChanges();
            }

            if (controlDate > startDate)
            {
                FetchHistoricalData(startDate, controlDate, symbol, name, sector);
            }
        }
Esempio n. 4
0
        public static double[] CalculateRSI(string symbol, int window)
        {
            double[] closePrices = null;

            using (InvestmentAnalysisContext context = new InvestmentAnalysisContext())
            {
                closePrices = context.HistoricalDataBlocks
                              .Where(q => q.Symbol.Equals(symbol))
                              .OrderByDescending(q => q.RecordDate)
                              .Take(window)
                              .Select(c => (double)c.LastPrice)
                              .ToArray();
            }

            return(RelativeStrengthIndex.Calculate(closePrices.Reverse().ToArray()));
        }
Esempio n. 5
0
        public static double[] CalculateEMA(string symbol, int window, int period)
        {
            double[] closePrices = null;

            using (InvestmentAnalysisContext context = new InvestmentAnalysisContext())
            {
                closePrices = context.HistoricalDataBlocks
                              .Where(q => q.Symbol.Equals(symbol))
                              .OrderByDescending(q => q.RecordDate)
                              .Take(window)
                              .Select(c => (double)c.LastPrice)
                              .ToArray();
            }

            return(ExponentialMovingAverage.Calculate(closePrices.Reverse().ToArray(), period));
        }
Esempio n. 6
0
        public static void Main(string[] args)
        {
            using (InvestmentAnalysisContext context = new InvestmentAnalysisContext())
            {
                context.Database.Initialize(false);
            }

            DateTime startDate = new DateTime(2000, 1, 1);
            DateTime endDate   = new DateTime(2016, 12, 31);

            Stopwatch stopwatchLocal = null;

            Console.WriteLine("START");

            //Console.WriteLine("GARAN..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(new DateTime(2016, 12, 1), new DateTime(2016, 12, 31), "GARAN", "TÜRKİYE GARANTİ BANKASI A.Ş.", "Bankacılık");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("HALKB..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2007, 5, 31), "HALKB", "TÜRKİYE HALK BANKASI A.Ş.", "Bankacılık");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("AKBNK..");
            //stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "AKBNK", "AKBANK T.A.Ş.", "Bankacılık");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("VAKBN..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2005, 11, 30), "VAKBN", "TÜRKİYE VAKIFLAR BANKASI T.A.O.", "Bankacılık");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("ISCTR..");
            //stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "ISCTR", "TÜRKİYE İŞ BANKASI A.Ş.", "Bankacılık");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("YKBNK..");
            //stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "YKBNK", "YAPI VE KREDİ BANKASI A.Ş.", "Bankacılık");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("LOGO..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2000, 5, 30), "LOGO", "LOGO YAZILIM SANAYİ VE TİCARET A.Ş.", "Bilişim ve Teknoloji");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("NETAS..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "NETAS", "NETAŞ TELEKOMÜNİKASYON A.Ş.", "Bilişim ve Teknoloji");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("SISE..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, new DateTime(2006, 1, 31), "SISE", "TÜRKİYE ŞİŞE VE CAM FABRİKALARI A.Ş", "Cam ve Porselen");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("TRKCM..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "TRKCM", "TRAKYA CAM SANAYİİ A.Ş.", "Cam ve Porselen");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("ARCLK..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "ARCLK", "ARÇELİK A.Ş.", "Dayanıklı Tüketim Malları");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("VESBE..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2006, 4, 30), "VESBE", "VESTEL BEYAZ EŞYA SANAYİ VE TİCARET A.Ş.", "Dayanıklı Tüketim Malları");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("VESTL..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "VESTL", "VESTEL ELEKTRONİK SANAYİ VE TİCARET A.Ş.", "Dayanıklı Tüketim Malları");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("ADEL..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "ADEL", "ADEL KALEMCİLİK TİCARET VE SANAYİ A.Ş.", "Diğer İmalat");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("EKGYO..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2010, 12, 31), "EKGYO", "ENKA İNŞAAT VE SANAYİ A.Ş.", "Gayrimenkul Yatırım Ortaklıkları");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("CCOLA..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2006, 5, 31), "CCOLA", "COCA - COLA İÇECEK A.Ş.", "Gıda ve İçecek");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("ULKER..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "ULKER", "ÜLKER BİSKÜVİ SANAYİ A.Ş.", "Gıda ve İçecek");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("DOHOL..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "DOHOL", "DOĞAN ŞİRKETLER GRUBU HOLDİNG A.Ş.", "Holding");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("ECZYT..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, new DateTime(2000, 7, 31), "ECZYT", "ECZACIBAŞI YATIRIM HOLDİNG ORTAKLIĞI A.Ş.", "Holding");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("KCHOL..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "KCHOL", "KOÇ HOLDİNG A.Ş.", "Holding");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("SAHOL..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "SAHOL", "HACI ÖMER SABANCI HOLDİNG A.Ş.", "Holding");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("TKFEN..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2007, 11, 30), "TKFEN", "TEKFEN HOLDİNG A.Ş.", "Holding");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("ENKAI..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "ENKAI", "ENKA İNŞAAT VE SANAYİ A.Ş.", "İnşaat ve Bayındırlık");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("KARTN..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "KARTN", "KARTONSAN KARTON SANAYİ VE TİCARET A.Ş.", "Kağıt, Ambalaj, Matbaacılık ve Yayın");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("AKSA..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "AKSA", "AKSA AKRİLİK KİMYA SANAYİİ A.Ş.", "Kimya, Petrol ve Plastik");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("PETKM..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "PETKM", "PETKİM PETROKİMYA HOLDİNG A.Ş.", "Kimya, Petrol ve Plastik");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("SODA..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2000, 4, 30), "SODA", "SODA SANAYİİ A.Ş.", "Kimya, Petrol ve Plastik");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("TUPRS..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "TUPRS", "TÜPRAŞ-TÜRKİYE PETROL RAFİNERİLERİ A.Ş.", "Kimya, Petrol ve Plastik");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("KOZAL..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2010, 2, 28), "KOZAL", "KOZA ALTIN İŞLETMELERİ A.Ş.", "Madencilik");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("EREGL..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "EREGL", "EREĞLİ DEMİR VE ÇELİK FABRİKALARI T.A.Ş.", "Metal Ana Sanayi");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("DOAS..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2004, 6, 30), "DOAS", "DOĞUŞ OTOMOTİV SERVİS VE TİCARET A.Ş.", "Otomotiv Sanayii");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("FROTO..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, new DateTime(2014, 12, 31), "FROTO", "FORD OTOMOTİV SANAYİ A.Ş.", "Otomotiv Sanayii");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("OTKAR..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "OTKAR", "OTOKAR OTOMOTİV VE SAVUNMA SANAYİ A.Ş.", "Otomotiv Sanayii");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("TMSN..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2012, 12, 31), "TMSN", "TÜMOSAN MOTOR VE TRAKTÖR SANAYİ A.Ş", "Otomotiv Sanayii");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("TOASO..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "TOASO", "TOFAŞ TÜRK OTOMOBİL FABRİKASI A.Ş.", "Otomotiv Sanayii");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("TTRAK..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2004, 6, 30), "TTRAK", "TÜRK TRAKTÖR VE ZİRAAT MAKİNELERİ A.Ş.", "Otomotiv Sanayii");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("BRISA..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "BRISA", "BRİSA BRIDGESTONE SABANCI LASTİK SANAYİ VE TİCARET A.Ş.", "Otomotiv Yan Sanayi");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("EGEEN..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "EGEEN", "EGE ENDÜSTRİ VE TİCARET A.Ş.", "Otomotiv Yan Sanayi");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("GOODY..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "GOODY", "GOODYEAR LASTİKLERİ T.A.Ş.", "Otomotiv Yan Sanayi");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("PARSN..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2000, 1, 31), "PARSN", "PARSAN MAKİNA PARÇALARI SANAYİİ A.Ş", "Otomotiv Yan Sanayi");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("BIMAS..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2005, 7, 31), "BIMAS", "BİM BİRLEŞİK MAĞAZALAR A.Ş.", "Perakende Ticaret");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("MGROS..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "MGROS", "MİGROS TİCARET A.Ş.", "Perakende Ticaret");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("TKNSA..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2012, 5, 31), "TKNSA", "TEKNOSA İÇ VE DIŞ TİCARET A.Ş.", "Perakende Ticaret");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("ASELS..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "ASELS", "ASELSAN ELEKTRONİK SANAYİ VE TİCARET A.Ş.", "Savunma Sanayii");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("GUBRF..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "GUBRF", "GÜBRE FABRİKALARI T.A.Ş.", "Tarım, Ormancılık ve Hayvancılık");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("PGSUS..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2013, 4, 30), "PGSUS", "PEGASUS HAVA TAŞIMACILIĞI A.Ş.", "Ulaştırma ve Haberleşme");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("TAVHL..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2007, 2, 28), "TAVHL", "TAV HAVALİMANLARI HOLDİNG A.Ş.", "Ulaştırma ve Haberleşme");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("TCELL..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2000, 7, 31), "TCELL", "TURKCELL İLETİŞİM HİZMETLERİ A.Ş.", "Ulaştırma ve Haberleşme");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            //Console.WriteLine("THYAO..");
            //stopwatchLocal = new Stopwatch();stopwatchLocal.Start();
            //FetchManager.FetchHistoricalData(startDate, endDate, "THYAO", "TÜRK HAVA YOLLARI A.O.", "Ulaştırma ve Haberleşme");
            //stopwatchLocal.Stop();
            //Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("TTKOM..");
            stopwatchLocal = new Stopwatch(); stopwatchLocal.Start();
            FetchManager.FetchHistoricalData(startDate, new DateTime(2008, 5, 31), "TTKOM", "TÜRK TELEKOMÜNİKASYON A.Ş.", "Ulaştırma ve Haberleşme");
            stopwatchLocal.Stop();
            Console.WriteLine("Time elapsed: {0}", stopwatchLocal.Elapsed);

            Console.WriteLine("END");
        }