AUTOMATIC Swing Trading Stock Selection with Google Sheet

A detailed guide to setting up an automated swing trading stock screening system for beginners using Google Sheets. Here is a summary of the key points of the document:

Introduction to Swing Trading:

Swing trading: An investment strategy that involves holding stocks for a few days, weeks, or months and selling them after making a profit.

Pros: Can be done in parallel with your daily job or business as an additional source of income.

Importance of Stock Screening:

It is crucial to select the right stocks for swing trading.

Screening using the Moving Average Crossover Strategy.

Moving Average Crossover Strategy:

When the stock price continuously breaks through the 10-day, 30-day, 60-day, 90-day, 120-day, and finally the 200-day moving average, it is considered a buy signal.

Conversely, when the stock price continuously breaks through the above-mentioned moving averages, it is considered a sell signal.

Data Acquisition and Collation:

Download all stock data using NSE India Bhavcopy.

Select the top 100 or 200 stocks with the largest trading volume to ensure liquidity and stability.

Google Sheets Setup:

Import stock symbols in Google Sheets.

Use formulas to automatically get the current market price (CMP) and volume for each stock.

Calculate the 20-day average volume for each stock to identify volume breakouts.

Moving average calculation:

Use Google Finance functions and formulas to calculate 10-day, 30-day, 60-day, 90-day, 120-day, and 200-day moving averages.

Formula example: =AVERAGE(QUERY(GOOGLEFINANCE(B2, "price", TODAY()-365, TODAY()), "select Col2")) (need to be adjusted according to the specific number of days)

Buy and sell signal generation:

Generate buy or sell signals by comparing the current stock price with each level of moving average.

The sample formula is used to identify whether the stock price breaks through or falls below each level of moving average continuously.

Signal screening and trading decisions:

Based on the formula results, automatically screen out stocks that show buy or sell signals.

Make trading decisions based on the stock price, moving average, and volume.