List of usage examples for org.apache.poi.ss.usermodel DataFormatter DataFormatter
public DataFormatter()
From source file:jdbc.Multiples.java
public static void run(String company) throws ClassNotFoundException, InstantiationException, IllegalAccessException, ParseException, Exception { Connection conn = null;/* www . j a v a 2 s . c om*/ String url = "jdbc:mysql://gator4185.hostgator.com:3306/"; String db = "vninvest_company"; String dbName = db + "?useUnicode=true&characterEncoding=UTF-8"; String driver = "com.mysql.jdbc.Driver"; String userName = "vninvest_admin"; String password = "c.Kz?gF]8t]G"; Statement statement = null; ResultSet result = null; PreparedStatement prestatement = null; String part = null; String part_change = null; String clause = null; Integer year = 2015; Double data_09 = 0.0; Double data_10 = 0.0; Double data_11 = 0.0; Double data_12 = 0.0; Double data_13 = 0.0; Double data_14 = 0.0; Double eat_09 = 0.0; Double eat_10 = 0.0; Double eat_11 = 0.0; Double eat_12 = 0.0; Double eat_13 = 0.0; Double eat_14 = 0.0; Double share_09 = 0.0; Double share_10 = 0.0; Double share_11 = 0.0; Double share_12 = 0.0; Double share_13 = 0.0; Double share_14 = 0.0; Double earn_09 = 0.0; Double earn_10 = 0.0; Double earn_11 = 0.0; Double earn_12 = 0.0; Double earn_13 = 0.0; Double earn_14 = 0.0; Double ev_09 = 0.0; Double ev_10 = 0.0; Double ev_11 = 0.0; Double ev_12 = 0.0; Double ev_13 = 0.0; Double ev_14 = 0.0; Integer n = 0; Integer b = 0; String output_09 = null; String output_10 = null; String output_11 = null; String output_12 = null; String output_13 = null; String output_14 = null; String dtt_09 = null; String dtt_10 = null; String dtt_11 = null; String dtt_12 = null; String dtt_13 = null; String dtt_14 = null; String sn_09 = null; String sn_10 = null; String sn_11 = null; String sn_12 = null; String sn_13 = null; String sn_14 = null; String stock_09 = null; String stock_10 = null; String stock_11 = null; String stock_12 = null; String stock_13 = null; String stock_14 = null; String div_09 = null; String div_10 = null; String div_11 = null; String div_12 = null; String div_13 = null; String div_14 = null; String ebit_09 = null; String ebit_10 = null; String ebit_11 = null; String ebit_12 = null; String ebit_13 = null; String ebit_14 = null; String cf_09 = null; String cf_10 = null; String cf_11 = null; String cf_12 = null; String cf_13 = null; String cf_14 = null; String lst_09 = null; String lst_10 = null; String lst_11 = null; String lst_12 = null; String lst_13 = null; String lst_14 = null; Double wc_09 = null; Double wc_10 = null; Double wc_11 = null; Double wc_12 = null; Double wc_13 = null; Double wc_14 = null; String ta_09 = null; String ta_10 = null; String ta_11 = null; String ta_12 = null; String ta_13 = null; String ta_14 = null; String td_09 = null; String td_10 = null; String td_11 = null; String td_12 = null; String td_13 = null; String td_14 = null; String std_09 = null; String std_10 = null; String std_11 = null; String std_12 = null; String std_13 = null; String std_14 = null; String cb_09 = null; String cb_10 = null; String cb_11 = null; String cb_12 = null; String cb_13 = null; String cb_14 = null; Double ebt_09 = 0.0; Double ebt_10 = 0.0; Double ebt_11 = 0.0; Double ebt_12 = 0.0; Double ebt_13 = 0.0; Double change_09 = 0.0; Double change_10 = 0.0; Double change_11 = 0.0; Double change_12 = 0.0; Double change_13 = 0.0; Double t_09 = 0.0; Double t_10 = 0.0; Double t_11 = 0.0; Double t_12 = 0.0; Double t_13 = 0.0; String ctcvmcp_09 = ""; String ctcvmcp_10 = ""; String ctcvmcp_11 = ""; String ctcvmcp_12 = ""; String ctcvmcp_13 = ""; String g_10 = ""; String g_11 = ""; String g_12 = ""; String g_13 = ""; String g_14 = ""; String tttphcp_09 = ""; String tttphcp_10 = ""; String tttphcp_11 = ""; String tttphcp_12 = ""; String tttphcp_13 = ""; String vcsh_09 = ""; String vcsh_10 = ""; String vcsh_11 = ""; String vcsh_12 = ""; String vcsh_13 = ""; String ebitda_09 = ""; String ebitda_10 = ""; String ebitda_11 = ""; String ebitda_12 = ""; String ebitda_13 = ""; String ebitda_14 = ""; DataFormatter fmt = new DataFormatter(); NumberFormat nf = NumberFormat.getInstance(Locale.FRANCE); try { Multiples obj = new Multiples(); Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url + dbName, userName, password); statement = conn.createStatement(); add_company(conn, prestatement, company); FileInputStream file_FI = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\All\\" + company + "_FI.xlsx")); XSSFWorkbook workbook_FI = new XSSFWorkbook(file_FI); XSSFSheet sheet_FI = workbook_FI.getSheetAt(0); Iterator<Row> rowIterator_FI = sheet_FI.iterator(); FileInputStream file_IS = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\All\\" + company + "_IS.xlsx")); XSSFWorkbook workbook_IS = new XSSFWorkbook(file_IS); XSSFSheet sheet_IS = workbook_IS.getSheetAt(0); Iterator<Row> rowIterator_IS = sheet_IS.iterator(); FileInputStream file_CFS = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\All\\" + company + "_CFS.xlsx")); XSSFWorkbook workbook_CFS = new XSSFWorkbook(file_CFS); XSSFSheet sheet_CFS = workbook_CFS.getSheetAt(0); Iterator<Row> rowIterator_CFS = sheet_CFS.iterator(); FileInputStream file_BS = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\All\\" + company + "_BS.xlsx")); XSSFWorkbook workbook_BS = new XSSFWorkbook(file_BS); XSSFSheet sheet_BS = workbook_BS.getSheetAt(0); Iterator<Row> rowIterator_BS = sheet_BS.iterator(); // Read Financial Index b = 0; part = "_FI"; while (rowIterator_FI.hasNext()) { Row row = rowIterator_FI.next(); n = 0; b = b + 1; if (b == 6) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_14 = fmt.formatCellValue(cell); if ("-".equals(stock_14) || "".equals(stock_14)) { stock_14 = "0.0"; } break; } if (n == 4) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } n = 5; } if (n == 3) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 4; } if (n == 2) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 3; } if (n == 1) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 9) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { div_14 = fmt.formatCellValue(cell); if ("-".equals(div_14) || "".equals(div_14)) { div_14 = "0.0"; } break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); div_13 = fmt.formatCellValue(cell); if ("-".equals(div_13) || "".equals(div_13)) { div_13 = "0.0"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); div_12 = fmt.formatCellValue(cell); if ("-".equals(div_12) || "".equals(div_12)) { div_12 = "0.0"; } n = 4; } if (n == 2) { div_11 = fmt.formatCellValue(cell); if ("-".equals(div_11) || "".equals(div_11)) { div_11 = "0.0"; } n = 3; } if (n == 1) { div_10 = fmt.formatCellValue(cell); if ("-".equals(div_10) || "".equals(div_10)) { div_10 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 5) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { output_14 = fmt.formatCellValue(cell); if ("-".equals(output_14) || "".equals(output_14)) { output_14 = "0.0"; } g_10 = output_10; g_11 = output_11; g_12 = output_12; g_13 = output_13; g_14 = output_14; break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); output_13 = fmt.formatCellValue(cell); if ("-".equals(output_13) || "".equals(output_13)) { output_13 = "0.0"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); output_12 = fmt.formatCellValue(cell); if ("-".equals(output_12) || "".equals(output_12)) { output_12 = "0.0"; } n = 4; } if (n == 2) { output_11 = fmt.formatCellValue(cell); if ("-".equals(output_11) || "".equals(output_11)) { output_11 = "0.0"; } n = 3; } if (n == 1) { output_10 = fmt.formatCellValue(cell); if ("-".equals(output_10) || "".equals(output_10)) { output_10 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } share_10 = Double.parseDouble(rs(stock_10)); if ("0.0".equals(stock_11)) { stock_11 = stock_10; } if ("0.0".equals(stock_12)) { stock_12 = stock_11; } if ("0.0".equals(stock_13)) { stock_13 = stock_12; } if ("0.0".equals(stock_14)) { stock_14 = stock_13; } share_11 = Double.parseDouble(rs(stock_11)); share_12 = Double.parseDouble(rs(stock_12)); share_13 = Double.parseDouble(rs(stock_13)); share_14 = Double.parseDouble(rs(stock_14)); earn_10 = Double.parseDouble(rs(div_10)); earn_11 = Double.parseDouble(rs(div_11)); earn_12 = Double.parseDouble(rs(div_12)); earn_13 = Double.parseDouble(rs(div_13)); earn_14 = Double.parseDouble(rs(div_14)); Double dps_09 = earn_10 * 1000; Double dps_10 = earn_10 * 1000; Double dps_11 = earn_11 * 1000; Double dps_12 = earn_12 * 1000; Double dps_13 = earn_13 * 1000; // Read Income Statement b = 0; part = "_Mult_IS"; while (rowIterator_IS.hasNext()) { Row row = rowIterator_IS.next(); n = 0; b = b + 1; if (b == 23) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { ebit_13 = fmt.formatCellValue(cell); if ("-".equals(ebit_13) || "".equals(ebit_13)) { ebit_13 = "0.0"; } break; } if (n == 4) { ebit_12 = fmt.formatCellValue(cell); if ("-".equals(ebit_12) || "".equals(ebit_12)) { ebit_12 = "0.0"; } n = 5; } if (n == 3) { ebit_11 = fmt.formatCellValue(cell); if ("-".equals(ebit_11) || "".equals(ebit_11)) { ebit_11 = "0.0"; } n = 4; } if (n == 2) { ebit_10 = fmt.formatCellValue(cell); if ("-".equals(ebit_10) || "".equals(ebit_10)) { ebit_10 = "0.0"; } n = 3; } if (n == 1) { ebit_10 = fmt.formatCellValue(cell); if ("-".equals(ebit_09) || "".equals(ebit_09)) { ebit_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 22) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ebitda_09 = stock_09; ebitda_10 = stock_10; ebitda_11 = stock_11; ebitda_12 = stock_12; ebitda_13 = stock_13; System.out.println(stock_13); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 18) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } eat_09 = Double.parseDouble(rs(stock_09)); eat_10 = Double.parseDouble(rs(stock_10)); eat_11 = Double.parseDouble(rs(stock_11)); eat_12 = Double.parseDouble(rs(stock_12)); eat_13 = Double.parseDouble(rs(stock_13)); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 16) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); t_09 = abs(Double.parseDouble(stock_09)) / ebt_09; t_10 = abs(Double.parseDouble(stock_10)) / ebt_10; t_11 = abs(Double.parseDouble(stock_11)) / ebt_11; t_12 = abs(Double.parseDouble(stock_12)) / ebt_12; t_13 = abs(Double.parseDouble(stock_13)) / ebt_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 15) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_09+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13); // add_data(conn,prestatement,company,part,clause,stock_13,stock_12,stock_11,stock_10,stock_09); // if (Double.parseDouble(rs(stock_09)) <= 20000) { // t_09 = 0.2; // } else { // t_09 = 0.22; // } // if (Double.parseDouble(rs(stock_10)) <= 20000) { // t_10 = 0.2; // }else { // t_10 = 0.22; // } // if (Double.parseDouble(rs(stock_11)) <= 20000) { // t_11 = 0.2; // } else { // t_11 = 0.22; // } // if (Double.parseDouble(rs(stock_12)) <= 20000) { // t_12 = 0.2; // } else { // t_12 = 0.22; // } // if (Double.parseDouble(rs(stock_13)) <= 20000) { // t_13 = 0.2; // } else { // t_09 = 0.22; // } ebt_09 = abs(Double.parseDouble(rs(stock_09))); ebt_10 = abs(Double.parseDouble(rs(stock_10))); ebt_11 = abs(Double.parseDouble(rs(stock_11))); ebt_12 = abs(Double.parseDouble(rs(stock_12))); ebt_13 = abs(Double.parseDouble(rs(stock_13))); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 4) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); String gvbh_09 = stock_09; String gvbh_10 = stock_10; String gvbh_11 = stock_11; String gvbh_12 = stock_12; String gvbh_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 3) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); dtt_09 = stock_09; dtt_10 = stock_10; dtt_11 = stock_11; dtt_12 = stock_12; dtt_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b < 23 && b > 3) { Iterator<Cell> cellIterator = row.cellIterator(); n = 0; while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { // data_13 = cell.getNumericCellValue(); stock_13 = fmt.formatCellValue(cell); // output_13 = cell.getStringCellValue(); if ("-".equals(stock_13) || "".equals(stock_13)) { // data_13 = 0.0; stock_13 = "N/A"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // n = 0; break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { // data_12 = 0.0; stock_12 = "N/A"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { // data_11 = 0.0; stock_11 = "N/A"; } n = 4; } if (n == 2) { // data_10 = cell.getNumericCellValue(); stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { // data_10 = 0.0; stock_10 = "N/A"; } n = 3; } if (n == 1) { // data_09 = cell.getNumericCellValue(); stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { // data_09 = 0.0; stock_09 = "N/A"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } Double eps_09 = eat_09 / share_10 * 1000000; Double eps_10 = eat_10 / share_11 * 1000000; Double eps_11 = eat_11 / share_12 * 1000000; Double eps_12 = eat_12 / share_13 * 1000000; Double eps_13 = eat_13 / share_14 * 1000000; Double peps_09 = obj.close_price(company, year - 4) / eps_09 * 1000; Double peps_10 = obj.close_price(company, year - 3) / eps_10 * 1000; Double peps_11 = obj.close_price(company, year - 2) / eps_11 * 1000; Double peps_12 = obj.close_price(company, year - 1) / eps_12 * 1000; Double peps_13 = obj.close_price(company, year) / eps_13 * 1000; // Reading Balance Sheet part = "_Mult_BS"; b = 0; while (rowIterator_BS.hasNext()) { Row row = rowIterator_BS.next(); n = 0; b = b + 1; if (b == 62) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); vcsh_09 = stock_09; vcsh_10 = stock_10; vcsh_11 = stock_11; vcsh_12 = stock_12; vcsh_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 42) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); std_09 = stock_09; std_10 = stock_10; std_11 = stock_11; std_12 = stock_12; std_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 41) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); td_09 = stock_09; td_10 = stock_10; td_11 = stock_11; td_12 = stock_12; td_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 37) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ta_09 = stock_09; ta_10 = stock_10; ta_11 = stock_11; ta_12 = stock_12; ta_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 4) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); div_09 = stock_09; div_10 = stock_10; div_11 = stock_11; div_12 = stock_12; div_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b < 83 && b > 3) { n = 0; Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { // data_13 = cell.getNumericCellValue(); output_13 = fmt.formatCellValue(cell); // output_13 = cell.getStringCellValue(); if ("-".equals(output_13) || "".equals(output_13)) { // data_13 = 0.0; output_13 = "N/A"; } if ("N/A".equals(output_09)) { stock_09 = "0.0"; } else { stock_09 = output_09; } if ("N/A".equals(output_10)) { stock_10 = "0.0"; } else { stock_10 = output_10; } if ("N/A".equals(output_11)) { stock_11 = "0.0"; } else { stock_11 = output_11; } if ("N/A".equals(output_12)) { stock_12 = "0.0"; } else { stock_12 = output_12; } if ("N/A".equals(output_13)) { stock_13 = "0.0"; } else { stock_13 = output_13; } // change_10 = (Double.parseDouble(rs(stock_10)) - Double.parseDouble(rs(stock_09)))/Double.parseDouble(rs(stock_09))*100; // change_11 = (Double.parseDouble(rs(stock_11)) - Double.parseDouble(rs(stock_10)))/Double.parseDouble(rs(stock_10))*100; // change_12 = (Double.parseDouble(rs(stock_12)) - Double.parseDouble(rs(stock_11)))/Double.parseDouble(rs(stock_11))*100; // change_13 = (Double.parseDouble(rs(stock_13)) - Double.parseDouble(rs(stock_12)))/Double.parseDouble(rs(stock_12))*100; // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); output_12 = fmt.formatCellValue(cell); if ("-".equals(output_12) || "".equals(output_12)) { // data_12 = 0.0; output_12 = "N/A"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); output_11 = fmt.formatCellValue(cell); if ("-".equals(output_11) || "".equals(output_11)) { // data_11 = 0.0; output_11 = "N/A"; } n = 4; } if (n == 2) { // data_10 = cell.getNumericCellValue(); output_10 = fmt.formatCellValue(cell); if ("-".equals(output_10) || "".equals(output_10)) { // data_10 = 0.0; output_10 = "N/A"; } n = 3; } if (n == 1) { // data_09 = cell.getNumericCellValue(); output_09 = fmt.formatCellValue(cell); if ("-".equals(output_09) || "".equals(output_09)) { // data_09 = 0.0; output_09 = "N/A"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } wc_09 = (Double.parseDouble(rs(div_09)) - Double.parseDouble(rs(std_09))) * 1000000; wc_10 = (Double.parseDouble(rs(div_10)) - Double.parseDouble(rs(std_10))) * 1000000; wc_11 = (Double.parseDouble(rs(div_11)) - Double.parseDouble(rs(std_11))) * 1000000; wc_12 = (Double.parseDouble(rs(div_12)) - Double.parseDouble(rs(std_12))) * 1000000; wc_13 = (Double.parseDouble(rs(div_13)) - Double.parseDouble(rs(std_13))) * 1000000; Double bvps_09 = Double.parseDouble(rs(vcsh_09)) / share_10 * 1000000; Double bvps_10 = Double.parseDouble(rs(vcsh_10)) / share_10 * 1000000; Double bvps_11 = Double.parseDouble(rs(vcsh_11)) / share_11 * 1000000; Double bvps_12 = Double.parseDouble(rs(vcsh_12)) / share_12 * 1000000; Double bvps_13 = Double.parseDouble(rs(vcsh_13)) / share_13 * 1000000; Double pbvps_09 = obj.close_price(company, year - 4) / bvps_09 * 1000; Double pbvps_10 = obj.close_price(company, year - 3) / bvps_10 * 1000; Double pbvps_11 = obj.close_price(company, year - 2) / bvps_11 * 1000; Double pbvps_12 = obj.close_price(company, year - 1) / bvps_12 * 1000; Double pbvps_13 = obj.close_price(company, year) / bvps_13 * 1000; ev_13 = obj.close_price(company, year) / share_13 * 1000; // Read Cash Flow Statement part = "_FINA_CFS"; b = 0; while (rowIterator_CFS.hasNext()) { Row row = rowIterator_CFS.next(); n = 0; b = b + 1; if (b == 41) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 39) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_13)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 38) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 37) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 31) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ctcvmcp_09 = stock_09; ctcvmcp_10 = stock_10; ctcvmcp_11 = stock_11; ctcvmcp_12 = stock_12; ctcvmcp_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 30) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); tttphcp_09 = stock_09; tttphcp_10 = stock_10; tttphcp_11 = stock_11; tttphcp_12 = stock_12; tttphcp_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 29) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } //////////////////////////////////////////////////// ///////////////////////////////////////////////// if (b == 21) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } cf_09 = stock_09; cf_10 = stock_10; cf_11 = stock_11; cf_12 = stock_12; cf_13 = stock_13; if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } //////////////////////////////////////////////////// ///////////////////////////////////////////////// if (b == 18) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); // add_data(conn,prestatement,company,part,clause,stock_13,stock_12,stock_11,stock_10,stock_09); // add_change(conn,prestatement,company,part_change,clause,Double.toString(change_13),Double.toString(change_12),Double.toString(change_11),Double.toString(change_10),"N/A"); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 12) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 5) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); div_09 = stock_09; div_10 = stock_10; div_11 = stock_11; div_12 = stock_12; div_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } Double cfps_09 = Double.parseDouble(rs(cf_09)) / share_10 * 1000000; Double cfps_10 = Double.parseDouble(rs(cf_10)) / share_11 * 1000000; Double cfps_11 = Double.parseDouble(rs(cf_11)) / share_12 * 1000000; Double cfps_12 = Double.parseDouble(rs(cf_12)) / share_13 * 1000000; Double cfps_13 = Double.parseDouble(rs(cf_13)) / share_14 * 1000000; Double sps_09 = Double.parseDouble(rs(dtt_09)) / share_10 * 1000000; Double sps_10 = Double.parseDouble(rs(dtt_10)) / share_10 * 1000000; Double sps_11 = Double.parseDouble(rs(dtt_11)) / share_11 * 1000000; Double sps_12 = Double.parseDouble(rs(dtt_12)) / share_12 * 1000000; Double sps_13 = Double.parseDouble(rs(dtt_13)) / share_13 * 1000000; Double pcfps_09 = obj.close_price(company, year - 4) / cfps_09 * 1000; Double pcfps_10 = obj.close_price(company, year - 3) / cfps_10 * 1000; Double pcfps_11 = obj.close_price(company, year - 2) / cfps_11 * 1000; Double pcfps_12 = obj.close_price(company, year - 1) / cfps_12 * 1000; Double pcfps_13 = obj.close_price(company, year) / cfps_13 * 1000; Double psps_09 = obj.close_price(company, year - 4) / sps_09 * 1000; Double psps_10 = obj.close_price(company, year - 3) / sps_10 * 1000; Double psps_11 = obj.close_price(company, year - 2) / sps_11 * 1000; Double psps_12 = obj.close_price(company, year - 1) / sps_12 * 1000; Double psps_13 = obj.close_price(company, year) / sps_13 * 1000; // System.out.println(cfps_09+" , "+cfps_10+" , "+cfps_11+" , "+cfps_12+" , "+cfps_13); Double fcfps_09 = 0.0; Double fcfps_10 = Double.parseDouble(rs(ebit_10)) * (1 - t_10) * 1000000 + Double.parseDouble(rs(div_10)) * 1000000 - (wc_10 - wc_09) - (Double.parseDouble(rs(ta_10)) - Double.parseDouble(rs(ta_09))) * 1000000 + (Double.parseDouble(rs(td_10)) - Double.parseDouble(rs(td_09))) * 1000000; Double fcfps_11 = Double.parseDouble(rs(ebit_11)) * (1 - t_11) * 1000000 + Double.parseDouble(rs(div_11)) * 1000000 - (wc_11 - wc_10) - (Double.parseDouble(rs(ta_11)) - Double.parseDouble(rs(ta_10))) * 1000000 + (Double.parseDouble(rs(td_11)) - Double.parseDouble(rs(td_10))) * 1000000; Double fcfps_12 = Double.parseDouble(rs(ebit_12)) * (1 - t_12) * 1000000 + Double.parseDouble(rs(div_12)) * 1000000 - (wc_12 - wc_11) - (Double.parseDouble(rs(ta_12)) - Double.parseDouble(rs(ta_11))) * 1000000 + (Double.parseDouble(rs(td_12)) - Double.parseDouble(rs(td_11))) * 1000000; Double fcfps_13 = Double.parseDouble(rs(ebit_13)) * (1 - t_13) * 1000000 + Double.parseDouble(rs(div_13)) * 1000000 - (wc_13 - wc_12) - (Double.parseDouble(rs(ta_13)) - Double.parseDouble(rs(ta_12))) * 1000000 + (Double.parseDouble(rs(td_13)) - Double.parseDouble(rs(td_12))) * 1000000; Double pfcfps_09 = 0.0; Double pfcfps_10 = obj.close_price(company, year - 3) / fcfps_10 * 1000; Double pfcfps_11 = obj.close_price(company, year - 2) / fcfps_11 * 1000; Double pfcfps_12 = obj.close_price(company, year - 1) / fcfps_12 * 1000; Double pfcfps_13 = obj.close_price(company, year) / fcfps_13 * 1000; Double yield_09 = dps_09 / obj.close_price(company, year - 4) / 1000 * 100; Double yield_10 = dps_10 / obj.close_price(company, year - 3) / 1000 * 100; Double yield_11 = dps_11 / obj.close_price(company, year - 2) / 1000 * 100; Double yield_12 = dps_12 / obj.close_price(company, year - 1) / 1000 * 100; Double yield_13 = dps_13 / obj.close_price(company, year) / 1000 * 100; if (g_12 == "0.0") { g_12 = g_13; } if (g_11 == "0.0") { g_11 = g_12; } if (g_10 == "0.0") { g_10 = g_11; } Double bby_09 = 0.0; Double bby_10 = Double.parseDouble(rs(ctcvmcp_10)) / (Double.parseDouble(rs(g_10)) * share_10); Double bby_11 = Double.parseDouble(rs(ctcvmcp_11)) / (Double.parseDouble(rs(g_11)) * share_11); Double bby_12 = Double.parseDouble(rs(ctcvmcp_12)) / (Double.parseDouble(rs(g_12)) * share_12); Double bby_13 = Double.parseDouble(rs(ctcvmcp_13)) / (Double.parseDouble(rs(g_13)) * share_13); Double shy_09 = 0.0; Double shy_10 = (dps_10 + Double.parseDouble(rs(ctcvmcp_10)) - Double.parseDouble(rs(tttphcp_10))) / (Double.parseDouble(rs(g_10)) * share_10); Double shy_11 = (dps_11 + Double.parseDouble(rs(ctcvmcp_11)) - Double.parseDouble(rs(tttphcp_11))) / (Double.parseDouble(rs(g_11)) * share_11); Double shy_12 = (dps_12 + Double.parseDouble(rs(ctcvmcp_12)) - Double.parseDouble(rs(tttphcp_12))) / (Double.parseDouble(rs(g_12)) * share_12); Double shy_13 = (dps_13 + Double.parseDouble(rs(ctcvmcp_13)) - Double.parseDouble(rs(tttphcp_13))) / (Double.parseDouble(rs(g_13)) * share_13); Double evebitda_09 = 0.0; Double evebitda_10 = (Double.parseDouble(rs(g_10)) * share_10) / Double.parseDouble(rs(ebitda_10)); Double evebitda_11 = (Double.parseDouble(rs(g_11)) * share_11) / Double.parseDouble(rs(ebitda_11)); Double evebitda_12 = (Double.parseDouble(rs(g_12)) * share_12) / Double.parseDouble(rs(ebitda_12)); Double evebitda_13 = (Double.parseDouble(rs(g_13)) * share_13) / Double.parseDouble(rs(ebitda_13)); add_data(conn, prestatement, company, "Price/Earning per share", Double.toString(peps_13), Double.toString(peps_12), Double.toString(peps_11), Double.toString(peps_10), Double.toString(peps_09)); add_data(conn, prestatement, company, "Price/Book value per share", Double.toString(pbvps_13), Double.toString(pbvps_12), Double.toString(pbvps_11), Double.toString(pbvps_10), Double.toString(pbvps_09)); add_data(conn, prestatement, company, "Price/Sales per share", Double.toString(psps_13), Double.toString(psps_12), Double.toString(psps_11), Double.toString(psps_10), Double.toString(psps_09)); add_data(conn, prestatement, company, "Price/Cash Flow per share", Double.toString(pcfps_13), Double.toString(pcfps_12), Double.toString(pcfps_11), Double.toString(pcfps_10), Double.toString(pcfps_09)); add_data(conn, prestatement, company, "Price/Free Cash Flow per share", Double.toString(pfcfps_13), Double.toString(pfcfps_12), Double.toString(pfcfps_11), Double.toString(pfcfps_10), Double.toString(pfcfps_09)); add_data(conn, prestatement, company, "Yield", Double.toString(yield_13), Double.toString(yield_12), Double.toString(yield_11), Double.toString(yield_10), Double.toString(yield_09)); add_data(conn, prestatement, company, "Buy Back Yield", Double.toString(bby_13), Double.toString(bby_12), Double.toString(bby_11), Double.toString(bby_10), Double.toString(bby_09)); add_data(conn, prestatement, company, "Share Holder Yield", Double.toString(shy_13), Double.toString(shy_12), Double.toString(shy_11), Double.toString(shy_10), Double.toString(shy_09)); add_data(conn, prestatement, company, "Enterprise value/EBITDA", Double.toString(evebitda_13), Double.toString(evebitda_12), Double.toString(evebitda_11), Double.toString(evebitda_10), Double.toString(evebitda_09)); file_BS.close(); file_CFS.close(); file_FI.close(); file_IS.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) try { conn.close(); } catch (Exception ignore) { } if (statement != null) try { statement.close(); } catch (Exception ignore) { } if (result != null) try { result.close(); } catch (Exception ignore) { } if (prestatement != null) try { prestatement.close(); } catch (Exception ignore) { } } }
From source file:jdbc.Ratio.java
public static void run(String company) throws ClassNotFoundException, InstantiationException, IllegalAccessException, ParseException, Exception { Connection conn = null;//w ww. j a va 2 s .c om String url = "jdbc:mysql://gator4185.hostgator.com:3306/"; String db = "vninvest_company"; String dbName = db + "?useUnicode=true&characterEncoding=UTF-8"; String driver = "com.mysql.jdbc.Driver"; String userName = "vninvest_admin"; String password = "c.Kz?gF]8t]G"; Statement statement = null; ResultSet result = null; PreparedStatement prestatement = null; String part = null; String part_change = null; String clause = null; String ctcvmcp_09 = ""; String ctcvmcp_10 = ""; String ctcvmcp_11 = ""; String ctcvmcp_12 = ""; String ctcvmcp_13 = ""; String g_10 = ""; String g_11 = ""; String g_12 = ""; String g_13 = ""; String g_14 = ""; String lg_09 = ""; String lg_10 = ""; String lg_11 = ""; String lg_12 = ""; String lg_13 = ""; String gvbh_09 = ""; String gvbh_10 = ""; String gvbh_11 = ""; String gvbh_12 = ""; String gvbh_13 = ""; String ltd_09 = ""; String ltd_10 = ""; String ltd_11 = ""; String ltd_12 = ""; String ltd_13 = ""; String cptlv_09 = ""; String cptlv_10 = ""; String cptlv_11 = ""; String cptlv_12 = ""; String cptlv_13 = ""; String vvcq_09 = ""; String vvcq_10 = ""; String vvcq_11 = ""; String vvcq_12 = ""; String vvcq_13 = ""; String lcpp_09 = ""; String lcpp_10 = ""; String lcpp_11 = ""; String lcpp_12 = ""; String lcpp_13 = ""; String tttphcp_09 = ""; String tttphcp_10 = ""; String tttphcp_11 = ""; String tttphcp_12 = ""; String tttphcp_13 = ""; String ebitda_09 = ""; String ebitda_10 = ""; String ebitda_11 = ""; String ebitda_12 = ""; String ebitda_13 = ""; String ebitda_14 = ""; Double data_09 = 0.0; Double data_10 = 0.0; Double data_11 = 0.0; Double data_12 = 0.0; Double data_13 = 0.0; Double data_14 = 0.0; Double share_09 = 0.0; Double share_10 = 0.0; Double share_11 = 0.0; Double share_12 = 0.0; Double share_13 = 0.0; Double share_14 = 0.0; Double earn_09 = 0.0; Double earn_10 = 0.0; Double earn_11 = 0.0; Double earn_12 = 0.0; Double earn_13 = 0.0; Double earn_14 = 0.0; Double ev_09 = 0.0; Double ev_10 = 0.0; Double ev_11 = 0.0; Double ev_12 = 0.0; Double ev_13 = 0.0; Double ev_14 = 0.0; Integer n = 0; Integer b = 0; String output_09 = null; String output_10 = null; String output_11 = null; String output_12 = null; String output_13 = null; String output_14 = null; String dtt_09 = null; String dtt_10 = null; String dtt_11 = null; String dtt_12 = null; String dtt_13 = null; String dtt_14 = null; String ckpt_09 = null; String ckpt_10 = null; String ckpt_11 = null; String ckpt_12 = null; String ckpt_13 = null; String ckpt_14 = null; String htk_09 = null; String htk_10 = null; String htk_11 = null; String htk_12 = null; String htk_13 = null; String htk_14 = null; String vcsh_09 = null; String vcsh_10 = null; String vcsh_11 = null; String vcsh_12 = null; String vcsh_13 = null; String vcsh_14 = null; String sn_09 = null; String sn_10 = null; String sn_11 = null; String sn_12 = null; String sn_13 = null; String sn_14 = null; String stock_09 = null; String stock_10 = null; String stock_11 = null; String stock_12 = null; String stock_13 = null; String stock_14 = null; String div_09 = null; String div_10 = null; String div_11 = null; String div_12 = null; String div_13 = null; String div_14 = null; String ebit_09 = null; String ebit_10 = null; String ebit_11 = null; String ebit_12 = null; String ebit_13 = null; String ebit_14 = null; String cf_09 = null; String cf_10 = null; String cf_11 = null; String cf_12 = null; String cf_13 = null; String cf_14 = null; String sta_09 = null; String sta_10 = null; String sta_11 = null; String sta_12 = null; String sta_13 = null; String sta_14 = null; Double wc_09 = null; Double wc_10 = null; Double wc_11 = null; Double wc_12 = null; Double wc_13 = null; Double wc_14 = null; String ta_09 = null; String ta_10 = null; String ta_11 = null; String ta_12 = null; String ta_13 = null; String ta_14 = null; String td_09 = null; String td_10 = null; String td_11 = null; String td_12 = null; String td_13 = null; String td_14 = null; String std_09 = null; String std_10 = null; String std_11 = null; String std_12 = null; String std_13 = null; String std_14 = null; String cb_09 = null; String cb_10 = null; String cb_11 = null; String cb_12 = null; String cb_13 = null; String cb_14 = null; Double ebt_09 = 0.0; Double ebt_10 = 0.0; Double ebt_11 = 0.0; Double ebt_12 = 0.0; Double ebt_13 = 0.0; Double eat_09 = 0.0; Double eat_10 = 0.0; Double eat_11 = 0.0; Double eat_12 = 0.0; Double eat_13 = 0.0; Double change_09 = 0.0; Double change_10 = 0.0; Double change_11 = 0.0; Double change_12 = 0.0; Double change_13 = 0.0; Double t_09 = 0.0; Double t_10 = 0.0; Double t_11 = 0.0; Double t_12 = 0.0; Double t_13 = 0.0; DataFormatter fmt = new DataFormatter(); NumberFormat nf = NumberFormat.getInstance(Locale.FRANCE); try { Ratio obj = new Ratio(); Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url + dbName, userName, password); statement = conn.createStatement(); FileInputStream file_FI = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\" + company + "_FI.xlsx")); XSSFWorkbook workbook_FI = new XSSFWorkbook(file_FI); XSSFSheet sheet_FI = workbook_FI.getSheetAt(0); Iterator<Row> rowIterator_FI = sheet_FI.iterator(); FileInputStream file_IS = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\" + company + "_IS.xlsx")); XSSFWorkbook workbook_IS = new XSSFWorkbook(file_IS); XSSFSheet sheet_IS = workbook_IS.getSheetAt(0); Iterator<Row> rowIterator_IS = sheet_IS.iterator(); FileInputStream file_CFS = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\" + company + "_CFS.xlsx")); XSSFWorkbook workbook_CFS = new XSSFWorkbook(file_CFS); XSSFSheet sheet_CFS = workbook_CFS.getSheetAt(0); Iterator<Row> rowIterator_CFS = sheet_CFS.iterator(); FileInputStream file_BS = new FileInputStream( new File("C:\\Users\\tri\\Desktop\\busi\\data\\" + company + "_BS.xlsx")); XSSFWorkbook workbook_BS = new XSSFWorkbook(file_BS); XSSFSheet sheet_BS = workbook_BS.getSheetAt(0); Iterator<Row> rowIterator_BS = sheet_BS.iterator(); // Read Financial Index b = 0; part = "_FI"; while (rowIterator_FI.hasNext()) { Row row = rowIterator_FI.next(); n = 0; b = b + 1; if (b == 6) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_14 = fmt.formatCellValue(cell); if ("-".equals(stock_14) || "".equals(stock_14)) { stock_14 = "0.0"; } break; } if (n == 4) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } n = 5; } if (n == 3) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 4; } if (n == 2) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 3; } if (n == 1) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 9) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { div_14 = fmt.formatCellValue(cell); if ("-".equals(div_14) || "".equals(div_14)) { div_14 = "0.0"; } break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); div_13 = fmt.formatCellValue(cell); if ("-".equals(div_13) || "".equals(div_13)) { div_13 = "0.0"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); div_12 = fmt.formatCellValue(cell); if ("-".equals(div_12) || "".equals(div_12)) { div_12 = "0.0"; } n = 4; } if (n == 2) { div_11 = fmt.formatCellValue(cell); if ("-".equals(div_11) || "".equals(div_11)) { div_11 = "0.0"; } n = 3; } if (n == 1) { div_10 = fmt.formatCellValue(cell); if ("-".equals(div_10) || "".equals(div_10)) { div_10 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 5) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { output_14 = fmt.formatCellValue(cell); if ("-".equals(output_14) || "".equals(output_14)) { output_14 = "0.0"; } g_10 = output_10; g_11 = output_11; g_12 = output_12; g_13 = output_13; g_14 = output_14; break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); output_13 = fmt.formatCellValue(cell); if ("-".equals(output_13) || "".equals(output_13)) { output_13 = "0.0"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); output_12 = fmt.formatCellValue(cell); if ("-".equals(output_12) || "".equals(output_12)) { output_12 = "0.0"; } n = 4; } if (n == 2) { output_11 = fmt.formatCellValue(cell); if ("-".equals(output_11) || "".equals(output_11)) { output_11 = "0.0"; } n = 3; } if (n == 1) { output_10 = fmt.formatCellValue(cell); if ("-".equals(output_10) || "".equals(output_10)) { output_10 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } share_10 = Double.parseDouble(rs(stock_10)); if ("0.0".equals(stock_11)) { stock_11 = stock_10; } if ("0.0".equals(stock_12)) { stock_12 = stock_11; } if ("0.0".equals(stock_13)) { stock_13 = stock_12; } if ("0.0".equals(stock_14)) { stock_14 = stock_13; } share_11 = Double.parseDouble(rs(stock_11)); share_12 = Double.parseDouble(rs(stock_12)); share_13 = Double.parseDouble(rs(stock_13)); share_14 = Double.parseDouble(rs(stock_14)); earn_10 = Double.parseDouble(rs(div_10)); earn_11 = Double.parseDouble(rs(div_11)); earn_12 = Double.parseDouble(rs(div_12)); earn_13 = Double.parseDouble(rs(div_13)); earn_14 = Double.parseDouble(rs(div_14)); Double dps_09 = earn_10 * 1000; Double dps_10 = earn_10 * 1000; Double dps_11 = earn_11 * 1000; Double dps_12 = earn_12 * 1000; Double dps_13 = earn_13 * 1000; // Read Income Statement b = 0; part = "_Mult_IS"; add_company(conn, prestatement, company); while (rowIterator_IS.hasNext()) { Row row = rowIterator_IS.next(); n = 0; b = b + 1; if (b == 23) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { ebit_13 = fmt.formatCellValue(cell); if ("-".equals(ebit_13) || "".equals(ebit_13)) { ebit_13 = "0.0"; } // System.out.println(clause+" , "+ebit_13); break; } if (n == 4) { ebit_12 = fmt.formatCellValue(cell); if ("-".equals(ebit_12) || "".equals(ebit_12)) { ebit_12 = "0.0"; } n = 5; } if (n == 3) { ebit_11 = fmt.formatCellValue(cell); if ("-".equals(ebit_11) || "".equals(ebit_11)) { ebit_11 = "0.0"; } n = 4; } if (n == 2) { ebit_10 = fmt.formatCellValue(cell); if ("-".equals(ebit_10) || "".equals(ebit_10)) { ebit_10 = "0.0"; } n = 3; } if (n == 1) { ebit_09 = fmt.formatCellValue(cell); if ("-".equals(ebit_09) || "".equals(ebit_09)) { ebit_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 22) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ebitda_09 = stock_09; ebitda_10 = stock_10; ebitda_11 = stock_11; ebitda_12 = stock_12; ebitda_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 18) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } eat_09 = Double.parseDouble(rs(stock_09)); eat_10 = Double.parseDouble(rs(stock_10)); eat_11 = Double.parseDouble(rs(stock_11)); eat_12 = Double.parseDouble(rs(stock_12)); eat_13 = Double.parseDouble(rs(stock_13)); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 16) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); t_09 = abs(Double.parseDouble(stock_09)) / ebt_09; t_10 = abs(Double.parseDouble(stock_10)) / ebt_10; t_11 = abs(Double.parseDouble(stock_11)) / ebt_11; t_12 = abs(Double.parseDouble(stock_12)) / ebt_12; t_13 = abs(Double.parseDouble(stock_13)) / ebt_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 15) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_09+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13); // add_data(conn,prestatement,company,part,clause,stock_13,stock_12,stock_11,stock_10,stock_09); // if (Double.parseDouble(rs(stock_09)) <= 20000) { // t_09 = 0.2; // } else { // t_09 = 0.22; // } // if (Double.parseDouble(rs(stock_10)) <= 20000) { // t_10 = 0.2; // }else { // t_10 = 0.22; // } // if (Double.parseDouble(rs(stock_11)) <= 20000) { // t_11 = 0.2; // } else { // t_11 = 0.22; // } // if (Double.parseDouble(rs(stock_12)) <= 20000) { // t_12 = 0.2; // } else { // t_12 = 0.22; // } // if (Double.parseDouble(rs(stock_13)) <= 20000) { // t_13 = 0.2; // } else { // t_09 = 0.22; // } ebt_09 = abs(Double.parseDouble(rs(stock_09))); ebt_10 = abs(Double.parseDouble(rs(stock_10))); ebt_11 = abs(Double.parseDouble(rs(stock_11))); ebt_12 = abs(Double.parseDouble(rs(stock_12))); ebt_13 = abs(Double.parseDouble(rs(stock_13))); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 8) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); cptlv_09 = stock_09; cptlv_10 = stock_10; cptlv_11 = stock_11; cptlv_12 = stock_12; cptlv_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 6) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); lg_09 = stock_09; lg_10 = stock_10; lg_11 = stock_11; lg_12 = stock_12; lg_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 4) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); gvbh_09 = stock_09; gvbh_10 = stock_10; gvbh_11 = stock_11; gvbh_12 = stock_12; gvbh_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 3) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); dtt_09 = stock_09; dtt_10 = stock_10; dtt_11 = stock_11; dtt_12 = stock_12; dtt_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b < 23 && b > 3) { Iterator<Cell> cellIterator = row.cellIterator(); n = 0; while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { // data_13 = cell.getNumericCellValue(); stock_13 = fmt.formatCellValue(cell); // output_13 = cell.getStringCellValue(); if ("-".equals(stock_13) || "".equals(stock_13)) { // data_13 = 0.0; stock_13 = "N/A"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // n = 0; break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { // data_12 = 0.0; stock_12 = "N/A"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { // data_11 = 0.0; stock_11 = "N/A"; } n = 4; } if (n == 2) { // data_10 = cell.getNumericCellValue(); stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { // data_10 = 0.0; stock_10 = "N/A"; } n = 3; } if (n == 1) { // data_09 = cell.getNumericCellValue(); stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { // data_09 = 0.0; stock_09 = "N/A"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } Double eps_09 = eat_09 / share_10 * 1000000; Double eps_10 = eat_10 / share_11 * 1000000; Double eps_11 = eat_11 / share_12 * 1000000; Double eps_12 = eat_12 / share_13 * 1000000; Double eps_13 = eat_13 / share_14 * 1000000; Double peps_09 = obj.close_price(company, 2010) / eps_09 * 1000; Double peps_10 = obj.close_price(company, 2011) / eps_10 * 1000; Double peps_11 = obj.close_price(company, 2012) / eps_11 * 1000; Double peps_12 = obj.close_price(company, 2013) / eps_12 * 1000; Double peps_13 = obj.close_price(company, 2014) / eps_13 * 1000; // Reading Balance Sheet part = "_Mult_BS"; b = 0; while (rowIterator_BS.hasNext()) { Row row = rowIterator_BS.next(); n = 0; b = b + 1; if (b == 77) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); lcpp_09 = stock_09; lcpp_10 = stock_10; lcpp_11 = stock_11; lcpp_12 = stock_12; lcpp_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 63) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); vvcq_09 = stock_09; vvcq_10 = stock_10; vvcq_11 = stock_11; vvcq_12 = stock_12; vvcq_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 62) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); vcsh_09 = stock_09; vcsh_10 = stock_10; vcsh_11 = stock_11; vcsh_12 = stock_12; vcsh_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 53) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" ," +stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ltd_09 = stock_09; ltd_10 = stock_10; ltd_11 = stock_11; ltd_12 = stock_12; ltd_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 42) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" ," +stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); std_09 = stock_09; std_10 = stock_10; std_11 = stock_11; std_12 = stock_12; std_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 41) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+ " ,"+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); td_09 = stock_09; td_10 = stock_10; td_11 = stock_11; td_12 = stock_12; td_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 37) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ta_09 = stock_09; ta_10 = stock_10; ta_11 = stock_11; ta_12 = stock_12; ta_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 8) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); htk_09 = stock_09; htk_10 = stock_10; htk_11 = stock_11; htk_12 = stock_12; htk_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 7) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ckpt_09 = stock_09; ckpt_10 = stock_10; ckpt_11 = stock_11; ckpt_12 = stock_12; ckpt_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 4) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(clause+" , "+stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); sta_09 = stock_09; sta_10 = stock_10; sta_11 = stock_11; sta_12 = stock_12; sta_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b < 83 && b > 3) { n = 0; Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { // data_13 = cell.getNumericCellValue(); output_13 = fmt.formatCellValue(cell); // output_13 = cell.getStringCellValue(); if ("-".equals(output_13) || "".equals(output_13)) { // data_13 = 0.0; output_13 = "N/A"; } break; } if (n == 4) { // data_12 = cell.getNumericCellValue(); output_12 = fmt.formatCellValue(cell); if ("-".equals(output_12) || "".equals(output_12)) { // data_12 = 0.0; output_12 = "N/A"; } n = 5; } if (n == 3) { // data_11 = cell.getNumericCellValue(); output_11 = fmt.formatCellValue(cell); if ("-".equals(output_11) || "".equals(output_11)) { // data_11 = 0.0; output_11 = "N/A"; } n = 4; } if (n == 2) { // data_10 = cell.getNumericCellValue(); output_10 = fmt.formatCellValue(cell); if ("-".equals(output_10) || "".equals(output_10)) { // data_10 = 0.0; output_10 = "N/A"; } n = 3; } if (n == 1) { // data_09 = cell.getNumericCellValue(); output_09 = fmt.formatCellValue(cell); if ("-".equals(output_09) || "".equals(output_09)) { // data_09 = 0.0; output_09 = "N/A"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } wc_09 = (Double.parseDouble(rs(sta_09)) - Double.parseDouble(rs(std_09))) * 1000000; wc_10 = (Double.parseDouble(rs(sta_10)) - Double.parseDouble(rs(std_10))) * 1000000; wc_11 = (Double.parseDouble(rs(sta_11)) - Double.parseDouble(rs(std_11))) * 1000000; wc_12 = (Double.parseDouble(rs(sta_12)) - Double.parseDouble(rs(std_12))) * 1000000; wc_13 = (Double.parseDouble(rs(sta_13)) - Double.parseDouble(rs(std_13))) * 1000000; Double bvps_09 = Double.parseDouble(rs(vcsh_09)) / share_10 * 1000000; Double bvps_10 = Double.parseDouble(rs(vcsh_10)) / share_10 * 1000000; Double bvps_11 = Double.parseDouble(rs(vcsh_11)) / share_11 * 1000000; Double bvps_12 = Double.parseDouble(rs(vcsh_12)) / share_12 * 1000000; Double bvps_13 = Double.parseDouble(rs(vcsh_13)) / share_13 * 1000000; Double pbvps_09 = obj.close_price(company, 2010) / bvps_09 * 1000; Double pbvps_10 = obj.close_price(company, 2011) / bvps_10 * 1000; Double pbvps_11 = obj.close_price(company, 2012) / bvps_11 * 1000; Double pbvps_12 = obj.close_price(company, 2013) / bvps_12 * 1000; Double pbvps_13 = obj.close_price(company, 2014) / bvps_13 * 1000; ev_13 = obj.close_price(company, 2014) / share_13 * 1000; // System.out.println(ev_13); // Read Cash Flow Statement part = "_FINA_CFS"; add_company(conn, prestatement, company); b = 0; while (rowIterator_CFS.hasNext()) { Row row = rowIterator_CFS.next(); n = 0; b = b + 1; if (b == 41) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 39) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_13)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 38) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 37) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 31) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); ctcvmcp_09 = stock_09; ctcvmcp_10 = stock_10; ctcvmcp_11 = stock_11; ctcvmcp_12 = stock_12; ctcvmcp_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 30) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); tttphcp_09 = stock_09; tttphcp_10 = stock_10; tttphcp_11 = stock_11; tttphcp_12 = stock_12; tttphcp_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 29) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } //////////////////////////////////////////////////// ///////////////////////////////////////////////// if (b == 21) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } cf_09 = stock_09; cf_10 = stock_10; cf_11 = stock_11; cf_12 = stock_12; cf_13 = stock_13; if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } //////////////////////////////////////////////////// ///////////////////////////////////////////////// if (b == 18) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); // add_data(conn,prestatement,company,part,clause,stock_13,stock_12,stock_11,stock_10,stock_09); // add_change(conn,prestatement,company,part_change,clause,Double.toString(change_13),Double.toString(change_12),Double.toString(change_11),Double.toString(change_10),"N/A"); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 12) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } if (b == 5) { Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); if (n == 5) { stock_13 = fmt.formatCellValue(cell); if ("-".equals(stock_13) || "".equals(stock_13)) { stock_13 = "0.0"; } if ("N/A".equals(stock_09)) { output_09 = "0.0"; change_10 = 0.0; } else { output_09 = stock_09; } if ("N/A".equals(stock_10)) { output_10 = "0.0"; } else { output_10 = stock_10; } if ("N/A".equals(stock_11)) { output_11 = "0.0"; } else { output_11 = stock_11; } if ("N/A".equals(stock_12)) { output_12 = "0.0"; } else { output_12 = stock_12; } if ("N/A".equals(stock_13)) { output_13 = "0.0"; } else { output_13 = stock_13; } if (("N/A".equals(stock_09) && "N/A".equals(stock_10)) || "N/A".equals(stock_09)) { change_10 = 0.0; } else { change_10 = (Double.parseDouble(rs(output_10)) - Double.parseDouble(rs(output_09))) / Double.parseDouble(rs(output_09)) * 100; } if (("N/A".equals(stock_10) && "N/A".equals(stock_11)) || "N/A".equals(stock_11)) { change_11 = 0.0; } else { change_11 = (Double.parseDouble(rs(output_11)) - Double.parseDouble(rs(output_10))) / Double.parseDouble(rs(output_10)) * 100; } if ("N/A".equals(stock_11) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_12 = 0.0; } else { change_12 = (Double.parseDouble(rs(output_12)) - Double.parseDouble(rs(output_11))) / Double.parseDouble(rs(output_11)) * 100; } if ("N/A".equals(stock_13) && "N/A".equals(stock_12) || "N/A".equals(stock_11)) { change_13 = 0.0; } else { change_13 = (Double.parseDouble(rs(output_13)) - Double.parseDouble(rs(output_12))) / Double.parseDouble(rs(output_12)) * 100; } // System.out.println(stock_10+" , "+stock_11+" , "+stock_12+" , "+stock_13+" , "+stock_14); div_09 = stock_09; div_10 = stock_10; div_11 = stock_11; div_12 = stock_12; div_13 = stock_13; break; } if (n == 4) { stock_12 = fmt.formatCellValue(cell); if ("-".equals(stock_12) || "".equals(stock_12)) { stock_12 = "0.0"; } n = 5; } if (n == 3) { stock_11 = fmt.formatCellValue(cell); if ("-".equals(stock_11) || "".equals(stock_11)) { stock_11 = "0.0"; } n = 4; } if (n == 2) { stock_10 = fmt.formatCellValue(cell); if ("-".equals(stock_10) || "".equals(stock_10)) { stock_10 = "0.0"; } n = 3; } if (n == 1) { stock_09 = fmt.formatCellValue(cell); if ("-".equals(stock_09) || "".equals(stock_09)) { stock_09 = "0.0"; } n = 2; } if (n == 0) { clause = fmt.formatCellValue(cell); n = 1; } } } } Double cfps_09 = Double.parseDouble(rs(cf_09)) / share_10 * 1000000; Double cfps_10 = Double.parseDouble(rs(cf_10)) / share_11 * 1000000; Double cfps_11 = Double.parseDouble(rs(cf_11)) / share_12 * 1000000; Double cfps_12 = Double.parseDouble(rs(cf_12)) / share_13 * 1000000; Double cfps_13 = Double.parseDouble(rs(cf_13)) / share_14 * 1000000; Double sps_09 = Double.parseDouble(rs(dtt_09)) / share_10 * 1000000; Double sps_10 = Double.parseDouble(rs(dtt_10)) / share_10 * 1000000; Double sps_11 = Double.parseDouble(rs(dtt_11)) / share_11 * 1000000; Double sps_12 = Double.parseDouble(rs(dtt_12)) / share_12 * 1000000; Double sps_13 = Double.parseDouble(rs(dtt_13)) / share_13 * 1000000; Double pcfps_09 = obj.close_price(company, 2010) / cfps_09 * 1000; Double pcfps_10 = obj.close_price(company, 2011) / cfps_10 * 1000; Double pcfps_11 = obj.close_price(company, 2012) / cfps_11 * 1000; Double pcfps_12 = obj.close_price(company, 2013) / cfps_12 * 1000; Double pcfps_13 = obj.close_price(company, 2014) / cfps_13 * 1000; Double psps_09 = obj.close_price(company, 2010) / sps_09 * 1000; Double psps_10 = obj.close_price(company, 2011) / sps_10 * 1000; Double psps_11 = obj.close_price(company, 2012) / sps_11 * 1000; Double psps_12 = obj.close_price(company, 2013) / sps_12 * 1000; Double psps_13 = obj.close_price(company, 2014) / sps_13 * 1000; // System.out.println(cfps_09+" , "+cfps_10+" , "+cfps_11+" , "+cfps_12+" , "+cfps_13); Double fcfps_09 = 0.0; Double fcfps_10 = Double.parseDouble(rs(ebit_10)) * (1 - t_10) * 1000000 + Double.parseDouble(rs(div_10)) * 1000000 - (wc_10 - wc_09) - (Double.parseDouble(rs(ta_10)) - Double.parseDouble(rs(ta_09))) * 1000000 + (Double.parseDouble(rs(td_10)) - Double.parseDouble(rs(td_09))) * 1000000; Double fcfps_11 = Double.parseDouble(rs(ebit_11)) * (1 - t_11) * 1000000 + Double.parseDouble(rs(div_11)) * 1000000 - (wc_11 - wc_10) - (Double.parseDouble(rs(ta_11)) - Double.parseDouble(rs(ta_10))) * 1000000 + (Double.parseDouble(rs(td_11)) - Double.parseDouble(rs(td_10))) * 1000000; Double fcfps_12 = Double.parseDouble(rs(ebit_12)) * (1 - t_12) * 1000000 + Double.parseDouble(rs(div_12)) * 1000000 - (wc_12 - wc_11) - (Double.parseDouble(rs(ta_12)) - Double.parseDouble(rs(ta_11))) * 1000000 + (Double.parseDouble(rs(td_12)) - Double.parseDouble(rs(td_11))) * 1000000; Double fcfps_13 = Double.parseDouble(rs(ebit_13)) * (1 - t_13) * 1000000 + Double.parseDouble(rs(div_13)) * 1000000 - (wc_13 - wc_12) - (Double.parseDouble(rs(ta_13)) - Double.parseDouble(rs(ta_12))) * 1000000 + (Double.parseDouble(rs(td_13)) - Double.parseDouble(rs(td_12))) * 1000000; Double pfcfps_09 = 0.0; Double pfcfps_10 = obj.close_price(company, 2011) / fcfps_10 * 1000; Double pfcfps_11 = obj.close_price(company, 2012) / fcfps_11 * 1000; Double pfcfps_12 = obj.close_price(company, 2013) / fcfps_12 * 1000; Double pfcfps_13 = obj.close_price(company, 2014) / fcfps_13 * 1000; Double yield_09 = dps_09 / obj.close_price(company, 2010) / 1000 * 100; Double yield_10 = dps_10 / obj.close_price(company, 2011) / 1000 * 100; Double yield_11 = dps_11 / obj.close_price(company, 2012) / 1000 * 100; Double yield_12 = dps_12 / obj.close_price(company, 2013) / 1000 * 100; Double yield_13 = dps_13 / obj.close_price(company, 2014) / 1000 * 100; if (g_12 == "0.0") { g_12 = g_13; } if (g_11 == "0.0") { g_11 = g_12; } if (g_10 == "0.0") { g_10 = g_11; } Double bby_10 = Double.parseDouble(rs(ctcvmcp_10)) / (Double.parseDouble(rs(g_10)) * share_10); Double bby_11 = Double.parseDouble(rs(ctcvmcp_11)) / (Double.parseDouble(rs(g_11)) * share_11); Double bby_12 = Double.parseDouble(rs(ctcvmcp_12)) / (Double.parseDouble(rs(g_12)) * share_12); Double bby_13 = Double.parseDouble(rs(ctcvmcp_13)) / (Double.parseDouble(rs(g_13)) * share_13); Double shy_10 = (dps_10 + Double.parseDouble(rs(ctcvmcp_10)) - Double.parseDouble(rs(tttphcp_10))) / (Double.parseDouble(rs(g_10)) * share_10); Double shy_11 = (dps_11 + Double.parseDouble(rs(ctcvmcp_11)) - Double.parseDouble(rs(tttphcp_11))) / (Double.parseDouble(rs(g_11)) * share_11); Double shy_12 = (dps_12 + Double.parseDouble(rs(ctcvmcp_12)) - Double.parseDouble(rs(tttphcp_12))) / (Double.parseDouble(rs(g_12)) * share_12); Double shy_13 = (dps_13 + Double.parseDouble(rs(ctcvmcp_13)) - Double.parseDouble(rs(tttphcp_13))) / (Double.parseDouble(rs(g_13)) * share_13); Double evebitda_10 = (Double.parseDouble(rs(g_10)) * share_10) / Double.parseDouble(rs(ebitda_10)); Double evebitda_11 = (Double.parseDouble(rs(g_11)) * share_11) / Double.parseDouble(rs(ebitda_11)); Double eveebitda_12 = (Double.parseDouble(rs(g_12)) * share_12) / Double.parseDouble(rs(ebitda_12)); Double eveebitda_13 = (Double.parseDouble(rs(g_13)) * share_13) / Double.parseDouble(rs(ebitda_13)); Double gpm_09 = Double.parseDouble(rs(lg_09)) / Double.parseDouble(rs(dtt_09)); Double gpm_10 = Double.parseDouble(rs(lg_10)) / Double.parseDouble(rs(dtt_10)); Double gpm_11 = Double.parseDouble(rs(lg_11)) / Double.parseDouble(rs(dtt_11)); Double gpm_12 = Double.parseDouble(rs(lg_12)) / Double.parseDouble(rs(dtt_12)); Double gpm_13 = Double.parseDouble(rs(lg_13)) / Double.parseDouble(rs(dtt_13)); Double om_09 = Double.parseDouble(rs(ebit_09)) * 1000 / Double.parseDouble(rs(dtt_09)); Double om_10 = Double.parseDouble(rs(ebit_10)) * 1000 / Double.parseDouble(rs(dtt_10)); Double om_11 = Double.parseDouble(rs(ebit_11)) * 1000 / Double.parseDouble(rs(dtt_11)); Double om_12 = Double.parseDouble(rs(ebit_12)) * 1000 / Double.parseDouble(rs(dtt_12)); Double om_13 = Double.parseDouble(rs(ebit_13)) * 1000 / Double.parseDouble(rs(dtt_13)); Double npm_09 = eat_09 / Double.parseDouble(rs(dtt_09)); Double npm_10 = eat_10 / Double.parseDouble(rs(dtt_10)); Double npm_11 = eat_11 / Double.parseDouble(rs(dtt_11)); Double npm_12 = eat_12 / Double.parseDouble(rs(dtt_12)); Double npm_13 = eat_13 / Double.parseDouble(rs(dtt_13)); Double roa_09 = eat_09 / Double.parseDouble(rs(ta_09)); Double roa_10 = eat_10 / Double.parseDouble(rs(ta_10)); Double roa_11 = eat_11 / Double.parseDouble(rs(ta_11)); Double roa_12 = eat_12 / Double.parseDouble(rs(ta_12)); Double roa_13 = eat_13 / Double.parseDouble(rs(ta_13)); Double roe_09 = eat_09 / Double.parseDouble(rs(vcsh_09)); Double roe_10 = eat_10 / Double.parseDouble(rs(vcsh_10)); Double roe_11 = eat_11 / Double.parseDouble(rs(vcsh_11)); Double roe_12 = eat_12 / Double.parseDouble(rs(vcsh_12)); Double roe_13 = eat_13 / Double.parseDouble(rs(vcsh_13)); Double qr_09 = (Double.parseDouble(rs(sta_09)) - Double.parseDouble(rs(htk_09))) / Double.parseDouble(rs(std_09)); Double qr_10 = (Double.parseDouble(rs(sta_10)) - Double.parseDouble(rs(htk_10))) / Double.parseDouble(rs(std_10)); Double qr_11 = (Double.parseDouble(rs(sta_11)) - Double.parseDouble(rs(htk_11))) / Double.parseDouble(rs(std_11)); Double qr_12 = (Double.parseDouble(rs(sta_12)) - Double.parseDouble(rs(htk_12))) / Double.parseDouble(rs(std_12)); Double qr_13 = (Double.parseDouble(rs(sta_13)) - Double.parseDouble(rs(htk_13))) / Double.parseDouble(rs(std_13)); Double cr_09 = Double.parseDouble(rs(sta_09)) / Double.parseDouble(rs(std_09)); Double cr_10 = Double.parseDouble(rs(sta_10)) / Double.parseDouble(rs(std_10)); Double cr_11 = Double.parseDouble(rs(sta_11)) / Double.parseDouble(rs(std_11)); Double cr_12 = Double.parseDouble(rs(sta_12)) / Double.parseDouble(rs(std_12)); Double cr_13 = Double.parseDouble(rs(sta_13)) / Double.parseDouble(rs(std_13)); Double pr_09 = dps_09 / eps_09; Double pr_10 = dps_10 / eps_10; Double pr_11 = dps_11 / eps_11; Double pr_12 = dps_12 / eps_12; Double pr_13 = dps_13 / eps_13; Double tie_09 = Double.parseDouble(rs(ebit_09)) / Double.parseDouble(rs(cptlv_09)); Double tie_10 = Double.parseDouble(rs(ebit_10)) / Double.parseDouble(rs(cptlv_10)); Double tie_11 = Double.parseDouble(rs(ebit_11)) / Double.parseDouble(rs(cptlv_11)); Double tie_12 = Double.parseDouble(rs(ebit_12)) / Double.parseDouble(rs(cptlv_12)); Double tie_13 = Double.parseDouble(rs(ebit_13)) / Double.parseDouble(rs(cptlv_13)); part = "DEBT MANAGEMENT"; Double tlta_09 = Double.parseDouble(rs(td_09)) / Double.parseDouble(rs(ta_09)); Double tlta_10 = Double.parseDouble(rs(td_10)) / Double.parseDouble(rs(ta_10)); Double tlta_11 = Double.parseDouble(rs(td_11)) / Double.parseDouble(rs(ta_11)); Double tlta_12 = Double.parseDouble(rs(td_12)) / Double.parseDouble(rs(ta_12)); Double tlta_13 = Double.parseDouble(rs(td_13)) / Double.parseDouble(rs(ta_13)); Double ltdte_09 = Double.parseDouble(rs(ltd_09)) / Double.parseDouble(rs(vcsh_09)); Double ltdte_10 = Double.parseDouble(rs(ltd_10)) / Double.parseDouble(rs(vcsh_10)); Double ltdte_11 = Double.parseDouble(rs(ltd_11)) / Double.parseDouble(rs(vcsh_11)); Double ltdte_12 = Double.parseDouble(rs(ltd_12)) / Double.parseDouble(rs(vcsh_12)); Double ltdte_13 = Double.parseDouble(rs(ltd_13)) / Double.parseDouble(rs(vcsh_13)); Double ltdtc_09 = Double.parseDouble(rs(ltd_09)) / (Double.parseDouble(rs(ltd_09)) + Double.parseDouble(rs(vvcq_09))); Double ltdtc_10 = Double.parseDouble(rs(ltd_10)) / (Double.parseDouble(rs(ltd_10)) + Double.parseDouble(rs(vvcq_10))); Double ltdtc_11 = Double.parseDouble(rs(ltd_11)) / (Double.parseDouble(rs(ltd_11)) + Double.parseDouble(rs(vvcq_11))); Double ltdtc_12 = Double.parseDouble(rs(ltd_12)) / (Double.parseDouble(rs(ltd_12)) + Double.parseDouble(rs(vvcq_12))); Double ltdtc_13 = Double.parseDouble(rs(ltd_13)) / (Double.parseDouble(rs(ltd_13)) + Double.parseDouble(rs(vvcq_13))); part = "ASSET MANAGEMENT"; Double rt_09 = Double.parseDouble(rs(lg_09)) / (Double.parseDouble(rs(ckpt_09))); Double rt_10 = Double.parseDouble(rs(lg_10)) / ((Double.parseDouble(rs(ckpt_10)) + Double.parseDouble(rs(ckpt_09))) / 2); Double rt_11 = Double.parseDouble(rs(lg_11)) / ((Double.parseDouble(rs(ckpt_11)) + Double.parseDouble(rs(ckpt_10))) / 2); Double rt_12 = Double.parseDouble(rs(lg_12)) / ((Double.parseDouble(rs(ckpt_12)) + Double.parseDouble(rs(ckpt_11))) / 2); Double rt_13 = Double.parseDouble(rs(lg_13)) / ((Double.parseDouble(rs(ckpt_13)) + Double.parseDouble(rs(ckpt_12))) / 2); Double it_09 = Double.parseDouble(rs(gvbh_09)) / (Double.parseDouble(rs(htk_09))); Double it_10 = Double.parseDouble(rs(gvbh_10)) / ((Double.parseDouble(rs(htk_10)) + Double.parseDouble(rs(htk_09))) / 2); Double it_11 = Double.parseDouble(rs(gvbh_11)) / ((Double.parseDouble(rs(htk_11)) + Double.parseDouble(rs(htk_10))) / 2); Double it_12 = Double.parseDouble(rs(gvbh_12)) / ((Double.parseDouble(rs(htk_12)) + Double.parseDouble(rs(htk_11))) / 2); Double it_13 = Double.parseDouble(rs(gvbh_13)) / ((Double.parseDouble(rs(htk_13)) + Double.parseDouble(rs(htk_12))) / 2); Double at_09 = Double.parseDouble(rs(dtt_09)) / Double.parseDouble(rs(ta_09)); Double at_10 = Double.parseDouble(rs(dtt_10)) / Double.parseDouble(rs(ta_10)); Double at_11 = Double.parseDouble(rs(dtt_11)) / Double.parseDouble(rs(ta_11)); Double at_12 = Double.parseDouble(rs(dtt_12)) / Double.parseDouble(rs(ta_12)); Double at_13 = Double.parseDouble(rs(dtt_13)) / Double.parseDouble(rs(ta_13)); Integer f_09 = 0; Integer f_10 = 0; Integer f_11 = 0; Integer f_12 = 0; Integer f_13 = 0; Double z_09 = 0.0; Double z_10 = 0.0; Double z_11 = 0.0; Double z_12 = 0.0; Double z_13 = 0.0; if (roa_09 > 0) { f_09 = f_09 + 1; } if (roa_10 > 0) { f_10 = f_10 + 1; } if (roa_11 > 0) { f_11 = f_11 + 1; } if (roa_12 > 0) { f_12 = f_12 + 1; } if (roa_13 > 0) { f_13 = f_13 + 1; } if (Double.parseDouble(rs(cf_09)) > 0) { f_09 = f_09 + 1; } if (Double.parseDouble(rs(cf_10)) > 0) { f_10 = f_10 + 1; } if (Double.parseDouble(rs(cf_11)) > 0) { f_11 = f_11 + 1; } if (Double.parseDouble(rs(cf_12)) > 0) { f_12 = f_12 + 1; } if (Double.parseDouble(rs(cf_13)) > 0) { f_13 = f_13 + 1; } if (roa_10 > roa_09) { f_10 = f_10 + 1; } if (roa_11 > roa_10) { f_11 = f_11 + 1; } if (roa_12 > roa_11) { f_12 = f_12 + 1; } if (roa_13 > roa_12) { f_13 = f_13 + 1; } if (Double.parseDouble(rs(cf_09)) > roa_09) { f_09 = f_09 + 1; } if (Double.parseDouble(rs(cf_10)) > roa_10) { f_10 = f_10 + 1; } if (Double.parseDouble(rs(cf_11)) > roa_11) { f_11 = f_11 + 1; } if (Double.parseDouble(rs(cf_12)) > roa_12) { f_12 = f_12 + 1; } if (Double.parseDouble(rs(cf_13)) > roa_13) { f_13 = f_13 + 1; } if (Double.parseDouble(rs(ltd_10)) < Double.parseDouble(rs(ltd_09))) { f_10 = f_10 + 1; } if (Double.parseDouble(rs(ltd_11)) < Double.parseDouble(rs(ltd_10))) { f_11 = f_11 + 1; } if (Double.parseDouble(rs(ltd_12)) < Double.parseDouble(rs(ltd_11))) { f_12 = f_12 + 1; } if (Double.parseDouble(rs(ltd_13)) < Double.parseDouble(rs(ltd_12))) { f_13 = f_13 + 1; } if (cr_10 > cr_09) { f_10 = f_10 + 1; } if (cr_11 > cr_10) { f_11 = f_11 + 1; } if (cr_12 > cr_11) { f_12 = f_12 + 1; } if (cr_13 > cr_12) { f_13 = f_13 + 1; } if (share_11 == share_10) { f_10 = f_10 + 1; } if (share_12 == share_11) { f_11 = f_10 + 1; } if (share_13 == share_12) { f_12 = f_10 + 1; } if (share_14 == share_13) { f_13 = f_10 + 1; } if (gpm_10 > gpm_09) { f_10 = f_10 + 1; } if (gpm_11 > gpm_10) { f_11 = f_11 + 1; } if (gpm_12 > gpm_11) { f_12 = f_12 + 1; } if (gpm_13 > gpm_12) { f_13 = f_13 + 1; } if (at_10 > at_09) { f_10 = f_10 + 1; } if (at_11 > at_10) { f_11 = f_11 + 1; } if (at_12 > at_11) { f_12 = f_12 + 1; } if (at_13 > at_12) { f_13 = f_13 + 1; } Double a_09 = (Double.parseDouble(rs(sta_09)) - Double.parseDouble(rs(std_09))) / Double.parseDouble(rs(ta_09)); Double a_10 = (Double.parseDouble(rs(sta_10)) - Double.parseDouble(rs(std_10))) / Double.parseDouble(rs(ta_10)); Double a_11 = (Double.parseDouble(rs(sta_11)) - Double.parseDouble(rs(std_11))) / Double.parseDouble(rs(ta_11)); Double a_12 = (Double.parseDouble(rs(sta_12)) - Double.parseDouble(rs(std_12))) / Double.parseDouble(rs(ta_12)); Double a_13 = (Double.parseDouble(rs(sta_13)) - Double.parseDouble(rs(std_13))) / Double.parseDouble(rs(ta_13)); Double b_09 = Double.parseDouble(rs(lcpp_09)) / Double.parseDouble(rs(ta_09)); Double b_10 = Double.parseDouble(rs(lcpp_10)) / Double.parseDouble(rs(ta_10)); Double b_11 = Double.parseDouble(rs(lcpp_11)) / Double.parseDouble(rs(ta_11)); Double b_12 = Double.parseDouble(rs(lcpp_12)) / Double.parseDouble(rs(ta_12)); Double b_13 = Double.parseDouble(rs(lcpp_13)) / Double.parseDouble(rs(ta_13)); Double c_09 = Double.parseDouble(rs(ebit_09)) / Double.parseDouble(rs(ta_09)); Double c_10 = Double.parseDouble(rs(ebit_10)) / Double.parseDouble(rs(ta_10)); Double c_11 = Double.parseDouble(rs(ebit_11)) / Double.parseDouble(rs(ta_11)); Double c_12 = Double.parseDouble(rs(ebit_12)) / Double.parseDouble(rs(ta_12)); Double c_13 = Double.parseDouble(rs(ebit_13)) / Double.parseDouble(rs(ta_13)); Double d_09 = share_10 * obj.close_price(company, 2010) / (Double.parseDouble(rs(td_09)) * 1000); Double d_10 = share_11 * obj.close_price(company, 2011) / (Double.parseDouble(rs(td_10)) * 1000); Double d_11 = share_12 * obj.close_price(company, 2012) / (Double.parseDouble(rs(td_11)) * 1000); Double d_12 = share_13 * obj.close_price(company, 2013) / (Double.parseDouble(rs(td_12)) * 1000); Double d_13 = share_14 * obj.close_price(company, 2014) / (Double.parseDouble(rs(td_13)) * 1000); Double e_09 = Double.parseDouble(rs(lg_09)) / Double.parseDouble(rs(ta_09)); Double e_10 = Double.parseDouble(rs(lg_10)) / Double.parseDouble(rs(ta_10)); Double e_11 = Double.parseDouble(rs(lg_11)) / Double.parseDouble(rs(ta_11)); Double e_12 = Double.parseDouble(rs(lg_12)) / Double.parseDouble(rs(ta_12)); Double e_13 = Double.parseDouble(rs(lg_13)) / Double.parseDouble(rs(ta_13)); z_09 = 1.2 * a_09 + 1.4 * b_09 + 3.3 * c_09 + 0.6 * d_09 + e_09; z_10 = 1.2 * a_10 + 1.4 * b_10 + 3.3 * c_10 + 0.6 * d_10 + e_10; z_11 = 1.2 * a_11 + 1.4 * b_11 + 3.3 * c_11 + 0.6 * d_11 + e_11; z_12 = 1.2 * a_12 + 1.4 * b_12 + 3.3 * c_12 + 0.6 * d_12 + e_12; z_13 = 1.2 * a_13 + 1.4 * b_13 + 3.3 * c_13 + 0.6 * d_13 + e_13; // System.out.println(a_13+" , "+b_13+" , "+c_13+" , "+d_13+" , "+e_13); add_data(conn, prestatement, company, "PROFITABILITY", "", "", "", "", ""); add_data(conn, prestatement, company, "Gross Profit Margin", Double.toString(gpm_13), Double.toString(gpm_12), Double.toString(gpm_11), Double.toString(gpm_10), Double.toString(gpm_09)); add_data(conn, prestatement, company, "Operating Margin", Double.toString(om_13), Double.toString(om_12), Double.toString(om_11), Double.toString(om_10), Double.toString(om_09)); add_data(conn, prestatement, company, "Net Profit Margin", Double.toString(npm_13), Double.toString(npm_12), Double.toString(npm_11), Double.toString(npm_10), Double.toString(npm_09)); add_data(conn, prestatement, company, "Return on Assets", Double.toString(roa_13), Double.toString(roa_12), Double.toString(roa_11), Double.toString(roa_10), Double.toString(roa_09)); add_data(conn, prestatement, company, "Return on Equity", Double.toString(roe_13), Double.toString(roe_12), Double.toString(roe_11), Double.toString(roe_10), Double.toString(roe_09)); add_data(conn, prestatement, company, "LIQUIDITY", "", "", "", "", ""); add_data(conn, prestatement, company, "Quick Ratio", Double.toString(qr_13), Double.toString(qr_12), Double.toString(qr_11), Double.toString(qr_10), Double.toString(qr_09)); add_data(conn, prestatement, company, "Current Ratio", Double.toString(cr_13), Double.toString(cr_12), Double.toString(cr_11), Double.toString(cr_10), Double.toString(cr_09)); add_data(conn, prestatement, company, "Payout Ratio", Double.toString(pr_13), Double.toString(pr_12), Double.toString(pr_11), Double.toString(pr_10), Double.toString(pr_09)); add_data(conn, prestatement, company, "Times Interest Earned", Double.toString(tie_13), Double.toString(tie_12), Double.toString(tie_11), Double.toString(tie_10), Double.toString(tie_09)); add_data(conn, prestatement, company, "DEBT MANAGEMENT", "", "", "", "", ""); add_data(conn, prestatement, company, "Total Liabilities to Total Assets", Double.toString(tlta_13), Double.toString(tlta_12), Double.toString(tlta_11), Double.toString(tlta_10), Double.toString(tlta_09)); add_data(conn, prestatement, company, "Long-term Debt to Capital", Double.toString(ltdtc_13), Double.toString(ltdtc_12), Double.toString(ltdtc_11), Double.toString(ltdtc_10), Double.toString(ltdtc_09)); add_data(conn, prestatement, company, "Long-term Debt to Equity", Double.toString(ltdte_13), Double.toString(ltdte_12), Double.toString(ltdte_11), Double.toString(ltdte_10), Double.toString(ltdte_09)); add_data(conn, prestatement, company, "ASSETS MANAGEMENT", "", "", "", "", ""); add_data(conn, prestatement, company, "Receivables Turnover", Double.toString(rt_13), Double.toString(rt_12), Double.toString(rt_11), Double.toString(rt_10), Double.toString(rt_09)); add_data(conn, prestatement, company, "Inventory Turnover", Double.toString(it_13), Double.toString(it_12), Double.toString(it_11), Double.toString(it_10), Double.toString(it_09)); add_data(conn, prestatement, company, "Assets Turnover", Double.toString(at_13), Double.toString(at_12), Double.toString(at_11), Double.toString(at_10), Double.toString(at_09)); add_data(conn, prestatement, company, "FINANCIAL STRENGTH", "", "", "", "", ""); add_data(conn, prestatement, company, "F-Score", Double.toString(f_13), Double.toString(f_12), Double.toString(f_11), Double.toString(f_10), Double.toString(f_09)); add_data(conn, prestatement, company, "Z-Score", Double.toString(z_13), Double.toString(z_12), Double.toString(z_11), Double.toString(z_10), Double.toString(z_09)); file_BS.close(); file_CFS.close(); file_FI.close(); file_IS.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) try { conn.close(); } catch (Exception ignore) { } if (statement != null) try { statement.close(); } catch (Exception ignore) { } if (result != null) try { result.close(); } catch (Exception ignore) { } if (prestatement != null) try { prestatement.close(); } catch (Exception ignore) { } } }
From source file:mj.ocraptor.extraction.tika.parser.microsoft.ooxml.XSSFExcelExtractorDecorator.java
License:Apache License
public XSSFExcelExtractorDecorator(ParseContext context, XSSFEventBasedExcelExtractor extractor, Locale locale, Metadata metadata) {//from w ww . jav a2 s .c o m super(context, extractor); this.metadata = metadata; this.extractor = extractor; extractor.setFormulasNotResults(false); extractor.setLocale(locale); if (locale == null) { formatter = new DataFormatter(); } else { formatter = new DataFormatter(locale); } }
From source file:mpqq.MPQQ.java
private static XSSFWorkbook procTab1(XSSFWorkbook referenceWB, XSSFWorkbook mpqqWB, int referenceFirstRow) { XSSFSheet trackerTab = referenceWB.getSheetAt(USE_FOR_TAB1); XSSFSheet tab1 = mpqqWB.getSheetAt(1); //Iterator<Row> rowIterator = trackerTab.iterator(); DataFormatter df = new DataFormatter(); //MPQQ first row int rowIdx = 11; for (int refCurRow = referenceFirstRow; refCurRow <= trackerTab.getLastRowNum(); refCurRow++) { Row row = trackerTab.getRow(refCurRow); //Check if row is visible if (!row.getZeroHeight() || (row.isFormatted() && row.getRowStyle().getHidden())) { int colIdx = 1; //Iterate trough the Columns Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); switch (cell.getColumnIndex()) { case 3: Cell currentCell = checkRowCellExists(tab1, rowIdx, colIdx); currentCell.setCellValue(df.formatCellValue(row.getCell(T2PEPSICO_STOCK_CODE))); //Go to next Column colIdx++;//from w w w .ja va 2 s . co m break; case 4: break; default: } } //Jump Next Row rowIdx++; } } return mpqqWB; }
From source file:net.cpollet.jixture.fixtures.transformers.ExcelFileFixtureTransformer.java
License:Apache License
@Override protected List<Object> parse(From fixture) { InputStream inputStream = fixture.getInputStream(); Workbook workbook = createWorkbook(inputStream); DataFormatter dataFormatter = new DataFormatter(); FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator(); List<Object> mappings = new LinkedList<Object>(); Helpers helpers = new Helpers(); helpers.dataFormatter = dataFormatter; helpers.evaluator = evaluator;/*from w ww . java 2 s . com*/ Parameters parameters = new Parameters(); parameters.mode = fixture.getMode(); for (int sheetIndex = 0; sheetIndex < workbook.getNumberOfSheets(); sheetIndex++) { Sheet sheet = workbook.getSheetAt(sheetIndex); mappings.addAll(parseSheet(sheet, helpers, parameters)); } return mappings; }
From source file:net.geoprism.data.etl.excel.ExcelSheetReader.java
License:Open Source License
public ExcelSheetReader(SheetHandler handler) { this(handler, new DataFormatter()); }
From source file:net.geoprism.data.etl.excel.XSSFSheetXMLHandler.java
License:Open Source License
/** * Accepts objects needed while parsing. * * @param styles// w w w . j a v a2 s . c om * Table of styles * @param strings * Table of shared strings */ public XSSFSheetXMLHandler(StylesTable styles, ReadOnlySharedStringsTable strings, SheetHandler sheetContentsHandler, DataFormatter dataFormatter, boolean formulasNotResults) { this.stylesTable = styles; this.sharedStringsTable = strings; this.output = sheetContentsHandler; this.formulasNotResults = formulasNotResults; this.nextDataType = ColumnType.NUMBER; this.contentFormatter = dataFormatter; this.cellFormatter = new DataFormatter(); }
From source file:net.geoprism.data.etl.excel.XSSFSheetXMLHandler.java
License:Open Source License
/** * Accepts objects needed while parsing. * * @param styles//from ww w . j a v a 2 s . c o m * Table of styles * @param strings * Table of shared strings */ public XSSFSheetXMLHandler(StylesTable styles, ReadOnlySharedStringsTable strings, SheetHandler sheetContentsHandler, boolean formulasNotResults) { this(styles, strings, sheetContentsHandler, new DataFormatter(), formulasNotResults); }
From source file:net.pcal.sqlsheet.XlsResultSet.java
License:Apache License
public XlsResultSet(Workbook wb, Sheet s, int firstSheetRowOffset) throws SQLException { if (s == null) { throw new IllegalArgumentException("null sheet"); }// w w w .j a v a2s . c o m if (wb == null) { throw new IllegalArgumentException("null workbook"); } formatter = new DataFormatter(); workbook = wb; sheet = s; this.firstSheetRowOffset = firstSheetRowOffset; cursorSheetRow = this.firstSheetRowOffset - 1; metadata = new XlsResultSetMetaData(s, this, firstSheetRowOffset); // set the default date cell format dateStyle = workbook.createCellStyle(); dateStyle.setDataFormat(workbook.createDataFormat().getFormat("yyyy-mm-dd")); }
From source file:net.pcal.sqlsheet.XlsResultSetMetaData.java
License:Apache License
public XlsResultSetMetaData(Sheet sheet, XlsResultSet resultset, int firstSheetRowOffset) throws SQLException { if (sheet == null) throw new IllegalArgumentException(); this.resultset = resultset; Row row = sheet.getRow(firstSheetRowOffset - 1); if (row == null) { throw new SQLException("No header row in sheet"); }//from w ww .j a v a2 s . c o m formatter = new DataFormatter(); columnNames = new ArrayList<String>(); for (short c = 0; c < row.getLastCellNum(); c++) { Cell cell = row.getCell(c); String columnName = formatter.formatCellValue(cell); // Is it unique in the column name set int suffix; while (columnNames.contains(columnName)) { suffix = 1; columnName += "_" + suffix; } columnNames.add(columnName); } // Data Type profiling on the whole excel file int currentRowNumber = resultset.getRow(); // A double map to back the relation between the column Id and the count of type Map<Integer, Map<Integer, Integer>> columnTypeScan = new HashMap<Integer, Map<Integer, Integer>>(); while (resultset.next()) { int typeCode; for (int columnId = 1; columnId <= getColumnCount(); columnId++) { Cell cell = resultset.getCell(columnId); if (cell != null) { int excelCellType = cell.getCellType(); switch (excelCellType) { case Cell.CELL_TYPE_BOOLEAN: typeCode = Types.VARCHAR; break; case Cell.CELL_TYPE_STRING: typeCode = Types.VARCHAR; break; case Cell.CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { typeCode = Types.DATE; } else { typeCode = Types.DOUBLE; } break; case Cell.CELL_TYPE_BLANK: typeCode = Types.NULL; break; case Cell.CELL_TYPE_FORMULA: try { cell.getStringCellValue(); typeCode = Types.VARCHAR; } catch (Exception e) { cell.getNumericCellValue(); typeCode = Types.DOUBLE; } break; case Cell.CELL_TYPE_ERROR: throw new RuntimeException("The ExcelType ( ERROR ) is not supported - Cell (" + resultset.getRow() + "," + columnId + ")"); default: throw new RuntimeException("The ExcelType (" + excelCellType + ") is not supported - Cell (" + resultset.getRow() + "," + columnId + ")"); } } else { typeCode = Types.NULL; } Map<Integer, Integer> columnIdTypeMap = columnTypeScan.get(columnId); if (columnIdTypeMap == null) { columnIdTypeMap = new HashMap<Integer, Integer>(); columnIdTypeMap.put(typeCode, 1); columnTypeScan.put(columnId, columnIdTypeMap); } else { Integer columnIdType = columnIdTypeMap.get(typeCode); if (columnIdType == null) { columnIdTypeMap.put(typeCode, 1); } else { int count = columnIdTypeMap.get(typeCode) + 1; columnIdTypeMap.put(typeCode, count); } } } // Retrieve only one type for (Integer columnId : columnTypeScan.keySet()) { Integer numberOfVarchar = 0; Integer numberOfDouble = 0; Integer numberOfDate = 0; for (Map.Entry<Integer, Integer> columnIdTypeMap : columnTypeScan.get(columnId).entrySet()) { if (columnIdTypeMap.getKey() == Types.VARCHAR) { numberOfVarchar = columnIdTypeMap.getValue(); } else if (columnIdTypeMap.getKey() == Types.DOUBLE) { numberOfDouble = columnIdTypeMap.getValue(); } else if (columnIdTypeMap.getKey() == Types.DATE) { numberOfDate = columnIdTypeMap.getValue(); } } Integer finalColumnType = null; if (numberOfVarchar != 0) { finalColumnType = Types.VARCHAR; } else { if (numberOfDouble != 0 && numberOfDate == 0) { finalColumnType = Types.DOUBLE; } if (numberOfDouble == 0 && numberOfDate != 0) { finalColumnType = Types.DATE; } } if (finalColumnType == null) { finalColumnType = Types.VARCHAR; } columnTypeMap.put(columnId, finalColumnType); } } // Go back to the current row resultset.absolute(currentRowNumber); }