Ipoh Community Forums

Full Version: I want to live link a list of stocks in excel/google sheet
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have gone through youtube but can’t find any helpful ones.
I know this thing will be basic for those who know.
Say, I have a list of 150 stocks. I need a live feed for that, LIKE opening price, LTP, high low.
Please.
Google Excel formula live data feed, some time data get delayed depend on google rules and T&C.
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.