public void Test_MSCI_Indexes_Daily_Security() { var x = new { indexType = indexType_DM, xmlPath = rootPath_DM, xsdClass = typeof(MSCIBarra_EquityIndex.package_D15D), xmlDataFile = "CORE_DM_ALL_SECURITY_MAIN_DAILY_D.xml" }; MSCIBarra_EquityIndex.package_D15D p = (MSCIBarra_EquityIndex.package_D15D) this.Test_package(x.xmlPath, x.xsdClass, PREFIX_DATE + x.xmlDataFile); Console.WriteLine("DATE;ISIN;SEDOL;CODE_RIC;CODE_BLOOM;NOM;PAYS;DEVISE;SECTEUR;SOUSSECTEUR;COURS Ouverture;COURS Cloture;FLOTTANT;ACTIF_NET;ACTIF_NET_USD;PERF_PRICE;PERF_PRICE_USD;PERF_GROSS;PERF_GROSS_USD;PERF_NET;PERF_NET_USD;FACTEUR_AJUSTEMENT_PRIX"); //Console.WriteLine("ALL: Nb of Securities: {0}", p.dataset_D15D.Count); foreach (MSCIBarra_EquityIndex.package_D15DEntry e in p.dataset_D15D) { //Console.WriteLine("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9}", e.calc_date, e.security_name, e.isin, e.price, e.price_ISO_currency_symbol, e.price_return_loc, e.bb_ticker, e.industry, e.ISO_country_symbol, e.sector); Console.WriteLine("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9};{10};{11};{12};{13};{14};{15};{16};{17};{18};{19};{20};{21}", String.Format("{0:dd/MM/yyyy}", e.calc_date), e.isin, e.sedol, e.RIC, e.bb_ticker, e.security_name, e.ISO_country_symbol, e.price_ISO_currency_symbol, e.sector, e.sub_industry, e.price, e.price, e.closing_number_of_shares, e.initial_mkt_cap_loc_next_day, e.initial_mkt_cap_usd_next_day, e.price_return_loc, e.price_return_usd, e.gross_return_loc, e.gross_return_usd, e.net_return_intl_loc, e.net_return_intl_usd, e.price_adjustment_factor); } }
private DataTable read(MSCIBarra_EquityIndex.package_D15D p) { DataTable DT = new DataTable("MSCI_D15D"); string columnsDef = "DATE;ISIN;SEDOL;CODE_RIC;CODE_BLOOM;NOM;PAYS;DEVISE;SECTEUR;SOUSSECTEUR;COURS Ouverture;COURS Cloture;FLOTTANT;ACTIF_NET;ACTIF_NET_USD;PERF_PRICE;PERF_PRICE_USD;PERF_GROSS;PERF_GROSS_USD;PERF_NET;PERF_NET_USD;FACTEUR_AJUSTEMENT_PRIX"; foreach (string c in columnsDef.Split(';')) { DT.Columns.Add(c); } //Console.WriteLine("ALL: Nb of Securities: {0}", p.dataset_D15D.Count); foreach (MSCIBarra_EquityIndex.package_D15DEntry e in p.dataset_D15D) { DT.Rows.Add(String.Format("{0:dd/MM/yyyy}", e.calc_date), e.isin, e.sedol, e.RIC, e.bb_ticker, e.security_name, e.ISO_country_symbol, e.price_ISO_currency_symbol, e.sector, e.sub_industry, e.price, e.price, e.closing_number_of_shares, e.initial_mkt_cap_loc_next_day, e.initial_mkt_cap_usd_next_day, e.price_return_loc, e.price_return_usd, e.gross_return_loc, e.gross_return_usd, e.net_return_intl_loc, e.net_return_intl_usd, e.price_adjustment_factor); //Console.WriteLine("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9}", e.calc_date, e.security_name, e.isin, e.price, e.price_ISO_currency_symbol, e.price_return_loc, e.bb_ticker, e.industry, e.ISO_country_symbol, e.sector); } return(DT); }
public void Test_MSCI_Indexes_Daily_Security_ZIPFile() { var x = new { indexType = indexType_DM, xmlPath = rootPath, xsdClass = typeof(MSCIBarra_EquityIndex.package_D15D), xmlDataFile = "CORE_DM_ALL_SECURITY_MAIN_DAILY_D.xml", zipDataFile = USED_DATE + @"core_dm_daily_d.zip" }; MSCIBarra_EquityIndex.package_D15D p = (MSCIBarra_EquityIndex.package_D15D) this.Test_packageZIP(x.xmlPath, x.xsdClass, x.zipDataFile, PREFIX_DATE + x.xmlDataFile); DataSet DS = new DataSet(); DS.Tables.Add(this.read(p)); String excel = @"C:\YYYYMMDDMSCI_Sec.xls"; DateTime now = DateTime.Now; excel = excel.Replace("YYYYMMDD", now.ToString("yyyyMMdd")); ExcelFile.CreateWorkbook(DS, excel); }