Ipoh Community Forums
I want to live link a list of stocks in excel/google sheet - Printable Version

+- Ipoh Community Forums (https://forums.ipoh.com.my)
+-- Forum: Fun Corner (https://forums.ipoh.com.my/forum-65.html)
+--- Forum: General Discussion (https://forums.ipoh.com.my/forum-67.html)
+--- Thread: I want to live link a list of stocks in excel/google sheet (/thread-10242.html)



I want to live link a list of stocks in excel/google sheet - ChristopherMurrayq - 11-08-2024

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.


RE: I want to live link a list of stocks in excel/google sheet - AlfonsoWilkins - 11-08-2024

Google Excel formula live data feed, some time data get delayed depend on google rules and T&C.


RE: I want to live link a list of stocks in excel/google sheet - RobertArias - 11-08-2024

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.