Nov 10 2021 12:45 AM
Hi Folks,
I want a real time update of stocks in excel if possible on desktop without a macro, If not please guide on the most effective macro. Please refer to the attached sheet
Thanks
Nov 10 2021 04:16 AM
Nov 10 2021 01:58 PM
Depends what do you mean under real time.
In insiders version of Excel some settings for the refresh were added
My understanding that is refresh of data provider data, not sure how often data provider refreshes it. I guess ones per 15 min.
Nov 12 2021 01:37 PM
Nov 12 2021 01:37 PM
Nov 12 2021 02:09 PM
Even if you find the way to update data card more often I don't think that helps. Microsoft doesn't take data directly from stock exchange, it takes it from data provider, Refinitiv. And Refinitiv collects data and provide it on data interface which Microsoft uses for Excel with some delay, I'm almost sure we speak about minutes. That's not the trading tool.
Nov 12 2021 02:24 PM