Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package jdbc; import com.opencsv.CSVReader; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileReader; import java.io.IOException; import static java.lang.Math.abs; import java.math.BigDecimal; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.DecimalFormat; import java.text.NumberFormat; import java.text.ParseException; import java.util.ArrayList; import java.util.Collections; import java.util.List; import java.util.Iterator; import java.util.Locale; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.DataFormatter; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import static jdbc.Import_data_csv.isDouble; /** * * @author tri */ public class Ratio { public static void main(String[] args) throws Exception { Ratio obj = new Ratio(); Integer linenumber = 2; String name; while (linenumber < 691) { name = Import_data_excel_Fin_Annual.readfile(linenumber); // name = name.substring(1,name.length()); System.out.println(name); obj.run(name); linenumber += 1; } } public static void run(String company) throws ClassNotFoundException, InstantiationException, IllegalAccessException, ParseException, Exception { Connection conn = null; 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) { } } } public static String rs(String currency) throws Exception { // Replace all dots with commas currency = currency.replaceAll("\\.", ","); // If fractions exist, the separator must be a . if (currency.length() >= 3) { char[] chars = currency.toCharArray(); if (chars[chars.length - 2] == ',') { chars[chars.length - 2] = '.'; } else if (chars[chars.length - 3] == ',') { chars[chars.length - 3] = '.'; } currency = new String(chars); } // Remove all commas return currency.replaceAll(",", ""); } public static void add_data(Connection conn, PreparedStatement prestatement, String name, String clause, String output_09, String output_10, String output_11, String output_12, String output_13) throws SQLException { prestatement = conn.prepareStatement("INSERT INTO `" + name + "_RAT` (`clause`, `Current`, `1 Year Ago`, `2 Years Ago`, `3 Years Ago`, `4 Years Ago`) VALUES(N?,?,?,?,?,?);"); prestatement.setString(1, clause); prestatement.setString(2, output_09); prestatement.setString(3, output_10); prestatement.setString(4, output_11); prestatement.setString(5, output_12); prestatement.setString(6, output_13); prestatement.executeUpdate(); } public static void add_company(Connection conn, PreparedStatement prestatement, String name) throws SQLException//creating templates for prepared statement { prestatement = conn.prepareStatement("DROP TABLE IF EXISTS `" + name + "_RAT`;"); prestatement.executeUpdate(); prestatement = conn.prepareStatement("CREATE TABLE `" + name + "_RAT` ( ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, `clause` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Current` VARCHAR(255), `1 Year Ago` VARCHAR(255), `2 Years Ago` VARCHAR(255), `3 Years Ago` VARCHAR(255), `4 Years Ago` VARCHAR(255))"); prestatement.executeUpdate(); } public Double close_price(String name, Integer year) { String csvFilename = "C:\\Users\\tri\\Desktop\\VI\\BUSINESS\\" + name + "_PRICE.csv"; Double today = 0.0; Double yesterday = 0.0; String[] row = null; Double change = 0.0; Integer n = 0; Integer d = 0; try { CSVReader csvReader = new CSVReader(new FileReader(csvFilename)); List content = csvReader.readAll();//read whole file String sign = null; for (Object object : content) { row = (String[]) object; if (isDouble(row[1])) { double date = Double.parseDouble(row[1]) / 10000; long day = (long) date; if (year == day) { if (n == 0) { //check if row[5] is double today = Double.parseDouble(row[5]); n = n + 1; } } } } } catch (Exception e) { e.printStackTrace(); } finally { return today; } } public Double change(String numer, String deno) { Double rs = 0.0; try { if ("0.0".equals(deno)) { rs = 0.0; } else { rs = (Double.parseDouble(numer) - Double.parseDouble(deno)) / Double.parseDouble(deno); } } catch (Exception e) { e.printStackTrace(); } finally { return rs; } } }