Is there a way I can live stream market data directly into excel and have it fill in cells automatically?
Is there a way I can live stream market data directly into excel and have it fill in cells automatically?
It is possible, but I don't know about it in US.
Are you using Excel 2019 or something newer?
In 365 you have Stocks on the Data ribbon.
Last edited by AliGW; 02-06-2024 at 04:45 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Well, but it is not "live stream".
The data updates automatically ... Doesn't that amount to the same thing?
You have said that it's possible but have not said how, so please share your method. Thanks.
I used to pay for it in Brazil, it popup every second, so it is different from the MS update that if I'm not wrong do it every 15 min or more.
You can Buy & Sell based in live stream service, but with MS service you will be always late.
I said it is possible for him to keep looking for it, but I don't have the information about services like this in US, but I know they exist for sure.
I am using excel 2019 and I need futures data as well
In a fast search I found this:
Quotestream.com $17.95/month
NASDAQ
DOWJONES
MarketWatch
Contact them.
I was aware of these this doesn't provide a technical solution to streaming market data directly into excel.
Have you looked at this link?
https://www.michael-saunders.com/sto...ages/info.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This one also bring streaming data for Excel.
Marketxls
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks