locked
Share Price Updates after 2011 - An Idea? RRS feed

  • Question

  • I use my copy of Money to track my share portfolio on a daily basis.  At present Money updates every 15 minutes, so when I want to get an idea of share values I can just look in Money.  I understand that from 1st January 2011 Microsoft will discontinue provision of online updates.

     

    Would it not be possible to patch the software to received quotes from an alternative source?  I guess somewhere within Money there's reference to a server address to which it connects to obtain updates. Would it not be possible to change this to a server run and supported by Money users?

     

    There seems to be a number of Money users who would like to stick with it (I use UK V.14) and I guess we could all maybe chip in a few pounds to get an ADVFN or similar data feed which could then be referenced by a patched version of the software.

     

    Just an idea!

    • Edited by Big Notion Wednesday, May 26, 2010 3:14 PM Typo
    Wednesday, May 26, 2010 12:18 PM

All replies

  • Here's exactly what you're looking for.

    It doesn't appear to be that user friendly, but it does seem workable:

    http://thefinancebuff.com/2009/09/security-quote-script-for-microsoft-money.html
    Thursday, May 27, 2010 12:07 AM
  • Thanks, this does work but involves a manual process.  I was hoping for something a bit more automatic.  Maybe a program that sits in the background, downloads quotes and update the necessary entries within the Money file?

    Does any know what format the .mny file is in?  If so, I could put together a program that gets quotes from a suitable server and updates the .mny file directly... if I knew what to update that is!

    What do everyone think?  Is this worth the bother?  I'd use it myself, but would be good to know if others could use it.

    Thursday, May 27, 2010 1:25 PM
  • That sounds GREAT, if it can be done!  I'd definitely use it.  Stock price update is an important feature that I will miss.  I am using Money 07 at the moment.

     

     

    Thursday, May 27, 2010 3:56 PM
  • Sure - I'd use it, especially if it were a properly maintained and complete database of up-to-date funds and shares (unlike the present arrangement!). I'd guess that there must be many thousands of active users in UK who could be persuaded to chip in - if the cost per head were less than, say £10 pa. [I still use Money 2001 - v9]

    I really don't understand MS' reluctance to continue to provide this dataflow (other than the cost!) to a large band of extremely loyal users - who are not being offered any alternative. What are we supposed to do? We bought the software in good faith that it would provide for our ongoing financial needs and we have invested significant time and effort in loading all our financial records on to it; I see it as a breach of faith (and commercial sharp practice?) to withdraw support without offering an upgrade path (not that it's needed), whatever the small print may say to provide a justification.

    Am I alone in thinking this?

    Friday, May 28, 2010 1:16 AM
  • Quick update.  I've sent an enquiry to Microsoft UK as follows:

    Hi,

    I'm a Microsoft Certified Professional Developer based in the UK.  I've been using Microsoft Money since the early 2000's and I understand that Microsoft have ceased support and development of the product, and indeed will be ceasing provision of stocks and shares updates from January 2011.

    The stocks and shares management facilities within Microsoft Money (I’m currently using Version 14.0.120.1105) is a feature I use very regularly.  The cessation of automatic price updates is a real issue for me.  I’ve made a post within the Microsoft forums (see http://social.microsoft.com/Forums/en-US/money/thread/2c03e3d8-9bc1-4fc9-8862-78fcdb7e29d9) in order to see what interest there is in providing some other form of update mechanism. My impression is that there are still a significant number of users who would like to use the software, and that alternative, non-Microsoft personal finance packages do not provide for the needs of these users.

    As a Microsoft developer I feel this is a service I may be able to provide for UK based Money users, however I would require some assistance from Microsoft in order to fully understand how the software goes about obtaining quotes.

    Could you please let me know who would be the best person to speak to with regards to this?

    Yours, etc.

    So... fingers crossed, will update further once I get a reply! :)

    Friday, May 28, 2010 9:48 AM
  • I would certainly be interested in a share feed post 2011 and would subscribe to it
    Thursday, June 3, 2010 3:57 PM
  • I would certainly be interested in a share feed post 2011 and would subscribe to it

    Me too
    Sunday, June 13, 2010 8:49 AM
  • You may wish to also look at this Java script. It is easy to use and really does need anything special if you have Java Script installed.

    http://microsoftmoneyoffline.wordpress.com/2010/02/12/java-app-to-update-quotes/

    http://www.le.com/~hle/out/hleOfxQuotes/

    It also is a manual process.

    Mike

     

    Sunday, July 4, 2010 2:01 PM
  • Thanks for pointing out the Java and Python script methods that are covered in my Blogsite "Microsoft Money Offline".  Please note however that these wouldn't fill Big Notion's requirement of monitoring price quotes throughout the day in Money itself, although the apps themselves would do so.

    At present Money updates every 15 minutes, so when I want to get an idea of share values I can just look in Money.

    Money only records the first price quote value for any given day using the Offline methods.

    - ameridan
    http://microsoftmoneyoffline.wordpress.com

    Monday, July 5, 2010 12:10 AM
  • I too am looking desperately for a solution to continue updates.

    I too would pay a small fee for this service (say about £10 per year).

    I have written to my stockbroker (one of the biggest retail brokers in UK, who advertise heavily on MSN) suggesting that they take an interest in providing this service too.

     

    Richard

    Wednesday, July 14, 2010 2:45 PM
  • Another idea - Money used to interface with the old really excellent MSN Portfolio. Would it not be easier to ask Microsoft to release or sell this, and make it interface with another provider of stockquotes. If Money 2005 could then interface with the old online portfolio (instead of the rubbish new one) then stocks could be locally downloaded too?
    Wednesday, July 14, 2010 3:07 PM
  • Here's exactly what you're looking for.

    It doesn't appear to be that user friendly, but it does seem workable:

    http://thefinancebuff.com/2009/09/security-quote-script-for-microsoft-money.html


    That only works for US listed stocks, as does the other solution proposed further down the thread.

    These solutions not only need to be more user friendly, but also need to work for any ISIN stocknumber, not just US stock numbers.

    Wednesday, July 14, 2010 3:32 PM
  • I beg to differ when you state that the quote scripts only work for US listed stocks.   I've experimented with stocks from all over the world with successful results, although they do seem to be the US dollar values.

     The section of Python code that gathers the quote (thanks to TFB)...

           

    url = "http://finance.yahoo.com/d/quotes.csv?s=%s&f=nl1d1t1" % self.ticker
            try:
                csv = urllib2.urlopen(url).read()

     

    could easily be modified if someone finds the same csv quote function on UK's Yahoo site (as an example, and I would presume the units would then be in Pounds, rather than US dollars).

    See my blog entry from last February where I explored this somewhat... http://microsoftmoneyoffline.wordpress.com/2010/02/14/adapting-quotes-py-for-worldwide-stocks-funds/ 

    and explore this further rather than say it can't be done.  If someone finds an answer, feel free to post a comment on my Blog so that I can post the solution for others :)

    • Edited by ameridan Thursday, July 15, 2010 2:31 PM
    Wednesday, July 14, 2010 9:09 PM
  • If you say it works for non US stocks, I will try again. But I found the whole python thingy very un user-friendly - just trying to understand what Python is was difficult enough. When I finally managed to install it, the first fund I tried (Swiss domiciled) did not work, even though it is listed on Yahoo USA.

    As somebody else suggested, would it not be possible to make it more user friendly? For example, make a program that runs in the background, collects prices, then dumps them into Money at pre-determined intervals?

    Thursday, July 15, 2010 5:13 AM
  • I totally agree, Python is user unfriendly, and ability to update international stock quotes should be a must.  Come on all you geniuses out there, help us out please!
    Thursday, July 15, 2010 6:12 AM
  • I realize this is an old thread but I want to give an update for our UK friends. We've made enough of progress to be able to get MM2005UK to update quote prices. It is not as smooth as the US-Yahoo path but if you can put up with a couple of additional steps: manual download from ft.com, extra dialog from MM, then you can get quote price to update.

    See: http://code.google.com/p/hle-ofx-quotes/wiki/UKUsers

    Best,

     

     

    Wednesday, February 16, 2011 4:04 AM
  • Great to see a possible solution. I saw on another thread that you appear to be making progress on automating the procedure.

    Just in case anybody from Microsoft reads this thread, just like to say how disgusted I am at the refusal to offer any assistance at all to the Big Notion's offer to write some code so that MS Money can keep running. It stinks of abject arrogance on the part of Microsoft. I don't know how Microsoft expect users to trust their data to their "cloud" computing strategy when they have already demonstrated their disdain for users personal financial data. Us UK users do not even have the "option" of switching to Quicken, so our data is only usable in MS Money.

    Wednesday, February 16, 2011 1:12 PM
  • Not sure what is going on with the share price updates.  I'm running MS Money 2002, updating had stopped for me by Monday am 14/2/11.  Today (17/2/11) I tried updating (in a vain hope the service was working again) and lo and behold it updated and continued to do so for about 30 minutes then stopped completely again.  Any thoughts?  

    I'm looking for software to replace the portfolio side of MS Money (assuming it is truly dead and buried), anyone any experience of Stock Market Eye? 

    Thursday, February 17, 2011 10:33 AM
  • Seems to be working again.  Please MS Money, tell us what is going on!
    Thursday, February 17, 2011 10:37 AM
  • This works great with FT.com except that my prices are all being improted into MM with the MM source as "Buy" rather than "update" or "online". This means that my graphs show daily prices points as Buy - a bit anoying.
    Saturday, February 26, 2011 11:14 PM
  • This works great with FT.com except that my prices are all being improted into MM with the MM source as "Buy" rather than "update" or "online". This means that my graphs show daily prices points as Buy - a bit anoying.

    hleOfxQuotes has kindly supplied the following solution:

    "If you are using Sunset, make sure to set

     

      Incrementally Increased Share Count or Randomize Share Count (Edit -> Quotes) to FALSE so that OFX does not generate non-zero shares.

       Different way to saying this: with Sunset, we can import in zero share and MM will update the price."

     

    Many thanks to hleOfxQuotes 

     

    Sunday, February 27, 2011 8:30 AM