Well tomorrow Microsoft is supposed to start installing Windows 10 as an “upgrade” to PCs running Windows 7 and Windows 8.x and it appears that some early testers have observed hiccups without official acknowledgement of fixes being offered. I for one plan on not accepting the Windows 10 upgrade for a while (assuming of course that I will be offered the option and it won’t just install on its own).
Of course, patching the dll as previously discussed in the Windows 8 Compatibility discussion will be necessary if you are installing Money on a clean install of Windows 10, but if the PC is simply being “upgraded” to Windows 10, I’m thinking that should already be done.
I happened to note that Robin Wheeler has observed that Microsoft Money is expecting that the version number for Internet Explorer should be defined with no more than 15 characters. The current version number in the registry for Internet Explorer 11 is 9.11.10240.16384 and she has found that the value needs to be truncated by removing the 16th character (4) in order for Money to run. Great observation Robin! This could be a pain if Microsoft is going to update Internet Explorer (or Edge which is the name of IE’s replacement) using version numbers greater than 15 characters long.
*** Should be easy for someone to write a python script to keep the version number truncated in the registry as it changes in the future.***
So, to clarify, in order to resolve the error: [updated 8/2/2015 to include 32-bit variance]
- Open Registry Editor (RegEdit).
- Navigate to the following registry key for 64-bit Windows:
or for 32-bit Windows:
- In the right pane, look for Version registry value.
- Modify the value data to 9.11.10240.1638 so that it contains no more than 15 characters.
She questioned why Money looks at the IE version #. Unlike a program that generically invokes a browser by simply looking up the registry to identify the default browser, Microsoft Money is designed to use Internet Explorer exclusively as the entire user interface and consequently it looks up the registry to find the installed version. If no entry is found, it will default to prompting you to install Internet Explorer 6 – which of course will never install with Windows 8 or 10.
I’m going to inject my theory here at the risk of being proven wrong (I don’t have Windows 10 yet), but based on past experience, I don’t think it matters if Windows default browser is set to Edge or Firefox or Chrome – Money is always going to use Internet Explorer, or at least what the registry leads Money to think is Internet Explorer. Based on all of the changes reported to work for “Version”, it seems that it can be almost anything, as long as it isn’t longer than 15 characters AND as long as a version of Internet Explorer can be found, that is what is invoked to open up Money.
What isn’t clear yet is whether a clean install of Windows 10 (vs. an upgrade) and/or future iterations of Windows 10 will always install a version of IE, whether Edge will always act like a future version of IE, and whether Microsoft will continue to use the registry as a means to fooling legacy programs like Money into thinking that the current browser will behave properly with Money as IE has up through Version 11.
I’ll do my best to keep track of any issues and solutions that keep me from using Microsoft Money as I really have no intentions of not using this fantastic program.
MSMoneyQuotes by Gaier Software, LLC
[UPDATE 1/3/2015] Dan has just released version 2.0 for 2015 that obtains financial data from an entirely new online quote service built for the new MSN.com and MSN Money websites, and is also used by the Windows 8 Finance app. The new online quote service is more reliable, has better symbol coverage, and should be here to stay for a long time. It is backed by a Morningstar quote feed and should prove to be more useful to more users than MSN.com has been this past year!
Well, I stated in my previous blog post that this addon program looked promising, and indeed, even though Money is offline now, with MSMoneyQuotes, we once again have the ability of feeding live (20 minutes delayed) MSN online quotes data into our Money database once again – even if your Money program isn’t currently running! For those using Pocketsense, simply make sure that you run this program prior to Pocketsense each day (or stop retrieving quotes with Pocketsense ~ comment them out in sites.dat file by inserting # in first column, and use it for statement downloads only) so that your quote price is input into Money as online rather than update. Online allows for continuous updating throughout that day whereas Update only holds the first price entered that day. There is even an option for updating quotes every 15 minutes like Money used to do!
[[UPDATE 5/13/2014] Cal brought up a good point in his review of my review ;-) ” We remember that quotes used to be a big factor in the size growth in Money files. So maybe some of us might run two Money files… one with all of the investment info, and one slower-growing. Anyway, it does honor Money’s selection of about what quotes get downloaded. “ By running Pocketsense prior to MSMoneyQuotes and keeping active those stocks that a representative stock price only is adequate (no other quote data is needed) by listing them in your sites.dat file, you will retain much less data in your Money file. Those stocks that you really wish to retain all of the MSN quote data for will still be entered into Money as long as MSMoneyQuotes is the source of that data. Or you could use this strategy once per month to gather and save the detailed data, using Pocketsense for the other days… Very versatile!!
In addition to Last Price, you’ll also see the following fields updated by MSMoneyQuotes if the MSN site has things set up correctly: change, open, high, low, 52 week high, 52 week low, ask, beta, bid, market cap, shares outstanding, PE, volume, and yield.
Many of my blog readers were involved in the Beta trial and based on the terrific feedback provided, Dan Gaier has come up with a very compact and efficient program that has many powerful options which weren’t available in the original trial release. Well worth the $9.99 lifetime purchase price and in conjunction with Pocketsense, Money really feels like it’s online again! If you would like to try or buy the program – click here. In addition to those of us already using this program, the program’s author will be monitoring this thread so feel free to ask questions by leaving a comment here if the official support page doesn’t answer your questions. You also have the option of emailing Dan Gaier directly at email@example.com. Thank you Dan for making this available to Money diehards!!!! Long live MS Money offline – it’s already been 4 years.
Restoring Microsoft Money Quote Updates
I’m a former Microsoft employee who worked on the Microsoft Money product and MSN Money website for almost a decade. Yep, I was the software developer who built the Portfolio Manager for both products, worked on the quote services that powered them, and in 2009 built the Money-to-Quicken Converter for Intuit.
Since Microsoft pulled the plug on the quote servers in the summer of 2013, I often get asked if it’s possible to build something that would restore Money’s ability to get quote information. It turns out it is possible!
So in my (very limited) spare time, I’ve been tinkering with building such a tool over the last 6 months. The Money code is old and complex (written in C/C++, Win32, COM for those technical folks) and it took a fair amount of time and effort to work through some hurdles, but I finally have something that works.
The tool is a separate executable that can open your Money file (including password protected ones), inspect the securities in your portfolio, make service call(s) to MSN Money’s new quote services to fetch data for these securities, and update your Money file. It follows nearly the same logic as the original Money code in terms of updating this information, and includes data such as last, change, open, high, low, 52 week high, 52 week low, ask, beta, bid, market cap, shares outstanding, PE, volume, and yield. It also handles pounds to pence price conversions for you UK users. It can be run throughout the day, knows when to add vs. update an existing price entry, and can be run while you have Money open.
I’ve tested it with a few recent versions of Money, but have no idea if it will work for older versions. I’d consider the current version in a “Beta” stage.
I’d like for you to try it out to see if it works. I’ve made a special version of this tool called MSMoneyQuotesTrial.exe that allows 30 quote updates.
Depending on the feedback I receive, I may put more time and effort into releasing a polished version of this tool and unlock it to allow for unlimited quote updates.
Click here to register as a tester and download this executable for free.
Click here to download updates if you’ve already registered.
© 2014, Gaier Software LLC
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 41,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 15 sold-out performances for that many people to see it.
Just throwing this out there for the programmers / Money “experts” out there…
I happened to stumble on the possible source of links in Money Plus to the MSN servers that might be used to redirect to alternative solutions for those functions that used to be provided by the MSN servers.
In MNYCoreFIles/WebCache is a file rooturl.xml that reveals the following:
[?xml version=”1.0″ encoding=”UTF-8″?]
It couldn’t be so simple as to plug in new urls, could it?
I’ve been beta testing two new apps that interface with Sunset Money that I’ll be reviewing today. Knowing that many of my blog readers have stated that they want to be able to update quotes from Google and Yahoo without having to deal with Python is the reason for my inclusion of the first (beta) app, which actually is not “new” in that it was released in 2011. It is SunsetOFX from Syntap Software and it is a simple Windows app that only requires .NET 3.5 which is native to Windows 7. If you are running Windows XP as I am, you are probably running .NET 3.5 as well, and if not, it is an easy to install update. Whichever folder you install the single EXE file into is where the XML and OFX files are also saved (when exiting). The app has an ADD button to add stocks, funds and options.
There is no DELETE button, but by right-clicking the XML file, which also serves to store your security selections, you can select edit and your text editor will open the file for editing. Similar to Pocketsense and TheFinanceBuff’s scripts, you should create a dummy account with zero shares of the quoted securities and you can only update Money once per day, so if you update a mutual fund prior to 5 or 6 pm, the quote will probably be from the prior business day. Any feature requests regarding SunsetOFX should be left on Syntap’s blog page.
The developer(s) of the second app seem very anxious to get a much more robust Money addon program to fruition. It is called PalOMoney and it has really advanced in the last few weeks. I believe I am the first outside beta tester and I probably caused a few headaches for the developer(s) as I installed the app as I thought a typical user would (rather than the suggested “ideal test computer” conditions using a root folder, etc) but I can honestly state that I’m confident that unlike version 1.0.3, the current version (1.0.4 as I’m writing this) should install nicely and work as advertised.
It too is a Windows program, but this one actually directly interfaces with Money’s data file with the intent of updating delayed, real-time and historical quotes, Read the rest of this entry »
[UPDATE: The revised scrubber routine is now incorporated into newer released versions of Pocketsense, so you no longer need to look for the beta version 12/12/2013]
I discovered that Schwab has started using a new tag CORRECTACTION when uploading their ofx data, and Robert immediately added a routine to his Pocketsense scrubber script for me to try out. After testing it out, he released the revision and I am happy to report that was apparently the only issue that has caused errors recently for Schwab ofx updates. You can download the beta package by heading to the February 17th entry in Robert’s blog comments. It is reported that Quicken does not like this tag, so I can’t imagine why Schwab is still using the tag, as most of Schwab’s clients attaching to the OFX server are undoubtedly Quicken users.
The new scrubber should also fix transaction (-) sign issues that have been seen in Fidelity Net Benefits ofx downloads. I think this is the same issue I reported last summer from VALIC as well that would actually crash Money.
Thank you Robert!