{"id":198253,"date":"2023-10-26T10:16:43","date_gmt":"2023-10-26T14:16:43","guid":{"rendered":"https:\/\/ibkrcampus.com\/?p=198253"},"modified":"2025-02-12T10:47:30","modified_gmt":"2025-02-12T15:47:30","slug":"excel-converting-string-date-to-date-type","status":"publish","type":"post","link":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/","title":{"rendered":"Excel: Converting String Date to Date Type"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-converting-string-date-to-date-type\">Converting String Date to Date Type<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This method is a time-saving solution for processing date columns represented as strings like &#8217;12-Nov-2022&#8242;. Crafting an Excel formula to convert these strings to &#8216;2022-11-12&#8217; each time can be laborious and time-consuming. It&#8217;s a common task to handle when preprocessing daily financial data in empirical analysis.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-excel-formula\">Excel formula<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Given a target cell B2 with the value like &#8217;14-Jun-1961&#8242;, a first Excel formula to convert this date string to the &#8216;yyyy-mm-dd&#8217; date format is as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=DATE(\nRIGHT(B2,4),\nIF(MID(B2,4,3)=\"Jan\",\"01\",IF(MID(B2,4,3)=\"Feb\",\"02\",\nIF(MID(B2,4,3)=\"Mar\",\"03\",IF(MID(B2,4,3)=\"Apr\",\"04\",\nIF(MID(B2,4,3)=\"May\",\"05\",IF(MID(B2,4,3)=\"Jun\",\"06\",\nIF(MID(B2,4,3)=\"Jul\",\"07\",IF(MID(B2,4,3)=\"Aug\",\"08\",\nIF(MID(B2,4,3)=\"Sep\",\"09\",IF(MID(B2,4,3)=\"Oct\",\"10\",\nIF(MID(B2,4,3)=\"Nov\",\"11\",IF(MID(B2,4,3)=\"Dec\",\"12\",\n\"\")))))))))))),\nMID(B2,1,2)\n)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A second, more compact Excel formula to achieve the same date conversion is:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=DATE(\nRIGHT(B2,4),\nMATCH(MID(B2, 4, 3),\n    {\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\n     \"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov\",\"Dec\"}, 0),\nMID(B2,1,2)\n)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A third, more robust Excel formula is:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=DATE(\nFILTERXML(\"&lt;root>&lt;item>\" &amp; SUBSTITUTE(B2, \"-\", \n    \"&lt;\/item>&lt;item>\") &amp; \"&lt;\/item>&lt;\/root>\", \"\/\/item[3]\"),\nMATCH(FILTERXML(\"&lt;root>&lt;item>\" &amp; SUBSTITUTE(B2, \"-\", \n    \"&lt;\/item>&lt;item>\") &amp; \"&lt;\/item>&lt;\/root>\", \"\/\/item[2]\"),\n    {\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\n     \"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov\",\"Dec\"}, 0),\nFILTERXML(\"&lt;root>&lt;item>\" &amp; SUBSTITUTE(B2, \"-\", \n    \"&lt;\/item>&lt;item>\") &amp; \"&lt;\/item>&lt;\/root>\", \"\/\/item[1]\")\n)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Result<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We can observe the results of the three Excel formulas, and the third formula stands out for its robustness in dealing with variable day lengths, which are often encountered.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"742\" height=\"285\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2023\/10\/string_date_to_date_excel-SHLee-AI-Financial.png\" alt=\"\" class=\"wp-image-198257 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/10\/string_date_to_date_excel-SHLee-AI-Financial.png 742w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/10\/string_date_to_date_excel-SHLee-AI-Financial-700x269.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/10\/string_date_to_date_excel-SHLee-AI-Financial-300x115.png 300w\" data-sizes=\"(max-width: 742px) 100vw, 742px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 742px; aspect-ratio: 742\/285;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Originally posted on <a href=\"https:\/\/shleeai.blogspot.com\/2023\/10\/excel-converting-string-date-to-date.html\">SHLee AI Financial Model<\/a> blog.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.<\/p>\n","protected":false},"author":662,"featured_media":182721,"comment_status":"open","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[339,338,341],"tags":[806,5878],"contributors-categories":[13728],"class_list":["post-198253","post","type-post","status-publish","format-standard","has-post-thumbnail","category-data-science","category-ibkr-quant-news","category-quant-development","tag-data-science","tag-excel","contributors-categories-sh-fintech-modeling"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v28.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Excel: Converting String Date to Date Type | IBKR Quant<\/title>\n<meta name=\"description\" content=\"This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.\" \/>\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.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/198253\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Converting String Date to Date Type | IBKR Campus US\" \/>\n<meta property=\"og:description\" content=\"This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus US\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-26T14:16:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-12T15:47:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/02\/formula-equations-abstract.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"543\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sang-Heon Lee\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sang-Heon Lee\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\\\/\\\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"NewsArticle\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/#article\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/\"\n\t            },\n\t            \"author\": {\n\t                \"name\": \"Sang-Heon Lee\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/0a959ff9de7f0465a07baa1fe1ae0200\"\n\t            },\n\t            \"headline\": \"Excel: Converting String Date to Date Type\",\n\t            \"datePublished\": \"2023-10-26T14:16:43+00:00\",\n\t            \"dateModified\": \"2025-02-12T15:47:30+00:00\",\n\t            \"mainEntityOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/\"\n\t            },\n\t            \"wordCount\": 165,\n\t            \"commentCount\": 0,\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/02\\\/formula-equations-abstract.jpg\",\n\t            \"keywords\": [\n\t                \"Data Science\",\n\t                \"Excel\"\n\t            ],\n\t            \"articleSection\": [\n\t                \"Data Science\",\n\t                \"Quant\",\n\t                \"Quant Development\"\n\t            ],\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"CommentAction\",\n\t                    \"name\": \"Comment\",\n\t                    \"target\": [\n\t                        \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/#respond\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/\",\n\t            \"name\": \"Excel: Converting String Date to Date Type | IBKR Campus US\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\"\n\t            },\n\t            \"primaryImageOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/02\\\/formula-equations-abstract.jpg\",\n\t            \"datePublished\": \"2023-10-26T14:16:43+00:00\",\n\t            \"dateModified\": \"2025-02-12T15:47:30+00:00\",\n\t            \"description\": \"This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/excel-converting-string-date-to-date-type\\\/#primaryimage\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/02\\\/formula-equations-abstract.jpg\",\n\t            \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/02\\\/formula-equations-abstract.jpg\",\n\t            \"width\": 900,\n\t            \"height\": 543,\n\t            \"caption\": \"Creating a CTA from Scratch- II\"\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"name\": \"IBKR Campus US\",\n\t            \"description\": \"Financial Education from Interactive Brokers\",\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Organization\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\",\n\t            \"name\": \"Interactive Brokers\",\n\t            \"alternateName\": \"IBKR\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"logo\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\",\n\t                \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"width\": 669,\n\t                \"height\": 669,\n\t                \"caption\": \"Interactive Brokers\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\"\n\t            },\n\t            \"publishingPrinciples\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/about-ibkr-campus\\\/\",\n\t            \"ethicsPolicy\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/cyber-security-notice\\\/\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/0a959ff9de7f0465a07baa1fe1ae0200\",\n\t            \"name\": \"Sang-Heon Lee\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/author\\\/sang-heonlee\\\/\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel: Converting String Date to Date Type | IBKR Quant","description":"This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.","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.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/198253\/","og_locale":"en_US","og_type":"article","og_title":"Excel: Converting String Date to Date Type | IBKR Campus US","og_description":"This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.","og_url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/","og_site_name":"IBKR Campus US","article_published_time":"2023-10-26T14:16:43+00:00","article_modified_time":"2025-02-12T15:47:30+00:00","og_image":[{"width":900,"height":543,"url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/02\/formula-equations-abstract.jpg","type":"image\/jpeg"}],"author":"Sang-Heon Lee","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sang-Heon Lee","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/#article","isPartOf":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/"},"author":{"name":"Sang-Heon Lee","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/0a959ff9de7f0465a07baa1fe1ae0200"},"headline":"Excel: Converting String Date to Date Type","datePublished":"2023-10-26T14:16:43+00:00","dateModified":"2025-02-12T15:47:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/"},"wordCount":165,"commentCount":0,"publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/02\/formula-equations-abstract.jpg","keywords":["Data Science","Excel"],"articleSection":["Data Science","Quant","Quant Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/","url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/","name":"Excel: Converting String Date to Date Type | IBKR Campus US","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/#primaryimage"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/02\/formula-equations-abstract.jpg","datePublished":"2023-10-26T14:16:43+00:00","dateModified":"2025-02-12T15:47:30+00:00","description":"This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/excel-converting-string-date-to-date-type\/#primaryimage","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/02\/formula-equations-abstract.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/02\/formula-equations-abstract.jpg","width":900,"height":543,"caption":"Creating a CTA from Scratch- II"},{"@type":"WebSite","@id":"https:\/\/ibkrcampus.com\/campus\/#website","url":"https:\/\/ibkrcampus.com\/campus\/","name":"IBKR Campus US","description":"Financial Education from Interactive Brokers","publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ibkrcampus.com\/campus\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ibkrcampus.com\/campus\/#organization","name":"Interactive Brokers","alternateName":"IBKR","url":"https:\/\/ibkrcampus.com\/campus\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","width":669,"height":669,"caption":"Interactive Brokers"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/"},"publishingPrinciples":"https:\/\/www.interactivebrokers.com\/campus\/about-ibkr-campus\/","ethicsPolicy":"https:\/\/www.interactivebrokers.com\/campus\/cyber-security-notice\/"},{"@type":"Person","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/0a959ff9de7f0465a07baa1fe1ae0200","name":"Sang-Heon Lee","url":"https:\/\/www.interactivebrokers.com\/campus\/author\/sang-heonlee\/"}]}},"jetpack_featured_media_url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/02\/formula-equations-abstract.jpg","_links":{"self":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/198253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/users\/662"}],"replies":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/comments?post=198253"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/198253\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media\/182721"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media?parent=198253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/categories?post=198253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/tags?post=198253"},{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/contributors-categories?post=198253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}