Having seen how GnuCash and Moneydance can download transactions directly from the financial institutions, I wondered if there is a way to use an alternative application for downloading. I can then import the downloaded files into Microsoft Money.
With some trial and error, I figured out how to use them on Windows. I provide enough details to make it work even if you are not that technical. Skip if you are not interested. Download and install Python. I used the latest ActivePython 2. I think the 2. Download the Python scripts : ofx-ba-tfb. Just save them in a folder.
Open it in a text editor. You will see something like this:. These are the address and IDs used in downloading from the sample financial institutions. You will need the address and IDs for the financial institutions you use. Look for OFX settings. There is another searchable list at a web site OFX Home. If the companies you use are not listed there, you will have to find them yourself in some other way. Update Python script. Open the Python script again in a text editor. Replace the sample settings in the scripts with the settings for the companies you use.
Give each entry a short name. Fill in fiorg, fid, and url. Add bank settings to the script. You will also need the routing number for your bank. Run Python scripts. For credit cards and brokerage accounts, type. The script will download a [site][yyyymmdd]. Open Microsoft Money. Double click on the downloaded. The Microsoft Money Import Handler mnyimprt.
With more modifications, I made the script:. You can download my automated script. To use the automated script, insert your online password between your login and your account number.
For credit card or brokerage account:. To download one account after another, a batch file calls the automated script for each account. Because you have to put your logins, passwords, and account numbers into the batch file, I suggest you put the scripts and the batch file on a portable USB drive.
Plug the USB drive into your computer only when you import. Unplug when you are done. I placed a shortcut to the batch file on my desktop. Now I have my own one-step update. The files generated by these scripts only work with Microsoft Money. Attempting to import the same file into an older version of Quicken gave me this error:. These transaction download scripts only update the prices of securities held at the institutions that provide direct OFX downloads.
If you are paying an advisor a percentage of your assets, you are paying x too much. Learn how to find an independent advisor, pay for advice, and only the advice.
Find Advice-Only. Not directly. The brokerage statement includes the positions and the current prices. If you have positions elsewhere, those prices are not updated. However, it is conceivable to create a dummy brokerage account in Money, construct a fake OFX statement with prices from Yahoo!
In your Money reports, you just exclude that dummy account. I will leave that exercise to the future or a more capable developer. Is that about right? The scripts are a nice idea for sticking with Money, but it seens like once money is dead, the OFX download format will soon be after it, and I can see most financial institutions might stop offering it. Maybe I will write a summary post after I get the stock quotes working and after I take a look at Quicken We will just have to see.
The scripts just piggy back on Quicken. To test if import works for MS Money, try pulling the network cable after downloading the files, then do the import. If MS Money needs to phone home, like Quicken does, you should get an error during the import. J — Yep, tested. After downloading the transactions, I turned off WiFi on my laptop. Money imported the files successfully.
Your posts absolutely made my day. Probably my week too, which otherwise would have been spent buying Quicken and converting heaps of data into it. If you have multiple accounts at the same bank, using the BAT file below requires a few small changes to the Python in order to make the filename on each OFX unique, thus to prevent overwrite.
Something like client. REM Prompt for password. If Money REM is running, it will be imported automatically. If not, Money will process REM the import the next time it starts. I am evaluating two options at the moment. My first option is to use Yodlee to handle all the downloading. It is an easier way to do the same thing you are doing with the scrips.
Yodlee downloads and aggregates all my transactions from banks and investment institutions and some other vendors too. Then I export from Yodlee and import to GnuCash. I decided that in addition to moving away from MS Money, I wanted to move away from all Microsoft products, so my goals are a bit different, although my requirementes are very similar to yours. TFB: Again I appreciate your pulling this information together. I have the following suggestions to help clarify the use of the various scripts you provide in your article:.
Using the ofx-ba. The modified script appears to only allow for credit card and financial institution downloads, excluding bank statements. The ofx. DK — Thank you for the notes. I will do the same modification and update the post later.
I found out that MS Money will run in Ubuntu 9. All my online banking works. My investment account transactions are downloaded too. I think these older versions of Money e. DK — I found out that the ofx-ba. I re-did my modified scripts based on ofx-ba. I updated the post and links. I hope everything is clear now. TFB — Thanks for this valuable scripts.
I have received an excel doc with two columns, one for the date and the other for th price. I wold like to import this data into MS Money, so that I can make some index comparison, etc. Thanks in advance. I have had no problem using your quotes. I am quite happy to just update the prices on a daily basis after the market closes but I did see that someone would like to update the prices though out the day.
The only way I have found how to do this is: — 1. Do the first update of the day as usual. Not an ideal solution but it seems to work and could come in handy if you update before all the closing mutual fund prices are in and have to do a second update.
John — Thanks for the tip on making the number of unit zero. I never thought of that. Let me try it. If it works well, I will update the script. TFB, I have modified the quotes. It works basically like your script. I like this new option as it lets me download prices for days on which I missed downloading prices with the quotes script. When attempting to execute your auto script though either at the command line or with the batch file I get the following error.
Any thoughts as to the cause? I am using the 32 bit version instead now and the scripts run fine. Thanks so much TFB for this fine site and solution. Can this be set up to just get quotes into MOney without contacting a financial institution. I just want to update stock prices. I had to use Python 2.
Now that I have used the cd command to change directories to the python26 folder, I am getting a different message. I got it to work now. Thanks for giving me this fun experience of feeling like I am back in college in my beginning computer science class.
Clearly I learned a LOT. Has anyone successfully tried to download account information from an entity that uses Yodlee? I get a long string of problems relating to sending with a final soctet. I have two a bank account and a couple of credit cards athat have Yodlee as the Org and use the same provider url. When I use ofx. When Money imports it, I have to match every symbol to one in my account they all seem to be the same anyways and OK it.
Then it shows all my share counts as 0. It also appears to be from and not showing any activity newer than that. I admit that I was having problems with getting it to work with JP Morgan Retirement Services—the server kept returning error codes something about invalid date in the request.
I tracked it down by comparing what Money was sending in its request. Thanks so much for the great work.
I have one more challenge for you though. In addition to a userid and password, my bank also during successive logins rotates through several other predefined qualifying questions i. Money does support this feature. Any idea on how to replicate this feature in your scripts. It only calls five programs, the first two the originating python program and the last three to httplib.
Traceback most recent call last httplib. Can I get some insight to fixing the following error? I am getting the same error as referenced in message I am trying to access a bank which has Yodlee as designation. Does anyone know the source of this problem — I get urlopen error no connection could be made because target machine actively refused it.
Any help will be appreciated. Yodlee charges Microsoft for its service. It will not let you just connect to it. If the bank itself does not provide a web download, the best workaround is perhaps using Yodlee MoneyCenter. The ofx-ba-tfb-auto. I tried a single python script for checking. Is there something else I need to change? Does any body know any way to get more than 30 days of historical data? I changed default to 8 in my bat file. Change to number of days you need.
The bank id for Chase savings apparently was incorrect. It should have been Although I live in Indiana, and my checks use , the routing number needed was that for Kentucky! Using this, the download worked. I just purchased a new computer and installed MM which does not require activation on it. I imported my data from my old computer using a. Previously, previously downloaded transactions were ignored.
I used a backup file to get the online settings restored. Thanks so much to all the comments and help being offered at this site.
It has been a life saver for me. I have to say thank you, thank you, thank you for putting this information out on the net.
I saw this script update info months ago but having little knowledge about scripts and batch files it seemed way too complicated for me. Since Fidelity and Vanguard are major holdings of mine I decided that since you had a working script that I would finally give this a try. It probably took me much longer than it should but I finally got downloads working for Fidelity, Vanguard, and security price updates. I still have other accounts that I will probably update manually but since I do my bill paying with Fidelity SmartCash that is the account that I really had to have updated automatically instead of manually.
So screw you Microsoft, instead of getting cash from me every 2 yearsto renew my software like before now you get nothing and I still have a useful Money product. So thanks again to the original poster and for all the comments that followed. I am still using MS money deluxe version and I am able to download my credit card and bank transactions as well as stock quotes.
Here is the trick 1. Set the computer time back to some time in year or any time before the online update expiration date. Run MS money, and open you file. Change the computer clock back to current. Update your online account, new transactions and latest stock quotes will show up.
Excellent information! I found your post while looking for options to move data from Money Plus. As for the scripts, they are fairly straight-forward, but being a programmer of sorts, I quickly started modifying a few things.
I now have a question regarding OFX messages. Parsing and aggregating multiple ofx files would be easy, but is there an official OFX format for this that Money will accept?
Having said that, I think my requirement is not as demanding as yours. I simply want to update my fund closing prices. So, I created a portfolio with the intention of manually updating the prices this is before I discovered your site. I thought, Hey this is great, can Money import it? Apparently it can and does. At least when I tried it, something was imported as I got a success message.
Can someone help? I will release a small application with a graphical user interface for updating the prices shortly. Stay tuned. What data is a person downloading? It looks like you can enter buys and sells on Google Finance and then download those buys and sells to OFX. Is there any down side to changing the system date as suggested by Actigraph?. I tried it and it works. I like this idea better than running the scrips because I have some investments that I have not yet set up to update using the script.
Are you aware of a solution with Schwab brokerage? You said that in your last Python script, you managed to launch Money import Handler automatically to download your ofx file into money. Could you give me this part of code? Dennis — In the automated transaction download script , this line starts the Money import handler:. Thanks for the reply. It sounds like the Direct Connect that Schwab uses is a two-way conversation to generate the ofx, rather than a simple download.
I get no errors, but no transactions either. After downloading my Schwab statements, Money wants to change all of my positions to a quantity of 0. I wonder what values Scott is using for appid and appver. Would appreciate it if anyone can provide the script to download prices for a specific date. This would be handy for getting month-end prices after the fact.
All of my position information seems to be getting recorded properly as well. Are you at least getting the transactions through? I also made some changes to the date functionality see comment 31 for details to make the script work with another service provider.
I could have sworn that Schwab was working before I implemented those, but I suppose you could try implementing them too. John Brinnand — Reader DK sent me histquot. I have not had the chance to test it. Is it your understanding that online services have to be turned off in Money in order for these scripts to work? My quotes.
Now I know which one you referred to. C, post 70 Refer to prior post If you remove online update status and MSMoney expires, you must restore your money file from a backup when the accounts had update status to reinstate update status.
Money is smart enough to know which transactions have been already downloaded and which ones are new. For this script to show anything in Money, there have to be new transactions not yet downloaded. Just stop using it for a few days or at least check off the box in the list of accounts to be updated for the account you are testing. I remembered reading 49, but was curious whether the scripts and online updates could be run simultaneously, which as you point out now — yes they can.
After running the scripts several times this morning for both Discover and Schwab, with no transactions or positions ending up in the ofx files this morning, I did the Money online update and got 7 Discover transactions and 5 Schwab transactions. So there were transactions in the que. I ran the scripts several times this morning for both Schwab Brokerage and Discover CC and got no transactions in either ofx file.
Then when I ran the Money online update I received several transactions from both, so I know they were in the que. Earlier, you mentioned that you received only account numbers in your downloaded transaction file. Is that still the case? This is what happens for me if I call the script using only my Schwab account credentials and not an account number—this asks Schwab to just list your accounts and nothing else.
If I provide the account number on the command line when executing the script, it should download the actual account content an transactions for the account. That did the trick — so you get an ofx file for each account. I looked in the ofx file and Wala, the transactions were there AND the positions. TFB — If this was pointed out, I missed it, but to help others, I think it should be pointed out that if you have multiple accounts at a brokerage, you need to run the script for each account.
C, I have no trouble with Discover Card. Have you edited the ofx file to see if it has any comments or error codes? Post 78 matches my memory. Login for Discover is usually the account plus password, but you still have to include an account in the account field last parameter input to the script call I believe.
I take password from the download. OK, thanks everyone. I sure was wrong!! I sure feel stupid! All is well now — all of the scripts work great. The python scripts will keep Money going for quite awhile. If I fix the duplicates, and then re-download the transactions soon after, all is well.
If I come back and do the same a few days later, it re-enters a bunch of duplicate transactions again… not all of them, but a lot. I got 49 Discover transactions today in my ofx file that were all repeats. I right clicked each one and selected delete rather than accepting them to delete later.
Quick Batch File Compiler convert your batch files into actual program. EXE format in one click. Content of your batch file will be encrypted and protected from changes.
If you reconcile your accounts periodically, the amounts should match, or at least be pretty close, depending on whether you have future transactions recorded etc. I saw that the correct bank balance was there, but it may have already been correct. It seems that you are correct regarding a slight difference in the downloaded transactions vs. A sample of a downloaded transaction…. Not really a problem except as you stated they have to be manually matched if running both updates in parallel. It also makes an OFX file easier to read.
I see the balance in the ofx files for all statements I download. Please update your browser. Close this message. Credit Cards. Checking Accounts. Savings Accounts. Home Equity. Invest with a J. Morgan Advisor. Online Investing with J. Chase for Business. Commercial Banking. See all. Read the Microsoft license terms and click on the I Accept button to continue. Step 5. Wait for the installation to complete. Once done, you should see a message saying that Installation is complete , and click on Finish to confirm it.
Step 6. After you installed the Windows 10 Microsoft Money software successfully, you can double click the Microsoft Money Plus shortcut and start using the tool. A lot of layers want to add Windows Store games to Steam. How to add non-Steam games to Steam?
0コメント