{"id":1065,"date":"2025-03-21T13:30:00","date_gmt":"2025-03-21T13:30:00","guid":{"rendered":"https:\/\/www.tejwin.com\/en\/insights\/tquant-from-0-to-1-day-3-building-a-comprehensive-investment-data-perspective-stock-pool-screening-and-data-retrieval-with-tejtoolapi-2\/"},"modified":"2025-03-21T13:30:00","modified_gmt":"2025-03-21T13:30:00","slug":"tquant-from-0-to-1-day-3-building-a-comprehensive-investment-data-perspective-stock-pool-screening-and-data-retrieval-with-tejtoolapi-2","status":"publish","type":"insight","link":"https:\/\/www.tejwin.com\/en\/insights\/tquant-from-0-to-1-day-3-building-a-comprehensive-investment-data-perspective-stock-pool-screening-and-data-retrieval-with-tejtoolapi-2\/","title":{"rendered":"[TQuant from 0 to 1 – Day 3] Building a Comprehensive Investment Data Perspective: Stock Pool Screening and Data Retrieval with TejToolAPI"},"content":{"rendered":"
\"stock
Photo by Carlos Muza<\/a> on Unsplash<\/a><\/figcaption><\/figure>\n

Preface<\/h2>\n

In financial investment, mastering accurate and comprehensive data is an indispensable skill, and effectively managing stock pools and acquiring stock price data is the key to unlocking this skill. With the tools and APIs provided by TQuant Lab, we can easily define screening criteria, quickly establish stock pools that meet specific requirements, and retrieve relevant historical stock price data.<\/strong><\/p>\n

This article will guide you step by step through setting up the environment and configuring your API Key, as well as explain how to use the <\/strong>get_universe function to obtain stock samples based on specific conditions. Whether you are a beginner in investing or a data analysis enthusiast, this guide will help you master the automation of data retrieval, laying a solid foundation for future quantitative analysis. Through examples and hands-on operations, you can quickly get started and apply these techniques to your investment strategies.<\/strong><\/p>\n

\n

What is a Stock Pool?<\/h2>\n

A stock pool is like a shopping list in our daily lives. Imagine grocery shopping in a supermarket with thousands of products on the shelves. If you don\u2019t filter your choices, you may spend a long time selecting items or buying things you don\u2019t need. However, if you prepare a shopping list in advance, such as \u201cbreakfast ingredients\u201d or \u201cfitness diet,\u201d you can quickly locate the relevant items in the store, saving time and improving efficiency.<\/strong><\/p>\n

Similarly, a stock pool aims to help investors filter out stocks that meet specific criteria from the vast stock market. For instance, you might set a condition like:<\/strong><\/p>\n

\u201cI want to find common stocks of semiconductor companies listed in Taiwan.\u201d<\/strong><\/p>\n

With a stock pool, you get a curated list of stocks that meet this condition, just like a shopping list helps you focus on relevant grocery items. This allows you to concentrate on analyzing only the relevant stocks without wasting time on unrelated companies.<\/strong><\/p>\n

In short, a stock pool acts as a \u201ccompass\u201d in your investment journey, helping you navigate the complex market and providing a reliable foundation for decision-making.<\/strong><\/p>\n

\n

Benefits of a Well-Designed Stock Pool<\/h2>\n

<\/a>1. Improved Analysis Efficiency<\/strong><\/h3>\n

With thousands of stocks in the market, it is easy to get lost in a sea of data if you lack clear selection criteria. A well-defined stock pool lets you focus on relevant stocks quickly, saving time.<\/strong><\/p>\n

<\/a>2. Reducing the Impact of Survivor Bias<\/strong><\/h3>\n

By setting specific selection criteria, a stock pool ensures that you consider both successful and failed companies, rather than only analyzing those that have survived. This helps create a more comprehensive view when backtesting investment strategies.<\/strong><\/p>\n

<\/a>3. Automation and Quantitative Applications<\/strong><\/h3>\n

Stock pools can be integrated with quantitative strategies, aiding in backtesting and data analysis. This ensures that your investment targets are based on a filtered and reliable dataset, improving the accuracy and effectiveness of your analysis.<\/strong><\/p>\n

\n

Introduction to the get_universe Function<\/h2>\n

In quantitative analysis and investment strategy design, quickly and accurately retrieving stock pool data is critical. With the tools provided by TQuant Lab, we can conveniently use the <\/strong>get_universe function to create custom stock pools based on different screening criteria, laying the groundwork for subsequent analysis.<\/strong><\/p>\n

The <\/strong>get_universe function is primarily used to screen and return a list of stock symbols that meet specific conditions. It allows users to filter stocks within a particular time range based on criteria such as market type, industry, and security type. The resulting stock list can seamlessly integrate with quantitative strategies and backtesting tools.<\/strong><\/p>\n

<\/a>Key Features of <\/strong>get_universe<\/strong><\/h3>\n

\u2705 Stock Pool Creation \u2013 Automatically filters stocks that meet the specified criteria, eliminating the need for manual selection.<\/strong><\/p>\n

\u00a0\u2705 Conditional Filtering \u2013 Supports various screening conditions such as market type, sector, industry, index inclusion, etc.<\/strong><\/p>\n

\u00a0\u2705 Dynamic Range Selection \u2013 Returns stocks that meet the criteria within a specified date range.<\/strong><\/p>\n

get_universe(start,\nend = datetime.datetime.now().date().strftime(%Y-%m-%d),\ntrading_calender = get_calender('TEJ_XTAI'),\n**kwargs)\n\n\n<\/code><\/pre>\n
Leveraging the get_universe function can significantly enhance your stock screening process, ensuring your investment analysis is based on structured and high-quality data.<\/strong><\/p>\n
\"tejtoolapi\"
The integration of the stock pool content relationships.<\/figcaption><\/figure>\n
Parameters for Defining Screening Time Range and Trading Calendar<\/strong><\/h3>\n
The following parameters are responsible for setting the time range and trading calendar when filtering the stock pool:<\/strong><\/p>\n
<\/a>1. <\/strong>start<\/strong> (datetime or str)<\/strong><\/h4>\n