OFX download settings for Fidelity Investments, Fidelity Net Benefits, Janus, Bank of America, PNC Bank, ING Direct Bank, TD Ameritrade, USAA, Chase Bank, Schwab, Discover Card, Citi Card, CitiBusiness Card, American Express, Capital One, Sears Card, OptionsXpress, VALIC, Vanguard and Wells Fargo Advisors


[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]
[EDIT - ameridan added updated settings for Bank of America credit cards on 12/12/2013]
[EDIT - Ken added settings for Scottrade on 3/31/2014]

 

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).

If you don’t see what you are looking for below, make sure you check out the  Look Up Your OFX Settings  Blogpage with links to all of the other sources of OFX settings that I am aware of.

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 : Bank of America 
     AcctType : CCSTMT    #credit card 
     fiorg : HAN 
     fid  : 5959 
     url  : https://eftx.bankofamerica.com/eftxweb/access.ofx 
     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>
<site> 
     SiteName : SCOTTRADE 
     AcctType : INVSTMT 
     fiorg    : Scottrade 
     url      : https://ofxstl.scottsave.com 
     fid      : 777
     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.  :)

click for larger image

Version 2 of ameridan’s OFFLINE webpage addon to Money
About these ads

70 Comments »

  1. 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?

  2. 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.

  3. 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 ?

  4. 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

  5. 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?

  6. 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.

    Money webpage version 2

    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

  7. 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).

    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?

    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!

  8. 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!!!

  9. 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

      0

      INFO

      20110103192834.147[0:GMT]

      ENG

      Hibernia

      1001

      9a0185fe0dcd432dbac3c737dbc3e7cb

      2003

      ERROR

      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#.

  10. 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.

  11. 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. :)

  12. 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.

  13. 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?

  14. 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.

  15. 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.

  16. 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 :-)

  17. 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.

  18. 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.

  19. ameridan said

    Hung Le,

    For Savings, try Money Market instead; that has worked for others

  20. 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!

  21. 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:

    Note on Wells Fargo: You must enable (and pay for) OFX access to your account. If you have a PMA relationship contact your Wells banker, they may waive the OFX access fees.

    source: http://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings

    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.

  22. 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 :)

  23. 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.

  24. 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!

  25. Cheryl said

    Brilliant! I’ll try changing QFX to OFX. I just want my darn data ;)

  26. 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.

  27. 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

  28. 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.

  29. 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”).

  30. 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?)

  31. 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.

  32. 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.

  33. MirchiFM said

    Does Capital One credit card download work.?
    when i put

    SiteName : CAPITAL ONE #(see note)
    AcctType : CCSTMT #credit card
    fiorg : Hibernia
    fid : 1001
    url : https://onlinebanking.capitalone.com/ofx/process.ofx
    bankid :051405515
    brokerid :
    appid :
    appver :
    mininterval:

    all I get in ofx file is _____________
    I tried for 3 days .

  34. 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:

    I contacted the Capital One FI( Financial Institution) regarding the issue about special sign-in information, they do not offer direct online banking for credit cards for Microsoft Money or Quicken, what they have available for credit card customers is a feature that is in their website, where it allows the customer to download account information for up to 6 months.

    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

  35. 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.

  36. 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

    0
    INFO
    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.

  37. 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 :

  38. 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.

  39. 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.

  40. 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!

  41. 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

  42. 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.

  43. 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 :)

  44. 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

  45. 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

  46. 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” }

    * remember to use…

    fiorg in place of fi_org
    fid in place of fi_id
    url in place of bootstrap_url

    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!)

  47. Ken said

    In case anyone is interested I recently opened an account at Scottrade. From info at OFXHome it didn’t appear that it was working. Fortunately with a little effort I have it up and running so thought I’d share:

    SiteName : SCOTTRADE
    AcctType : INVSTMT #brokerage account
    fiorg : Scottrade
    fid : 777
    url : https://ofxstl.scottsave.com
    bankid :
    brokerid : http://www.scottrade.com
    appid :
    appver :
    mininterval:

    Hope it’s of use to others.

  48. ameridan said

    Thanks Ken, I’ve added your data and a Scottrade tag to help others.

RSS feed for comments on this post

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 106 other followers

%d bloggers like this: