Can anyone provide me a link to the auto-updating excel?

General
1

Hi All,

I have been looking for an excel which auto-updates the LTP, O-H-L-C for certain scrips which have been added to the excel, mostly the Nifty 50 stocks.

Can anyone help me out with this?

Regards,

Mangesh

2

Check this:

https://docs.google.com/spreadsheets/d/17lBm-OU1Yv9UZ7VT26eB2TqgDy2NMcrHVohK4CqmWA8/edit

3

Hi PavanKishore,
Looks like it’s a pdf file… I opened the link during live market hours, but it is not updating the quotes.
Is there any excel which auto-updates, say every 1 min?
Looking for help on this…
Regards,
Mangesh

4

Mangesh . Thats a Google Sheet ans it works. In case the problem persists, try to open your gmail account and save it to your drive.
It actually picks up data directly from Google Finance.
http://blog.ayamih.com/2017/07/faq-on-google-sheets-google-finance-for_26.html

If you are looking for a more sophisticated application, check this free fatafat screener:

https://docs.google.com/spreadsheets/d/1iY15IUifnWVas_ljQDGcS48EoyqWjQ_MuqcmKWmAtcc/edit?chrome=false&rm=demo

5

You can do this yourself. Check out the formulas here. I believe what @PavanKishore has shared does this.
https://support.google.com/docs/answer/3093281?hl=en

Thanks Pavan for the resource.