pedromenezes

<a href="http://dolarhoje.com/" class="dolar-hoje-button" data-currency="dolar">Dólar Hoje</a><script async src="//s3.amazonaws.com/dolarhoje-widgets/v1.js"></script>

pedromenezes

function dolarHojeExtract(url, reference){
  return UrlFetchApp.fetch(url.replace(/([^\/]+)$/, '$1/') + "cotacao.txt").getContentText();
}

function refresh() {
  SpreadsheetApp.getActiveSheet().getActiveCell().setValue("Última atualização: " + new Date().toLocaleString());
}

function onOpen(e) {
  SpreadsheetApp.getUi().createMenu('Dólar Hoje').addItem('Atualizar', 'refresh').addToUi();

pedromenezes

function dolarHojePegaCotacao(url, reference){
  return parseFloat(UrlFetchApp.fetch(url.replace(/([^\/]+)$/, '$1/') + "cotacao.txt").getContentText().replace(',', '.'));
}

function refresh() {
  SpreadsheetApp.getActiveSheet().getActiveCell().setValue("Última atualização: " + new Date().toLocaleString());
}

function onOpen(e) {
  SpreadsheetApp.getUi().createMenu('Dólar Hoje').addItem('Atualizar', 'refresh').addToUi();