Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I want to live link a list of stocks in excel/google sheet
#1
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.
Reply
#2
Google Excel formula live data feed, some time data get delayed depend on google rules and T&C.
Reply
#3
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)