{"id":1645,"date":"2018-10-28T00:41:27","date_gmt":"2018-10-28T00:41:27","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=1645"},"modified":"2023-06-12T17:41:34","modified_gmt":"2023-06-12T17:41:34","slug":"calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/","title":{"rendered":"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM"},"content":{"rendered":"<h2>Acerca del modelo CAPM<\/h2>\n<p>Casualidades de la vida, en las \u00faltimas semanas me he interesado mucho en el modelo CAPM: <em>capital asset pricing model<\/em>. Ciertamente no lo domino (a\u00fan), pero estoy examinando el tema y elaborando material en distintas herramientas que me permitan entrarle al tema con m\u00e1s rigor y que me permitan abordar otros temas relacionados. Empezar\u00e9 por lo b\u00e1sico: c\u00e1lculo de betas en Google Sheets.<\/p>\n<p>La idea general del modelo CAPM es esta: determinar la tasa de rentabilidad esperada para un activo, bajo la premisa de que un inversionista espera una compensaci\u00f3n consistente de dos elementos: i) una parte que compense el valor del dinero en el tiempo; ii) una parte (premio) que compense por el riesgo. La primera parte est\u00e1 determinada por la tasa libre de riesgo, la segunda parte depende del activo relevante.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1657\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta0.png\" alt=\"modelo capm\" width=\"579\" height=\"243\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta0.png 838w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta0-300x126.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta0-768x323.png 768w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><\/p>\n<p>Para determinar la parte que compensa por el riesgo, necesitamos un coeficiente llamado &#8220;beta&#8221;. Es una medida de volatlidad del activo relativa a la variabilidad del mercado de referencia. Un valor alto del coeficiente, muestra una mayor volatilidad. El c\u00e1lculo del coeficiente beta es como sigue:<\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1663 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta1.png\" alt=\"beta modelo capm\" width=\"365\" height=\"154\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta1.png 365w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta1-300x127.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/h2>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- post_edate --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4902726138\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>La herramienta<\/h2>\n<p>La herramienta que aqu\u00ed se presenta, depende del servicio Google Finance (Google Finanzas). Se trata de un servicio de informaci\u00f3n financiera, mismo que tiene entregas disponibles en Google Sheets con la f\u00f3rmula <strong>GOOGLEFINANCE <\/strong>(ver detalles en este <strong><a href=\"https:\/\/support.google.com\/docs\/answer\/3093281?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">link<\/a><\/strong>).&nbsp;Ampliamente recomendable: encuentras mucha informaci\u00f3n oportuna y ordenada en web, y tambi\u00e9n disponible para descarga.<\/p>\n<p>La hoja en Google Sheets est\u00e1 disponible en este link (haz una copia a tu Google Drive):<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/13Vfdd19rCxov_WAh5c-QacPWCrFFsYQSs_Tn5xiAYLw\/edit#gid=596502174\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/13Vfdd19rCxov_WAh5c-QacPWCrFFsYQSs_Tn5xiAYLw.<\/a><br \/>\nFunciona as\u00ed:<\/p>\n<p>0. En la hoja &#8220;theCompany&#8221;, ver\u00e1s la informaci\u00f3n de la compa\u00f1\u00eda que est\u00e1s revisando. En este caso, eleg\u00ed la compa\u00f1\u00eda <strong>MSCI<\/strong>. El ticker es <strong>MSCI<\/strong> (celda E2).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1667\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta2.png\" alt=\"\" width=\"257\" height=\"200\"><br \/>\n1. Eliges una frecuencia. En Google Finance hay dos opciones: semanal o diario. Para este caso, eleg\u00ed diario.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1668\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta3.png\" alt=\"\" width=\"258\" height=\"159\"><\/p>\n<p>2. Establecer cu\u00e1ntos a\u00f1os de informaci\u00f3n quieres revisar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1669\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta4.png\" alt=\"\" width=\"259\" height=\"145\"><\/p>\n<p>3.&nbsp;En la hoja &#8220;theBenchmark&#8221;, ver\u00e1s la informaci\u00f3n del mercado de referencia. En este caso, estoy tomando como referencia el <strong>S&amp;P 500<\/strong>. El ticker es <b>.INX<\/b>(celda E1).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1677\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta7.png\" alt=\"\" width=\"1048\" height=\"397\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta7.png 1048w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta7-300x114.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta7-768x291.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta7-1024x388.png 1024w\" sizes=\"auto, (max-width: 1048px) 100vw, 1048px\" \/><\/p>\n<p>4. Estos datos actualizan las f\u00f3rmulas para extraer informaci\u00f3n. Celda A1 en tab &#8220;theCompany&#8221;. Celda A1 en tab &#8220;theBenchmark&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1673\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png\" alt=\"\" width=\"580\" height=\"213\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png 580w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1-300x110.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1675\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta6-1.png\" alt=\"\" width=\"774\" height=\"224\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta6-1.png 774w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta6-1-300x87.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta6-1-768x222.png 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/p>\n<p>Los datos se descargar\u00e1n, y se realizar\u00e1 el c\u00e1lculo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1679\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta8.png\" alt=\"\" width=\"1068\" height=\"234\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta8.png 1068w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta8-300x66.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta8-768x168.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta8-1024x224.png 1024w\" sizes=\"auto, (max-width: 1068px) 100vw, 1068px\" \/><\/p>\n<p>Para verificar, busque el mismo dato en Yahoo Finanzas (Yahoo Finance). No es exacto, pero es cercano. Parece que fue una buena estimaci\u00f3n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1681\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta9.png\" alt=\"\" width=\"896\" height=\"519\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta9.png 896w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta9-300x174.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta9-768x445.png 768w\" sizes=\"auto, (max-width: 896px) 100vw, 896px\" \/><\/p>\n<p>Conoce el potencial de toda la suite de Google, obt\u00e9n una prueba gratuita de la suite; m\u00e1s informaci\u00f3n en este enlace (Google): <a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/goo.gl\/ZPXKU2<\/a><\/p>\n<p><a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-267 size-medium\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/google-300x200.jpg\" alt=\"Google workspace\" width=\"300\" height=\"200\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Acerca del modelo CAPM Casualidades de la vida, en las \u00faltimas semanas me he interesado mucho en el modelo CAPM: capital asset pricing model. Ciertamente no lo domino (a\u00fan), pero estoy examinando el tema y elaborando material en distintas herramientas <a href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1673,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69,150,10],"tags":[11],"class_list":["post-1645","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finanzas","category-google-finance","category-google-sheets","tag-google-sheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"google finance en google sheets, ejemplo del modelo CAPM con datos de google verificando en Yahoo Finanzas (Yahoo Finance).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"google finance en google sheets, ejemplo del modelo CAPM con datos de google verificando en Yahoo Finanzas (Yahoo Finance).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-28T00:41:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-12T17:41:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"580\" \/>\n\t<meta property=\"og:image:height\" content=\"213\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM\",\"datePublished\":\"2018-10-28T00:41:27+00:00\",\"dateModified\":\"2023-06-12T17:41:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/\"},\"wordCount\":467,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/beta5-1.png\",\"keywords\":[\"Google Sheets\"],\"articleSection\":[\"Finanzas\",\"Google Finance\",\"Google Sheets\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/\",\"name\":\"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/beta5-1.png\",\"datePublished\":\"2018-10-28T00:41:27+00:00\",\"dateModified\":\"2023-06-12T17:41:34+00:00\",\"description\":\"google finance en google sheets, ejemplo del modelo CAPM con datos de google verificando en Yahoo Finanzas (Yahoo Finance).\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/beta5-1.png\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/beta5-1.png\",\"width\":580,\"height\":213},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-sheets\\\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"contentUrl\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/excelyfinanzasmx\\\/\",\"https:\\\/\\\/x.com\\\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM - Business Intelligence MX","description":"google finance en google sheets, ejemplo del modelo CAPM con datos de google verificando en Yahoo Finanzas (Yahoo Finance).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/","og_locale":"en_US","og_type":"article","og_title":"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM - Business Intelligence MX","og_description":"google finance en google sheets, ejemplo del modelo CAPM con datos de google verificando en Yahoo Finanzas (Yahoo Finance).","og_url":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-10-28T00:41:27+00:00","article_modified_time":"2023-06-12T17:41:34+00:00","og_image":[{"width":580,"height":213,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png","type":"image\/png"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM","datePublished":"2018-10-28T00:41:27+00:00","dateModified":"2023-06-12T17:41:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/"},"wordCount":467,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png","keywords":["Google Sheets"],"articleSection":["Finanzas","Google Finance","Google Sheets"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/","url":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/","name":"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png","datePublished":"2018-10-28T00:41:27+00:00","dateModified":"2023-06-12T17:41:34+00:00","description":"google finance en google sheets, ejemplo del modelo CAPM con datos de google verificando en Yahoo Finanzas (Yahoo Finance).","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/10\/beta5-1.png","width":580,"height":213},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/calculo-de-betas-en-google-sheets-con-google-finance-para-el-modelo-capm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"C\u00e1lculo de betas en Google Sheets (con Google Finance) para el modelo CAPM"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/1645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=1645"}],"version-history":[{"count":30,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/1645\/revisions"}],"predecessor-version":[{"id":19400,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/1645\/revisions\/19400"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/1673"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=1645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=1645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=1645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}