> ## Documentation Index
> Fetch the complete documentation index at: https://quant.5loi.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Entry level tools

title: Entry-Level Tools

description: Introduces free/low-cost tools suitable for investment beginners, helping you quickly start investment analysis

## draft: false

# Entry-Level Tools

For investment beginners, choosing the right entry-level tools is very important. This page will introduce you to some simple-to-operate, low-cost (or even free) tools to help you quickly start investment analysis without requiring professional background or large capital investment.

## Yahoo Finance: Obtaining Basic Market Data

Yahoo Finance is a powerful and free financial data platform that provides real-time and historical data for global stocks, bonds, funds, futures, and other financial products. For investment beginners, this is an ideal tool for obtaining basic market data.

### How to Use Yahoo Finance to Query Key Indicators

<Tabs>
  <Tab icon="pe-ratio" title="Query P/E (Price-to-Earnings Ratio)">
    <div className="space-y-4">
      <h4 className="text-lg font-medium">Step 1: Visit the Yahoo Finance Website</h4>
      <p>Open your browser and visit the <a href="https://finance.yahoo.com/" target="_blank">official Yahoo Finance website</a>.</p>

      <h4 className="text-lg font-medium">Step 2: Search for Stock Code</h4>
      <p>Enter the stock code in the top search box (e.g., Kweichow Moutai is 600519.SS, Apple Inc. is AAPL), then click on the search result to enter the stock details page.</p>

      <h4 className="text-lg font-medium">Step 3: View P/E Ratio</h4>
      <p>On the "Summary" tab of the stock details page, you can find the P/E ratio (price-to-earnings ratio). It is usually displayed as "PE Ratio (TTM)", which represents the price-to-earnings ratio based on the past 12 months of earnings.</p>

      <h4 className="text-lg font-medium">Step 4: Compare Historical and Industry Average</h4>
      <p>Scroll down the page, and in the "Key Statistics" section, you can view more valuation indicators, including historical P/E range and industry average P/E.</p>
    </div>
  </Tab>

  <Tab icon="volume" title="Query Trading Volume">
    <div className="space-y-4">
      <h4 className="text-lg font-medium">Step 1: Access Stock Details Page</h4>
      <p>Follow the above steps to enter the target stock's details page.</p>

      <h4 className="text-lg font-medium">Step 2: View Daily Trading Volume</h4>
      <p>At the top of the stock details page, you can see the daily trading volume (Volume) and its comparison with the average volume (e.g., "1.23M vs avg. volume 980.56K").</p>

      <h4 className="text-lg font-medium">Step 3: Analyze Historical Trading Volume</h4>
      <p>Below the price chart, you can see the trading volume bar chart. Click on the time range selector above the chart (such as 1D, 1W, 1M, 1Y, etc.) to view volume changes over different time periods.</p>

      <h4 className="text-lg font-medium">Step 4: Identify Volume Anomalies</h4>
      <p>Look for trading days with significantly higher-than-average volume. These are usually important market signals that may be related to major news, earnings releases, or institutional trading.</p>
    </div>
  </Tab>

  <Tab icon="financials" title="Query Financial Data">
    <div className="space-y-4">
      <h4 className="text-lg font-medium">Step 1: Enter Financial Data Page</h4>
      <p>In the navigation bar above the stock details page, click on the "Financials" tab.</p>

      <h4 className="text-lg font-medium">Step 2: View Income Statement</h4>
      <p>The default display is the income statement, where you can view historical data of key indicators such as revenue, profit, gross profit margin, etc. You can choose "Annual" or "Quarterly" data.</p>

      <h4 className="text-lg font-medium">Step 3: View Balance Sheet</h4>
      <p>Click on the "Balance Sheet" tab to view the company's assets, liabilities, and shareholders' equity data to understand the company's financial position.</p>

      <h4 className="text-lg font-medium">Step 4: View Cash Flow</h4>
      <p>Click on the "Cash Flow" tab to view the cash flows generated by the company's operating activities, investing activities, and financing activities to understand the company's cash generation capacity.</p>
    </div>
  </Tab>
</Tabs>

<Image src="/images/yahoo-finance-example.png" alt="Yahoo Finance Interface Example" caption="Yahoo Finance provides rich market data and analysis tools" />

## Excel Templates: Volume-Price Breakout Detection

Excel is a powerful and commonly used data analysis tool. Through simple formulas and functions, we can create practical investment analysis templates. Below, we will introduce how to use Excel to create a simple volume-price breakout detection template.

### Template Design and Formulas

#### Data Input Area

First, we need to set up a data input area for entering historical price and volume data of stocks.

| Date       | Open   | High   | Low    | Close  | Volume    |
| ---------- | ------ | ------ | ------ | ------ | --------- |
| 2025-01-02 | 150.00 | 155.00 | 149.50 | 153.20 | 1,200,000 |
| 2025-01-03 | 153.50 | 156.80 | 152.10 | 154.60 | 980,000   |
| 2025-01-04 | 154.80 | 159.30 | 154.20 | 157.80 | 1,850,000 |
| ...        | ...    | ...    | ...    | ...    | ...       |

#### Technical Indicator Calculation Area

Next, we need to add calculations for some commonly used technical indicators, such as moving averages and volume indicators.

```excel theme={null}
// Calculate 5-day moving average closing price
=AVERAGE(D2:D6)  // Assuming closing price is in column D

// Calculate 10-day moving average closing price
=AVERAGE(D2:D11)

// Calculate 20-day moving average closing price
=AVERAGE(D2:D21)

// Calculate 5-day average volume
=AVERAGE(F2:F6)  // Assuming volume is in column F

// Calculate volume ratio (current day volume / 5-day average volume)
=F2/G2  // Assuming column G is 5-day average volume

// Detect price breakout (whether closing price is greater than 20-day moving average)
=IF(D2>I2, "Yes", "No")  // Assuming column I is 20-day moving average closing price

// Detect volume anomaly (whether volume ratio is greater than 2)
=IF(H2>2, "Yes", "No")  // Assuming column H is volume ratio

// Detect volume-price breakout signal (price breakout and volume anomaly)
=IF(AND(J2="Yes", K2="Yes"), "Volume-Price Breakout", "No Signal")  // Assuming column J is price breakout and column K is volume anomaly
```

#### Signal Prompt Area

Finally, we can add a signal prompt area and use conditional formatting to highlight volume-price breakout signals.

1. Select the signal column (column L)
2. Click "Home" > "Conditional Formatting" > "New Rule"
3. Select "Format only cells that contain"
4. In "Format only cells with", select "Cell Value" > "equal to" > "Volume-Price Breakout"
5. Click "Format", set the background color to red and font color to white
6. Click "OK" to complete the setup

### How to Use the Template

<Steps>
  <Step title="Download Historical Data">
    Download historical price and volume data of stocks from websites like Yahoo Finance (usually can be exported in CSV format)
  </Step>

  <Step title="Import Data">
    Open the Excel template and copy-paste the downloaded data into the data input area
  </Step>

  <Step title="Update Formula Range">
    Update the cell reference range in the formulas according to the actual number of data rows
  </Step>

  <Step title="View Signals">
    View volume-price breakout signals in the signal prompt area, which will be automatically highlighted
  </Step>

  <Step title="Analyze Results">
    Combine market news and fundamental analysis to evaluate the effectiveness of the signals and investment opportunities
  </Step>
</Steps>

<Callout type="info" title="Template Optimization Tips" icon="brain-circuit">
  You can add more technical indicators to the template according to your needs, such as Relative Strength Index (RSI), Bollinger Bands, etc., to improve signal accuracy. You can also use Excel's chart functions to create visual charts of prices and volumes for more intuitive market trend analysis.
</Callout>

## Other Practical Entry-Level Tools

In addition to Yahoo Finance and Excel templates, there are some other practical entry-level tools to help you with investment analysis and decision-making.

### Free Chart Tool: TradingView

TradingView is a powerful free chart tool that provides rich technical indicators and chart types, suitable for technical analysis.

<AccordionGroup type="default">
  <Accordion title="Main Functions of TradingView">
    * Provides real-time and historical data for global stocks, futures, foreign exchange, cryptocurrencies, and other markets
    * Rich technical indicator library (over 100 built-in indicators)
    * Multiple chart types (candlestick charts, line charts, bar charts, etc.)
    * Supports custom indicators and drawing tools
    * Community sharing and communication functions, allowing you to view analyses and opinions from other users
  </Accordion>

  <Accordion title="How to Use TradingView for Technical Analysis">
    1. Visit the <a href="https://www.tradingview.com/" target="_blank">official TradingView website</a> and register for a free account
    2. Enter the stock code in the search box to enter the stock's chart page
    3. Use the top toolbar to select the time period (such as 1 minute, 5 minutes, 1 hour, 1 day, etc.)
    4. Click the "Indicators" button, select and add the technical indicators you are interested in
    5. Use drawing tools to mark key support levels, resistance levels, and trend lines
    6. Save your analysis charts for easy viewing and updating later
  </Accordion>
</AccordionGroup>

### Financial News Aggregation: Wall Street见闻

Wall Street见闻 is a professional financial news aggregation platform that provides real-time, comprehensive financial news and market analysis to help you stay updated with market dynamics.

### Investment Community: Xueqiu

Xueqiu is an active investment community that brings together the views and experience sharing of many investors. By participating in discussions in the Xueqiu community, you can learn from the experiences of other investors and gain market insights.

### Official Data Source: CNINFO

CNINFO is the designated information disclosure platform for listed companies by the China Securities Regulatory Commission. It provides authoritative information such as official announcements and financial statements of listed companies, serving as an important data source for fundamental analysis.

## Tool Combination Usage Recommendations

As an investment beginner, it is recommended to use the following tools in combination to form a complete entry-level analysis system:

<Columns cols={2}>
  <Card title="Data Acquisition" description="Yahoo Finance + CNINFO" icon="database" />

  <Card title="Technical Analysis" description="TradingView + Excel Templates" icon="chart-line" />

  <Card title="Market Information" description="Wall Street见闻 + Xueqiu" icon="newspaper" />

  <Card title="Decision Support" description="Excel Portfolio Tracking Sheet" icon="check-square" />
</Columns>