OFX download settings for Fidelity Investments, Fidelity Net Benefits, Janus, 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]

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.

Read the rest of this entry »

Comments (65)

Microsoft is cutting the cord early on Yodlee feeds

There are quite a few Money users who have paid to extend their services through January 2011 that will be upset to learn that the data feeds through a 3rd -party (namely Yodlee) will be discontinued as of October 1st.  If you get the following message when you sign up for online services with your financial institution:

* This service is provided by a third party provider, not your financial institution. It is only available if you have Microsoft Money 2005 or later. You will need to use Microsoft .NET Passport in order to access your account information.
Your financial institution may offer an alternative means of downloading statements and transactions from their web site into Microsoft Money 2004 and earlier.

then you may want to check out one of the Offline solutions covered in my blog this month!

Comments (3)

Chase Bank OFX downloads

In hopes of assisting others in the same boat as Ken, I am posting this setup data for those looking to download OFX data from Chase Bank into PocketSense.    Ken has verified that these settings work. Thanks Ken :)

Read the rest of this entry »

Comments (13)

Fidelity brokerage OFX downloads

Once your Microsoft Money program is offline (online services are no longer active),  there may be no way to import your transactions and statements (as well as the update of your quote data on all of your investments) from your Fidelity brokerage account(s)  into Money other than via using Python scripts.   Unlike the websites of many financial institutions that at least let you initiate a download of your transactions in either QIF or OFX format, it has been reported that there is no such option at Fidelity.

In hopes of assisting others in the same boat as MikeV99, I am posting this setup data for  PocketSense  hoping that someone will verify that it worksAs I learn more regarding the outcome, I will update this Blog.   Mike has verified the correct settings and I have updated the blog accordingly. Thanks Mike :)   

Read the rest of this entry »

Comments (45)

OFFLINE intro

If you agree with me that Microsoft Money is the BEST personal (and small business) financial management software package available, then you’ve come to the right place for improving Money’s OFFLINE capabilities.

  • Even though Microsoft has elected to divorce the program from the MSN Money servers as of January 31st, 2011 (which did much more than just grab statement downloads, including independent stock and fund quotes for ALL of your investments, passing through third-party web-scrapes of your data, supporting Online banking, investment news, tax and exchange rates, LiveID password authentication, etc.), they have made available a **FREE**  legal copy (the SUNSET edition) of the latest updated  OFFLINE  version of  Microsoft Money Plus Deluxe that you can download, even if you’ve never used Money before!

  • Now by installing Python and downloading Bobby’s PocketSense script package that runs on Python, you will be able to essentially mimic those Online functions that Microsoft will no longer be providing.

  • For those that only need to update quotes (no Account Statement updates) and don’t wish to install Python scripting, Hung Le had written a Java app a year ago that has been recently updated and the link in the original Blog page has been updated with this new version.

  • I have developed Ameridan’s addon package to PocketSense that allows you to run these scripts (and review your Online investment data) from within your Money program.
Make sure you check out the Look Up Your OFX Settings Blogpage with links to all of the sources of OFX settings that I am aware of.

IMPORTANT!! (Courtesy of Cal Learner)

People using LiveID (Passport) in Microsoft Money should turn that off by logging in offline.   You may have to do this to accomplish that:

Disconnect from the Internet. If using Money Plus, change the date on your computer to a date in January, such as 2011 Jan 15.   Start Money, and log in offline.    Remove your LiveID.   Do not attempt to change your LiveID.

To remove the Live ID, go to File-PasswordManager, and choose to remove your LiveID.   To remove or add a conventional password, also see File->PasswordManager.

If you get a warning that you cannot remove the LiveID, turn off Tools->Settings->ReceiveAccountUpdatesFromMsnMoneyMyAccounts if you set that, even if you leave on Live ID to work with Ultrasoft Money.

SITE NAVIGATION IMPROVEMENTS:
I’ve recently optimized the Blog widget settings to make navigating within this Blog as easy as possible. I hope you find it a little easier to find things – I pledge to continue doing my best to keep it up-to-date as a resource of helpful material for Microsoft Money users as well.

-ameridan

Comments off

Microsoft releases Sunset editions of Money Plus Deluxe and Money Plus Home & Business

Yesterday Microsoft has released the English Sunset edition of Money Plus Deluxe which is a replacement for Money Plus Standard, Deluxe, and Premium editions which shipped with digital rights management that required activation of the product.   Microsoft has also released the English Sunset edition of Money Plus Home & Business, and like the first Sunset edition, they are both essentially FREE legal copies of the latest updated OFFLINE versions of Microsoft Money Plus that you can download, even if you’ve never used Money before! Choose the latter version if you’d like to keep track of (and print) invoices as well as small business expenses.
 
Money 2007  had a couple of minor bugs that are fixed in Money Plus Deluxe and Sunset including:

  • being able to write to drives with more than 2 GB of space remaining
  • the setting for the number of scheduled backups to retain is honored
  • spinoffs are handled properly

Read the rest of this entry »

Comments (20)

Updating quotes via OFX

I’ve located a Microsoft document that some may find useful in digging into OFX further.  One complaint that we’ve all expressed (or at least read from others) is that, unlike getting Online quotes via MSN which will constantly overwrite themselves with the most recent value for that particular day, the Python scripted version only takes the first value received that day.   Only by deleting that entry (or manually changing the value) are you able to download a new value for the day.   Maybe someone can figure out if this excerpt will help get around this behavior…

Read the rest of this entry »

Comments (5)

Online updates for Bank of America customers

Bank of America (BOA) is another financial institution that requires going through a third-party (Yodlee) and signing on to Money with a Microsoft Live sign-on (which I’ve always refused to do after hearing of the many issues that some users have experienced).

Now that the OFX scripts work so well, I need to decide on opening up a free checking account at Bank of America, which I understand will then entitle me to daily access to my BOA credit card data via OFX, rather than waiting for a monthly statement download on their website.   Once I verify that I won’t be charged a monthly fee for this capability, I may just do that.  

Read the rest of this entry »

Comments (2)

Online updates for PNC Bank customers

In November and February, 2.9 million customers and 560 branches of National City were converted to PNC Bank throughout western Pennsylvania, Youngstown, central and southern Ohio, the entire state of Kentucky, southern Indiana and Florida.   Another 1.5 million customers and signs at some 420 branches, including more than 235 in Michigan, were converted last week as part of the biggest acquisition in the bank’s 157-year history.

Although National City offered online updates via Direct Connect for Microsoft Money, PNC doesn’t provide this service without going through a third-party (Yodlee) which requires a Microsoft Live sign-on, so I’m happy to report that the Python OFX scripts work great with PNC Bank to return the online update function to Microsoft Money users.

Read the rest of this entry »

Comments (8)

Webpage V2 enhancement(s) POLL

Because of all the variabilities in users OS and file property settings, I‘d like to come up with a python script that could mate with PocketSense that would actually create the webpage addin for Money.   This would compensate for those variabilities and would eliminate the need for any editing.

Read the rest of this entry »

Comments (8)

« Newer Posts · Older Posts »
Follow

Get every new post delivered to your Inbox.

Join 47 other followers