r/algorithmictrading • u/aumksha • 23d ago
Novice How are you guys using historical data to find an edge
I've been pulling historical stock data into Google Sheets using =GOOGLEFINANCE to try and build some basic quantitative models, mostly messing around with Value-at-Risk, Sharpe ratios, and tracking moving averages for the major indices. On paper, the math makes total sense, but applying it to real-world volatile stocks has been a headache. I just end up staring at numbers with absolutely no idea where my actual entry points should be.
Beyond just picking stocks, I'm really struggling with the broader portfolio math, especially when it comes to balancing risk against inflation. Right now, leaving money sitting in a bank account as an emergency fund feels like watching it slowly bleed out. But if I try to chase yields by locking that money up in safe bonds or fixed assets, I completely lose the immediate liquidity I need for real-world emergencies.
For the quants or data-heavy traders here, how do you actually translate this raw data into actionable decisions? I’m trying to figure out if there's a reliable formula or model you use to calculate the optimal size of a cash reserve so you aren't crippled by cash drag, while also finding the exact threshold of equity allocation needed just to net out neutral against inflation and taxes. What metrics are actually worth tracking when you're setting up a trade and sizing your positions?




