コード例 #1
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  /**
   * Construct Statements based on given stock price.
   *
   * @param tableModel give stock price
   * @return the constructed Statements. UNKNOWN_STATEMENTS if fail
   */
  public static Statements newInstanceFromStockPrices(Map<Code, Double> stockPrices) {
    GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(GUIBundleWrapper.Language.INDEPENDENT);
    Statements s = new Statements(Statement.Type.StockPrice, guiBundleWrapper);

    final String code_string = guiBundleWrapper.getString("MainFrame_Code");
    final String last_string = guiBundleWrapper.getString("MainFrame_Last");
    for (Map.Entry<Code, Double> stockPrice : stockPrices.entrySet()) {
      Code key = stockPrice.getKey();
      Double value = stockPrice.getValue();
      final List<Atom> atoms = new ArrayList<Atom>();
      atoms.add(new Atom(key.toString(), code_string));
      atoms.add(new Atom(value.toString(), last_string));
      Statement statement = new Statement(atoms);
      // They should be the same type. The checking just act as paranoid.
      if (s.getType() != statement.getType()) {
        throw new java.lang.RuntimeException("" + statement.getType());
      }
      s.statements.add(statement);
    }
    return s;
  }
コード例 #2
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  /**
   * Construct Statements based on given stock pairs.
   *
   * @param tableModel give stock pairs
   * @return the constructed Statements. UNKNOWN_STATEMENTS if fail
   */
  public static Statements newInstanceFromUserDefinedDatabase(
      java.util.List<Pair<Code, Symbol>> pairs) {
    GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(GUIBundleWrapper.Language.INDEPENDENT);
    Statements s = new Statements(Statement.Type.UserDefinedDatabase, guiBundleWrapper);

    final String code_string = guiBundleWrapper.getString("MainFrame_Code");
    final String symbol_string = guiBundleWrapper.getString("MainFrame_Symbol");

    for (Pair<Code, Symbol> pair : pairs) {
      final List<Atom> atoms = new ArrayList<Atom>();
      atoms.add(new Atom(pair.first, code_string));
      atoms.add(new Atom(pair.second, symbol_string));
      Statement statement = new Statement(atoms);

      // They should be the same type. The checking just act as paranoid.
      if (s.getType() != statement.getType()) {
        throw new java.lang.RuntimeException("" + statement.getType());
      }
      s.statements.add(statement);
    }
    return s;
  }
コード例 #3
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  public static Statements newInstanceFromPortfolioInfos(List<PortfolioInfo> portfolioInfos) {
    GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(GUIBundleWrapper.Language.INDEPENDENT);
    Statements s = new Statements(Statement.Type.PortfolioInfos, guiBundleWrapper);

    final String country_string = guiBundleWrapper.getString("PortfolioInfo_Country");
    final String name_string = guiBundleWrapper.getString("PortfolioInfo_Name");
    final String size_string = guiBundleWrapper.getString("PortfolioInfo_Size");

    for (PortfolioInfo portfolioInfo : portfolioInfos) {
      final List<Atom> atoms = new ArrayList<Atom>();
      atoms.add(new Atom(portfolioInfo.country, country_string));
      atoms.add(new Atom(portfolioInfo.name, name_string));
      atoms.add(new Atom(portfolioInfo.size, size_string));
      Statement statement = new Statement(atoms);
      // They should be the same type. The checking just act as paranoid.
      if (s.getType() != statement.getType()) {
        throw new java.lang.RuntimeException("" + statement.getType());
      }
      s.statements.add(statement);
    }
    return s;
  }
コード例 #4
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  public static Statements newInstanceFromStockNameDatabase(StockNameDatabase stockNameDatabase) {
    GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(GUIBundleWrapper.Language.INDEPENDENT);
    Statements s = new Statements(Statement.Type.StockNameDatabase, guiBundleWrapper);

    final String code_string = guiBundleWrapper.getString("MainFrame_Code");
    final String name_string = guiBundleWrapper.getString("MainFrame_Name");

    for (Map.Entry<Code, String> entry : stockNameDatabase.getCodeToName().entrySet()) {
      final Code code = entry.getKey();
      final String name = entry.getValue();
      final List<Atom> atoms = new ArrayList<Atom>();
      atoms.add(new Atom(code, code_string));
      atoms.add(new Atom(name, name_string));
      Statement statement = new Statement(atoms);

      // They should be the same type. The checking just act as paranoid.
      if (s.getType() != statement.getType()) {
        throw new java.lang.RuntimeException("" + statement.getType());
      }
      s.statements.add(statement);
    }
    return s;
  }
コード例 #5
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  public static boolean saveAsExcelFile(File file, List<StatementsEx> statementsExs) {
    final HSSFWorkbook wb = new HSSFWorkbook();
    boolean needToWrite = false;
    for (StatementsEx statementsEx : statementsExs) {
      final String title = statementsEx.title;
      final Statements statements = statementsEx.statements;
      assert (statements != null);
      if (statements.getType() == Statement.Type.Unknown) {
        continue;
      }
      needToWrite = true;
      final HSSFSheet sheet = wb.createSheet(title);
      // Do not obtain "type" through statements, as there is possible that
      // statements is empty.
      final List<String> strings =
          Statement.typeToStrings(statements.getType(), statements.getGUIBundleWrapper());
      final int columnCount = strings.size();
      // First row. Print out table header.
      {
        final HSSFRow row = sheet.createRow(0);
        for (int i = 0; i < columnCount; i++) {
          row.createCell(i).setCellValue(new HSSFRichTextString(strings.get(i)));
        }
      }

      final int rowCount = statements.size();
      for (int i = 0; i < rowCount; i++) {
        final HSSFRow row = sheet.createRow(i + 1);
        for (int j = 0; j < columnCount; j++) {
          // Value shouldn't be null, as we prevent atom with null value.
          final Object value = statements.get(i).getAtom(j).getValue();
          final HSSFCell cell = row.createCell(j);
          POIUtils.invokeSetCellValue(cell, value);
        }
      }
    }
    if (needToWrite == false) {
      return needToWrite;
    }
    boolean status = false;
    FileOutputStream fileOut = null;
    try {
      fileOut = new FileOutputStream(file);
      wb.write(fileOut);
      status = true;
    } catch (FileNotFoundException ex) {
      log.error(null, ex);
    } catch (IOException ex) {
      log.error(null, ex);
    } finally {
      org.yccheok.jstock.gui.Utils.close(fileOut);
    }
    return status;
  }
コード例 #6
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  public static Statements newInstanceFromBuyPortfolioTreeTableModel(
      BuyPortfolioTreeTableModelEx buyPortfolioTreeTableModel, boolean languageIndependent) {
    final JStockOptions jStockOptions = MainFrame.getInstance().getJStockOptions();
    final boolean isPenceToPoundConversionEnabled = jStockOptions.isPenceToPoundConversionEnabled();

    final GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(
            languageIndependent
                ? GUIBundleWrapper.Language.INDEPENDENT
                : GUIBundleWrapper.Language.DEFAULT);

    final String[] tmp = {
      guiBundleWrapper.getString("MainFrame_Code"),
      guiBundleWrapper.getString("MainFrame_Symbol"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_Date"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_Units"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_PurchasePrice"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_CurrentPrice"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_PurchaseValue"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_CurrentValue"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_GainLossPrice"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_GainLossValue"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_GainLossPercentage"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_Broker"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_ClearingFee"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_StampDuty"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_NetPurchaseValue"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_NetGainLossValue"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_NetGainLossPercentage"),
      guiBundleWrapper.getString("PortfolioManagementJPanel_Comment")
    };

    Statement.What what = Statement.what(Arrays.asList(tmp));
    final Statements statements = new Statements(what.type, what.guiBundleWrapper);

    final Portfolio portfolio = (Portfolio) buyPortfolioTreeTableModel.getRoot();
    final int summaryCount = portfolio.getChildCount();

    for (int i = 0; i < summaryCount; i++) {
      Object o = portfolio.getChildAt(i);
      final TransactionSummary transactionSummary = (TransactionSummary) o;

      // Metadatas will be used to store TransactionSummary's comment.
      final String comment = transactionSummary.getComment().trim();
      if (comment.isEmpty() == false) {
        final Stock stock = ((Transaction) transactionSummary.getChildAt(0)).getStock();
        statements.metadatas.put(stock.getCode().toString(), comment);
      }

      final int transactionCount = transactionSummary.getChildCount();
      for (int j = 0; j < transactionCount; j++) {
        final Transaction transaction = (Transaction) transactionSummary.getChildAt(j);
        final Stock stock = transaction.getStock();
        final List<Atom> atoms = new ArrayList<Atom>();
        atoms.add(new Atom(stock.getCode().toString(), tmp[0]));
        atoms.add(new Atom(stock.getSymbol().toString(), tmp[1]));

        DateFormat dateFormat = org.yccheok.jstock.gui.Utils.getCommonDateFormat();
        final String dateString =
            transaction.getDate() != null ? dateFormat.format(transaction.getDate().getTime()) : "";
        atoms.add(new Atom(dateString, tmp[2]));
        atoms.add(new Atom(transaction.getQuantity(), tmp[3]));
        atoms.add(new Atom(transaction.getPrice(), tmp[4]));
        atoms.add(new Atom(buyPortfolioTreeTableModel.getCurrentPrice(transaction), tmp[5]));
        if (isPenceToPoundConversionEnabled == false) {
          atoms.add(new Atom(transaction.getTotal(), tmp[6]));
        } else {
          atoms.add(new Atom(transaction.getTotal() / 100.0, tmp[6]));
        }
        atoms.add(new Atom(buyPortfolioTreeTableModel.getCurrentValue(transaction), tmp[7]));
        atoms.add(new Atom(buyPortfolioTreeTableModel.getGainLossPrice(transaction), tmp[8]));
        if (isPenceToPoundConversionEnabled == false) {
          atoms.add(new Atom(buyPortfolioTreeTableModel.getGainLossValue(transaction), tmp[9]));
        } else {
          atoms.add(
              new Atom(buyPortfolioTreeTableModel.getGainLossValue(transaction) / 100.0, tmp[9]));
        }
        atoms.add(new Atom(buyPortfolioTreeTableModel.getGainLossPercentage(transaction), tmp[10]));
        atoms.add(new Atom(transaction.getBroker(), tmp[11]));
        atoms.add(new Atom(transaction.getClearingFee(), tmp[12]));
        atoms.add(new Atom(transaction.getStampDuty(), tmp[13]));
        if (isPenceToPoundConversionEnabled == false) {
          atoms.add(new Atom(transaction.getNetTotal(), tmp[14]));
          atoms.add(new Atom(buyPortfolioTreeTableModel.getNetGainLossValue(transaction), tmp[15]));
        } else {
          atoms.add(new Atom(transaction.getNetTotal() / 100.0, tmp[14]));
          atoms.add(
              new Atom(
                  buyPortfolioTreeTableModel.getNetGainLossValue(transaction) / 100.0, tmp[15]));
        }
        atoms.add(
            new Atom(buyPortfolioTreeTableModel.getNetGainLossPercentage(transaction), tmp[16]));
        atoms.add(new Atom(transaction.getComment(), tmp[17]));

        final Statement statement = new Statement(atoms);

        if (statements.getType() != statement.getType()) {
          return UNKNOWN_STATEMENTS;
        }
        statements.statements.add(statement);
      }
    }
    return statements;
  }
コード例 #7
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  /**
   * Construct Statements based on given TableModel.
   *
   * @param tableModel given TableModel
   * @return the constructed Statements. UNKNOWN_STATEMENTS if fail
   */
  public static Statements newInstanceFromTableModel(
      TableModel tableModel, boolean languageIndependent) {
    final CSVHelper csvHelper = (CSVHelper) tableModel;
    final GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(
            languageIndependent
                ? GUIBundleWrapper.Language.INDEPENDENT
                : GUIBundleWrapper.Language.DEFAULT);

    final int column = tableModel.getColumnCount();
    final int row = tableModel.getRowCount();

    List<String> strings = new ArrayList<String>();
    for (int i = 0; i < column; i++) {
      final String type =
          languageIndependent
              ? csvHelper.getLanguageIndependentColumnName(i)
              : tableModel.getColumnName(i);
      if (tableModel.getColumnClass(i).equals(Stock.class)) {
        final String code_string = guiBundleWrapper.getString("MainFrame_Code");
        final String symbol_string = guiBundleWrapper.getString("MainFrame_Symbol");
        strings.add(code_string);
        strings.add(symbol_string);
      } else {
        strings.add(type);
      }
    }

    // Comment handling.
    CommentableContainer commentableContainer = null;
    if (tableModel instanceof CommentableContainer) {
      commentableContainer = (CommentableContainer) tableModel;
    }

    Statement.What what = Statement.what(strings);
    final Statements s = new Statements(what.type, what.guiBundleWrapper);

    for (int i = 0; i < row; i++) {
      final List<Atom> atoms = new ArrayList<Atom>();
      for (int j = 0; j < column; j++) {
        final String type =
            languageIndependent
                ? csvHelper.getLanguageIndependentColumnName(j)
                : tableModel.getColumnName(j);
        final Object object = tableModel.getValueAt(i, j);
        if (tableModel.getColumnClass(j).equals(Stock.class)) {
          final Stock stock = (Stock) object;
          // There are no way to represent Stock in text form. We
          // will represent them in Code and Symbol.
          // Code first. Follow by symbol.

          final String code_string = guiBundleWrapper.getString("MainFrame_Code");
          final String symbol_string = guiBundleWrapper.getString("MainFrame_Symbol");

          atoms.add(new Atom(stock.getCode().toString(), code_string));
          atoms.add(new Atom(stock.getSymbol().toString(), symbol_string));
        } else if (tableModel.getColumnClass(j).equals(Date.class)) {
          DateFormat dateFormat = org.yccheok.jstock.gui.Utils.getCommonDateFormat();
          atoms.add(
              new Atom(object != null ? dateFormat.format(((Date) object).getTime()) : "", type));
        } else {
          // For fall below and rise above, null value is permitted.
          // Use empty string to represent null value.
          atoms.add(new Atom(object != null ? object : "", type));
        }
      }

      // Comment handling.
      if (commentableContainer != null) {
        atoms.add(
            new Atom(
                commentableContainer.getCommentable(i).getComment(),
                guiBundleWrapper.getString("PortfolioManagementJPanel_Comment")));
      }

      final Statement statement = new Statement(atoms);

      if (s.getType() != statement.getType()) {
        // Doesn't not match. Return UNKNOWN_STATEMENTS to indicate we fail to
        // construct Statements from TableModel.
        return UNKNOWN_STATEMENTS;
      }

      s.statements.add(statement);
    }

    return s;
  }
コード例 #8
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  /**
   * Construct Statements based on given stock info database.
   *
   * @param tableModel give stock info database
   * @return the constructed Statements. UNKNOWN_STATEMENTS if fail
   */
  public static Statements newInstanceFromStockInfoDatabase(StockInfoDatabase stockInfoDatabase) {
    GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(GUIBundleWrapper.Language.INDEPENDENT);
    Statements s = new Statements(Statement.Type.StockInfoDatabase, guiBundleWrapper);

    // Build mechanism, to retrieve StockInfo's Board and Industry.
    Map<StockInfo, Industry> stockInfo2Industry = new HashMap<StockInfo, Industry>();
    Map<StockInfo, Board> stockInfo2Board = new HashMap<StockInfo, Board>();

    List<Industry> industries = stockInfoDatabase.getIndustries();
    List<Board> boards = stockInfoDatabase.getBoards();

    for (Industry industry : industries) {
      List<StockInfo> stockInfos = stockInfoDatabase.getStockInfos(industry);
      for (StockInfo stockInfo : stockInfos) {
        stockInfo2Industry.put(stockInfo, industry);
      }
    }

    for (Board board : boards) {
      List<StockInfo> stockInfos = stockInfoDatabase.getStockInfos(board);
      for (StockInfo stockInfo : stockInfos) {
        stockInfo2Board.put(stockInfo, board);
      }
    }

    final String code_string = guiBundleWrapper.getString("MainFrame_Code");
    final String symbol_string = guiBundleWrapper.getString("MainFrame_Symbol");
    final String industry_string = guiBundleWrapper.getString("MainFrame_Industry");
    final String board_string = guiBundleWrapper.getString("MainFrame_Board");

    List<StockInfo> stockInfos = stockInfoDatabase.getStockInfos();
    for (StockInfo stockInfo : stockInfos) {
      Industry industry = stockInfo2Industry.get(stockInfo);
      Board board = stockInfo2Board.get(stockInfo);
      if (industry == null) {
        // Shouldn't happen.
        industry = Industry.Unknown;
      }
      if (board == null) {
        // Shouldn't happen.
        board = Board.Unknown;
      }
      final List<Atom> atoms = new ArrayList<Atom>();
      atoms.add(new Atom(stockInfo.code, code_string));
      atoms.add(new Atom(stockInfo.symbol, symbol_string));
      // Do not use toString, as we had overridden toString. Use
      // toOriginalString, as later we need to perfrom string to enum
      // conversion.
      atoms.add(new Atom(industry.toOriginalString(), industry_string));
      atoms.add(new Atom(board.toOriginalString(), board_string));
      Statement statement = new Statement(atoms);

      // They should be the same type. The checking just act as paranoid.
      if (s.getType() != statement.getType()) {
        throw new java.lang.RuntimeException("" + statement.getType());
      }
      s.statements.add(statement);
    }
    return s;
  }
コード例 #9
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  /**
   * Construct Statements based on given CSV File.
   *
   * @param file Given CSV File
   * @return the constructed Statements. UNKNOWN_STATEMENTS if fail
   */
  public static Statements newInstanceFromCSVFile(File file) {
    boolean status = false;

    FileInputStream fileInputStream = null;
    InputStreamReader inputStreamReader = null;
    CSVReader csvreader = null;
    Statements s = null;

    try {
      fileInputStream = new FileInputStream(file);
      inputStreamReader = new InputStreamReader(fileInputStream, Charset.forName("UTF-8"));
      csvreader = new CSVReader(inputStreamReader);
      final List<String> types = new ArrayList<String>();

      String[] nextLine;
      Map<String, String> metadatas = new LinkedHashMap<String, String>();
      if ((nextLine = csvreader.readNext()) != null) {

        // Metadata handling.
        while (nextLine != null && nextLine.length == 1) {
          String[] tokens = nextLine[0].split("=", 2);
          if (tokens.length == 2) {
            String key = tokens[0].trim();
            String value = tokens[1].trim();
            if (key.length() > 0) {
              // Is OK for value to be empty.
              metadatas.put(key, value);
              nextLine = csvreader.readNext();
            } else {
              break;
            }
          } else {
            break;
          }
        }

        if (nextLine != null) {
          types.addAll(Arrays.asList(nextLine));
        }
      } /* if ((nextLine = csvreader.readNext()) != null) */

      if (types.isEmpty()) {
        return UNKNOWN_STATEMENTS;
      } else {
        Statement.What what = Statement.what(types);
        s = new Statements(what.type, what.guiBundleWrapper);
      }

      while ((nextLine = csvreader.readNext()) != null) {
        // Shall we continue to ignore, or shall we just return null to
        // flag an error?
        if (nextLine.length != types.size()) {
          // Give a warning message.
          log.error("Incorrect CSV format. There should be exactly " + types.size() + " item(s)");
          continue;
        }

        int i = 0;
        final List<Atom> atoms = new ArrayList<Atom>();
        for (String value : nextLine) {
          final String type = types.get(i++);
          final Atom atom = new Atom(value, type);
          atoms.add(atom);
        }
        final Statement statement = new Statement(atoms);
        if (s.getType() != statement.getType()) {
          // Doesn't not match.
          return UNKNOWN_STATEMENTS;
        }

        s.statements.add(statement);
      }

      // Pump in metadata.
      for (Map.Entry<String, String> entry : metadatas.entrySet()) {
        String key = entry.getKey();
        String value = entry.getValue();
        s.metadatas.put(key, value);
      }

      status = true;
    } catch (IOException ex) {
      log.error(null, ex);
    } finally {
      if (csvreader != null) {
        try {
          csvreader.close();
        } catch (IOException ex) {
          log.error(null, ex);
        }
      }
      org.yccheok.jstock.gui.Utils.close(inputStreamReader);
      org.yccheok.jstock.gui.Utils.close(fileInputStream);
    }

    if (status) {
      return s;
    }

    return UNKNOWN_STATEMENTS;
  }
コード例 #10
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  /**
   * Construct Statements based on given Excel File.
   *
   * @param file Given Excel File
   * @return the List of constructed Statements. Empty list if fail.
   */
  public static List<Statements> newInstanceFromExcelFile(File file) {
    FileInputStream fileInputStream = null;
    final List<Statements> statementsList = new ArrayList<Statements>();
    try {
      fileInputStream = new FileInputStream(file);
      final POIFSFileSystem fs = new POIFSFileSystem(fileInputStream);
      final HSSFWorkbook wb = new HSSFWorkbook(fs);
      final int numberOfSheets = wb.getNumberOfSheets();
      for (int k = 0; k < numberOfSheets; k++) {
        final HSSFSheet sheet = wb.getSheetAt(k);
        final int startRow = sheet.getFirstRowNum();
        final int endRow = sheet.getLastRowNum();
        // If there are 3 rows, endRow will be 2.
        // We must have at least 2 rows. (endRow = 1)
        if (startRow != 0 || endRow <= startRow) {
          continue;
        }

        final HSSFRow row = sheet.getRow(startRow);
        if (row == null) {
          continue;
        }

        final int startCell = row.getFirstCellNum();
        final int endCell = row.getLastCellNum();
        // If there are 2 cols, endCell will be 2.
        // We must have at least 1 col. (endCell = 1)
        if (startCell != 0 || endCell <= startCell) {
          continue;
        }

        final List<String> types = new ArrayList<String>();
        for (int i = startCell; i < endCell; i++) {
          final HSSFCell cell = row.getCell(i);
          if (cell == null) {
            continue;
          }

          // Exception may be thrown here, as cell may be numerical value.
          final String type = cell.getRichStringCellValue().getString();
          if (type != null) {
            types.add(type);
          }
        }

        if (types.isEmpty()) {
          continue;
        }

        if (types.size() != (endCell - startCell)) {
          continue;
        }

        final Statement.What what = Statement.what(types);
        Statements s = new Statements(what.type, what.guiBundleWrapper);
        for (int i = startRow + 1; i <= endRow; i++) {
          final HSSFRow r = sheet.getRow(i);
          if (r == null) {
            continue;
          }
          final List<Atom> atoms = new ArrayList<Atom>();
          for (int j = startCell; j < endCell; j++) {
            final HSSFCell cell = r.getCell(j);
            if (cell == null) {
              continue;
            }
            Object value = null;
            if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
              final HSSFRichTextString richString = cell.getRichStringCellValue();
              if (richString != null) {
                value = richString.getString();
              } else {
                value = "";
              }
            } else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
              try {
                value = new Double(cell.getNumericCellValue());
              } catch (NumberFormatException ex) {
                log.error(null, ex);
                value = new Double(0.0);
              }
            } else {
            }

            if (null == value) {
              continue;
            }
            atoms.add(new Atom(value, types.get(j - startCell)));
          }
          final Statement statement = new Statement(atoms);

          if (s.getType() != statement.getType()) {
            // Give up.
            s = null;
            break;
          }
          s.statements.add(statement);
        } // for (int i = startRow + 1; i <= endRow; i++)

        if (s != null) {
          statementsList.add(s);
        }
      } /* for(int k = 0; k < numberOfSheets; k++) */
    } catch (Exception ex) {
      log.error(null, ex);
    } finally {
      org.yccheok.jstock.gui.Utils.close(fileInputStream);
    }
    return statementsList;
  }
コード例 #11
0
ファイル: Statements.java プロジェクト: KazemTapTop/tsemc
  /**
   * Construct Statements based on given stock history server.
   *
   * @param server stock history server
   * @param languageIndependent should the returned statements be language independent?
   * @return the constructed Statements. UNKNOWN_STATEMENTS if fail
   */
  public static Statements newInstanceFromStockHistoryServer(
      StockHistoryServer server, boolean languageIndependent) {
    final GUIBundleWrapper guiBundleWrapper =
        GUIBundleWrapper.newInstance(
            languageIndependent
                ? GUIBundleWrapper.Language.INDEPENDENT
                : GUIBundleWrapper.Language.DEFAULT);

    final Statements s = new Statements(Statement.Type.StockHistory, guiBundleWrapper);

    final int size = server.size();

    final DateFormat dateFormat = org.yccheok.jstock.gui.Utils.getCommonDateFormat();

    Stock stock = null;
    for (int i = 0; i < size; i++) {
      final long timestamp = server.getTimestamp(i);
      stock = server.getStock(timestamp);
      assert (timestamp != 0 && stock != null);
      final List<Atom> atoms = new ArrayList<Atom>();
      final Atom atom0 =
          new Atom(dateFormat.format(timestamp), guiBundleWrapper.getString("StockHistory_Date"));
      final Atom atom1 =
          new Atom(
              Double.valueOf(stock.getOpenPrice()),
              guiBundleWrapper.getString("StockHistory_Open"));
      final Atom atom2 =
          new Atom(
              Double.valueOf(stock.getHighPrice()),
              guiBundleWrapper.getString("StockHistory_High"));
      final Atom atom3 =
          new Atom(
              Double.valueOf(stock.getLowPrice()), guiBundleWrapper.getString("StockHistory_Low"));
      final Atom atom4 =
          new Atom(
              Double.valueOf(stock.getLastPrice()),
              guiBundleWrapper.getString("StockHistory_Close"));
      // TODO: CRITICAL LONG BUG REVISED NEEDED.
      final Atom atom5 =
          new Atom(
              Long.valueOf(stock.getVolume()), guiBundleWrapper.getString("StockHistory_Volume"));
      atoms.add(atom0);
      atoms.add(atom1);
      atoms.add(atom2);
      atoms.add(atom3);
      atoms.add(atom4);
      atoms.add(atom5);

      Statement statement = new Statement(atoms);
      // They should be the same type. The checking just act as paranoid.
      if (s.getType() != statement.getType()) {
        throw new java.lang.RuntimeException("" + statement.getType());
      }
      s.statements.add(statement);
    }

    if (stock != null) {
      // Metadata. Oh yeah...
      s.metadatas.put("code", stock.getCode().toString());
      s.metadatas.put("symbol", stock.getSymbol().toString());
      s.metadatas.put("name", stock.getName());
      s.metadatas.put("board", stock.getBoard().name());
      s.metadatas.put("industry", stock.getIndustry().name());
    }

    return s;
  }