{"id":42,"date":"2025-02-07T01:04:51","date_gmt":"2025-02-07T01:04:51","guid":{"rendered":"https:\/\/blogs.oregonstate.edu\/seansyntax\/?p=42"},"modified":"2025-02-07T01:04:51","modified_gmt":"2025-02-07T01:04:51","slug":"the-tech-stack","status":"publish","type":"post","link":"https:\/\/blogs.oregonstate.edu\/seansyntax\/2025\/02\/07\/the-tech-stack\/","title":{"rendered":"The Tech Stack"},"content":{"rendered":"\n<p>Welcome back to Sean\u2019s Syntax! Today I&#8217;m talking about tech stack for my algorithmic trading project. As I continue to work on this project I&#8217;m finding new tools to utilize. I&#8217;m going to cover my favorite and least favorite parts of my tech stack, aswell as one that was hard to learn but is worth it.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">The best part of my tech stack: Python<\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"400\" src=\"https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image-1.png\" alt=\"\" class=\"wp-image-44\" srcset=\"https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image-1.png 600w, https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image-1-300x200.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>Python is my go to tool because it\u2019s simple, easy to read, and works for almost anything. We use it for backtesting strategies, optimizing performance, or analyzing data. Libraries like NumPy, Pandas, and backtesting.py are essential for working with financial data, and pymoo helps with optimization. There\u2019s also a large community supporting the language, which makes learning and troubleshooting easier.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">My least favorite part of the tech stack: SQL<\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"304\" src=\"https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image-2.png\" alt=\"\" class=\"wp-image-45\" srcset=\"https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image-2.png 612w, https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image-2-300x149.png 300w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/figure>\n\n\n\n<p>SQL is useful but not my favorite. Writing queries, managing databases, and dealing with joins can feel tedious. Unlike Python, where I can be creative, SQL feels more rigid. Still, it\u2019s necessary for handling large datasets, especially when working with historical market data. Even though I don\u2019t love it, I know it\u2019s important for organizing and retrieving financial data quickly.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Difficult to learn but well worth it: AWS<\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"375\" src=\"https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image.png\" alt=\"\" class=\"wp-image-43\" srcset=\"https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image.png 600w, https:\/\/osu-wams-blogs-uploads.s3.amazonaws.com\/blogs.dir\/8098\/files\/2025\/02\/image-300x188.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>AWS was confusing at first. There are so many services, settings, and best practices. IAM roles, EC2, S3\u2026 a lot to learn. But once I got comfortable, I saw how powerful it was. AWS will make it easy to deploy and scale our trading algorithm application. With cloud-based execution, we can run backtests, store market data, and set up automated testing. Learning AWS has been very important to this project.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome back to Sean\u2019s Syntax! Today I&#8217;m talking about tech stack for my algorithmic trading project. As I continue to work on this project I&#8217;m finding new tools to utilize. I&#8217;m going to cover my favorite and least favorite parts of my tech stack, aswell as one that was hard to learn but is worth [&hellip;]<\/p>\n","protected":false},"author":14489,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-softwareproject"],"_links":{"self":[{"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/users\/14489"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":1,"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":46,"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/posts\/42\/revisions\/46"}],"wp:attachment":[{"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/seansyntax\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}