Which is the best day of the week to buy stocks historically?

%%
Learner 88 wants buy signal; that could work.. Something else that can work; buy over 200 dma + about 50 days above 200dma And ''slow sto'' signal saying its over bought for 50 days. Not because 50 days is such a perfect number; its simply a good upTrend in that case.

 

Sonnds like Learner 88 has some work to do

 

looks like wed for SPY from 2014 to present

Code:

import pandas as pd
import pandas_datareader.data as web
import datetime

start = datetime.datetime(2014, 1, 1)
end = datetime.datetime(2018, 12, 4)
spy= web.DataReader('SPY', 'iex', start, end)
spy['day_of_week']=pd.to_datetime(spy.index)
spy['day_of_week']=spy.day_of_week.dt.day_name()
spy['range'] = spy.close - spy.open
spy.groupby('day_of_week').agg(mean)['range']
        

---------------------
day_of_week
Friday       0.002380
Monday      -0.060331
Thursday    -0.003328
Tuesday      0.045062
Wednesday    0.072605

 

Buy on Mo and Th, sell on Fr. Got it!!!

 

2Rosy thanks for the code. Let me make sure I am interpreting this correctly...the SPY tends to gain 7 cents just by buying 9:30 and selling4pm Wednesdays and tends to lose 6 cents on Mondays? If that it, that is a very small edge right?

 

correct. I wouldn't call it an edge. it just happens to be that way for the given symbol over the given time frame. I or anyone could find billions of these scenarios... then create a newsletter or service and sell to the masses

 

i betcha if u look at less efficient/liquid names those figures will be more interesting.. esp close yest - open today

 

%%
Not a prediction, but since you like 88.
barchart.com rates SPY an 88% sell.

I dont buy bear rallies very often;
+ not a prediction + FRI maybe better up than today-Thur.LOL It tends take me more comissions in bear rally, so i was not suggesting a SPY buy on FRI. And if 1st quarter/200day moving average tends to do well+ oops does not do well, well that helps also .

 

12 years of data on SPX, looks like buy monday close

 

Lets kick it up a notch! ...measuring granular vols > open2close, yestclose2Open, yestClose2Close... some of these tickers have interesting profiles...very pronounced on multinational names/ADR's vs. the "locals"