{"product_id":"128628","title":"Automated Stock \u0026amp; Cryptocurrency Trading System Created with ChatGPT and Excel ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jX1PGHGE6IiyjTqrVCy3Upn0zSTZZ.png?v=1765058347\" style=\"max-width:100%;max-height:10px\"\u003e\u003c\/div\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\n\n\u003cdiv style=\"width:95%\"\u003e\n\n\u003cdiv style=\"text-align:center;font-size:30px;font-weight:bolder;line-height:1.6em\"\u003e Automated Stock \u0026amp; Cryptocurrency Trading System Created with ChatGPT and Excel \u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"border-bottom:1px;border-bottom-style:dotted;border-color:;padding-bottom:20px\"\u003e\u003ccenter\u003e\u003ctable align=\"center\" width=\"100%\"\u003e\u003ctbody style=\"border:0px\"\u003e\n\n\u003ctr\u003e\u003ctd align=\"center\" style=\"line-height:1.2em;text-align:center;font-size:18px;color:black;font-weight:bold;padding-bottom:20px;\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\u003ctr\u003e\u003ctd style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/image.yes24.com\/goods\/151170115\/XL\" style=\"max-width:100%;height:auto\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\u003c\/table\u003e\u003c\/center\u003e\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;{split_style6}padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e Description \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;word-break:break-all;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eBook Introduction\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eBuilding an AI-based trading system that anyone can use\u003cbr\u003e Complete financial automation with Excel VBA and ChatGPT!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e It's okay if you don't know complex Excel VBA.\u003cbr\u003e Simply ask ChatGPT a question and paste the code it generates into Excel to complete the automation program.\u003cbr\u003e The key is not memorizing complex grammar, but the ability to define the problem and how to utilize what data. \u003cbr\u003eBy adding an AI assistant called ChatGPT to the familiar tool Excel, anyone can collect and analyze financial data and implement an automated trading system.\u003cbr\u003e This book guides securities traders step-by-step through how to automate their investments using ChatGPT and Excel VBA.\u003cbr\u003e Practical examples cover everything from collecting and analyzing stock and cryptocurrency data to backtesting, sending Telegram quotes, and building automated trading programs.\u003cbr\u003e In particular, in addition to ChatGPT, we compare various generative AI tools such as Gemini, Copilot, and Claude, and also present criteria for selecting the appropriate AI depending on the situation.\u003cbr\u003e In the era of generative AI, anyone can now try automated trading using just Excel.\u003cbr\u003e\n\n\u003c\/div\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cul\u003e\u003cli\u003e You can preview some of the book's contents.\u003cbr\u003e \u003cspan\u003ePreview\u003c\/span\u003e\n\n\u003c\/li\u003e\u003c\/ul\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e Preface viii\u003cbr\u003e\u003cbr\u003e CHAPTER 01 Introduction\u003cbr\u003e Excel and Financial Programming 3\u003cbr\u003e 4 Things You Can Gain from ChatGPT \u003cbr\u003eExcel VBA Programming with ChatGPT 5\u003cbr\u003e\u003cbr\u003e CHAPTER 02 Preparing to Meet Generative AI Technology\u003cbr\u003e 10 Ways to Use OpenAI ChatGPT\u003cbr\u003e How to Use Google Gemini 14\u003cbr\u003e How to Use Microsoft Copilot 16\u003cbr\u003e How to Use Antropic Clod 19\u003cbr\u003e [Trader's Story] How do securities firms use Excel in their trading departments? 24\u003cbr\u003e\u003cbr\u003e CHAPTER 03 Excel VBA Basics\u003cbr\u003e Getting Started with Excel VBA 29\u003cbr\u003e Setting up Excel VBA 30 \/ Writing your first Excel VBA code 33\u003cbr\u003e Excel VBA Basic Grammar 36\u003cbr\u003e __Variable declaration and data types 37 \/ Conditional statements 43 \/ Loops 44 \/ Arrays 45 \/ Subroutines and functions 46 \/ Comments 47\u003cbr\u003e Writing Excel VBA Programs Using Generative AI 48\u003cbr\u003e Generative AI Questioning Method 52 \/ Creating with ChatGPT 54 \/ Creating with Gemini 57 \/ Creating with Copilot 60 \/ Creating with Claude 63\u003cbr\u003e Excel VBA Basic Programming Practice 1 67\u003cbr\u003e Excel VBA Basic Programming Practice 2 72 \u003cbr\u003e[Trader's Story] How useful is VBA for trading compared to traditional Excel? 78\u003cbr\u003e\u003cbr\u003e CHAPTER 04 Data Collection Using ChatGPT and Excel\u003cbr\u003e Stock Data API Setup 84\u003cbr\u003e Receive stock data 88\u003cbr\u003e Cryptocurrency API Setup 101\u003cbr\u003e Receive cryptocurrency data 107\u003cbr\u003e [Trader's Story] What's the Difference Between Python and VBA? 115\u003cbr\u003e\u003cbr\u003e CHAPTER 05 Data Analysis Using ChatGPT and Excel\u003cbr\u003e Correlation Analysis Using ChatGPT 121\u003cbr\u003e Stock Correlation Analysis 122 \/ Cryptocurrency Correlation Analysis 138\u003cbr\u003e Technical Indicator Analysis Using ChatGPT 147\u003cbr\u003e __Implementing Moving Averages for Stocks 149 \/ Implementing MACD for Stocks 166 \/ Implementing RSI for Cryptocurrencies 185 \/ Implementing Bollinger Bands for Cryptocurrencies 194\u003cbr\u003e [Trader's Story] What do front, middle, and back mean in a securities firm? 200\u003cbr\u003e\u003cbr\u003e CHAPTER 06 Creating a Practical Excel VBA System\u003cbr\u003e Building a Telegram Bot 207\u003cbr\u003e How to Create a Telegram Bot 208 \/ Using a Telegram Bot in Excel 212 \u003cbr\u003eCreating a Real-Time Cryptocurrency Price Transmission System 215\u003cbr\u003e __Get real-time Bitcoin prices 216 \/ Send real-time prices to Telegram 224\u003cbr\u003e Building a Stock Backtesting System 230\u003cbr\u003e __Establishing a Backtest Strategy 232 \/ Implementing a Backtest System 234\u003cbr\u003e [Trader's Story] No-Code, Excel, and ChatGPT 244\u003cbr\u003e\u003cbr\u003e CHAPTER 07 Creating an Automated Trading System\u003cbr\u003e Securities API Order Test 249\u003cbr\u003e Developing an Automated Stock Trading System 262\u003cbr\u003e __Determining System Implementation Goals 263 \/ Creating an Excel UI 263 \/ Configuring ChatGPT Questions Including UI Connections 264 \/ Applying Code Created Through ChatGPT 268 \/ Running the Created Code 273\u003cbr\u003e Testing Cryptocurrency API Orders 276\u003cbr\u003e Developing an Automated Cryptocurrency Trading System 282\u003cbr\u003e __Determining System Implementation Goals 282 \/ Creating an Excel UI 283 \/ Configuring ChatGPT Questions Including UI Connections 285 \/ Applying Code Created Through ChatGPT 288 \/ Running the Created Code 295\u003cbr\u003e\u003cbr\u003e CHAPTER 08 Conclusion \u003cbr\u003eWhat I learned from this book: 301\u003cbr\u003e Financial Programming 302 Using ChatGPT and Excel VBA\u003cbr\u003e\u003cbr\u003e Search 304\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eDetailed image\u003c\/b\u003e \u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate5522\/MidCate004\/552131275(1).jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eInto the book\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e Although Python is a very powerful and attractive language, it has a high barrier to entry for beginners in programming.\u003cbr\u003e Especially for those who have no prior coding experience, the entire process from setting up the environment to running the code may feel like a hurdle.\u003cbr\u003e \/ Faced with this reality, I began to wonder if it would be possible to connect ChatGPT and the world of coding using more familiar tools.\u003cbr\u003e The tool that came to mind at that time was Excel.\u003cbr\u003e Excel, which many people have already used for work or everyday data organization, is an excellent medium that can be very well-suited to the code generated by ChatGPT. \u003cbr\u003eIn particular, we judged that Excel VBA could serve as a bridge that relatively lowers the coding barrier for Excel users.\u003cbr\u003e\u003cbr\u003e --- p.viii\u003cbr\u003e\u003cbr\u003e In the financial market, various data is generated every day, and it is important for those investing in stocks or coins to utilize this data to establish and execute optimal investment strategies.\u003cbr\u003e But this is not an easy task.\u003cbr\u003e (Omitted) This book aims to provide a method to solve these concerns through Excel financial programming using ChatGPT.\u003cbr\u003e We present how to collect and analyze data using Excel and implement automated investment strategies using financial programming. \u003cbr\u003eIn other words, we want to provide those unfamiliar with coding with tools to make efficient investments, while also introducing new areas for creativity for those who already know how to code.\u003cbr\u003e\u003cbr\u003e --- p.3\u003cbr\u003e\u003cbr\u003e Effective questions are the first step to solving programming problems.\u003cbr\u003e Rather than asking a general question like \"process data,\" it's important to specify a specific goal, such as \"calculate the average of a specific column in an Excel file.\"\u003cbr\u003e This provides clear direction to the AI, leading to efficient answers.\u003cbr\u003e \/ When asking questions to generative AI, including ChatGPT, you can get more accurate results by including your current situation, goals, specific APIs you want to use, and even example code. \u003cbr\u003eFor example, it's best to explain the situation specifically and pose a clear question, such as \"Retrieving Samsung Electronics' closing price and trading volume data using sample code from the Kiwoom Securities API.\"\u003cbr\u003e\u003cbr\u003e --- p.53\u003cbr\u003e\u003cbr\u003e Gathering financial data is a key part of investing and analysis.\u003cbr\u003e However, manually collecting and organizing data is not only time-consuming but also prone to errors.\u003cbr\u003e Therefore, an automated method is needed, and here we introduce a method to efficiently collect data by combining the artificial intelligence model ChatGPT and Excel VBA.\u003cbr\u003e\u003cbr\u003e --- p.83\u003cbr\u003e\u003cbr\u003e Correlation analysis plays a very important role in data analysis.\u003cbr\u003e This allows us to understand the relationships between variables, and these relationships provide practical insights in a variety of fields. \u003cbr\u003eFor example, in economics, we can analyze the correlation between consumption and income to understand consumption patterns, and in finance, we can analyze the correlation between stock prices and trading volume to predict market trends.\u003cbr\u003e Additionally, correlation analysis serves as the basis for statistical modeling and is used to build predictive models based on the association between two variables.\u003cbr\u003e\u003cbr\u003e --- p.121\u003cbr\u003e\u003cbr\u003e This tutorial covers how to build a Telegram bot that automatically sends messages when specific events occur, using Excel VBA and the Telegram API.\u003cbr\u003e Telegram bots can be used for a variety of purposes, including providing trading signal alerts and data update notifications, and their potential is further expanded when integrated with Excel.\u003cbr\u003e Now, let's take a look at how to set up a Telegram bot and write Excel VBA code to build a system that sends real-time notifications.\u003cbr\u003e\u003cbr\u003e --- p.207\u003cbr\u003e \u003cbr\u003eSince the past dates are set to the top of the two-year data, it shows data from August 22, 2022.\u003cbr\u003e Additionally, the 20, 60, and 120-day moving averages, MACD, and signal line are calculated and displayed in columns C through G.\u003cbr\u003e Columns I through M show the backtest results.\u003cbr\u003e It displays the entry date that satisfies the entry conditions of the backtest and the liquidation date that satisfies the liquidation conditions, including the price and rate of return.\u003cbr\u003e In addition, you can check the total return when trading with the corresponding strategy during the backtest period.\u003cbr\u003e\u003cbr\u003e --- p.243\u003cbr\u003e\u003cbr\u003e We'll cover how to implement a basic automated trading system for stocks and cryptocurrencies using ChatGPT. \u003cbr\u003eTo automatically trade stocks and cryptocurrencies, you must open an account with a brokerage or exchange and learn how to use their APIs. APIs are programming interfaces provided by brokerages and exchanges, allowing you to access data provided by each company and execute orders directly without going through a Home Trading System (HTS).\u003cbr\u003e\n\n\u003c\/div\u003e\n\u003cdiv\u003e --- p.249\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003ePublisher's Review\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eFrom investment strategies to actual trading, all done with Excel and AI.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Advances in AI technology have lowered the barriers to coding, ushering in an era where anyone can implement data analysis and automated trading systems.\u003cbr\u003e In particular, Excel is the most widely used business tool, and is a platform that is familiar enough for anyone to use, yet has very powerful functions for data processing.\u003cbr\u003e When combined with ChatGPT, the possibilities are endless. \u003cbr\u003eThe combination of Excel and ChatGPT is more practical than any other combination because it allows you to utilize new technologies with tools you're already familiar with, without the need for separate learning.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e This book is a practical guide that covers the process of collecting stock and cryptocurrency data and implementing correlation analysis, backtesting, stock prediction, real-time price transmission, and even an automated trading system, step by step.\u003cbr\u003e We've designed a system that allows readers to create their own, working systems, including a real-time price transmission system using Telegram, automatic ordering using securities firm APIs, and even backtesting to verify profitability.\u003cbr\u003e By comparing the use of various generative AIs, including ChatGPT, Gemini, Copilot, and Claude, we help readers choose the most suitable tool for themselves. We also explain in detail how to generate code using Excel VBA grammar and ChatGPT. \u003cbr\u003eAdditionally, by introducing the actual workflow of a securities firm's trading department and practical methods of using AI tools, we aim to foster practical skills that go beyond theory.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e In the era of generative AI, complex languages ​​and development environments are no longer necessary.\u003cbr\u003e Now, anyone can create an automated trading system using only Excel and ChatGPT.\u003cbr\u003e This book guides you through the first step in the easiest and most certain way.\u003cbr\u003e From data analysis and automation to investment strategy implementation, which once seemed difficult, now you can put it all into practice right at your fingertips.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eKey Contents\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e ● Introduction to major generative AIs such as ChatGPT, Gemini, Copilot, and Claude\u003cbr\u003e A financial programming approach using generative AI\u003cbr\u003e ● Introduction to Excel VBA and minimal coding concepts\u003cbr\u003e ● Financial knowledge required to understand financial data\u003cbr\u003e ● Collection of stock and cryptocurrency data and analysis of various indicators\u003cbr\u003e Creating a backtest system using stock data \u003cbr\u003e● Establishment of a real-time price transmission system using Telegram\u003cbr\u003e ● Establishing an automated stock and cryptocurrency trading system using APIs. \u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e GOODS SPECIFICS \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eDate of issue:\u003c\/strong\u003e August 28, 2025\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003ePage count, weight, size:\u003c\/strong\u003e 316 pages | 170*225*19mm\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN13:\u003c\/strong\u003e 9791194587583 \u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cspan\u003e\u003c\/span\u003e\n\n\u003c\/center\u003e\n\n\n\u003c\/center\u003e","brand":"LIBRAIRIE COREENNE","offers":[{"title":"Default Title","offer_id":43893154218026,"sku":"128628","price":36.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/c6f765f28eded7fb100c13cb984d25cb.jpg?v=1765390390","url":"https:\/\/librairie.coreenne.fr\/en\/products\/128628","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}