Update investments quotes in a libreoffice spreadsheet using ruby and yahoo finances gem

finances.rb

require 'yahoo-finance'

stocks = ["PETR3.SA"]

yahoo_client = YahooFinance::Client.new
data = yahoo_client.quotes( stocks, [:close])

File.open("quotes.csv", "w+") do |file|
  stocks.size.times do |x|
    file.puts "\"#{stocks[x]}\",#{data[x].close}"
  end
end

exec("libreoffice --calc -o Investimentos.ods")