{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Inicio","Cartera","Asignación de activos"],"not_rendered":{"charts":1,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Inicio","index":0,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[0,1,0,12],[2,1,2,11],[6,1,6,3],[6,11,6,12],[27,2,27,4]]}
[null,"SEGUIMIENTO DE LA INVERSIÓN"]
[]
[null,"La plantilla Seguimiento de la inversión le permitirá realizar un seguimiento de sus inversiones y la asignación de activos. El tipo de datos Cotizaciones de Excel mantendrá su cartera al día con los precios actuales y los detalles de sus activos. Hay dos hojas de cálculo, Cartera y Asignación de activos, que se describen a continuación. Nota: El tipo de datos Cotizaciones de Excel es una función de Office 365 disponible solo con suscripción. "]
[]
[null,"Cartera"]
[]
[null,"Agregue sus inversiones; escriba símbolos bursátiles, nombres de empresas o nombres de fondos en los ejemplos, o añada más ejemplos en filas adicionales. Seleccione una categoría de activo y escriba el número de acciones.",{"$nulls":9},"Haga clic en el botón Agregar columna para agregar columnas adicionales como Símbolo bursátil o Canje.\n"]
{"$rows_empty":16}
[null,"Haga clic en cualquiera de las cotizaciones para actualizar los datos. En la pestaña Datos, en el grupo Consultas y conexiones, haga clic en Actualizar todo o presione Ctrl+Alt+F5."]
[]
[null,"Asignación de activos"]
[]
[null,"Cambie Categorías y Mi objetivo para personalizar los objetivos de su cartera.","Cuando una categoría de activo supere el Umbral, las cantidades se resaltarán en amarillo."]

{"sheet":"Cartera","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[0,1,0,4]]}
[null,"SEGUIMIENTO DE LA INVERSIÓN"]
[]
[null,"Cartera"]
[]
[null,"Empresa","Categoría","Acciones","Precio","Cambio","Cambio (%)","Cartera %","Valor"]
[null,{"$error":"#VALUE!"},"Acciones de Estados Unidos",{"v":1200,"d":"1,200"},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Price\")","v":{"v":272.29,"d":"272.29 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change\")","v":{"v":-1.49,"d":"-1.49 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change (%)\",TRUE)","v":{"v":-0.005442,"d":"-0.54%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,TablePortfolio[Valor]),\"\")","v":""},{"$f":"D6 * E6","v":{"v":326748,"d":"326,748.00 €"}}]
[null,{"$error":"#VALUE!"},"Bonos",{"v":1300,"d":"1,300"},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Price\")","v":{"v":9.72,"d":"9.72 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change\")","v":{"v":0.09,"d":"0.09 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change (%)\",TRUE)","v":{"v":0.009346,"d":"0.93%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,TablePortfolio[Valor]),\"\")","v":""},{"v":12636,"d":"12,636.00 €"}]
[null,{"$error":"#VALUE!"},"Acciones internacionales",{"v":1200,"d":"1,200"},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Price\")","v":{"v":28.67,"d":"28.67 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change\")","v":0},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change (%)\",TRUE)","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,TablePortfolio[Valor]),\"\")","v":""},{"v":34404,"d":"34,404.00 €"}]
[null,{"$error":"#VALUE!"},"Efectivo",{"v":10000,"d":"10,000"},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Price\")","v":{"$error":"#VALUE!"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change\")","v":{"$error":"#VALUE!"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change (%)\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(I9/SUBTOTAL(109,TablePortfolio[Valor]),\"\")","v":""},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},"Inmuebles",125,{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Price\")","v":{"v":110.69,"d":"110.69 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change\")","v":{"v":-4.25,"d":"-4.25 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change (%)\",TRUE)","v":{"v":-0.036976,"d":"-3.70%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,TablePortfolio[Valor]),\"\")","v":""},{"v":13836.25,"d":"13,836.25 €"}]
[null,{"$error":"#VALUE!"},"Productos",100,{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Price\")","v":{"v":183.44,"d":"183.44 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change\")","v":{"v":3.07,"d":"3.07 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Empresa]],\"Change (%)\",TRUE)","v":{"v":0.017020999999999998,"d":"1.70%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,TablePortfolio[Valor]),\"\")","v":""},{"v":18344,"d":"18,344.00 €"}]
[null,"Total",{"$nulls":6},{"$f":"IFERROR(SUBTOTAL(109,TablePortfolio[Valor]), \"\")","v":""}]

{"sheet":"Asignación de activos","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,6]]}
[null,"SEGUIMIENTO DE LA INVERSIÓN"]
[]
[null,"Asignación de activos"]
{"$rows_empty":15}
[null,"Categoría","Mi objetivo","Real","Diferencia","Umbral","Valor"]
[null,"Acciones de Estados Unidos",{"v":0.55,"d":"55%"},{"$f":"IFERROR(G20/SUBTOTAL(109,TableAssetAllocation[Valor]),\"\")","v":""},{"$f":"D20 - C20","v":{"$error":"#VALUE!"}},{"$f":"MIN(5%, $C20 * 25%)","v":{"v":0.05,"d":"5%"}},{"$f":"SUMIF(TablePortfolio[Categoría], B20, TablePortfolio[Valor])","v":{"v":326748,"d":"326,748.00 €"}}]
[null,"Acciones internacionales",{"v":0.2,"d":"20%"},{"$f":"IFERROR(G21/SUBTOTAL(109,TableAssetAllocation[Valor]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.05,"d":"5%"},{"$f":"SUMIF(TablePortfolio[Categoría], B21, TablePortfolio[Valor])","v":{"v":34404,"d":"34,404.00 €"}}]
[null,"Bonos",{"v":0.1,"d":"10%"},{"$f":"IFERROR(G22/SUBTOTAL(109,TableAssetAllocation[Valor]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.025,"d":"3%"},{"$f":"SUMIF(TablePortfolio[Categoría], B22, TablePortfolio[Valor])","v":{"v":12636,"d":"12,636.00 €"}}]
[null,"Efectivo",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G23/SUBTOTAL(109,TableAssetAllocation[Valor]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Categoría], B23, TablePortfolio[Valor])","v":{"$error":"#VALUE!"}}]
[null,"Inmuebles",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G24/SUBTOTAL(109,TableAssetAllocation[Valor]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Categoría], B24, TablePortfolio[Valor])","v":{"v":13836.25,"d":"13,836.25 €"}}]
[null,"Productos",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,TableAssetAllocation[Valor]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Categoría], B25, TablePortfolio[Valor])","v":{"v":18344,"d":"18,344.00 €"}}]