Quant Investing

[hack2abi]

Hi Gaurav,

I have created this sheet where you can quickly check up on a stock’s price history.

Using Pivot Tables/Charts, Slicers & Screener to Semi-Automate Historical Peer Analysis

I am going to make this thread a repository of all the investing tool kits that I create for myself. Here is the 2nd tool kit. A google sheet that provides in-depth analysis of a stock’s price history. Functionalities as of today include: Return and CAGR since listing. All-Time high, 52-week High/Low and % difference between CMP and these milestones. Drawdown % and days. Average, Median, Standard Deviation, Maximum, Minimum, of Monthly/1/3/5/7/10 year rolling return periods. Win/Loss scenari…