Before deleting all of the ofx files, the name of the existing Discover file discover I opened my money file. I changed the date back to the current date. I was able to update all of my accounts. No scripts needed. I have bank and credit card accounts. Not sure if anyone has tried this before, but it works for me. When they pull those and they will , Money will no longer have what it needs, regardless of the system date.
I have downloaded the scripts and have run them. As I do a lot of programming at work I have made some modifications to output file names and locations. Regarding the activity script … the import file from Fidelity returned my monthly statement activity.
Have you, or anyone for that matter, found how to download daily activity for just the previous day s , as MsMoney Plus DeLuxe used to download? This would be like downloading the history for the last days or something like that. Ken — The script has hard coded to download 30 days of activities. If you want to make it download for fewer days, or remember the last download date and time and resume from that point, just play with that dtstart variable.
What Money does with the imported prices is controlled by Money. The download works, shows success and my account no. What could I be missing?
I am using the ofx-ba-tfb-auto. Thank you TFB for all your hard work. I was able to get Scottrade to work. The key for me was that the brokerid is not the same as the org. I know this breaks it for other brokerages and I was hoping you might amend the script in a better way. Thank you again, this has been a real life saver! Per the Online Banking Directory, Great Job!!
I will be one of your first testers. That scubber code for Discover is exactly what I was looking for. Your setup. Rather than try to figure that out tonight, I just added a link to a blogspot.
Hopefully, that works better. Sorry about the minInterval issue, I forgot to mention that on the setup page. Please help. This happens after it prompts me to enter my password. Firstly, thank you very much for this. Has anybody gotten these to download using the scripts.
Here is the code I have entered:. We should respectfully address questions to Bobby on his Blog comments page. Steve — You will have to show us what you had in the sites section. The script can throw an error if you missed a comma, a quote, a square bracket, or a curly brace, or if you had one too many of those.
I would also suggest you use ofx-ba-tfb. I only have ofx-ba. Hi, trying to get this to work, followed the steps correctly, i think, but get an error trying to execute the b-a py:. Yeah, i followed the steps listed above, but I still get that error. Are the parameters encapsulated in brackets [ ]? So, I made a bit of progress. I installed an earlier version of Python 2. I got further, it prompted me for a password, but then returns:. I am trying to build a DTD that will normalize data. Yeah, they should be following the ofx spec, but you know how that goes.
If so, you can axe any confidential info — just make sure you give me the bank name. I guess I could have documented it better, and it does contain an ugly hack that shows my ignorance of python.. This would integrate well with that… so you might see some more OFX related code from me. By the way, guys, you do NOT need to enclose the arguments to ofx-ba. You may be interested in the modified scripts I put together too. The primary reason I headed down that path was to allow encryption of locally stored account info, including user-names and passwords, but I extended the effort a bit.
Not a smooth GUI like Money. Anyway, while trying Quicken, I noticed that I could get Oppenhiemer accounts. Does anyboy out there access Oppenheimer with the OFX downloads? Does anybody have any suggestings for getting a new license to keep Money running or some other way around this? Thanks for publishing these instructions and these scripts. I have been fretting about losing the transaction downloads and cash flow forecast for several months now.
One note regarding USAA. I have gotten this to work. Thanks again. Also, I forgot to note that I has to put two leading zeroes in front of my account number in the script to get it to work. For instance, if my account number was , I had to put in the script. This is correct. However, my example was incorrect. A correct example would be:. After a lot of trial and error, I have determined that you can also download your USAA home equity line by using the following settings:.
Account number must be preceded by leading zeroes to create a digit account number. For example, account number would be formatted as Thanks for the scripts. Optionsxpress is proving to be a problem.
I get MS Money error stating that the file to import contains invalid data or is corrupt when trying to download an OFX file using your scripts.
Download manually after logging in to OptionsExpress if it offers downloads , or just enter them by hand. Is anybody else having a problem with Chase? My batch file calls several institutions and has been working find since last October. Now it works for all institutions except for Chase. Sorry — hit enter too soon, but am also having trouble downloading directly into MS-Money from Chase site.
Did you see they changed it some time last year? Thanks again for a terrific site too. I came because of the MS-Money issue and have stayed because of the excellent general content. Instead I built Python scripts with Mechanize to emulate web browser clicks to get the ofx files from the bank website. It works really well. Has anyone else had issues with American Express credit card downloads not working? They were working for me for quite a while, but it broken within the last three months with no changes on my part.
In my script, I have the app version and ID configured with these values. Sorry to interrupt the very useful programming discussion. Just to say this is a great post, thanks for the work. I was looking for a Money replacement also. I downloaded the OFX locally and tried to import it into Quicken, but no dice. As evil as it sounds, it nevertheless seems plausible, because I could not get the OFX files to import into Quicken. Then tried Moneydance, yes it did import the OFX files but the program seems not quite there yet in terms of the functionalities that I am used to from Money.
This is great, using Money like this should now be good for another 5 years, until a new bank data format or several more win OS generations finally break everything…. OK—I fixed my American Express download problem.
I was able to get it working again by configuring the script to point at:. My Edward Jones is also failing. Without an account number, the login is successful and the account numbers are returned. But when I use one of the account numbers, the return has the My main problem is I have loads of brokerage accounts with different securities.
I want one OFX for all of them, but Money only seems to like to import per account, which is quite time consuming — even if you are reloading from one large OFX. If anyone fancies hosting a replacement to the MS online services, serving up the same data we could change our hosts files to point to the new place. Thankyou for these scripts. Last week my Scottrade accounts stopped downloading their positions. I still get the account balance and the cash balance, just no stock positions.
This happened to all 5 accounts at the same time last week. After reaching out to Scottrade tech support, the downloads mysteriously started working again. Thanks, Christian. Fortunately, I found these helpful scripts which run under Python 2. Mostly, I am just trying to update my equity prices from yahoo, using the automated script. I still cannot get the OFX file to actually update the prices as of the last trade date or any other date.
PPS — Oh, and Money is matching up the securities with the imported data, just not posting the updated prices, which cannot be seen in portfolio view or on the price history. Still trying to figure it out. Andrew — Have you tried the Money sunset edition? There is one for home and business as well. People reported the quote script works out of the box with newer versions including the Plus and the Sunset editions. It worked fine — until now. The quote script is working fine so far, but Money is so far not recognizing the date and updating the prices, even thought the OFX file is being imported.
I missed this at first as I wanted it to work to see that the quotes were always updated. So long as that is moving, I know the stocks and funds are getting updated. I have 8 accounts in my python script, 2 with Wachovia and 6 with Vanguard. If I use the test function and test individually they all work correctly and import into MS Money Sunset.
However, If I try to initiate the script it runs but nothing gets imported. Everything looks correct. Any suggestions? My problem was a misunderstanding in how to use the Sites.
I set up a separate entry for every account at an institution, instead of just the one that is needed. I rebuilt my system onto a new pc and discovered this error when I went through the procedure to install the python scrips and pocketsense. It now works correctly with two accounts at my bank and 6 accounts at my mutual fund.
This is great. You could also contact ING to see what Quicken versions they do support. Regarding the malformed ING download. If I download the data directly from their website it works fine.
In response to earlier comment: Dodge and Cox seems to work OK as of today, anyway using data from the online banking directory given in the article. The account uses a peculiar xxx,xxxxxxxx format. When I missed off the leading xxx, part, no data came back other than the signon acknowledgement. Dodge and Cox correction: The address it used came from one of the other sources above, as follows…. How complicated are the fixes posted to convert Yahoo quotes into Money? I have Yahoo set up so that its captures all of my position daily, but I have over 50 positions at the moment and the thought that I will need to manually impute prices into Money is depressing Today is the end!
I type in my password at the prompt, and then after 1 second I get an output file which contains the following:. I have been using MS Money since, well, , and I cannot face the prospect of changing to another personal finance program.
None of the ones available today seems to have the combination of familiarity, ease of use, and feature set that Money has. The one aspect where it looks like it will not work is for options quotes, because the new option quote symbols are longer than what Money allows for the symbol of an investment.
Does anyone else have a similar experience, i. Could it be thatMicrosoft has reconsidered pulling the plug on the price quotes service, or more likely, perhaps it is an oversight and they will disappear soon enough! Having used several disappointing personal finance software over years, and considering all the time and money it needs to maintain them ….
Most financial institutions which offer quicken support, also offer download of transactions in spreadsheet formats. A feature to auto assign categories can be implemented as well.
You can use any Spreadsheet app like Excel, OpenOffice etc, which you use anyway. Are there any workarounds? Ann — Wells Fargo sent a letter to customers some time ago saying they would stop supporting Money downloads. Chase did too. I feed them to the script below successfully. X for example. I hope someone can help me.
In preparation for losing online services I set up Python scripts and tested them several months ago and I was able to import all of my accounts. Now when I try to import into Money I get an import dialog box for each account as expected, After the last account is imported my Money program just stops working and a windows dialog box pops up saying that there was a problem and the program stopped working.
Then I am dead in the water. When I close out of Money and then reopen it the program stops working with the same message that the program has stopped working. If I uninstall and reinstall Money there are no problems. But every time I import after running the Python scripts after the last import the same problem — Money stops working. This has to be a problem with my computer or else other people would have this problem.
So does anyone have any idea why after importing my last account Money stops working? I am using the Pocket Sense scripts but I do not see a recent discussion area there. Barry — I had this happen to me once. It was caused by bad data downloaded from Vanguard during a weekend. The solution was deleting temp files, as described in Method 5 in this Microsoft knowledge base article. After I deleted the temp files. Money launched OK. I then removed Vanguard accounts from the list of accounts I download.
You will have to find out which financial institution is giving you bad data and remove it. Otherwise you will have this happen again when it gives you bad data again. TFB Thanks for the quick response. I will look into it. Vanguard is one of my accounts so I will start with that. If it is bad data from an account then do I have to permanently remove that account from the script and update manually of is this just a temporary problem that will resolve itself?
TFB — I deleted the temp files and now Money starts so thank you for your help. I have not verified it yet but Vanguard is the last account on my import list so I suspect that is the problem account. Still looking for answers on whether I need to permanently remove Vanguard or if it is just a one time issue for the bad data that may have been sent. Also if there was bad data why does it affect Money with the Python script but not when I use Money itself to download. Maybe they only have this problem during some weekends when they do maintenance.
Maybe Microsoft has additional validation checks and massages the data if it sees problems. Hope that will help with some of these bad data problems. TFB thanks for taking the time to reply. Now that I know I can just delete those temp files if it happens again I will wait a few days before trying to download any Vanguard data.
Note : You don't need to do any of the Python setup in the article , only the Dummy account setup. This VBA program is an alternative to the Python scripts and utilizes Morningstar Portfolio data as the security price source.
Create a Google Sheet formatted similar to this sample sheet. Add tutorial Code. Note: The script's onOpen function will run every time the Google Sheet is opened. If your Google Sheet with the security data is already open, close it and re-open it to add the Util menu option. Skip to content. Star 1. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question.
Asked 11 years, 4 months ago. Active 5 years, 10 months ago. Viewed 8k times. Improve this question. Swapnadip Swapnadip 91 1 1 silver badge 4 4 bronze badges. Add a comment. Active Oldest Votes. Program layout. Located to the left of the screen, this contains all the shortcuts to loading the different brokerage CSV files. The Generic script will load CSV files with a layout described later in this text. The three buttons to left of the command strip perform the following actions described from left to right.
Download Scripts — This button starts the interface to download additional scripts. Setting s — Use this button to access the brokerage Account settings and the Stock definitions. The Show Advanced button. This controls the view-ability of three extra columns in the grid. The data has been set to default values, however, should you wish to change those values, you can do so.
A description of the contents here these columns can be found later in the this text. As the name suggests, this section of the screen handles the registration and licensing.
During the 30 Day trial, the program will display advertorial material, and for those running the program on a small screen, limit the size of viewable space. On purchasing a license to the program before or after the 30 Day trial period expires , you will utilize the same screen to validate to License key. Please ensure you select the option to validate if you are still covered by the trial period. Loading the Brokerage CSV file. Select the required script from the Broker Script Stack.
You are then presented with a Open file dialog box which you should utilize to browse to the file that you want to load.
0コメント