50:30:20 Rule of Budgeting on Google Sheet of Ankur Warikoo

---

f(x) : excel formula tutorial

    for i in range(3, 12):
        var = [f'=(A{i-1}+1)', f'=(D{i-1})', f'=(10%*B{i})',
               f'=(B{i}+C{i})', f'=(E{i-1}+C{i}*$J$2/12)',
               f'=(F{i-1}+C{i}*$I$2/12)',
               f'=(G{i-1}+C{i}*$H$2/12)', f'=(E{i}*12/$D{i})',
               f'=(F{i}*12/$D{i})', f'=(G{i}*12/$D{i})']

        obj.mark(sheet_id, f'A{i}', [var])

---

---

API Calls in Google Sheets

    function callNumbers() {
      let url = "https://api.metalpriceapi.com/v1/latest?base=USD&currencies=XAU,XAG&api_key=Dxt3fx5NcET88EGsAtvrdJ";
      let fact = UrlFetchApp.fetch(url);

      let apiResponse = JSON.parse(fact.getContentText());
      Logger.log(apiResponse);

      const date = new Date(apiResponse.timestamp*1000);
      let unixdate = date.toLocaleDateString("en-IN");
      let unixtime = date.toLocaleTimeString("en-IN");

      let price = apiResponse.rates.XAU*100000000;
      console.log(unixdate, unixtime, price);

      let sheet = SpreadsheetApp.getActiveSheet();
      sheet.getRange(1,1).setValue("Unix Timestamp");
      sheet.getRange(1,2).setValue("Rate of Gold");

      sheet.getRange(sheet.getLastRow() + 1,1).setValue(unixdate + ' ' + unixtime);
      sheet.getRange(sheet.getLastRow() + 0,2).setValue(price);
    }

---

Auto Function Trigger : StackOverflow