Silly Stock Analysis: Can you make money by buying a stock on a given day of the week and selling it on a given day of the week


I have a script that pulls a bunch of data on about 3,200 stocks and decided to pull the last 10 years of stock prices. I was bored yesterday and had a thought of is there a weekly buy/sell patterns for stocks and ran that analysis

Results: The majority of stocks are profitable, not very profitable, but profitable, there's some crazy outliers

Metric Value Percentage
Total Stocks 3246
Number of Profitable Stocks 2739 84.38%
Number of Non-Profitable Stocks 506 15.59%

Here's a link to the full google sheet:

Symbol Buy Day Sell Day Total Gain or Loss ($) Days with a Gain Days with a Loss Days of Data
A Monday Wednesday 60.56693268 261 203 2517
AA Thursday Tuesday 62.0277586 267 237 2517
AAIC Wednesday Tuesday -15.20999277 246 265 2517
AAIN Thursday Monday 1.249992371 48 44 521
AAL Friday Tuesday 22.48998547 264 235 2517

Daily Buy & Sell Strategy Overview

This Excel file contains an analysis of the best days to buy and sell for a set of stocks based on historical data. The strategy involves buying the stock on the day of the week when it has the lowest average return and selling it on the day when it has the highest average return.

Columns:

  • Symbol: The ticker symbol or identifier for the stock.

  • Buy Day: The day of the week when the stock typically has its lowest average return, making it the best day to buy.

  • Sell Day: The day of the week when the stock typically has its highest average return, making it the best day to sell.

  • Total Gain or Loss ($): The net gain or loss in dollars if one had followed the strategy of buying on the “Buy Day” and selling on the “Sell Day” for the entire period of historical data.

  • Days with a Gain: The number of transactions (buy & sell pairs) that resulted in a gain..

  • Days with a Loss: The number of transactions (buy & sell pairs) that resulted in a loss.

  • Days of Data: The total number of days of data available for the stock.

  • Notes:
    The strategy assumes a fixed investment amount ($1,000) for each buy transaction.
    The “Total Gain or Loss ($)” column considers all gains and losses from each buy-sell pair to arrive at a net result.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *