have gone by youtube however can’t discover any useful ones.I do know this factor can be primary for many who know.Say, I’ve a listing of 150 shares. I would like a reside feed for that, LIKE opening value, LTP, excessive low.
Please.
Google Excel system reside knowledge feed, a while knowledge get delayed depend upon google guidelines and T&C.
Google Finance Doc
help.google.com
GOOGLEFINANCE – Google Docs Editors Assist
Fetches present or historic securities data from Google Finance. Pattern Utilization GOOGLEFINANCE(“NASDAQ:GOOG”, “value”, DATE(2014,1,1), DATE(2014,12,31), “DAILY”) GOOGLEFINANCE(“NASDAQ:GOOG”,”
1 Like
Hey, thanks. Sure, i do learn about googlefinance. however it’s not realtime knowledge.is there anyway we will feed our dealer’s watchlist into excel?
Celina:
is there anyway we will feed our dealer’s watchlist into excel?
witch dealer do you could have?
I’ve espresso, fyers and dhan.
Fyers have the choice to take excel file and use the costs reside feed
obtain the fyers one and set up in home windows OS and choose watch-list which you wish to take reside feed proper click on anyone image and choose hyperlink to excel it’s going to ask to avoid wasting the file…https://fyers.in/merchandise/one/
OR
use TX3 platform its free desktop app as nicely knowledge feed. with excel
2 Likes
will attempt to let u know. Thanks once more
1 Like
I’ve been in that actual spot with monitoring a number of shares, and it may be difficult. What labored for me was organising a Google Sheets doc and utilizing the GOOGLEFINANCE perform to tug within the reside knowledge. For issues like opening value, LTP, excessive, and low, you should use one thing like =GOOGLEFINANCE(“TSE:TOI”, “open”) to get the opening value for a inventory. When you’ve got 150 shares, you possibly can simply drag the system down for each. I additionally discovered a useful useful resource in 141 Free Excel Templates and Spreadsheets – Microsoft Excel & Workplace Expertise Programs, which gave me some tips about higher organizing the info. It helped me get every part working easily.
is it attainable to trace reside kite watch checklist in excel?
