5 hours ago
(This post was last modified: 5 hours ago by RobertArias.)
I’ve been in that exact spot with tracking multiple stocks, and it can be tricky. What worked for me was setting up a Google Sheets document and using the GOOGLEFINANCE function to pull in the live data. For things like opening price, LTP, high, and low, you can use something like =GOOGLEFINANCE("TSE:TOI", "open") to get the opening price for a stock. If you have 150 stocks, you can just drag the formula down for each one. I also found a helpful resource in 141 Free Excel Templates and Spreadsheets - Microsoft Excel & Office Skills Courses, which gave me some tips on better organizing the data. It helped me get everything running smoothly.