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. |