[EDIT - Ressom provided additional input for American Express and Fidelity Net Benefits which I've also included below]
[EDIT - ameridan added settings for VALIC on 12/25/2010]
[EDIT - ameridan added settings for Capital One & CitiBusiness Card on 1/16/2011 - thanks Ken!]
[EDIT - ameridan merged previously published settings for Chase Bank, Discover Card & Schwab on 1/16/2011]
[EDIT - PHWhite provided additional input for TD Ameritrade on 1/19/2011]
[EDIT - Stephen provided additional input for ING Direct Bank on 1/20/2011]
[EDIT - ameridan merged previously published settings for PNC Bank on 1/28/2011]
[EDIT - hung le provided additional input for Sears Card on 1/29/2011]
[EDIT - ameridan added settings for OptionsXpress on 3/26/2011]
[EDIT - ameridan provided link to additional input for USAA on 4/19/2011]
[EDIT - Cal added settings for Wells Fargo Advisors on 10/6/2011]
[EDIT - Marc discovered new ofxVer setting for Capital One on 2/27/2013]
[EDIT - ameridan updated the URL for Citi credit cards on 3/15/2013]
Thank you Cal for the nice review of both my OFFLINE Blog and Bobby’s PocketSense site. I am going to quote it here as it might provide assistance setting up FIDELITY Investments, Citi Card, and Vanguard accounts. Regarding your Janus account, my experience is that without the FID number, you won’t get an error, but you won’t get data either – instead you probably get a list of your account numbers.
I think this is how Money Online established the setup link of all accounts at any financial institution you engaged Online services for. If you’ve ever turned on logging in Money, you would note that you got 4 files for each set of transactions being downloaded (if you have multiple accounts, otherwise you only get 2). The first ***RQ.txt file was the initial OFX file being sent by Microsoft Money. The first ***RS.txt file was the response from the financial institution listing all of your account numbers. Then the program proceeded to add the FID and the ACCOUNT NUMBERS for each account resulting in the second ***RQ.txt file that serves to reveal all of the OFX parameters that you need to get the PocketSense scripts to work. It’s this second ***RQ.txt file that requests the OFX downloads for all of your accounts at that institution (***RS.txt).
PHWhite also offered this tidbit regarding Ameritrade, but probably true in many other instances:
I had to call TD Ameritrade because transaction downloads for my accounts had been locked out because of my failed attempts, so even if you are using the right parameters it may not work until you call to get your accounts enabled for transaction downloads. I also needed to have TD Ameritrade reset the passwords.
OFX settings for various other financial institutions (in no particular order yet) that can be copied directly into PocketSense’s sites.dat file
<site>
SiteName : DISCOVER
AcctType : CCSTMT #credit card
fiorg : Discover Financial Services
fid : 7101
url : https://ofx.discovercard.com
bankid :
brokerid :
appid :
appver :
mininterval :
</site>
<site>
SiteName : PNC #(see note)
AcctType : BASTMT
fiorg : ISC
fid : 4501
url : https://www.oasis.cfree.com/4501.ofxgp
bankid : 041000124
brokerid :
appid :
appver :
mininterval :
</site>
<site>
SiteName : CHASE
AcctType : BASTMT
fiorg : B1
url : https://ofx.chase.com
fid : 10898
bankid : (use appropriate routing #)
brokerid :
appid :
appver :
mininterval :
</site>
<site>
SiteName : SCHWAB
AcctType : INVSTMT
fiorg : ISC
url : https://ofx.schwab.com/cgi_dev/ofx_server
fid :
bankid :
brokerid :
appid :
appver :
mininterval :
</site>
<site>
SiteName : TD AMERITRADE #(see note1 and NEW note2)
AcctType : INVSTMT
fiorg : Ameritrade
fid :
url : https://ofxs.ameritrade.com/cgi-bin/apps/OFX
bankid :
brokerid : ameritrade.com
appid :
appver :
mininterval :
</site>
<site>
SiteName : AmEx
AcctType : CCSTMT #credit card
fiorg : AMEX
fid : 3101
url : https://online.americanexpress.com/myca/ofxdl/desktop/desktopDownload.do?request_type=nl_ofxdownload
bankid :
brokerid :
appid :
appver :
mininterval:
</site>
<site>
SiteName : VALIC
AcctType : INVSTMT
fiorg : valic.com
url : https://ofx.valic.com/eftxweb/access.ofx
fid : 77019
bankid :
brokerid :
appid :
appver :
mininterval :
</site>
<site>
SiteName : CITICARD
AcctType : CCSTMT #credit card
fiorg : Citigroup
fid : 24909
url : https://www.accountonline.com/cards/svc/CitiOfxManager.do
bankid :
brokerid :
appid :
appver :
mininterval:
</site>
<site>
SiteName : CITI BUSINESS CARD
AcctType : CCSTMT #credit card
fiorg : Citigroup
fid : 26389
url : https://www.accountonline.com/cards/svc/CitiOfxManager.do
bankid :
brokerid :
appid :
appver :
mininterval:
</site>
<site>
SiteName : CAPITAL ONE #(see comment)
AcctType : BASTMT #bank accounts
fiorg : Hibernia
fid : 1001
url : https://onlinebanking.capitalone.com/ofx/process.ofx
bankid : 051405515
brokerid :
appid :
appver :
ofxVer : 103
mininterval:
</site>
<site>
SiteName : ING DIRECT BANK #(see comment)
AcctType : BASTMT
fiorg : ING DIRECT
fid : 031176110
url : https://ofx.ingdirect.com/OFX/ofx.html
bankid : 031176110
brokerid :
appid :
appver :
mininterval:
</site>
<site>
SiteName : Wells Fargo Advisors
AcctType : INVSTMT
fiorg : WF
url : https://ofxdc.wellsfargo.com/ofxbrokerage/process.ofx
fid : 12748
bankid :
brokerid : Wells Fargo Advisors
appid :
appver :
mininterval:
</site>
<site>
SiteName : FIDELITY
AcctType : INVSTMT
fiorg : fidelity.com
url : https://ofx.fidelity.com/ftgw/OFX/clients/download
fid : 7776
bankid :
brokerid : fidelity.com
appid :
appver :
mininterval:
</site>
<site>
SiteName : Janus Investments #(see comment)
AcctType : INVSTMT
fiorg :
fid :
url : https://ofx3.financialtrans.com/tf/OFXServer?tx=OFXController&cz=702110804131918&cl=50900132018
bankid :
brokerid : dstsystems.com
appid : Money
appver : 1900
mininterval:
</site>
<site>
SiteName : FIDELITY NET BENEFITS
AcctType : INVSTMT
fiorg : nbofx.fidelity.com
BrokerID : nbofx.fidelity.com
fid : 8288
url : https://nbofx.fidelity.com/netbenefits/ofx/download
appid :
appver :
minInterval: 30
</site>
<site>
SiteName : VANGUARD
AcctType : INVSTMT #investment
fiorg : Vanguard
fid :
url : https://vesnc.vanguard.com/us/OfxDirectConnectServlet
bankid :
brokerid : vanguard.com
appid :
appver :
mininterval: 30 #Vanguard doesn't like short intervals? Use 30 day window.
</site>
<site>
SiteName : SEARS CARD
AcctType : CCSTMT #credit card
fiorg : Citigroup
fid : 26810
url : https://secureofx.bankhost.com/tuxofx/cgi-bin/cgi_chip
bankid :
brokerid :
appid :
appver :
mininterval: 30
</site>
<site>
SiteName : USAA
AcctType : BASTMT #bank
fiorg : USAA
fid : 24591
url : https://service2.usaa.com/ofx/OFXServlet
bankid : 314074269
brokerid :
appid : QWIN
appver : 1900
mininterval:
</site>
<site>
SiteName : OPTIONSXPRESS
AcctType : INVSTMT
fiorg : optionxpress.com
url : https://ofx.optionsxpress.com/cgi-bin/ox.exe
fid :
bankid :
brokerid :
appid :
appver :
mininterval:
</site>
-ameridan
Regarding my addon package to PocketSense, version 1 is a simple webpage that you can access via Money’s favorite tab. The version 2 has been ready for a while based on an upcoming release of PocketSense that the author states will not only generate ofx files, but an html page that lists all of your investments with hyperlinks to the Yahoo detail webpage for those investments. My webpage addon will simply include that as a “frame” and the page itself is somewhat more visually appealing. It has changed somewhat from the example shown, but I can’t release it until Bobby completes the new version of his script, for obvious reasons. 
- Version 2 of ameridan’s OFFLINE webpage addon to Money
madbms said
I am having trouble with Fidelity Netbenifits download ofx files. These files lack ticker symbol associated with positions.
ameridan said
Have you checked the actual OFX file? One possibility…perhaps you were trying to gather the quotes via Yahoo, which use different symbols. Yahoo quotes should only be used for investments not included in your other OFX downloads.
madbms said
Thanks for prompt reply . I dont have many yohoo quotes only default ones. I will check the downloaded ofx file too.
Also I am able to download ofx files from ING Direct and Dodge and cox fund but when Money imports them , it complains that files are invalid or corrupt. I opened the file and I see the transactions in them. Is there any way I can run the validity ofthese files?
ameridan said
Madbms, I’m assuming you are using PocketSense to gather your OFX files. Sounds like you should revisit the instructions on that site and start over. You have to keep experimenting with the settings until the downloads sync with Money. For instance, the version of Quicken program that you are pretending to be and the minimum interval of days that you are requesting data for.
Not having accounts at those financial institutions, I can only report what others have reported as successful settings.
madbms said
Thanks again for your reply. I am able to download the files with transactions in them but it looks they are not complying with strict OFX format ( may be).
I am going to analyse the files with this tool tonight when I get home.
http://microsoftmoneyoffline.wordpress.com/ofx-file-analzer/
I will update you with my findings.
madbms said
I did check the ofx file format.
It was missing tag in all the download files from ING. so I manually edit the file and then imported in money.
it is consistent behavior from ING.
what value for these property should I use if I want to tell ING that I am using MONEY?
appid :
appver :
or can srubber.py do some of text editing too to put this extra tag ?
ameridan said
The Reference Pages listed in the right column should have everything you need. The page AppID & AppVER for OFX scripts @ http://microsoftmoneyoffline.wordpress.com/appid-appver/ lists all of the combinations, but I think you want Money Plus and 1700
Ouroboros said
Hi Ameridan,
Do you have any thoughts on getting the the last updated” field working? With a few changes to the pocketsense scripts, everything is pretty much as normal apart from this for me. I’d just like that as a check and balance that there wasn’t a quote import problem for a particular stock on that day.
Do you think it is a field that can be kicked with OFX? Or is it exclusively coded to only update from an MS online download?
ameridan said
Welcome Ouroboros,
[edited @ 3:00 pm as there is some confusion on my part as to the "Last Updated" field which in fact does work for me on the Account List page]
I’ve seen your name quite a bit lately at the Pocketsense and Money forums and I thank you for your efforts in attempting to uncover further possibilities and opportunities via our OFFLINE scripts. I’m very pleased that the scripts interface with Money to the extent that they do, since I’m sure Microsoft’s coders originally had a revenue-producing service in mind when all of the online updates went through MSN’s servers.
With that in mind, I personally feel that we will never get the OFFLINE scripts to mimic the MSN servers, hence we will probably never see a value for Change in the Investment Summary module, a value for Updated in the Favorite Accounts module, and we will probably not ever be able to update our stock quotes throughout the day either – the first quote obtained for the day will be the only one that Money displays, unless someone figures out a way to clear that quote to allow a subsequent update. Where I am confused however is why you state that the “Last Updated” column on the Account List page does not display a value as this does work for me using the PocketSense scripts. I show either yesterday’s or today’s date for all of my accounts (including the Dummy Account) that were updated via PocketSense. Ouroboros, do you mean the “Updated” column on the Home page?
What I can foresee however is a custom webpage that accomodates your thoughts. I’ve been waiting to see what Bobby comes up with for his next version of PocketSense. I’ve had this webpage done for months now with a framed link to a script-produced htm document (represented by the lower portion of the page with the scroll bar) that could include “Updated” and the most recent quote.
By not sending quotes directly to Money, but displaying on this webpage instead, the desired result could be obtained. A button on this page could be added that would give the user the ability to send the “end-of-day” quote to Money.
-Dan
ameridan said
Ouroboros,
After dwelling on your question some more, I have a feeling you were aiming at the “Last Updated” field in Portfolio Manager, which I forgot about as I had removed that column from my views months ago, as that field appears to be tied to Online updates only (which is your finding as well).
So, to answer your question if I am on the right track now, no I don’t think OFX will ever trigger this field.
Ouroboros said
Thanks – It’s not turning out to be a major issue as the download scripts are so reliable! And they tell you if a quote is skipped for whatever reason. A tip for others is to make sure ‘TR Week’ is enabled so you will quickly see if a Tickers price goes stale when it never changes also.
All in all, MS Money is as good as ever then. The only thing still left on my Windows VM!
Even loosing the Portfolio Mgr auto ‘Yield’ field has made me actually check this manually (I then use the memo field to record the yield and subsequently sort sort ) which is actually a positive thing as it forces you to check your holdings’ fundamentals from time to time!
Ken said
For lack of a better place to ask this question, has anyone gotten Capital One Bank OFX downloads to work? You can’t initiate the download from the Capital One site so there’s no easy way to capture what the field info looks like. I’ve tried every combination mentioned in the various OFX databases without luck. Basically here are the parameters I’m using:
SiteName : CAPITAL ONE BANK
AcctType : BASTMT #bank accounts
fiorg : Hibernia
fid : 1001
url : https://onlinebanking.capitalone.com/ofx/process.ofx
bankid : 065002030
I’ve tried various other bankid’s; this one is from the gnucash list. Any help would be appreciated. Other than this one account everything is working beautifully! Thanks and happy New Year!!!
ameridan said
Ken, I don’t have a Capital One account, but since your data matches the Moneydance list (which seems to be the most current for me http://microsoftmoneyoffline.wordpress.com/moneydance-ofx-settings/ ), my guess (looking at http://www.findroutingnumbers.com/BankNames.asp?name=Capital+One,+N.A.&lir=111131&title=Capital+One+Bank+Routing+Numbers ) is that the bankid #, which is the routing number, isn’t correct. Every state seems to have it’s own?, but rather than using the gnucash #, try other routing #s starting with the corporate headquarters state or perhaps the routing # printed on your checks.
and this was a good place to ask the question – once you zoom in on the correct settings, I’d be glad to add it to the others in this Blog.
Ken said
I had tried the various available routing numbers with no luck. I even called CapitalOne web tech support and they looked up the ABA routing number specific to my account. I just posted my question on the OFX forum to see if anyone has had success. Here is the error msg I get back:
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:4c44d09f6ee24895a96efbba990c2a66
0INFO
20110103192834.147[0:GMT]
ENG
Hibernia
1001
9a0185fe0dcd432dbac3c737dbc3e7cb
2003ERROR
The specified account could not be found.
4
I know the account number, UserID and Password are correct as these are identical to the ones I use in Money. I’m guessing the BankID isn’t the ABA routing number but I’ve run out of options having tried every BankID and routing number I can find. Maybe I’ll have success on the OFX forum. If so I’ll let you know.
Ken said
Finally figured out what the problem was with downloading my Capital One account transactions. Even though the statements say it’s a savings account turns out it’s considered a money market account. So the sites OFX data I was using was correct but when I added the account it asks what type of account it is; checking, savings, money market or a 4th choice. I had been saying savings but as soon as I changed it to money market the downloading went flawlessly. Here are the confirmed sites entries:
SiteName : CAPITAL ONE BANK
AcctType : BASTMT #bank accounts
fiorg : Hibernia
fid : 1001
url : https://onlinebanking.capitalone.com/ofx/process.ofx
bankid : 051405515
ameridan said
Thanks Ken,
I’ll fold this into the main thread to make it easier for others to find as well. Did the Bank ID turn out to be your bank’s routing #? If so, I’ll add a note to that effect.
Ken said
Yes, the bank ID was the routing number. Capital One only has 2 routing numbers (you seemed to think they had a different one for every state). The routing number above is the one for their online banking site (not sure what the other one is used for or if it’s still even any good). If this one doesn’t work you can double check it by either looking at their online FAQs or calling the customer support 800#.
Cal Learner said
SUBJECT: Scrubbing Quotes from OFX FILES
FYI, I have a working scrubber.py for Fidelity and Vanguard quotes that come in via PocketSense OFX. In each case, the quotes were recorded with the next-day time in Money. The scrubber modifies the OFX file without additional action by the user so that Money gets the price that corresponds to the actual closing prices for Yahoo. I expect to send that to Bobby, but there may provide what I have thru an alternate method. If I had certain data for other FIs, I could add a scrubber for those… testing would be limited. That information needed is
1. how does the recorded quote date in Money compare to the proper date for the closing price.
2. What are the DTASOF values in a sample OFX file, preferably recorded on Sunday for a typical worst case.
3. What are the DTPRICEASOF values — at least the first one.
4. When did PocketSense fetch the OFX file? That would ideally be a Sunday date. The closing price should then be dated Friday typically.
For Fidelity, I decremented the DTASOF fields to work around the problem. In Vanguard, I copy the first DTPRICEASOF date to any DTASOF fields. The Yahoo quotes don’t go thru the scrubber. If they did, the Vanguard method would be appropriate. I might modify quotes.py, but I think it would be better if Bobby did that.
Ken said
Cal, any chance I can get my hands on your Fidelity scrubber? It’s not a big deal for today’s price in Money to really be yesterday’s closing price but it would be a little more accurate to have prices for Monday thru Friday rather than Tuesday through Saturday (as I just realised it’s been doing).
Thanks.
ameridan said
Cal,
I believe Bobby is changing the PocketSense code to coincide with what you have in mind. The next version has been in the works a while now.
Cal Learner said
Ken, be glad to, but I have since found that my Fidelity scrub routine has problems if I don’t download during the right window. I have what looks to be a better method, but I have not coded that yet. When you do try it eventually, you will want to keep a copy of the original scrubber.py. Inspect it to see that somebody has not fiddled with it, and try to inspect. I understand that it is hard to inspect, but we have to try. I will probably post a sha1 checksum in a post that I have passworded access to. You can read about and download fciv from Microsoft in the mean time.
Dan, I don’t think Bobby is writing a Fidelity scrubber. He has planned that various people can write scrubber functions for the various FIs. I have already sent him my flawed scrubber. Let’s hope I can do better.
Cal Learner said
Ken: My scrubber.py –Kinda beta… put it at
scrubber cl00.zip
Ken said
Cal, thanks for the file. You mentioned that you have to download within a certain time window. Can you let me know what that is? If my suspicion is correct I’ll bet it has to be after today’s close and before the next day’s market open. Am I right?
I’ve asked this before but does anyone have a Capital One savings account that they’re able to use PocketSense to download transaction data? I’ve had no success.
Also, a new one: I’ve got both a Citicard credit card and a Citicard Business credit card. Although I go to the same website to view and download transaction data PocketSense is only working on the personal card. Anyone know if there are different parameters for business Citicards?
Cal Learner said
Ken: It is my experience that the quotes for a Wednesday, for example, will not be available in the Fidelity OFX files until a little after midnight ET. An hour later is midnight in my timezone. The window between may have worked better. But that may have only been with my earlier scrubber that I moved away from.
I think the newer scrubber should solve that. However I have not given it testing under a lot of conditions. I have tried to make this work for other timezones too.
The Fidelity times are marked in EDT -5 in the OFX, which corresponds to CST -5. So in the central timezone, there might be better behavior in the winter than the summer. Robert’s _scrubTime() function does a lot to help things. My scrubber assumes that _scrubTime will be run, so it does not attempt to duplicate that function.
Cal Learner said
I see I dropped my Wednesday example. For Fidelity, the Wednesday quotes should be available from the wee hours of Thursday thru the rest of Thursday ET with the scrubber I made. Any time from the wee hours of Saturday until almost midnight of the next day the market is open should get Friday’s closing price dated as Friday. That is the plan. So to reiterate, with the scrubber mod, you should not have to watch for a window. Without that, I am not sure what the time window effects are.
If you are getting Yahoo quotes, that can add some extra consideration. I made a mod to quotes.py, but I have not posted it. Robert plans on changing quotes.py. One thing to consider is to avoid downloadingYahoo quotes while the markets are open and mutual fund NAV prices have not yet been set. Once you have fed a quote on a security to Money, a later quote for that date is ignored.
Cal Learner said
Ken: I don’t know if any of these will help with your search for setting up CitiBusiness Credit Cards
:
http://ofxblog.wordpress.com/2008/10/16/ofx-fi-details-for-citibusiness-credit-cards/
https://www.citibusinesscreditcards.com
You could try setting it up in Money and look at the logs.
Ken said
Once again thanks are in order. I used your link and am now able to download my Citi Business credit card transactions. Here are the confirmed entries for sites.dat:
SiteName : CITI BUSINESS CARD
AcctType : CCSTMT #credit card
fiorg : Citigroup
fid : 26389
url : https://secureofx2.bankhost.com/citi/cgi-forte/ofx_rt?servicename=ofx_rt&pagename=ofx
And with that I now have all 18 of my Money accounts downloading flawlessly (and with 2 weeks to spare). Guess I’ll have to find a new project
ameridan said
Thanks Ken!
I edited the url as the tail end seemed to disconnect. Did I get it right? Some of this stuff would better fit in a Forum format, rather than Blog format, but I’ll fold this into the main thread to make it easier for others to find
Ken said
Yep, that’s the full, correct URL.
Hung Le said
Confirm Bank of the West OFX info:
AcctType : BASTMT
fiorg : BancWest Corp
url : https://olbp.bankofthewest.com/ofx0002/ofx_isapi.dll
fid : 5809
bankid : 121100782
I did run into a problem: I have a checking and saving account. Both have same account id: 123456. I did specify the account type: CHECKING and SAVINGS in the request. The response OFX content does appear to have the right data (one section for checking, one section for saving) but Money will import all the transactions into my checking only.
ameridan said
Hung Le,
For Savings, try Money Market instead; that has worked for others
Cheryl said
Pardon me for butting in to this, but It looks to me like Wells Fargo doesn’t support QIF or “any Microsoft® Money or Microsoft Office Accounting formats” as of 1/31/2011. Does anybody have a workaround for that?
I have this OFX setting, maybe it’s wrong?
SiteName : WF
AcctType : BASTMT
fiorg : Wells Fargo
fid : 3001
url : https://www.oasis.cfree.com/3001.ofxgp
bankid : 123006800
brokerid :
appid :
appver :
mininterval:
The bankid is the routing number. I tried leaving it blank but got an error from setup.py saying I needed it. But even with the routing number, I get an error log with this info:
[CODE]15500
ERROR
20110203051615
ENG
19700101000000
19700101000000
Wells Fargo
3001
1709e8dab3d74915b9e613dc95b31580
[CODE]15500
ERROR
4
Is my bankid wrong? Or am I out of luck with Wells Fargo?
Thanks for any help!
ameridan said
Cheryl,
According to the Moneydance resource, try changing fiorg : Wells Fargo to fiorg : ISC
Also, I’m not sure if you saw this note on the GnuCash Wiki page:
Bank of America is the same way – I find that it is much easier to simply await an email announcing that a new statement is ready (every 30 days) and download the OFX from their website instead.
Let us know the outcome.
Cheryl said
Thanks, Ameridan. I did see that comment but thought it looked like it might be old & possibly out-dated, so thought I’d give it a try anyway. If my setup is correct, then I can believe the failures are due to lack of access on WF’s end, which is good to know.
WF doesn’t offer ‘MS Money’-style output format on their download page, only Quicken & Quickbooks. Neither of which will import into MS Money, or am I missing something there, too? How do you get around that?
Thanks a million for your (apparently limitless) patience.
ameridan said
Cheryl – just select the Quicken format as it should work. QIF files import directly; for help with QFX files, see http://microsoftmoneyoffline.wordpress.com/2010/03/20/will-qfx-files-dominate-over-ofx/
And you are welcome
Ken said
Cheryl, what I found worked for Union Bank of CA is to download and save the QFX file. Then I just rename it and change the file type from QFX to OFX. By then clicking on the file (it now has a Money icon) it imports perfectly.
I will try the other alternatives and see if they work as they’re easier and require fewer steps but my existing method works perfectly.
BTW, Union Bank is very similar to Wells in that I couldn’t get PocketSense to work after trying everything (while Money was still active Union Bank charged for direct download) and they discontinued allowing downloads in OFX format effective 1/31.
Cheryl said
Thanks. I also just noticed that Money has a “Convert Quicken File” option in its File menu, so that should work, too. It’s amazing that I never noticed that before.
Such fun!
Cheryl said
Brilliant! I’ll try changing QFX to OFX. I just want my darn data
Cal Learner said
Correction on Janus Investments:
SiteName : Janus_Inv
AcctType : INVSTMT
fiorg : Janus
fid : 6115
url : https://ofx3.financialtrans.com/tf/OFXServer?tx=OFXController&cz=702110804131918&cl=50900132018
bankid :
brokerid : dstsystems.com
appid : Money
appver : 1700
mininterval :
I had to set the appid and apver to Money plus set fiorg and
fid to get the Janus Investments to work.
ameridan said
Thanks Cal,
I added that to the Janus section with a link to your comment.
JB said
I still have no luck getting into Janus even with these settings. Setup.py reports success, but MsMoney gives a “file invalid or corrupt” message. Extensive Googling yields no help. (Accounts from other mutual funds work fine).
Can you please tell what to fill in for account#, username, password? I’m using the same as I use to login to the website, with my ssn as the username.
Any other ideas?
Thanks for any help,
J
JB said
>>I still have no luck getting into Janus…
Followup to my own posting: I entered only username and pw, leaving the account# field blank. It *seems* to work now.
I knew I’d figure it out as soon as I asked for help
-J
Norm said
Anyone else have a problem, with TD Ameritrade? After March 1, 2011, I have not been able to down one of two accounts. Nothing has changed on my end. This is the OFX reply:
302 Moved Temporarily
This document you requested has moved temporarily.
It’s now at /amer/html/fatal.html.
The other account number returns a properly formatted OFX file.
Ladislaus said
Norm (et al.): I encountered the exact same issue that you described, and therefore, I called TD Ameritrade regarding OFX downloads. It appears that TD Ameritrade has disabled (’til further notice) the OFX download URL (“https://ofxs.ameritrade.com/cgi-bin/apps/OFX”).
ameridan said
Ladislaus,
I added a note pointing to your comment to the table. Meanwhile, see if someone at Moneydance has found a workaround (QFX file server?)
Norm said
Interesting comment from TA Ameritrade. I have two accounts with them, an IRA and a regular account. The IRA account returned the error message. The regular account returns a properly formated OFX file, but does not update the MS Money records or quotes.
The server is responding, at least for the regular account, but does not seem to have current account data. If we can get enough complaints, perhaps the server can be reactivated with current data. Don’t see where this is an issue to keep the existing system running.
Norm said
It’s Back! Thanks to everyone who contacted TDAmeritrade, the OFX server is now back on-line with new account information. We need to keep the pressure on financial providers to keep the OFX servers on-line. There seems to be an idea that with Money shutdown, the OFX servers are no longer needed.
ameridan said
In almost all cases, these are the same servers feeding OFX to Quicken users – though I think the files go thru Intuit and get turned into QFX files first. So as long as Quicken is around and doesn’t change their data import strategy, the OFX servers should be around for awhile (my opinion). But that doesn’t explain why TD Ameritrade brought that server down, unless there were other issues we don’t know about.
MirchiFM said
Does Capital One credit card download work.?
when i put
all I get in ofx file is _____________
I tried for 3 days .
ameridan said
You can not just change the account type for a savings account and expect that they’ll work for a credit card download. Do more research starting here: http://microsoftmoneyoffline.wordpress.com/look-up-your-ofx-settings/
This blog page was just meant to be a source for known good PocketSense settings, so when (if) you stumble on the settings for Capital One credit card, I’ll be glad to add them here.
[UPDATE] Doing a Google search for Capital One Credit Card OFX, I get the following:
so it sounds like you are in the same boat as I am with Bank of America Mastercard – you’ll just have to log in once a month to the website and download the OFX (or QFX) file to import into Money.
MirchiFM said
Thanks
MirchiFM said
Does anybody have OFX setting for DODGE AND COX FUNDS and oakmark Funds.
Oakmark started allowing transactions download from inside Quicken in Nov 2010 .while dodge and cox allows you to download qif file not ofx file.
MirchFM said
I used following entry for dodge and cox and got an OFX file . content of the file looks corrupt to me.
SiteName : DODGE_AND_COX
AcctType : INVSTMT #investment
fiorg :
fid :
url : https://ofx3.financialtrans.com/tf/OFXServer?tx=OFXController&cz=702110804131918&cl=50314030604
bankid :
brokerid : dodgeandcox.com
appid : QWIN
appver : 1900
mininterval: 30 # doesn’t like short intervals? Use 30 day window.
OFX file.
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
0INFO
SUCCESS
20110719213256.429[-5:CDT]
ENG
20110719213256.430[-5:CDT]
20110719213256.430[-5:CDT]
ameridan said
MirchFM,
Did you get Dodge & Cox working? If so, let us know and I will add the settings to the Blog above. Thanks.
Cal Learner said
Here is another tested site descriptor:
SiteName : Wells Fargo Advisors
AcctType : INVSTMT
fiorg : WF
url : https://ofxdc.wellsfargo.com/ofxbrokerage/process.ofx
fid : 12748
bankid :
brokerid : Wells Fargo Advisors
appid :
appver :
mininterval :
Ken said
Can anyone help with the correct settings for MB Financial? The only place I can find them listed is in the Quicken OFX listing but I can’t figure out how to interpret the info there. I’ve tried various combinations of FID and FIORG and URL can’t get anything to work. Any help with this is appreciated.
Thanks.
Cal Learner said
I am in the process of moving one of my computers to the newest (May 2011) PocketSense scripts. I am running a self-modified version on the other computer. In the newer software the timeOffset field is the new feature that affects me. I think it only matters when getting quotes via your broker’s OFX files. It is important to modify the DTASOF field that Money uses to assign the date for the downloaded quotes. This does not affect the dates of transactions– only stored quotes
For Fidelity, my thoughts are to use -23.5 (hours) as the offset value if the use is in timezone CDT. That adds this line to the site descriptor:
timeOffset : -23.5
I plan to test that; I have not tested it yet. I am thinking that when we get tested values from people, that line should be added to each broker descriptor here.
Note that from Fidelity, one should avoid downloads around 0:30 eastern time. Also avoid downloads on Sundays and Mondays to avoid quotes dated Saturday or Sunday.
Cal Learner said
To do downloads from Ing Direct with PocketSense, you will have
to log into the ING Direct website. Click
MyInfo->PersonalFinanceAccessCode)Create Code->CreateAccessCode.
The resulting page will remind you of your Customer Number, which
you will use as the User name in PocketSense setup. You will also
be given a new randomly generated Access Code, which you will use
as your Account password in PocketSense setup. This will be
different from the code you use to do the web access. The account
number that you give to PocketSense during setup is the number of
the ING Direct account.
You may get an error when you try to send the downloaded info to
Money. I found this was due to a missing record which must
follow the statement. I expect to make an ING Direct
scrubber if somebody is interested.
jason said
Yes I am having the same issue with ING Direct finally got it to work but getting the import error. Please make a scrubber.
Thanks!
Cal Learner said
Jason: At first I wrote a whole ING Direct scrubber function. Then I realized there was already a fix for the missing DTEND in place.
The reason the original did not work for ING Direct is they have records on separate lines.So making this change should fix the problem for ING Direct and still work for other cases.
To make the change in scrubber.py find line 144 which is
p = re.compile(r’(.+?)(?=<)’,re.IGNORECASE)
replace (or comment-out) that line and use this one:
p = re.compile(r’([^<\s]+)’, re.IGNORECASE)
The replacement line must start with 4 spaces, just as the original line does. Leading spaces matter a lot in Python.
Cal Learner said
Oops.. forgot the greater-thans get eaten… so this one should read right for the two code lines:
p = re.compile(r’(<DTSTART>.+?)(?=<)’,re.IGNORECASE)
replace (or comment-out) that line and use this one:
p = re.compile(r’(<DTSTART>[^<\s]+)’, re.IGNORECASE)
jason said
Ok thanks. I looked at scrubber.py and it is only 89 lines. And the line you wrote about is not in there. The top says Ver 1: rlc, 2010
Do I have an old version? I have not upgraded or made any changes to this in a long time as I use it every day and it always just works so why bother upgrading. Is there a new script I should install or version and if so where is it?
Thanks again,
Jason
Cal Learner said
The latest scrubber.py starts this way:
# scrubber.py
# http://sites.google.com/site/pocketsense/
# fix known issues w/ OFX downloads
# Ver 1: rlc, 2010
# 05-Aug-2010*rlc
# – Added _scrubTime() function to fix NULL time stamps so that transactions record on the correct date
# regardless of time zone.
# 28-Jan-2011*rlc
# – Added _scrubDTSTART() to fix missing fields when a exists.
# – Recoded scrub routines to use regex substitutions
It does work nicely. See
https://sites.google.com/site/pocketsense/home/msmoneyfixp1/p2
It talks about the upgrading procedure.
Note there is a separate popdown2.py that some of us start in a batch file. That pushes the button for us for each download. That is useful if you have several accounts that work with PocketSense.
ameridan said
Jason,
My bad…
I thought I had fixed Cal’s comment and I trashed his correction, but then I observed that I hadn’t fixed it after all. The restored comment is right above yours – I wish WordPress would publish what is submitted
jason said
AWESOME!
I downloaded the new scripts, placed them in (did not make any changes), tried it and now my ING direct works, and my Fidelity that stopped working a few months ago works again.
Thanks so much for your help. I’ve used money for 12 years and when they said they were shutting it down I was completely bummed till I found this way to do it. Really appreciate everyone who did work on it.
Take care
Ken said
Everything has been working so well I haven’t had a need to post in quite some time. But I’ve got accounts at 2 institutions and haven’t been able to figure out the correct parameters.
The first is HSA Bank which is owned by Webster Bank. I’m pretty sure they use the same server as their parent since they have the same FID as Webster Bank in the Intuit database and the BANKID is the routing number for Webster. I was able to decrypt a .ofx file I downloaded from them so all I’m missing is the URL for their OFX server. The decoded info is as follows:
FIORG: HSA Bank
FID: 11234
BANKID: 075907947
The second institution is ZionsDirect. They use mystreetscape and only support direct downloads into Quicken so I can’t trap the .qfx file and analyze it. Mystreetscape is Fidelity’s platform for other brokerage firms. In this case I would need all the parameters.
As always, any help is appreciated!
Ken
ameridan said
Ken,
I’ve got a Reference Page to look your OFX settings, but no one seems to use it
Try this url for HSA / Webster Bank…
https://www.websterfirst.com/onlineserv/HB/
I found these Moneydance* settings for Zions Bank (not sure if it is the same though)…
{ “id” = “md:1800″ “fi_name” = “Zions First National Bank” “fi_org” = “244-3″ “fi_id” = “4676″ “bootstrap_url” = ” https://www.oasis.cfree.com/fip/genesis/prod/04676.ofx ” “uses_fi_tag” = “y” “app_id” = “QWIN” “app_ver” = “2100″ “access_type” = “OFX” }
Another URL to try for Zions Direct: https://www.zionsbank.com/pc_banking.jsp
Ken said
I always check your reference page and go through each link meticulously before I post here. Don’t want to needlessly bother anyone and have them do work I can easily do myself. Zions Bank isn’t the same as Zions Direct. The URL for Zions Direct will definitely be some variation of myStreetscape.com.
And it’s always a nice surprise when you get a tech support rep who understands what you’re trying to do. I got hold of someone at HSA Bank and asked what the URL was for their Quicken QFX server. After explaining what I wanted to do they informed me they don’t support automatic download. So cross them off the list. I’ll just have to initiate the download from their website (and they’re nice enough to still support .ofx downloads!)