🚨 I’ll be live at 10 a.m. ET with Nate Tucci🚨
 We’ll kick off the week with a broad overview of where we stand after the weekend, things every trader should know and where we go from here [tap to join us for Opening Playbook]!
I’ll be honest — sometimes the best trading tools aren’t the fancy charting platforms or expensive data feeds. Sometimes it’s just a well-built Google Sheet and a little curiosity.
Recently, I’ve been noticing something unusual with gold prices on Fridays. Every time I come in to execute our Friday Gold Trade on Opening Playbook, it feels like I’m never getting a discount. Gold rarely seems to be down when I show up to place the trade.
Now, this could be nothing. It could be confirmation bias. But I’m a process guy — so instead of just wondering about it, I decided to do some digging.
Building a Historical Price Tracker in Under a Minute
That’s where Google Finance comes in. If you’ve never used it, it’s a powerful function built right into Google Sheets that lets you pull historical market data automatically.
The function looks at the specific date you feed it, the ticker you assign and the attribute you want — open, close, high or low. With one clean formula, it returns exactly the data you’re after.
Here’s how I set it up: I created a column with dates — yesterday, the day before, the day before that. Then I built a formula that references the date, the ticker symbol, and the attribute I want to analyze.
For gold I used SPDR Gold Shares (GLD) on the first reference. An index function finishes the job and keeps everything tidy.
The entire system took about 30 seconds to build. No manual data entry, no copying and pasting, no jumping between sources. Just a simple, repeatable way to get historical prices whenever I need them.
Investigating the Friday Gold Phenomenon
With the tool in place, I’m pulling weekday data to see if there’s any kind of recurring pattern heading into the weekend. I’m not assuming there’s something there — I’m checking because if a pattern exists, I want to know.
And if nothing repeats, then at least I’ve verified it instead of relying on gut feel.
Some people asked whether we should place the trade on Thursdays since gold can occasionally sell off then. Honestly, that probably would work. But I stick to Fridays because consistency matters. A strategy is only a strategy if you run it the same way every time because that’s what gives you reliable outcomes.
Still, the curiosity is real. Every Friday I come back and gold seems to be holding firm or even rallying. I’m getting tired of never getting a discount on our Friday Gold Trade, and that alone makes the data worth exploring.
Maybe there’s a subtle phenomenon happening before the weekend. Maybe not. But digging into historical data is how you can uncover small inefficiencies — and sometimes those turn into edges.
Once I finish combing through everything, I’ll share what I find. Whether you trade gold or not, the bigger lesson is simple: If something in the market keeps catching your eye, don’t speculate — test it.
You don’t always need advanced, expensive tools. Sometimes a Google Sheet is all it takes to start thinking like a data-driven trader.
Graham Lindman
Graham Lindman Trading
Follow along and join the conversation for real-time analysis, trade ideas, market insights and more!
- Telegram:https://t.me/+abM5RWRJKrpkNWI5
- YouTube:https://www.youtube.com/@NewMoneyCrew
Important Note: No one from the ProsperityPub team or Graham Lindman Trading will ever contact you directly on Telegram.
*This is for informational and educational purposes only. There is inherent risk in trading, so trade at your own risk.
P.S. Access the Lotto Board’s Top 3 Picks for Today!
Thanks to an algorithmic pricing error, the Lotto Board is able to filter options contracts that are massively underpriced.
It floats the top 3 most likely to give us a shot at a payout worth 50%, 100% and even more in a few days.
I can show you the top 3 it’s floating now, as well as how you can access the entire board today.
