There is a small piece of unfinished business in my series for replacing Microsoft Money.
After giving my requirements and looking at Quicken, Gnu Cash, and Moneydance, I came upon two OFX scripts for downloading transactions directly from the financial institutions, outside of Microsoft Money. They will also update the prices for the securities held in the investment accounts that provide transaction download.
With the Python scripts that download transactions and price quotes, I intend to use Money past its official expiration date.
Update: Since this was first published, other software developers created Pocket Sense and hle Ofx Quotes, which greatly improved upon the rudimentary script here.
You can change the language of your MSN Hotmail account by adjusting the account settings.
Depending on how you set them up in Money, ETFs can be either stocks or mutual funds. Follow the prompts with a few more clicks and you are done.
Because it simulates importing a statement from a broker, Microsoft Money will only update the prices once per day.
It’s best to run the script after the market closes.
If you run the script more than once when the market is open, only the first price update will get into Money; you will not get the closing price. I saw rates as low as 3.25% for 30-year fixed, 2.625% for 15-year fixed, with no points and low closing cost.
and writes a dummy OFX file for importing into Microsoft Money. I created a new Investment account in Money called Dummy Investment.
Being a Python newbie, I’m sure the script can be made much more elegant, but what I have now works. I ran the script, which imported a dummy statement with the current prices into the Dummy Investment account.
Because the number of shares is set to zero (thanks to suggestion from John Brinnand), the import will not add any shares to the Dummy Investment account.
It only updates the prices for your other accounts. You put the ticker symbols in two lists, one for stocks and one for mutual funds.