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.
Leave a Reply