{"id":208950,"date":"2024-07-17T10:45:05","date_gmt":"2024-07-17T14:45:05","guid":{"rendered":"https:\/\/ibkrcampus.com\/?p=208950"},"modified":"2024-08-12T14:57:53","modified_gmt":"2024-08-12T18:57:53","slug":"python-in-excel-pyxll-vs-microsoft","status":"publish","type":"post","link":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/","title":{"rendered":"Python in Excel \u2013 PyXLL vs Microsoft"},"content":{"rendered":"\n<p><em>The post \u201cPython in Excel \u2013 PyXLL vs Microsoft&#8221; first appeared on <a href=\"https:\/\/algotrading101.com\/learn\/python-excel-pyxll-vs-microsoft\/\">AlgoTrading101<\/a> blog.<\/em><\/p>\n\n\n\n<p><em>Excerpt<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-python-in-excel\">What is Python in Excel?<\/h2>\n\n\n\n<p>Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application. It provides many capabilities and improvements over what standard Excel offers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-why-should-i-use-python-in-excel\">Why should I use Python in Excel?<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Python in Excel tools offer ease of extendability<\/li>\n\n\n\n<li>Is easy to use<\/li>\n\n\n\n<li>Is very powerful<\/li>\n\n\n\n<li>Allows for easier explanation and usage by non-tech-savvy people<\/li>\n\n\n\n<li>Many businesses still hold a lot of data and Excel and use it day-to-day<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-why-shouldn-t-i-use-python-in-excel\">Why shouldn\u2019t I use Python in Excel?<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It constrains Python and the way you\u2019re used to building Python features and apps<\/li>\n\n\n\n<li>Might not be the best combination for the solution to your problem<\/li>\n\n\n\n<li>If you\u2019re good with Python and building projects, Excel is a nuisance<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-tools-can-i-use-to-have-python-in-excel\">What tools can I use to have Python in Excel?<\/h2>\n\n\n\n<p>Python in Excel tools vary and the two most popular and maintained ones are Microsoft\u2019s Python in Excel and PyXLL which is developed and maintained by Tony Roberts.<\/p>\n\n\n\n<p>In this article, we will explore both of these solutions and compare them head to head over several facets such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Setup<\/li>\n\n\n\n<li>Documentation<\/li>\n\n\n\n<li>Ease of use<\/li>\n\n\n\n<li>Performance<\/li>\n\n\n\n<li>Extendability<\/li>\n\n\n\n<li>Support<\/li>\n<\/ul>\n\n\n\n<p>Although I will try to be as objective as possible, please ensure that you do your own research and choose the tool that fits your particular needs for your particular context.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-pyxll\">What is PyXLL?<\/h2>\n\n\n\n<p>PyXLL is a Python Add-in for Microsoft Excel that is aimed at professionals and as a replacement for VBA. It is developed for better development experience and performance.<\/p>\n\n\n\n<p><a>Website:&nbsp;<\/a><a href=\"https:\/\/www.pyxll.com\/\">PyXLL \u2013 The Python Excel Add-in<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-use-pyxll\">How to use PyXLL?<\/h2>\n\n\n\n<p>Here are some examples on how to use Python with PyXLL:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=ar_PyW-yPRA\" target=\"_blank\" rel=\"noreferrer noopener\">PyXLL Introduction<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=74RDI3tA48I\" target=\"_blank\" rel=\"noreferrer noopener\">How Fast is Python in Excel?<\/a><\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-set-up-pyxll\"><a>How to set up PyXLL?<\/a><\/h2>\n\n\n\n<p>To set up PyXLL, we will need to have Python installed. I will create a new environment and execute the following commands:<\/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=\"\">$ pip install pyxll\n$ pyxll install<\/pre>\n\n\n\n<p>If you don\u2019t know what the above code mean, then check this video on installing Python and Python packages:&nbsp;<a href=\"https:\/\/www.youtube.com\/watch?v=KtxCiaDjQgw\" target=\"_blank\" rel=\"noreferrer noopener\">Windows version<\/a>,&nbsp;<a href=\"https:\/\/www.youtube.com\/watch?v=M323OL6K5vs\" target=\"_blank\" rel=\"noreferrer noopener\">Mac version<\/a>.<\/p>\n\n\n\n<p>This will take you through the installation steps. What is nice about PyXLL is that it offers you a free one-month trial without needing any credit card information. When you get to a prompt asking you for the license key say \u201cn\u201d if you want to use the trial.<\/p>\n\n\n\n<p>If you want to get a license key, please navigate to the website&nbsp;<a href=\"https:\/\/www.pyxll.com\/pricing.html\">pricing page<\/a>&nbsp;and select the plan that works for you.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"886\" height=\"616\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101.png\" alt=\"\" class=\"wp-image-209247 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101.png 886w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-700x487.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-300x209.png 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-768x534.png 768w\" data-sizes=\"(max-width: 886px) 100vw, 886px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 886px; aspect-ratio: 886\/616;\" \/><\/figure>\n\n\n\n<p>Now that we have PyXLL installed, you can check its status by running&nbsp;<code>pyxll status<\/code>. To configure your PyXLL, you can write&nbsp;<code>pyxll configure<\/code>.<\/p>\n\n\n\n<p>In the folder you chose to install PyXLL into you will find some examples, alongside the PyXLL add-in and its configuration file. If the PyXLL add-in has been successfully installed, your Excel will load it automatically.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1100\" height=\"183\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/pyxll-excel-1100x183.jpg\" alt=\"\" class=\"wp-image-208953 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/pyxll-excel-1100x183.jpg 1100w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/pyxll-excel-700x117.jpg 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/pyxll-excel-300x50.jpg 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/pyxll-excel-768x128.jpg 768w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/pyxll-excel.jpg 1195w\" data-sizes=\"(max-width: 1100px) 100vw, 1100px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1100px; aspect-ratio: 1100\/183;\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">What is Microsoft Python in Excel?<\/h2>\n\n\n\n<p>Microsoft Python in Excel is a new feature in Excel that is developed by Microsoft which seamlessly introduces Python inside your Excel for the Microsoft 365 Insider program members. Its goal is to unlock all the capabilities of Python without the need to set it up yourself.<\/p>\n\n\n\n<p><a>Website:&nbsp;<\/a><a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/python-in-excel\">Python in Excel \u2013 Python to Excel | Microsoft 365<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to set up Microsoft Python in Excel?<\/h2>\n\n\n\n<p>To set up Microsoft Python in Excel, you will need to have a subscription to the Microsoft Office 365 suite. They also offer a one-month free trial if you want to test it out first.<\/p>\n\n\n\n<p><a>To get the subscription, navigate to the following&nbsp;<\/a><a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/buy\/microsoft-365\">URL<\/a>&nbsp;and choose one of the two plans that fit your use case the most. I personally have the Microsoft 365 Family plan on a yearly subscription but any type of subscription will be suitable.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"884\" height=\"498\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-2.png\" alt=\"\" class=\"wp-image-209248 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-2.png 884w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-2-700x394.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-2-300x169.png 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-2-768x433.png 768w\" data-sizes=\"(max-width: 884px) 100vw, 884px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 884px; aspect-ratio: 884\/498;\" \/><\/figure>\n\n\n\n<p>When you decide, click the \u201cBuy Now\u201d button and follow through with the payment process. After that, you will be redirected and will be able to install Microsoft Office 365 which will automatically validate your license through your Microsoft account.<\/p>\n\n\n\n<p>When done, all we need to do is to open the Microsoft Office 365 app and start Excel. Then, click on the \u201cAccount\u201d button in the lower left section of your screen. There, you will see some information about your account settings.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"799\" height=\"796\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-365-insiders.jpg\" alt=\"\" class=\"wp-image-209250 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-365-insiders.jpg 799w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-365-insiders-700x697.jpg 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-365-insiders-300x299.jpg 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-365-insiders-768x765.jpg 768w\" data-sizes=\"(max-width: 799px) 100vw, 799px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 799px; aspect-ratio: 799\/796;\" \/><\/figure>\n\n\n\n<p>Press on the Microsoft 365 Insider and join it. The Beta channel is the one I have and it gives you access to beta features as they come out. Once you join, it will trigger the update of Excel that will grab these features.<\/p>\n\n\n\n<p>Now, open a new sheet and write&nbsp;<code>=PY<\/code>&nbsp;in a cell. It will show a tooltip that you should click which will prompt you to try out Python in Excel. To execute the code in the cell press<code>&nbsp;CTRL+Enter<\/code>&nbsp;and add a new line by pressing&nbsp;<code>Enter<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1100\" height=\"786\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-in-excel-preview-1100x786.jpg\" alt=\"\" class=\"wp-image-209251 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-in-excel-preview-1100x786.jpg 1100w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-in-excel-preview-700x500.jpg 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-in-excel-preview-300x214.jpg 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-in-excel-preview-768x549.jpg 768w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/microsoft-in-excel-preview.jpg 1252w\" data-sizes=\"(max-width: 1100px) 100vw, 1100px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1100px; aspect-ratio: 1100\/786;\" \/><\/figure>\n\n\n\n<p>If everything has been set up correctly, you will see Python in your Excel menu bar.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"892\" height=\"245\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-3.png\" alt=\"\" class=\"wp-image-209252 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-3.png 892w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-3-700x192.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-3-300x82.png 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/07\/python-in-excel-algotrading101-3-768x211.png 768w\" data-sizes=\"(max-width: 892px) 100vw, 892px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 892px; aspect-ratio: 892\/245;\" \/><\/figure>\n\n\n\n<p><em>Visit <a href=\"https:\/\/algotrading101.com\/learn\/python-excel-pyxll-vs-microsoft\/\">AlgoTrading101<\/a> for instructions on using Microsoft Python in Excel.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application. <\/p>\n","protected":false},"author":815,"featured_media":196081,"comment_status":"open","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[339,343,349,338,341],"tags":[806,1244,17458,17459],"contributors-categories":[13746],"class_list":{"0":"post-208950","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-data-science","8":"category-programing-languages","9":"category-python-development","10":"category-ibkr-quant-news","11":"category-quant-development","12":"tag-data-science","13":"tag-microsoft","14":"tag-python-in-excel","15":"tag-pyxll","16":"contributors-categories-algotrading101"},"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 v27.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Python in Excel \u2013 PyXLL vs Microsoft | IBKR Quant<\/title>\n<meta name=\"description\" content=\"Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application.\" \/>\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\/208950\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python in Excel \u2013 PyXLL vs Microsoft\" \/>\n<meta property=\"og:description\" content=\"Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus US\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-17T14:45:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-12T18:57:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/09\/python-green-letters-cloud-programming-languages.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Igor Radovanovic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Igor Radovanovic\" \/>\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\">{\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\\\/python-in-excel-pyxll-vs-microsoft\\\/#article\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/python-in-excel-pyxll-vs-microsoft\\\/\"\n\t            },\n\t            \"author\": {\n\t                \"name\": \"Igor Radovanovic\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/b43b33f424bad38d84a7b78eb0193592\"\n\t            },\n\t            \"headline\": \"Python in Excel \u2013 PyXLL vs Microsoft\",\n\t            \"datePublished\": \"2024-07-17T14:45:05+00:00\",\n\t            \"dateModified\": \"2024-08-12T18:57:53+00:00\",\n\t            \"mainEntityOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/python-in-excel-pyxll-vs-microsoft\\\/\"\n\t            },\n\t            \"wordCount\": 837,\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\\\/python-in-excel-pyxll-vs-microsoft\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/python-green-letters-cloud-programming-languages.jpg\",\n\t            \"keywords\": [\n\t                \"Data Science\",\n\t                \"Microsoft\",\n\t                \"Python in Excel\",\n\t                \"PyXLL\"\n\t            ],\n\t            \"articleSection\": [\n\t                \"Data Science\",\n\t                \"Programming Languages\",\n\t                \"Python Development\",\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\\\/python-in-excel-pyxll-vs-microsoft\\\/#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\\\/python-in-excel-pyxll-vs-microsoft\\\/\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/python-in-excel-pyxll-vs-microsoft\\\/\",\n\t            \"name\": \"Python in Excel \u2013 PyXLL vs Microsoft | 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\\\/python-in-excel-pyxll-vs-microsoft\\\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/python-in-excel-pyxll-vs-microsoft\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/python-green-letters-cloud-programming-languages.jpg\",\n\t            \"datePublished\": \"2024-07-17T14:45:05+00:00\",\n\t            \"dateModified\": \"2024-08-12T18:57:53+00:00\",\n\t            \"description\": \"Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application.\",\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\\\/python-in-excel-pyxll-vs-microsoft\\\/\"\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\\\/python-in-excel-pyxll-vs-microsoft\\\/#primaryimage\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/python-green-letters-cloud-programming-languages.jpg\",\n\t            \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/python-green-letters-cloud-programming-languages.jpg\",\n\t            \"width\": 1000,\n\t            \"height\": 563,\n\t            \"caption\": \"Python\"\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\\\/b43b33f424bad38d84a7b78eb0193592\",\n\t            \"name\": \"Igor Radovanovic\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/author\\\/igor-radovanovic\\\/\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Python in Excel \u2013 PyXLL vs Microsoft | IBKR Quant","description":"Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application.","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\/208950\/","og_locale":"en_US","og_type":"article","og_title":"Python in Excel \u2013 PyXLL vs Microsoft","og_description":"Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application.","og_url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/","og_site_name":"IBKR Campus US","article_published_time":"2024-07-17T14:45:05+00:00","article_modified_time":"2024-08-12T18:57:53+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/09\/python-green-letters-cloud-programming-languages.jpg","type":"image\/jpeg"}],"author":"Igor Radovanovic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Igor Radovanovic","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/#article","isPartOf":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/"},"author":{"name":"Igor Radovanovic","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/b43b33f424bad38d84a7b78eb0193592"},"headline":"Python in Excel \u2013 PyXLL vs Microsoft","datePublished":"2024-07-17T14:45:05+00:00","dateModified":"2024-08-12T18:57:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/"},"wordCount":837,"commentCount":0,"publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/09\/python-green-letters-cloud-programming-languages.jpg","keywords":["Data Science","Microsoft","Python in Excel","PyXLL"],"articleSection":["Data Science","Programming Languages","Python Development","Quant","Quant Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/","url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/","name":"Python in Excel \u2013 PyXLL vs Microsoft | IBKR Campus US","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/#primaryimage"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/09\/python-green-letters-cloud-programming-languages.jpg","datePublished":"2024-07-17T14:45:05+00:00","dateModified":"2024-08-12T18:57:53+00:00","description":"Python can be used in Excel to allow seamless integration of the Python programming language inside the Excel application.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/python-in-excel-pyxll-vs-microsoft\/#primaryimage","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/09\/python-green-letters-cloud-programming-languages.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/09\/python-green-letters-cloud-programming-languages.jpg","width":1000,"height":563,"caption":"Python"},{"@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\/b43b33f424bad38d84a7b78eb0193592","name":"Igor Radovanovic","url":"https:\/\/www.interactivebrokers.com\/campus\/author\/igor-radovanovic\/"}]}},"jetpack_featured_media_url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/09\/python-green-letters-cloud-programming-languages.jpg","_links":{"self":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/208950","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\/815"}],"replies":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/comments?post=208950"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/208950\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media\/196081"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media?parent=208950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/categories?post=208950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/tags?post=208950"},{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/contributors-categories?post=208950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}