SBI ネットバンク総投資額計算スクリプト

amont_sbi.rb

# coding: utf-8

require 'csv'

_header, *table = CSV.read(ARGV[0], encoding: 'cp932:utf-8')

SBI = 'ＳＢＩハイブリッド預金'

def column_sum(table, num)
  table.map do |item|
    if item[1] == SBI and item[num]
      item[num].sub(',', '').to_i
    else
      0
    end
  end.reduce(:+)
end

def jpy(money)
  (money / 10_000.0).to_s + ' 万円'
end

deposit = column_sum(table, 3)
payment = column_sum(table, 2)

puts '入金額 ' + jpy(deposit)
puts '出金額 ' + jpy(payment)
puts '株式投資額 ' + jpy(payment - deposit)