tesouro.js

// na planilha:
// =CONCATENATE("run('", SUBSTITUTE($A$1,"EXTRATO ANALÍTICO - ",""), "', '", SUBSTITUTE(SUBSTITUTE(D8, ".", ""), ",", "."), "', '", B8, "', '", SUBSTITUTE(SUBSTITUTE(C8, ".", ""), ",", "."), "', '", A8, "')")

function run(asset, total, qty, price, date) {
  new Date(date.split("/")[1] + '/' + date.split("/")[0] + '/' + date.split("/")[2]).toISOString().substring(0, 10)

  fetch("https://myprofitweb.com/API/NewAsset", {
    "headers": {
      "accept": "*/*",
      "accept-language": "en-US,en;q=0.9,pt-BR;q=0.8,pt;q=0.7",
      "content-type": "multipart/form-data; boundary=----WebKitFormBoundaryFETPyhQBwCmVWAaL",
      "sec-ch-ua": "\"Google Chrome\";v=\"95\", \"Chromium\";v=\"95\", \";Not A Brand\";v=\"99\"",
      "sec-ch-ua-mobile": "?0",
      "sec-ch-ua-platform": "\"Linux\"",
      "sec-fetch-dest": "empty",
      "sec-fetch-mode": "cors",
      "sec-fetch-site": "same-origin",
      "x-requested-with": "XMLHttpRequest",
      // "cookie": COPY THE COOKIE HERE MAIN
      "Referer": "https://myprofitweb.com/App/NewAsset.aspx",
      "Referrer-Policy": "strict-origin-when-cross-origin"
    },
    "body": "------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"action\"\r\n\r\nnew\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"category\"\r\n\r\nTreasury\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"type\"\r\n\r\nTREASURY\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"typeText\"\r\n\r\nTesouro Direto\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"operation\"\r\n\r\nManualBuy\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"exchange\"\r\n\r\nEasynvest\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"date\"\r\n\r\n" + date  + "\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"typetax\"\r\n\r\nnull\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"index\"\r\n\r\nnull\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"duedate\"\r\n\r\n\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"tax\"\r\n\r\n\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"qty\"\r\n\r\n" + qty + "\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"price\"\r\n\r\n" + price + "\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"total\"\r\n\r\n" + total  + "\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"docid\"\r\n\r\n0\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"previoustotal\"\r\n\r\n0\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"proventType\"\r\n\r\nRENDIMENTO\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"asset\"\r\n\r\n" + asset + "\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL\r\nContent-Disposition: form-data; name=\"assetBase\"\r\n\r\nnull\r\n------WebKitFormBoundaryFETPyhQBwCmVWAaL--\r\n",
    "method": "POST"
  });
}