function recordDailyNetworth() {

  updateRates();

  recordDailyFiatNetWorth();
  recordDailyCryptoNetWorth();
}

function recordDailyFiatNetWorth() {
  var netWorthSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Net Worth");
  var nwOverTimeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Net Worth Over Time");

  var totalUsdValue = netWorthSheet.getRange("totalUsdValue").getValue();
  var fiatUsdValue = netWorthSheet.getRange("fiatUsdValue").getValue();
  var cryptoUsdValue = netWorthSheet.getRange("cryptoUsdValue").getValue();

  var percentCryptoBtc = netWorthSheet.getRange("percentCryptoBtc").getValue();
  var percentCryptoAlt = netWorthSheet.getRange("percentCryptoAlt").getValue();

  var todaysRowNumber = nwOverTimeSheet.getRange("N1").getValue();

  nwOverTimeSheet.getRange(todaysRowNumber, 3).setValue(fiatUsdValue);
  nwOverTimeSheet.getRange(todaysRowNumber, 4).setValue(cryptoUsdValue);
  nwOverTimeSheet.getRange(todaysRowNumber, 5).setValue(totalUsdValue);

  nwOverTimeSheet.getRange(todaysRowNumber, 8).setValue(percentCryptoBtc);
  nwOverTimeSheet.getRange(todaysRowNumber, 9).setValue(percentCryptoAlt);
}

function recordDailyCryptoNetWorth() {

  var netWorthSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Net Worth");
  var cnwOverTimeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Crypto Value Over Time");

  var todaysRowNumber = cnwOverTimeSheet.getRange("A2").getValue();

  cnwOverTimeSheet.getRange(todaysRowNumber, 3).setValue(netWorthSheet.getRange("btcCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 4).setValue(netWorthSheet.getRange("kmdCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 5).setValue(netWorthSheet.getRange("xmrCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 6).setValue(netWorthSheet.getRange("bchCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 7).setValue(netWorthSheet.getRange("vtcCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 8).setValue(netWorthSheet.getRange("venCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 9).setValue(netWorthSheet.getRange("pivxCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 11).setValue(netWorthSheet.getRange("arkCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 12).setValue(netWorthSheet.getRange("omgCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 13).setValue(netWorthSheet.getRange("zecCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 14).setValue(netWorthSheet.getRange("qspCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 15).setValue(netWorthSheet.getRange("ethCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 16).setValue(netWorthSheet.getRange("viaCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 17).setValue(netWorthSheet.getRange("ubqCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 18).setValue(netWorthSheet.getRange("lskCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 19).setValue(netWorthSheet.getRange("expCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 20).setValue(netWorthSheet.getRange("dashCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 21).setValue(netWorthSheet.getRange("dogeCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 22).setValue(netWorthSheet.getRange("hsrCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 23).setValue(netWorthSheet.getRange("ltcCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 24).setValue(netWorthSheet.getRange("qtumCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 26).setValue(netWorthSheet.getRange("xlmCurrentValue").getValue());
  cnwOverTimeSheet.getRange(todaysRowNumber, 27).setValue(netWorthSheet.getRange("stratCurrentValue").getValue());
}


function updateRates() {

  var netWorthSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Net Worth");

  var btcUsdRate = getRateForCurrencyId('bitcoin');
  var kmdUsdRate = getRateForCurrencyId('komodo');
  var xmrUsdRate = getRateForCurrencyId('monero');
  var bchUsdRate = getRateForCurrencyId('bitcoin-cash');
  var vtcUsdRate = getRateForCurrencyId('vertcoin');
  var venUsdRate = getRateForCurrencyId('vechain');
  var pvxUsdRate = getRateForCurrencyId('pivx');
  var arkUsdRate = getRateForCurrencyId('ark');
  var omgUsdRate = getRateForCurrencyId('omisego');
  var zecUsdRate = getRateForCurrencyId('zcash');
  var qspUsdRate = getRateForCurrencyId('quantstamp');
  var ethUsdRate = getRateForCurrencyId('ethereum');
  var viaUsdRate = getRateForCurrencyId('viacoin');
  var ubqUsdRate = getRateForCurrencyId('ubiq');
  var lskUsdRate = getRateForCurrencyId('lisk');
  var expUsdRate = getRateForCurrencyId('expanse');
  var dashUsdRate = getRateForCurrencyId('dash');
  var dogeUsdRate = getRateForCurrencyId('dogecoin');
  var hsrUsdRate = getRateForCurrencyId('hshare');
  var ltcUsdRate = getRateForCurrencyId('litecoin');
  var qtumUsdRate = getRateForCurrencyId('qtum');
  var xlmUsdRate = getRateForCurrencyId('stellar');
  var stratUsdRate = getRateForCurrencyId('stratis');


  netWorthSheet.getRange("btcUsdRate").setValue(btcUsdRate);
  netWorthSheet.getRange("kmdUsdRate").setValue(kmdUsdRate);
  netWorthSheet.getRange("xmrUsdRate").setValue(xmrUsdRate);
  netWorthSheet.getRange("bchUsdRate").setValue(bchUsdRate);
  netWorthSheet.getRange("vtcUsdRate").setValue(vtcUsdRate);
  netWorthSheet.getRange("venUsdRate").setValue(venUsdRate);
  netWorthSheet.getRange("pvxUsdRate").setValue(pvxUsdRate);
  netWorthSheet.getRange("arkUsdRate").setValue(arkUsdRate);
  netWorthSheet.getRange("omgUsdRate").setValue(omgUsdRate);
  netWorthSheet.getRange("zecUsdRate").setValue(zecUsdRate);
  netWorthSheet.getRange("qspUsdRate").setValue(qspUsdRate);
  netWorthSheet.getRange("ethUsdRate").setValue(ethUsdRate);
  netWorthSheet.getRange("viaUsdRate").setValue(viaUsdRate);
  netWorthSheet.getRange("ubqUsdRate").setValue(ubqUsdRate);
  netWorthSheet.getRange("lskUsdRate").setValue(lskUsdRate);
  netWorthSheet.getRange("expUsdRate").setValue(expUsdRate);
  netWorthSheet.getRange("dashUsdRate").setValue(dashUsdRate);
  netWorthSheet.getRange("dogeUsdRate").setValue(dogeUsdRate);
  netWorthSheet.getRange("hsrUsdRate").setValue(hsrUsdRate);
  netWorthSheet.getRange("ltcUsdRate").setValue(ltcUsdRate);
  netWorthSheet.getRange("qtumUsdRate").setValue(qtumUsdRate);
  netWorthSheet.getRange("xlmUsdRate").setValue(xlmUsdRate);
  netWorthSheet.getRange("stratUsdRate").setValue(stratUsdRate);
}


function getRateForCurrencyId(currencyId) {

  var url = 'https://api.coinmarketcap.com/v1/ticker/' + currencyId + '/';
  var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true});
  var json = response.getContentText();
  var data = JSON.parse(json);

  return parseFloat(data[0]['price_usd']);
}