Median/Low Median Buy Chart for Fast Reference

Hey all,

I was inspired by 1percentbatman and wanted to make a Google Sheet that can quickly identify which funds are buys using his strategy.

https://docs.google.com/spreadsheets/d/1UZDr4KWSKuDwZIPXA_hhcoDBKfereVPrkm6QGg51BFo/edit?usp=sharing

Just make a copy of it so you can edit if you like.

The average is the the (52w low+52w high)/2 and low average is (52w average+52w low)/2

I also added total principal returns for YTD, since April 8th, and 1y so I could see which funds are showing as a buy, but have large NAV loss.

All of those will automatically update each day.

I also use Robinhood for my margin, so it has each fund's current maintenance requirement. You have to manually change this.

It's rough, as I made it with AI in like 10 minutes, but thought it could help some.