MSN Stock Quotes is not working.

Have a question about your personal investments? No matter how simple or complex, you can ask it here.

MSN Stock Quotes is not working.

Postby schmoglehead » Thu Jun 27, 2013 10:20 am

About two weeks ago, MSN stock quotes (msnsq.exe) stopped working.
This is a great Excel add-in that with one click allows you to update all of your holdings. Cells in Excel can be conditionally formatted so that the background color changes when you reach your 25/5 rule for rebalancing. It has worked like a charm for the past six years.
There is one good thread on this: http://answers.microsoft.com/en-us/office/forum/office_2010-excel/stock-quotes-from-msnmoney-has-not-worked-for-the/9d751848-22e4-4618-80dc-c7317014a3e5?page=1&tm=1372342884499
Has anyone found a fix?
Thanks,
Schmoglehead
User avatar
schmoglehead
 
Posts: 69
Joined: Thu Jan 31, 2008 12:39 pm

Re: MSN Stock Quotes is not working.

Postby blueridge » Thu Jun 27, 2013 10:50 am

I am seeing the same thing. Used it for years, and now it's hit or miss. I have noticed that whereas a few days ago it was failing to get about 3/4 of my quotes, now it is failing to get about 1/5 of them. So it's improving. Hopefully they'll have it working in a day or two.

Oh, just read your link. Did you try using "USA" instead of "US"? I can't try it right now, but maybe it will improve the results?
blueridge
 
Posts: 66
Joined: Tue Jun 25, 2013 4:46 pm

Re: MSN Stock Quotes is not working.

Postby dbr » Thu Jun 27, 2013 10:54 am

blueridge wrote:I am seeing the same thing. Used it for years, and now it's hit or miss. I have noticed that whereas a few days ago it was failing to get about 3/4 of my quotes, now it is failing to get about 1/5 of them. So it's improving. Hopefully they'll have it working in a day or two.

Oh, just read your link. Did you try using "USA" instead of "US"? I can't try it right now, but maybe it will improve the results?


My problems with this add-in were corrected by this change. Since then everything seems normal.
dbr
 
Posts: 14131
Joined: Sun Mar 04, 2007 10:50 am

Re: MSN Stock Quotes is not working.

Postby blueridge » Thu Jun 27, 2013 11:00 am

dbr wrote:My problems with this add-in were corrected by this change. Since then everything seems normal.

Was just able to try it - works for me too.
blueridge
 
Posts: 66
Joined: Tue Jun 25, 2013 4:46 pm

Re: MSN Stock Quotes is not working.

Postby schmoglehead » Thu Jun 27, 2013 11:31 am

I changed US to USA and it worked for some quotes and later stopped working.
I also changed the non-working quotes to NYSE and that worked also but with some quotes later stopped working.
Same behavior on two computers.
Is MSNSQ.EXE working properly for anyone over time? I get it to work temporarily.
User avatar
schmoglehead
 
Posts: 69
Joined: Thu Jan 31, 2008 12:39 pm

Re: MSN Stock Quotes is not working.

Postby chaika » Thu Jun 27, 2013 11:57 am

Started manually adding the A to "US" and realized there is such thing as Global Replace. :oops:

That fixed the problem for the funds and stock. But VMMXX money market still does not work. It gives me #N/A for the cell
=MSNStockQuote($B11,"Company Name","USA") referencing VMMXX.
chaika
 
Posts: 76
Joined: Sat Nov 10, 2007 3:53 pm
Location: Chapel Hill

Re: MSN Stock Quotes is not working.

Postby schmoglehead » Thu Jun 27, 2013 3:53 pm

Some stocks always update normally.
Others intermittantly work. Sometimes any of the following: US, USA and NYSE work sometimes none of these work.
There seems to be no rhyme or reason to this!
User avatar
schmoglehead
 
Posts: 69
Joined: Thu Jan 31, 2008 12:39 pm

Re: MSN Stock Quotes is not working.

Postby schmoglehead » Mon Jul 01, 2013 6:25 pm

Here is a good thread regarding alternatives.
http://financetrain.com/topic/alternative-to-msn-stock-quotes-add-in-in-excel/

It took a couple hours but I recreated my Excel financial sheet in Google Docs using Google spreadsheet with the GoogleFinance() functions http://seekingalpha.com/article/568641-using-google-spreadsheet-as-your-watch-list

A nice example of what you can do with this Google solution is found https://docs.google.com/spreadsheet/ccc?key=0AvwJ4YKNr03kdG9FbkpVY3JacEd3dnJOZXhHSU81SFE#gid=3

I sum our investments by asset allocation and use conditional formatting to flag allocation values that are past the 25/5 rule tolerances. So, when the sheet opens and updates, I know immediately if I need to rebalance. This was relatively easy in Google spreadsheet. I essentially reused all my Excel formulas.

Thanks Google!!

Schmoglehead
User avatar
schmoglehead
 
Posts: 69
Joined: Thu Jan 31, 2008 12:39 pm

Re: MSN Stock Quotes is not working.

Postby Alan S. » Mon Jul 01, 2013 9:15 pm

Sounds like about the same time the MSN Portfolio Tracker stopped providing support for manual cash balance (MM Funds) balances.
Alan S.
 
Posts: 3472
Joined: Mon May 16, 2011 7:07 pm
Location: Prescott, AZ

Re: MSN Stock Quotes is not working.

Postby blueridge » Tue Jul 02, 2013 5:26 pm

schmoglehead wrote:Here is a good thread regarding alternatives.
http://financetrain.com/topic/alternative-to-msn-stock-quotes-add-in-in-excel/

meh, that thread read like someone with an agenda, which always makes me tune out fast. That being said, there is one nugget in there, which works great for Excel 2010 or later...
http://beforeitsnews.com/financial-mark ... 18708.html

For earlier versions of Excel, msnsq also works well (for me anyway) if I change "US" to "USA" as mentioned earlier.
blueridge
 
Posts: 66
Joined: Tue Jun 25, 2013 4:46 pm

Re: MSN Stock Quotes is not working.

Postby serbeer » Tue Jul 02, 2013 5:38 pm

After MSN plug in I've been using for the past 6 years stopped working a couple of weeks ago, I just modified all of my spreadsheets today to use this plug in instead:
http://finance.groups.yahoo.com/group/smf_addin/
It was pretty easy to convert: after install I simply started using, for example,
=RCHGetYahooQuotes(A1,"l1",,NOW())
instead of
=MSNStockQuote.Functions.MSNStockQuote(A1,"Last Price","USA")
to get quote for ticker in A1 cell (actually, optimized for much better performance using array functions functionality as described here http://finance.groups.yahoo.com/group/s ... essage/124 to get quotes for the whole list of tickers I use).
User avatar
serbeer
 
Posts: 877
Joined: Fri Dec 28, 2007 3:09 pm

Re: MSN Stock Quotes is not working.

Postby Peculiar_Investor » Thu Jul 04, 2013 9:07 am

There is a parallel discussion of this issue starting with viewtopic.php?p=1728094#p1728094. From my experiences it seems to be an intermittent problem which I'm speculating relates to their underlying data feed and conversion process. IIRC MSN changed their data feed provider recently.

I've got an Excel spreadsheet that automatically pulls quotes from MSN periodically and I've found that intermittently no result is returned and then on the next refresh all is good again. Since I use the spreadsheet for informational purposes only, waiting for the next refresh is only a minor irritant rather than a major enough problem for me to consider revamping the spreadsheet to use another data source.
User avatar
Peculiar_Investor
 
Posts: 390
Joined: Thu Oct 20, 2011 1:23 am
Location: Calgary, AB

Re: MSN Stock Quotes is not working.

Postby Naresh » Thu Aug 01, 2013 10:26 pm

For me variation of USA or US worked for few symbols, but leaving that blank with "" worked for all the symbols.

=MSNStockQuote.Functions.MSNStockQuote(A1,"Last Price","")

goodluck!!
Naresh
 
Posts: 1
Joined: Thu Aug 01, 2013 10:22 pm


Return to Investing - Help with Personal Investments

Who is online

Users browsing this forum: alife, Baidu [Spider], bkslainte, BL, ChicagoMedStudent, FAST Enterprise [Crawler], HunterFinder, inbox788, ZiziPB and 82 guests