Live (or almost) stock prices in Excel?

This is a discussion on Live (or almost) stock prices in Excel? within the Data Feeds forums, part of the Methods category; It should be the easiest thing in the world IMO, but in the years I've traded stocks and wanted to ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Jul 25, 2017, 8:57am   #1
Joined Sep 2016
Live (or almost) stock prices in Excel?

It should be the easiest thing in the world IMO, but in the years I've traded stocks and wanted to follow the value of my stocks, making graphs etc., getting the data into excel has been a pain. For years I used Data Connection function, had to set up each individual stock and it took forever to update. Later I used the MSN Money function where I can get all stock prices updated at once, I think 15 min delayed. And that worked fine (except my GM stock sometimes pulled the price for other stocks with similar initials/names) until mid July. They write.:"We are improving the way that stock quotes are delivered to MSN Money users. Unfortunately, this means we are no longer able to provide financial market information to you in this format.".

Funny how companies get PR people to create their messaging, calling a major annoyance/disruption an improvement. How stupid do they think we are?! Offending.

So...does anybody have a good solution for this? I'd like a sheet that clicking a button/macro in the sheet updates with all the latest stock prices (15 min delay is OK), and it has to be able to pull stock from both US, UK, GE and my country Denmark, e.g. Novo (Novo Nordisk A/S (NOVO-B.CO)).
No Quarter is offline   Reply With Quote
Old Aug 2, 2017, 3:46pm   #2
Joined Jul 2010
https://marketxls.com/ or www.interactivebrokers.com for free.
Trading Spaces is offline   Reply With Quote
Old Aug 2, 2017, 10:02pm   #3
Joined Sep 2008
Quote:
Originally Posted by No Quarter View Post
Funny how companies get PR people to create their messaging, calling a major annoyance/disruption an improvement. How stupid do they think we are?! Offending.
Get used to it. This is the way all companies operate now. Tell the customers how getting screwed is a great improvement over not getting screwed.

Peter
wackypete2 is offline   Reply With Quote
Old Aug 4, 2017, 7:29am   #4
Joined Sep 2016
No Quarter started this thread
Quote:
Originally Posted by Trading Spaces View Post
Sorry, but can't see it. Marketxls wants money I think and on interactivebrokers I can't find anything about excel download, and they want money
No Quarter is offline   Reply With Quote
Old Aug 4, 2017, 9:25am   #5
Joined Sep 2016
No Quarter started this thread For now I've solved with a not so good solution. More cumbersome. In Google Finance, I have My Portfolio with my stock. All except Norwegian Jinhui that I can't find. There's a download to spreadsheet function that I copy paste from, and some text juggling functions.

So nowhere as good as MSN, hope they get it back.
No Quarter is offline   Reply With Quote
Old Aug 4, 2017, 1:41pm   #6
Joined Jul 2010
Quote:
Originally Posted by No Quarter View Post
Sorry, but can't see it. Marketxls wants money I think and on interactivebrokers I can't find anything about excel download, and they want money

Interactive brokers have an excel dde api. It is free you just have to fund an account. You could try the free demo account before funding it.


https://www.interactivebrokers.com/en/index.php?f=1062
Trading Spaces is offline   Reply With Quote
Old Dec 6, 2017, 4:38pm   #7
 
1 Posts
Joined Dec 2017
If you don't mind using a free addin, I would advise you to install Deriscope. Then you will be able to access in Excel live quotes with only one minute time delay for stocks worldwide from the Alpha Vantage live feeds provider.

If you are interested in US stocks, the situation is even better. Deriscope brings into Excel true Real Time prices (one second time delay) on over 8,000 US stocks and ETFs directly from IEX (The Investors Exchange). The exact same service would cost you 500$/month at tiingo.com, which by the way boasts to be one of the cheapest live feed providers!!!

Parenthetically Deriscope also provides historical data on global equities and quarterly company financial data on US equities through Yahoo Finance, Alpha Vantage and IEX.

Here is a url for a video tutorial on getting true Real Time US stock prices from IEX:
https://youtu.be/7xd_ZohgY08

The following is a video tutorial on getting live (one minute delay) global stock prices through Alpha Vantage:
https://youtu.be/1GoLvT2lG8I
The last video includes Yahoo Finance feeds as well because it was published before Yahoo interrupted their live feeds service.
deriscope is offline Software vendor   Reply With Quote
Old Jan 4, 2018, 3:55pm   #9
Joined Sep 2016
No Quarter started this thread
Quote:
Originally Posted by ralphab View Post
Don't know if you've already found a solution for the MSN disappearing act, the same thing recently happened with Yahoo, but I stumbled onto this a few days ago:
Thanks raplhab, but it doesn't seem to work too well. I made links to 11 tables, and when I refresh them all, some of them move adds columns to the left. Not all of them, and not the same ones every time, so linking the data to the rest of my sheet becomes very difficult. Have you experienced that?

Scratch that, I removed the Data Filter from each box, that seemed to remove the problem, hasn't been there since.

Last edited by No Quarter; Jan 4, 2018 at 4:14pm. Reason: Concern stated apparently fixed
No Quarter is offline   Reply With Quote
Old Jun 12, 2018, 11:47am   #10
Joined Jul 2010
www.deriscope.com is a free excel add in to get free stock and futures data.
Trading Spaces is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Live stock quotes in excel via DDE or other ? Spritey1964 Data Feeds 2 Dec 25, 2013 8:35am
The Most reliable website/iphone app for live stock prices hkmt First Steps 1 Nov 18, 2013 12:33pm
Getting live IG prices into excel spreadsheet cablemonster Techies Corner 10 Jun 25, 2013 10:00pm
Article: The Relationship Between Stock Prices and Bond Prices T2W Bot Educational Resources 0 Oct 1, 2010 2:13pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)