I am trying to get real time price quotes for stocks into Excel. Using Excel I can only get delayed data from Yahoo. I was able to get data from Google that updates about once per minute. However, the functionality of GoogleSheets is limited. Maybe there's a better way to get real-time stock quotes, but is it possible to extract the tables from GoogleSheets and have it update into Excel say, once per minute? Thank you. I tried using MSN, but I encounter an error. I'm trying to create a screener with all 5000+ stocks in the NYSE, NASDAQ, and AMEX. I need the real-time price, high, and low for all of them. Delayed volume is fine. Last trade time would be nice, but isn't necessary. I'll update the open/previous close manually daily to avoid unnecessary data retrieving.
Bookmarks