Document<\/title>\n <style>\n table {\n color: #798290 !important;\n overflow: hidden;\n \n }\n\n #tabla-container {\n overflow: hidden;\n max-width: 700px;\n\n margin: auto;\n display: flex;\n flex-direction: column;\n justify-content: center;\n }\n th {\n background: #B4DCC5;\n padding: 5px;\n }\n\n .fondoVerde {\n background-color: rgb(0, 156, 100);\n color: white;\n position: relative;\n padding: 5px;\n }\n\n tbody {\n display: flex;\n justify-content: center;\n align-items: center;\n width: 100%;\n flex-direction: column;\n }\n\n tr {\n\n display: grid;\n width: 100%;\n margin: auto;\n grid-template-columns: 50% 50%;\n gap:10px;\n }\n <\/style>\n<\/head>\n\n<body>\n\n <div id=\"tabla-container\"><\/div>\n <script>\n \n let contratosDeFuturos, contratosMini, contratosDeOpciones, dolarFuturo, rentaVariableByma, rentaFijaByma, caucionColocadoraByma,\n caucionTomadoraByma, opcionesByma, derivadosFuturosByma, chequePagoDiferidoMAV, pagareMAV, caucionTomadoraMAV, caucionColocadoraMAV\n\n\n\nconst urlSheet = 'https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/1FwLghSBRPTzcOVducwIeN16bW7yzfQaw0NKR6G8BuHc\/values\/comisiones!A:B?alt=json&key=AIzaSyCA0y4IomUXhE09JOqChDuhS0c9cUz_dwI';\nconst sheetOriginalEditable = 'https:\/\/docs.google.com\/spreadsheets\/d\/1FwLghSBRPTzcOVducwIeN16bW7yzfQaw0NKR6G8BuHc\/edit#gid=255459112'\n\nasync function getDataJson(urlSheet) {\n const response = await fetch(urlSheet)\n const dataJson = await response.json()\n return dataJson\n}\n\n\nfunction armarWidget() {\n getDataJson(urlSheet)\n .then(dataJson => verificarValoresJSON(dataJson.values.slice(1)))\n} function verificarValoresJSON(data) {\n\n\n data.forEach(item => {\n console.log('item', item)\n let comisionCorrespondiente = item[1]\n switch (item[0]) {\n case 'Contratos de Futuros':\n contratosDeFuturos = comisionCorrespondiente\n break;\n case 'Contratos MINI':\n contratosMini = comisionCorrespondiente\n break;\n case 'Contratos de Opciones':\n contratosDeOpciones = comisionCorrespondiente\n break;\n case 'D\u00f3lar Futuro':\n dolarFuturo = comisionCorrespondiente\n break;\n case 'Renta Variable':\n rentaVariableByma = comisionCorrespondiente\n break;\n case 'Renta Fija':\n rentaFijaByma = comisionCorrespondiente\n break;\n case 'Cauci\u00f3n Tomadora':\n caucionTomadoraByma = comisionCorrespondiente\n break;\n case 'Cauci\u00f3n Colocadora':\n caucionColocadoraByma = comisionCorrespondiente\n break;\n case 'Opciones':\n opcionesByma = comisionCorrespondiente;\n break;\n case 'Derivados y Futuros financieros':\n derivadosFuturosByma = comisionCorrespondiente\n break;\n case 'Cheque de Pago Diferido':\n chequePagoDiferidoMAV = comisionCorrespondiente;\n break;\n case 'Pagar\u00e9':\n pagareMAV = comisionCorrespondiente;\n break;\n case 'Cauci\u00f3n Tomadora MAV':\n caucionTomadoraMAV = comisionCorrespondiente\n break;\n case 'Cauci\u00f3n Colocadora MAV':\n caucionColocadoraMAV = comisionCorrespondiente\n break;\n default:\n break;\n }\n });\n\n construirTabla();\n}\n\n\n\n\nfunction construirTabla() {\n const tablaComisiones = `\n <h2 class=\"fondoVerde\">Comisiones en MATBA\/ROFEX<\/h2>\n <table>\n <thead>\n <tr>\n <th>Activo<\/th>\n <th>Comisi\u00f3n<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>Contratos de Futuros<\/td>\n <td>${contratosDeFuturos}<\/td>\n <\/tr>\n <tr>\n <td>Contratos MINI<\/td>\n <td>${contratosMini}<\/td>\n <\/tr>\n <tr>\n <td>Contratos de Opciones<\/td>\n <td>${contratosDeOpciones}<\/td>\n <\/tr>\n <tr>\n <td>D\u00f3lar Futuro<\/td>\n <td>${dolarFuturo}<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n\n <h2 class=\"fondoVerde\">Comisiones BYMA<\/h2>\n <table>\n <thead>\n <tr>\n <th>Activo<\/th>\n <th>Comisi\u00f3n<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>Renta Variable<\/td>\n <td>${rentaVariableByma}<\/td>\n <\/tr>\n <tr>\n <td>Renta Fija<\/td>\n <td>${rentaFijaByma}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Tomadora<\/td>\n <td>${caucionTomadoraByma}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Colocadora<\/td>\n <td>${caucionColocadoraByma}<\/td>\n <\/tr>\n <tr>\n <td>Opciones<\/td>\n <td>${opcionesByma}<\/td>\n <\/tr>\n <tr>\n <td>Derivados y Futuros financieros<\/td>\n <td>${derivadosFuturosByma}<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n\n <h2 class=\"fondoVerde\" >Comisiones MAV<\/h2>\n <table>\n <thead>\n <tr>\n <th>Activo<\/th>\n <th>Comisi\u00f3n<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>Cheque de Pago Diferido<\/td>\n <td>${chequePagoDiferidoMAV}<\/td>\n <\/tr>\n <tr>\n <td>Pagar\u00e9<\/td>\n <td>${pagareMAV}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Tomadora<\/td>\n <td>${caucionTomadoraMAV}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Colocadora<\/td>\n <td>${caucionColocadoraMAV}<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n `;\n\n document.getElementById('tabla-container').innerHTML = tablaComisiones;\n}\n\narmarWidget();\n <\/script>\n<\/body>\n\n<\/html>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Document<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/585"}],"collection":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=585"}],"version-history":[{"count":45,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/585\/revisions"}],"predecessor-version":[{"id":671,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/585\/revisions\/671"}],"wp:attachment":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

\n\t\t\t\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t\n\n\n\n \n \n \n Document<\/title>\n <style>\n table {\n color: #798290 !important;\n overflow: hidden;\n \n }\n\n #tabla-container {\n overflow: hidden;\n max-width: 700px;\n\n margin: auto;\n display: flex;\n flex-direction: column;\n justify-content: center;\n }\n th {\n background: #B4DCC5;\n padding: 5px;\n }\n\n .fondoVerde {\n background-color: rgb(0, 156, 100);\n color: white;\n position: relative;\n padding: 5px;\n }\n\n tbody {\n display: flex;\n justify-content: center;\n align-items: center;\n width: 100%;\n flex-direction: column;\n }\n\n tr {\n\n display: grid;\n width: 100%;\n margin: auto;\n grid-template-columns: 50% 50%;\n gap:10px;\n }\n <\/style>\n<\/head>\n\n<body>\n\n <div id=\"tabla-container\"><\/div>\n <script>\n \n let contratosDeFuturos, contratosMini, contratosDeOpciones, dolarFuturo, rentaVariableByma, rentaFijaByma, caucionColocadoraByma,\n caucionTomadoraByma, opcionesByma, derivadosFuturosByma, chequePagoDiferidoMAV, pagareMAV, caucionTomadoraMAV, caucionColocadoraMAV\n\n\n\nconst urlSheet = 'https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/1FwLghSBRPTzcOVducwIeN16bW7yzfQaw0NKR6G8BuHc\/values\/comisiones!A:B?alt=json&key=AIzaSyCA0y4IomUXhE09JOqChDuhS0c9cUz_dwI';\nconst sheetOriginalEditable = 'https:\/\/docs.google.com\/spreadsheets\/d\/1FwLghSBRPTzcOVducwIeN16bW7yzfQaw0NKR6G8BuHc\/edit#gid=255459112'\n\nasync function getDataJson(urlSheet) {\n const response = await fetch(urlSheet)\n const dataJson = await response.json()\n return dataJson\n}\n\n\nfunction armarWidget() {\n getDataJson(urlSheet)\n .then(dataJson => verificarValoresJSON(dataJson.values.slice(1)))\n} function verificarValoresJSON(data) {\n\n\n data.forEach(item => {\n console.log('item', item)\n let comisionCorrespondiente = item[1]\n switch (item[0]) {\n case 'Contratos de Futuros':\n contratosDeFuturos = comisionCorrespondiente\n break;\n case 'Contratos MINI':\n contratosMini = comisionCorrespondiente\n break;\n case 'Contratos de Opciones':\n contratosDeOpciones = comisionCorrespondiente\n break;\n case 'D\u00f3lar Futuro':\n dolarFuturo = comisionCorrespondiente\n break;\n case 'Renta Variable':\n rentaVariableByma = comisionCorrespondiente\n break;\n case 'Renta Fija':\n rentaFijaByma = comisionCorrespondiente\n break;\n case 'Cauci\u00f3n Tomadora':\n caucionTomadoraByma = comisionCorrespondiente\n break;\n case 'Cauci\u00f3n Colocadora':\n caucionColocadoraByma = comisionCorrespondiente\n break;\n case 'Opciones':\n opcionesByma = comisionCorrespondiente;\n break;\n case 'Derivados y Futuros financieros':\n derivadosFuturosByma = comisionCorrespondiente\n break;\n case 'Cheque de Pago Diferido':\n chequePagoDiferidoMAV = comisionCorrespondiente;\n break;\n case 'Pagar\u00e9':\n pagareMAV = comisionCorrespondiente;\n break;\n case 'Cauci\u00f3n Tomadora MAV':\n caucionTomadoraMAV = comisionCorrespondiente\n break;\n case 'Cauci\u00f3n Colocadora MAV':\n caucionColocadoraMAV = comisionCorrespondiente\n break;\n default:\n break;\n }\n });\n\n construirTabla();\n}\n\n\n\n\nfunction construirTabla() {\n const tablaComisiones = `\n <h2 class=\"fondoVerde\">Comisiones en MATBA\/ROFEX<\/h2>\n <table>\n <thead>\n <tr>\n <th>Activo<\/th>\n <th>Comisi\u00f3n<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>Contratos de Futuros<\/td>\n <td>${contratosDeFuturos}<\/td>\n <\/tr>\n <tr>\n <td>Contratos MINI<\/td>\n <td>${contratosMini}<\/td>\n <\/tr>\n <tr>\n <td>Contratos de Opciones<\/td>\n <td>${contratosDeOpciones}<\/td>\n <\/tr>\n <tr>\n <td>D\u00f3lar Futuro<\/td>\n <td>${dolarFuturo}<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n\n <h2 class=\"fondoVerde\">Comisiones BYMA<\/h2>\n <table>\n <thead>\n <tr>\n <th>Activo<\/th>\n <th>Comisi\u00f3n<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>Renta Variable<\/td>\n <td>${rentaVariableByma}<\/td>\n <\/tr>\n <tr>\n <td>Renta Fija<\/td>\n <td>${rentaFijaByma}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Tomadora<\/td>\n <td>${caucionTomadoraByma}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Colocadora<\/td>\n <td>${caucionColocadoraByma}<\/td>\n <\/tr>\n <tr>\n <td>Opciones<\/td>\n <td>${opcionesByma}<\/td>\n <\/tr>\n <tr>\n <td>Derivados y Futuros financieros<\/td>\n <td>${derivadosFuturosByma}<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n\n <h2 class=\"fondoVerde\" >Comisiones MAV<\/h2>\n <table>\n <thead>\n <tr>\n <th>Activo<\/th>\n <th>Comisi\u00f3n<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td>Cheque de Pago Diferido<\/td>\n <td>${chequePagoDiferidoMAV}<\/td>\n <\/tr>\n <tr>\n <td>Pagar\u00e9<\/td>\n <td>${pagareMAV}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Tomadora<\/td>\n <td>${caucionTomadoraMAV}<\/td>\n <\/tr>\n <tr>\n <td>Cauci\u00f3n Colocadora<\/td>\n <td>${caucionColocadoraMAV}<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n `;\n\n document.getElementById('tabla-container').innerHTML = tablaComisiones;\n}\n\narmarWidget();\n <\/script>\n<\/body>\n\n<\/html>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Document<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/585"}],"collection":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=585"}],"version-history":[{"count":45,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/585\/revisions"}],"predecessor-version":[{"id":671,"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/585\/revisions\/671"}],"wp:attachment":[{"href":"https:\/\/valcereal.com.ar\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}