public static void Import(string csv)
        {
            var csvMapper = new CsvMapper();
            //var csv = File.ReadAllText(@"D:\Dev\git\FatDividends\_documentation\D&E\earning_cba.csv");
            var mappings = new Dictionary<string, int>
                {
                    {"StockCode", 0},
                    {"Year", 1},
                    {"Period", 2},
                    {"ReportedDate", 3},
                    {"NPAT", 4},
                    {"Margin", 5},
                    {"CashFlow", 6},
                    {"EPS", 7},
                    {"DPS", 8},
                    {"ROE", 9}
                };

            var earnings = csvMapper.MapCsvTo<StockEarning>(mappings, csv, true);

            using (var service = new EarningService())
            {
                service.Add(earnings);
            }
        }
        public static void Import(string csv)
        {
            var csvMapper = new CsvMapper();
            var mappings = new Dictionary<string, int>
                {
                    {"StockCode", 0},
                    {"ExDate", 1},
                    {"Amount", 2},
                    {"Franked", 3},
                    {"FrankingCredit", 4},
                    {"PayableDate", 5}
                };

            var stockDividends = csvMapper.MapCsvTo<StockDividend>(mappings, csv, true).ToList();

            UpdateClosingPrices(stockDividends);

            using (var service = new DividendService())
            {
                service.Add(stockDividends);
            }
        }