Is there trading software that can identify and analyze similar trading days?

I think there are openings, middays and closes that bear a striking resemblance to many other openings, middays and closes. As anyone glued to their screen all day can attest.
 
Nice job! Was this in Excel only...?

Well, I eschew MicroBloat products where I can, so OpenOffice/LibréOffice. But, same difference: a standard spreadsheet.

BTW, I just checked the conditional filter in the column G, and indeed, it's just
=IF(AA25=5,F25,"") -- so, "If Friday, print."
 
Last edited:
Let's say it's Thursday before the Payroll numbers at the beginnin of a new month. Is there software that can look back over several years and consolidate the price action for a given security coming into and out of the Payroll number? Be nice to have some stats before making a trade.

I know this is the despised nearest neighbor algorithm. I'd still like to see how a security has behaved in the past in specific settings.

Some practical constraints: 1) only compare the security with its own history; 2) sample the security's price action from the same time of day.

TradeStation can do this. I do it a lot, and it's useful. For example, if you buy certain ETFs the last 2-3 days of the month and sell after a couple of days into the new month, it'll make about 6% per year on average. The trouble is...it doesn't do this 100% of the time. Over a year, it'll probably be profitable (based on the past 20+ years), but in any given 2-3 months, you may lose.
 
Back
Top