Monday, January 14, 2013

New Money Scripts Available (Updated: 14-Jul-2013)

The Money scripts were updated in Aug/Sept of 2012, in response to various requests over the previous year.  The beta version has now been in use for a few months, and seems to be working fine, so it’s time to update the “release” version.  There were a few minor updates since the last beta was posted, so if you're using that one, you should probably grab this update.

Change Summary
  • Added support for OFX 103.  Site entries allow a new parameter named ofxVer, and can have a value of 102 or 103 (Default=102).  A ClientUID value is automatically created, as required by OFX  103, and saved to sites.dat for use during subsequent connections.
  • Added a new sites.dat option named PromptInterval (Default=No).  If defined as "Yes", the user is prompted for the download interval (days), rather than using the global "default" and "site minimum" values defined in sites.dat.
  • Added a new sites.dat option named CombineOFX (Default=No). If defined as "Yes", OFX statements are combined prior to sending to Money, resulting in a single “accept” for all statements inside Money.  It is highly recommended that this option not be enabled until *after* testing/verifying account settings one at a time.
  • Added a new sites.dat option named quietScrub (Default=No).  If defined as “Yes”, statement scrubber messages are suppressed during download.
  • Performed minor maintenance and bug fixes, as needed.
The latest version can be downloaded from PocketSense: Install & Setup.  Refer to the sites.template file for information on the new parameters, and how they're used in your sites.dat file.

Thanks to everyone for the suggestions and support!
- Robert

192 comments:

  1. Great job Robert! The CombineOFX option is the ultimate addition as it simulates the way Money used to behave after hitting the GO button.

    -ameridan

    ReplyDelete
    Replies
    1. Glad it's working well for you Dan!

      Delete
  2. This comment has been removed by the author.

    ReplyDelete
  3. A couple of days ago I started getting these errors on attempts to download transactions from Oregon Community Credit Union (fid : 1001 & bankid : 323274461) checking accounts:

    Error in OFX message.
    ** Review .\xfr\filename.ofx for possible clues…

    I looked at the OFX files and did not see any obvious problems. I noticed that there was a new version of the PocketSense scripts so I implemented those and tried ofxVer : 103 in case there was an Oregon Community Credit Union OFX version change. That did not help.

    Transaction downloads from other financial institutions still work, and transaction downloads from Oregon Community Credit Union savings accounts also work. I have changed nothing, so I am suspecting that something has changed in the Oregon Community Credit Union OFX files for checking accounts, but I don’t know what.

    ReplyDelete
  4. Regarding my OFX error messages, I looked through the Python scripts and believe the error messages are being produced by the ofx.py script, but I was unable figure out the condition that is triggering the error messages.

    Then I decided to see what would happen if I imported the OFX files directly into Microsoft Money, and the imports appeared to work with no obvious problems. It seems that the PocketSense scripts may be treating something in the OFX files as an error that is actually not a problem.

    Next I tried setting the download interval to 1 day to see what would happen, and I still get the same error message.

    After that I looked for older OFX files in my backups from before I started getting the error messages. I found some and then used the Microsoft Word compare function to see if there were any significant differences between the new OFX files and the old OFX files. I compared old OFX files to both old and new OFX files, and I still cannot figure out what might be causing the error messages.

    I think I need some help with this.

    ReplyDelete
    Replies
    1. Hmmm... not sure what may be happening, but the best way to debug is for me to get a "cleaned" copy of the file. By cleaned, I simply mean that you would need to edit the file and change accounts, amounts, etc. to placeholder text. You can send an example to pocketsense1 /at/ gmail /dot/ com, and I'll take a look.

      Delete
    2. Release snapshot updated to address this issue.

      Delete
  5. Hello Robert. Thanks very much for your kindness. If you have time could you make it able to get quote data from Bloomberg and Reuters pls. It has quote of country that I resides in.

    -BK

    ReplyDelete
    Replies
    1. You're welcome. I don't currently have plans to implement parsers for alternate quote providers. I'd be interested if a site offers a free quote API, but parsing html "screen displays" can be a constant chore to keep up with.

      Delete
  6. I've been using these scripts for a very long time now and they are absolutely awesome! I just added a new Fidelity Netbenefits account to my portfolio and I'm having some troubles getting it to work correctly. Despite the fact that there are BUY transactions in the OFX download, Money doesn't try to match them or add them to my account. The only thing I see is overall account shares owned and total value.

    I've tried importing both the combined ofx and the individual netbenefit ofx file with no success. I've also tried this on a brand new Money.mny file with the same result. I'm confused why the transaction data that is clearly in the ofx download doesn't get processed.

    Please help!

    -Blake

    ReplyDelete
    Replies
    1. I think that this issue has been reported once before, but I didn't have time (or enough info) to accurately debug it. If you look in the OFX file, I suspect that your transaction Total fields are being reported as positive values. If so, that may be a problem, since the "total amount" recorded for a credit transaction against an investment account should be negative. Please verify. It may be easier to debug if you communicate w/ me directly at pocketsense1 /at/ gmail /dot/ com.

      Delete
    2. Hi Robert. I think it was me who reported this problem in the past. I was never able to get Money to download transactions from my NetBenefits 401K account , so I figured that there was a problem with Fidelity and never pursued a solution with Pocketsense. When I look at the OFX file I get back, there appeats to be no data in it at all, other than an acknowlegment that 'logi' was successful. So it looks like Blake has gotten somewaht farther than I ever could!

      Delete
  7. Hello Robert and thanks for all your work with these scripts, I have been using them for a long time now and they work great. However, as of today I am having problems with downloads from my Schwab Bank account - worked fine yesterday, today it fails with and error message saying the imported file contains "corrupted data". I wonder if anyone else may have hit a similar problem.

    ReplyDelete
    Replies
    1. I got the same thing yesterday. I figured some Quicken users would probably let them know - sure enough today all was well again.

      Delete
    2. Thanks. They must have fixed it after 9am. ET. as it was still broken then. I checked again now and everything is good.

      Delete
  8. Robert, The Schwab download misbehaved again today and again they added a tag (correctaction) that when scrubbed is OK. Is it possible to write a little scrub routine for this?

    Here's an example of what I'm seeing...



    DEBIT

    20130205120000

    20130205120000

    -70.36

    xxxxxxxxxxxxxxxxx

    REPLACE

    AT&T

    AT&T

    ReplyDelete
    Replies
    1. Hi Dan: You may want to send an email, since the comments filter on this site removes tags, etc. I have a scrub routine ready to test for the netbenefits issue, but have been holding off putting it out there, thinking that I may enhance it to cover a few more (related) ofx rules.

      Delete
    2. Hi Robert,

      My Schwab Brokeage download broke down recently when I changed my login ID. While searching for a solution, I was pleasantly surprised that your site is still active. I've been using your scripts since the beginning and am grateful to all of your collective efforts to allow us to continue using Microsoft Money.

      I'm not sure if the problem with Schwab Bank (mentioned by others) is the same as the one with Schwab Brokerage. I do get the same message about the file "appears to be invalid or contains corrupted data". I'm hoping that a solution can be found.

      Thanks,
      Tim

      Delete
    3. Tim: Are you using the latest version?

      Delete
    4. I was using the prior version when Schwab download failed. I've updated to the new version but still the same problem. I haven't updated my sites.dat file with the new format though. Would that make a difference?

      Delete
    5. I'm not sure. The best option is to send me a sanitized version of the OFX file returned by the server. Send to pocketsense1 /at/ gmail /dot/ com.

      Delete
  9. I have been using the May 2011 version to just download stock quotes (no statements needed) without problem. I updated to your Jan. 2013 version and Getdata would not allow me to proceed because I have not set up an account. I re-installed the old version but no stock quotes for me. What can I do?

    ReplyDelete
    Replies
    1. Al: Run setup.py and verify that Quotes are enabled. Check your sites.dat file and verify your ticker entries.

      Delete
    2. Thank you for the reply. I tracked the problem down to the Python interpreter. Somehow, Setup.py does not update the "flag" for Quote (option 6). After un-installing Python and re-installing it, everything works fine. Thank you for you fine effort.

      Delete
  10. Hi Robert - starting anew, first time with the scripts, very careful with your great instructions. Got everything configured with Chase & Amex. Goes through the motions, get no error messages but it connects with the 2 sites waaaaay too fast and hence no transactions are imported. Quotes seem to import OK. Script & testing tells me everything is OK. What do you think? Installed the sunset version and deleted all online connections OK from within the Sunset version since I deleted the original program a while ago and only have the data file.

    Thanks for this great project, I just can't stand Quicken and will give up the Bill Payment gladly just to have MS Money back! Mark

    ReplyDelete
    Replies
    1. Mark: I'm not sure what the 'way too fast' means, but test each account using Setup.py, which should provide some more useful feedback.

      Delete
    2. Hi, meaning that it completes its retrieval of data from the banks in milliseconds, tells me it was successful, triggers the import function within MSM but returns nothing to review. I did test each account one by one and all behave like this. Made sure it is retrieving a larger date range with available transactions. Have one account each from 3 separate OFX providers as a test. It goes through the motions OK but there is no way its logging in & retrieving that fast. Any idea why? Thanks

      Delete
    3. Look in each ofx file in the .\xfr directory and verify that data is being returned.

      Delete
  11. So I did some more research and compared an old OFX statement that worked with a new one that didn't. I noticed the Date formats were not consistent so I edited those, but that didn't solve the problem.

    Old Statement:
    20120107120000
    20120107120000
    20111210120000
    20120106120000
    20111222120000

    New Statement:
    20130216130729
    20130216
    20130119
    20130215120000
    20130211120000

    ReplyDelete
    Replies
    1. Note that the scripts adjust time values into a standard format, and adjust to 12 noon when needed.

      Delete
  12. A new beta version is available for testing. The update contains new scrub routines for transaction sign issues (noticed on Fidelity netbenefits), and CORRECTACTION/CORRECTFITID tags (not supported by Money).

    Download: https://sites.google.com/site/pocketsense/ofxpy_pocketsense_beta.zip

    ReplyDelete
    Replies
    1. Works great! Now Schwab download works. Thanks again for all your hard work!!

      Delete
  13. Thank you. Thank you. Thank you.

    Been using your scripts since Money died. They have functioned flawlessly! And your support has been the best. Yesterday Schwab downloads didn't work :-( Didn't have time to chase yesterday but did today. Upgraded to latest version, Schwab still no go. Tried the beta version just now and everything mo' bettah.

    You are a life-saver.

    ReplyDelete
  14. Thanks so much Robert for fixing the Fidelity Netbenefits issues!

    -Blake

    ReplyDelete
    Replies
    1. Fidelity Netbenefits works great now! The only issue that I noticed is that Money does not recognize a DIVIDEND transaction in the OFX.

      Nice work!

      Dave

      Delete
    2. Are you saying that your statement has a transaction type of 'DIVIDEND'? The TRNTYPE value should be 'DIV' for dividends, so I'm curious about this...

      Delete
    3. Looks like it is:

      I cut this out of the ofx:
      20130228OMBS02120130228070000.000[-5:EST]DIVIDEND;PIM REAL RETURN INST OMBS;as of 02/28/2013OMBSCUSIPDIV20.14OTHER1.64912.21

      Thanks!

      Dave

      Delete
    4. I can't tell from the above. It *looks* like the word 'dividend' is in a comment. Actual dividend transactions begin w/ a <DIV> tag.

      Delete
    5. It appears that the tag is called <INCOMETYPE>DIV
      Indeed, there is also a memo tag for DIVIDEND
      Dave

      Delete
    6. I would need to see an aggregate statement to make sense of it. Money supports most credit/debit transactions, so maybe something is wrong, or the scrubber is mis-handling something? Feel free to send a sanitized copy of an OFX file that has this problem to pocketsense1 /at/ gmail /dot/ com, and I'll see if something pops out.

      Delete
  15. Robert,

    I'm trying to have quotes working with Yahoo Canada and I'm having problems with 2 funds. In my Yahoo portfolio, everything is working.

    Here's the message I have :
    **FRIQUEEQUITY.TO : invalid quote response from Yahoo! Finance Skipping
    **FRIQUEBALANC.TO : invalid quote response from Yahoo! Finance Skipping
    FRIQUEAMR.TO 7.88 2/28/2013 3:00pm

    So FRIQUEAMR.TO is working fine but the 2 others are not. Could the funds'names be too long somewhere ?

    Also, I cannot find Dynamic fund (DYN041G) in Yahoo. Is there other options to find some funds ?

    Thanks in advance J Guy




    ReplyDelete
    Replies
    1. Those tickers aren't supported by the Yahoo quotes API. You can try the "screen scrape" option in the scripts by setting this option in sites.dat:

      EnableYahooScrape: Yes

      Delete
  16. A question about the Jan 2013 update. I downloaded the files and pasted them over the existing files. I renamed my sites.dat file and ran setup.py. This created a new sites.dat file but it has the same structure as the old sites.dat file. The new options from the template.dat file are missing. Did I do something wrong? Do I need to manually add these options to sites.dat?

    BTW, your work and support of these scripts is greatly appreciated.

    ReplyDelete
    Replies
    1. There is also a sites.bak file, which is read if sites.dat is missing. There is no reason to create a new sites.dat file though. You can add any option from sites.template that you want to use. Every option has a default value, and is only "over-ridden" if it is defined in sites.dat w/ a value different than the default.

      Delete
    2. Thanks for your response. I am not a programmer but I like to understand at a high level how the program works. I didn't realize that setup.py would use sites.bak if I only renamed sites.dat. I did a test and it does, indeed, use sties.template if sites.bak is also renamed. In any event, I opened sites.template, pasted in my existing site information, and saved it as sites.dat. Once I downloaded the beta version (I have a Schwab account) all is working fine.

      Two other questions:
      - How does sites.bak get updated after I manually edit sites.dat?
      - In which file is the account information stored?

      Delete
    3. - sites.dat is backed up every time you run setup.py
      - account data and general settings are stored in ofx_config.cfg

      Delete
  17. Release snapshot updated: 03-Mar-2013

    ReplyDelete
  18. Robert or Cal,

    Not sure if the screen scrape of quotes is working or not. I tried to use it with ^dji, but it failed. I have not tested this in quite a while, but I like to keep my options open.

    I use a different approach of screen scrape in my own software that downloads quotes and it does not choke on ^dji, but it has it's own peculiarities.

    If it does work, I will look into what it is I am doing wrong, and if it doesn't let me know and I will see if I can include my version in quotes.py

    Ray

    ReplyDelete
    Replies
    1. Ray: I'm not using the scrape function, so I'm not sure. Is it just the ^dji quote, or are others being missed?

      Delete
    2. Robert: The only one I have that hits the scrape function is ^dji. I could try others if I knew what they are.

      I am just going to keep testing what I have for now. I found an easy way to incorporate it with the other changes I make to your software so I'll just run it like this for now. Since nobody else seems to have a problem I'll let it go for now.

      Ray

      Delete
  19. Good Morning. Are any other users having problems with Citi Credit cards?

    Since March 6th. or 7th. my downloads have been failing with:-

    "ForteCGI Request Failure
    The Forteacute service you requested is busy or not available"

    I had a look in the OFX Home Directory for Citi CreditCards and it appears that there has been no successful validation of their OFX site since 3/6. I tried calling Citi but it was impossible to find anyone who knew what I was asking!

    Thanks

    ReplyDelete
    Replies
    1. I've been getting exactly the same thing. I got a canned response from their customer support indicating that they know about the problem and are working on it. Which imo is completely meaningless, since it's been four days now...

      Harold

      Delete
  20. Hi, Robert...

    I upgraded to your new (March 3, 2013) version of the scripts and I wanted to thank you for them.

    I took the opportunity to set up Capital One for downloading and I noticed what might be a new problem. Previously, when I got an error return from a bank in this format (I changed the angle brackets to brackets in order to get the snippet to post, but it came with what I thought were proper angle brackets):

    ---------------

    OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:9492f488-a8b6-4e51-b26d-6897cca9c844 [OFX] [SIGNONMSGSRSV1][SONRS] [STATUS] [CODE]2000 [SEVERITY]ERROR [MESSAGE]Oops, this device isn't authorized for use with your Capital One account. To authorize it, call Capital One Online

    ---------------

    the Pocketsense scripts picked up this error and displayed an error message. With this error file and the new version of the scripts, Pocketsense did not display any message and when I sent it into Money, it simply ignored the file without displaying a message either. This is Capital One, so I am using ofxVer=103 for it, if that makes a difference.

    I can send you the file if you like, although I can no longer reproduce the error.

    Harold

    ReplyDelete
    Replies
    1. I see two different issues. The first may have to do w/ the server not recognizing your account info, so you would need to contact them to see if that's the case. First, I'd try using ofxVer=102, in case they do not support 103. The other issue is that the scripts are missing the error condition. I can fix that part, but there is nothing in the return message above that points to an error in the script request.

      Delete
    2. At this point, CapitalOne seems to require ofxVer=103. And yes, the server needed some pre-authorization at CapitalOne... I called them and got that and it all worked fine.

      I was concerned with the fact that the scripts seemed not to pick up the error. Am I dreaming, or did the prior version pick up this kind of error and generate a message?

      Harold

      Delete
    3. You're not dreaming. I removed one "sniff test", since it was a poorly constructed filter, and could throw a flag on valid statements. Your message passed to Money because it really was "well formed" OFX SGML, but there was nothing to process. I would prefer to catch statements that don't have the right parts, so I may add a better trap for this type of condition.

      Delete
    4. The problem for me with this error message is that when I fed the file to Money, I did NOT get an error message from Money... it just ignored the file. So when I do my morning downloads with all the various banks, if the Pocketsense scripts don't flag something with "Severity error", I would never see that an error occurred.

      Since Money isn't changing, that leaves it up to you... [winks]

      H

      Delete
  21. For those having issues with citibank credit cards:

    Citibank updated the URL for their OFX server. The new URL is https://www.accountonline.com/cards/svc/CitiOfxManager.do
    Update your sites.dat file.
    Run Setup.py and test each citi account individually, sending the information to MS Money.
    The first time for each citi account, you will need to associate the OFX import with the appropriate citi account in Money. After that, all should be well.

    Hope this helps.

    Robin

    ReplyDelete
    Replies
    1. Thank you SO much! It worked perfectly.

      Out of curiosity, how in the world did you figure this out?

      Harold

      Delete
    2. Apparently users of other products (Moneydance, Moneywell, ibank, & Quicken) were experiencing the same issues. I spent an hour or so this morning going through forums for those products to figure out that the problem was with Citi. The updated URL was posted on one of those forums 3 days ago. I figured I'd give the new URL a try and it worked like a charm.

      This product has beenn awesome for me, it is about time I could contribute back in some small way.

      Robin

      Delete
    3. I just want to second your comment about how awesome this product is. I think it's just wonderful, Robert.

      H

      Delete
    4. This Citi credit card issue was driving me nuts, thank you! Having similar issue recently with American Express credit card, except the ofx is empty, 0 bytes. It used to work fine. Perhaps they changed their URL too??

      Delete
  22. Beta w/ [SEVERITY]ERROR check posted. Let me know if it works, and I'll go ahead and post it as final.
    Download: https://sites.google.com/site/pocketsense/ofxpy_pocketsense_beta.zip

    Thanks for the kind words guys!

    ReplyDelete
    Replies
    1. It works just fine...

      I changed one of my passwords to cause an error and tested it both in setup and download modes.

      Thanks so much!

      H

      Delete
    2. Thanks Harold. Final posted.

      Delete
  23. Robert,

    Back on April 11 I reported some issues with 401(k) downloads. Namely, although they had transactions they weren't importing. I tracked it down to a buy transaction not having a tag with a negative value. My workaround for the past year had been to do a global replace in the 401k file: with - (Notice the negative sign)

    I just downloaded the January/March update to PocketSense (I think I was still running August version). BINGO - the problem is fixed, and the 401k files now import (and have a negative sign for the tag).

    I didn't keep the old scripts (doh!) to see what change you made, but Thank You!

    Now if only Target would make their Red Card statements downloadable through an online banking interface rather than their web site my MS$ would be complete!

    Oh - and thank you for the CombineOFX functionality. Just gained major points with the wife!

    Carlos

    ReplyDelete
  24. I posted a comment on the OFXHome site about this, but it hasn't shown on their settings page yet. For anyone using a Citigroup credit card, they recently changed their OFX server connection. The following works:

    https://www.accountonline.com/cards/svc/CitiOfxManager.do

    ReplyDelete
  25. I've downloaded and install the 15-Mar-2013 version. After rebuilding my sites.dat and accounts the CITI site now works fine as well as my AMEX credit cards. My INVSTMT accounts are now getting an error.

    cannot concatenate 'str' and 'float' objects
    ** Review .\xfr\EDWARDJONES20130321110404853489.ofx for possible clues...
    An online error occurred while testing the new account.

    However, the resulting OFX file is complete and imports correctly. There are no errors in that file.

    ReplyDelete
    Replies
    1. Just an update... After walking through a debug, it appears to be related to the timeOffset in the scrubber. I had set the value to -20 and it errored. Removing that value and the transaction worked fine.

      Delete
    2. Thanks for posting Tom. Your follow-up comment pointed me in the right direction. I think it's fixed, but would appreciate someone testing:

      https://sites.google.com/site/pocketsense/ofxpy_pocketsense_beta.zip

      Delete
    3. Testing was successful. I tested both the timeOffset as well as the combineOFX. I did not test the combineOFX for the case when one of the OFX files errors off. Thanks for the update Robert.

      Delete
    4. Thanks for testing Tom. Release snapshot updated.

      Delete
  26. OFX URL from Quicken direct connect?

    Is there a way to find out the OFX URL that is used by Quicken direct connect? Transaction downloads stopped working a couple of weeks ago for my accounts at the Oregon Community Credit Union, so I have been investigating what the problem is. I discovered that the OFX files in the xfr folder are empty (0 length). In contacting the credit union’s technical support I was told that the URL (internetbanking.oregoncommunitycu.org/scripts/serverext.dll) that I have been using is out of date, but they were unable to provide me with the correct URL. They have a copy of Quicken that they use for testing, and they were able to do a trace that showed the URLs after the Quicken direct connect login, but they were unable to figure out the URL initially used.

    The credit union switched to a different service provider (command.onlinebank.com) in July 2012, at which point I started having some PocketSense timeouts and empty OFX files, but this only happened some of the time until a couple of weeks ago when the PocketSense downloads stopped working altogether. I have searched everywhere I can think of, and I only find the old URL that I am using. I can do web connect QFX downloads, but that is a lot more trouble, so I would really like to find the direct connect URL so that I can continue using the PocketSense scripts for the transaction downloads.

    ReplyDelete
    Replies
    1. I have no experience w/ Quicken downloads, but it's sad that the IT department of the CU can't figure out what the direct connect URL is. They have a contract w/ onlinebank.com, so surely they can ask?

      That said, I notice in the Moneydance institution data (http://moneydance.com/synch/fi2004.dict), that there are many banks that use onlinebank.com. The common server is https://www20.onlinebank.com/OROFX16Listener.

      Delete
    2. Having same issue recently with American Express credit card, the ofx is empty, 0 bytes. It used to work fine. Looks like they changed their URL, but the new one is nowhere to be found. OFXhome shows that the URL has been failing since March 28th until present.

      Delete
    3. The downloads for my American Express credit card have been working fine, including today. Here are the PocketSense parameters that I have been using:

      AcctType : CCSTMT
      fiorg : AMEX
      fid : 3101
      url : https://online.americanexpress.com/myca/ofxdl/desktop/desktopDownload.do?request_type=nl_ofxdownload

      Delete
    4. Oops, dumb mistake on my part. I had done a global search and replace on a number to change the mininterval, and it happened to match part of the Amex fid and changed it. Putting it back to 3101 works. It didn't help that OFXhome shows that the Amex URL fails validation, so I thought that confirmed a problem with the URL. Thanks for the quick and helpful response!

      Delete
    5. Here are the parameters that now seem to work for Oregon Community Credit Union downloads after the previous OCCU parameters stopped working in March 2013:

      FIORG: ORCC
      FID: 2077
      URL: https://www20.onlinebank.com/OROFX16Listener
      BANKID: 323274461

      I am using the PocketSense script defaults for the other OFX parameters, and my previous login credentials are working without any changes.

      The download problem began when the credit union moved to a different service provider in 2012. The previous parameters continued to work some of the time but downloads would sometimes fail. Then the downloads started always failing.

      There are other financial institutions that use the same service provider that my credit union is using, and it looks like the FIORG and URL parameters are the same, but that the FID and BANKID parameters are different for each financial institution.

      For me, the FID is within the URL that I see when I log in for online access to my credit union account: command.onlinebank.com/2077/. The BANKID is the routing code for the ACH transfers. I expect that this is how it also works for other financial institutions that use the same service provider that my credit union is using.

      Delete
    6. In addition to using the correct parameters for the Oregon Community Credit Union it is also necessary to enroll in Quicken Direct Services on the credit union web site. This does not have anything to do with actually using Quicken, but it makes it possible to use the same transaction download interface that Quicken uses. The steps to do this are 1) Sign in to Internet Banking, 2) Click on Member Services, 3) Click on Resources, 4) Click on Quicken Direct Connect, 5) Click on Enroll, 6) Click on Continue to confirm the enrollment.

      Delete
  27. Does anyone have the settings for TD Bank since they made their changes to online services in March 2013:
    http://help.infinitekind.com/discussions/problems/7963-td-bank-big-change-what-do-i-do

    As you can see above, MoneyDance added new settings and it works for them. I still have the old settings from OFXhome, and all I get is an Access Denied message in the ofx file, and also:

    You don't have permission to access "http://onlinebanking.tdbank.com/scripts/serverext.dll" on this server.

    ReplyDelete
    Replies
    1. Look in the Moneydance configuration file @ http://moneydance.com/synch/moneydance/fi2004.dict

      Delete
    2. Has anyone gotten TD Bank to work? I used the settings from the Moneydance file and I'm still getting the Access Denied error.

      Delete
    3. I don't use TD, so I can't test. Did you use the Moneydance "TD Bank Online Banking - NEW" settings?

      Delete
  28. Have just tried out this for the first time (am in the UK). Am having a problem with UK Mutual funds. I'm OK with stocks but although my Yahoo portfolio (from uk.finance.yahoo.com) is happy to find and include symbols like, for example, "GB0031092942.L" (Cazenove UK Smaller Companies B) , I get "invalid quote response from Yahoo! Finance. Skipping..." when testing. I'm very new to all this but any help would be appreciated.
    Martin West

    ReplyDelete
    Replies
    1. Martin: The Yahoo quote api only supports US stock tickers, afaik. The value that you see from Yahoo finance is via their html user interface, but they don't support those symbols from the Y! service that these scripts connect through.

      Delete
  29. Has there been any issues with the Test Account option on the latest version? Mar-22

    When I try and test any account, the scripts complains about expecting 2 values for getofx, and only receiving one value?
    I can send the screen shot to you if needed...
    Thanks!

    Dave

    ReplyDelete
    Replies
    1. Dave... re-install the latest version and test again. It's possible that you didn't copy over the latest setup.py. Works fine here.

      Delete
  30. hi Robert

    thanks so much for doing all of this!
    I am in no way computer literate but you saved me much anguish when money went silent.
    I spent a couple of hrs setting up the online updates a couple of yrs ago
    worked fine on my laptop on windows 7
    I bought a new laptop with windows 8 and after spending a couple hrs trying to transfer files or reload files I cant get it to work.
    asus machine
    any thoughts?
    any way you can do this remotely? more than happy to pay for your expertise!!

    niall

    ReplyDelete
    Replies
    1. Niall: I haven't used Windows 8 yet, but I'm curious. It may be best to discuss via email (pocketsense1 /at/ gmail /dot/ com), and put the final results here. My first recommendation is to look for the equivalent of "windows compatibility" that exists in Windows XP/Vista/7. I know how to do this on previous versions, so I did a quick search and found the two links. I'd start w/ Windows 7 mode, and then try XP if it doesn't work.

      http://www.dummies.com/how-to/content/how-to-run-older-programs-under-windows-8.html

      http://windows.microsoft.com/en-us/windows-8/get-apps-devices-working

      Delete
  31. The OFX file from ING Direct fails because it is missing a DTEND tag. During GetData, I can see the message from the scrubber "+Scrubber: Fixing missing field" reported for the ING account. However, the DTEND tag does not get saved to the OFX file. I am on Windows 7. The code seems to be doing what it's supposed to, but the tag does not get saved/inserted. Any ideas? Thanks.

    ReplyDelete
  32. The LT and GT symbols were stripped from my message above, the scrubber message is:
    +Scrubber: Fixing missing DTEND field

    ReplyDelete
    Replies
    1. Just saw the comment. Stay tuned...

      Delete
    2. Finally had a little time to look at it. Bug found. Update coming soon...

      Delete
    3. Beta uploaded (see below). Let me know if it fixed the issue.

      Delete
  33. BY chance, DTSTART doesn't occur more than once in your ING OFX file, does it?

    I see Bob had the comment:

    "The assumption is made that only one statement exists in the OFX file (no multi-statement files!)"

    -Dan (ameridan)

    ReplyDelete
  34. robert,

    cant seem to locate the sites.dat file. The only sites.dat file i have is a total player file. All i want to do is download quotes from yahoo.
    I have mm 2007 deluxe. what am i screwing yp?

    ReplyDelete
    Replies
    1. Refer to step 2.2.1 @ https://sites.google.com/site/pocketsense/home/msmoneyfixp1/p2

      Delete
  35. Bug fix in scrubber routine. Beta uploaded for testing:

    https://sites.google.com/site/pocketsense/ofxpy_pocketsense_beta.zip

    ReplyDelete
  36. I've set up all the ticker symbols in the sites.dat file. tested from setup.py and all worked well. I created a dummy account in Money Sunset, and entered all the ticker symbols there as well. Ran getdata.py and all went well, let it send the data to money and everything was up to date. About 2 hours later I reran getdata.py and all prices were updated, sent it to money, and the new prices were not updated. I checked the ofx file and the new prices are in there.

    Is this meant to be a once a day update? or have I mis-configured something?

    thanks
    Tony

    ReplyDelete
    Replies
    1. Money only stores one price per symbol per day, so only the first price is kept. Generally, the scripts pull in the price for the "last close date".

      Delete
    2. that was fast, thanks.

      I used to get stock updates every 20 minutes from money automatically right up to last week when the stock updates quit. So I'm guessing this method is good only for one daily update for stocks.

      Delete
    3. Yes. The Money OFX import routine only accepts a single quote per day, similar to if you manually enter a quote for a symbol. I'm not familiar with how the built-in quote engine worked, as I never used it.

      Delete
    4. p.s. Just fyi... ticker symbols are automatically created in the dummy import account at the time of import, so there is no need to manually add those. If you add some more symbols to sites.dat, the new symbols will be added during the next run.

      Delete
  37. I am using Money 06 Deluxe and PocketSense from the beginning. Everything was working beautifully.I just upgraded to the March 2013 version and I did something wrong, my portfolio Manger is not uploading for some reason to the latest quotes. All data show correctly in "view investment holdings" in Money, however in the Portfolio Manager the data is old and everything shows "unchanged"
    BTW setup. pyc and setup.py both show the same screen. I also noticed the "quotes.htm" file and I love it and it also has the correct and current data, is this new, or have I never noticed this before?

    ReplyDelete
    Replies
    1. I didn't have time to look at this during the week, but just checked, and my Portfolio Manager is current. However, I do not use any of the raw stock quotes inside investments, since all of mine are updated from the statements themselves. One thing to be aware of is that you can tell the scripts to use the raw quotes from Yahoo first, or statements first. The default is "statements first", so if you try to update before the bank/broker has updated their data from the last COB... there would be no change. My opinion is that you should *not* explicitly include stock/fund symbols when you are able to download the broker statement itself, which will include price updates, along with transactions.

      Delete
    2. p.s. I'm using Money Sunset.

      Delete
  38. The quotes.htm has been there for a couple of years. I had provided Robert the code for that in an attempt to have a screen within the Money program that would always show the most recent quote updates - as Tony just observed, Money only shows the first update for each day. If you want to, you can add the quotes.htm page as a Favorite in the Money program, as explained in my Blog http://microsoftmoneyoffline.wordpress.com/2011/02/17/version2/ or you can even attempt to use my addon webpage described in the blog that incorporates quotes.htm while also giving you access to Pocketsense from within Money.

    ReplyDelete
    Replies
    1. Thanks for the prompt reply
      I like your idea, even though I think PocketSence was designed to at least have the quotes updated once a day, so I think my Money program is somehow corrupted.
      now to your "webpage" add in, I did the first 6 steps however since I am running Money from my harddrive I can't find the Money's address bar.

      Delete
  39. It's right under Tools. The entire Money user interface is really just a customized browser.

    ReplyDelete
    Replies
    1. I am sorry, I am not the sharpest when it's about computers.
      Under tools: find and replace
      calculator
      internet updates
      alerts center
      Money for pocket PC
      finantial services
      settings
      I can't find anything close to an address bar. Would you suggest that I replace my Money2006 with Money Essentials?
      I do appreciate your help, I am getting desperate to get the quotes wrking.

      Delete
    2. I ment to say Money Sunset

      Delete
  40. I was trying to point you to the location of the address bar, which is the white "box" or bar that you can type an address in right under where you see "Tools" (it has nothing to do with Tools :) ).

    This is all in reference to your comment regarding quotes.htm though and has nothing to do with your comment "All data show correctly in "view investment holdings" in Money, however in the Portfolio Manager the data is old and everything shows "unchanged"."

    ReplyDelete
    Replies
    1. Thanks again
      Setup complete and "GetOfxData7(1) added to favorites.
      The webpage comes up and shows all the correct qotes.
      However when I click on "Downloads" or "setup and test your accounts" error pops up: "This program cannot display the webpage"
      The diagnostic tool shows the following:

      "The website you are trying to reach doesn't appear to be valid

      "file:///C:/Users/Gun/Documents/Money-Scripts/ofxpy_pocketsense/getdata%20-%20Shortcut.py.lnk" appears to be an invalid address."

      I noticed the address is very much different than what I typed, forward slashes etc.

      Delete
  41. New version posted with bug fix for "missing DTEND" scrub routine.

    https://sites.google.com/site/pocketsense/home/msmoneyfixp1/p2

    ReplyDelete
  42. Robert,
    I understand Money 2004 and earlier uses the OFC format, whereas Money 2005 and later uses the OFX format. Can you provide an option to use either format to allow those of us with older Money versions (who prefer not to update to Money Sunset) to just download quotes? I understand that I will not be able download account statements but I don't use that feature. Up until 7/1/2013, those of us with older Money versions have been able to update quotes only; now that is no longer available.

    ReplyDelete
    Replies
    1. I will not be adding OFC support to the scripts. I recommend installing Money Sunset, and creating a converted copy of your data file. If it doesn't work, then you haven't lost anything, other than a little effort. It should work fine, and you will gain full OFX functionality via the scripts, which iirc, is much more complete than OFC was. In fact, I thought that OFC didn't support investment transactions or stock/fund quotes, and was only intended for banking transactions?

      Delete
  43. What's the correct symbol for DJIA to use to be accepted by yahoo?
    None of these work: $INDU, ^DJI, ^DJIA

    ReplyDelete
    Replies
    1. Yahoo no longer provides DJIA quotes via their "open" quote API.

      Delete
  44. Same is the case with all my investments. Nothing is displayed from yahoo and hence i am getting error in all my quotes. Any other alternate Robert. Thanks

    ReplyDelete
    Replies
    1. What kind of quotes? The Yahoo service supports all US stocks/funds that I've tried. It does not support most foreign (non-US) stocks/funds.

      Delete
    2. Yup...i was trying INDIA market quotes...It was working like charm earlier but since recently stopped updating...

      Delete
  45. Hello,
    I'm French, if i make mistakes correct me :)

    Since July the 1st MS Money didn't update stocks' values due to a deleted .dll path (i believe).
    I want to known your "script" works for the french version of money and for the CaC40.

    Thanks

    ReplyDelete
  46. There seems to be a lot of interest in quotes lately, so I'm assuming Microsoft finally pulled the plug on their quote engine. To clarify for everyone, the PocketSense quote feature should be capable of updating any stock/fund that is actively listed on a US stock exchange. The package currently uses the free Yahoo quote API, which provides support for stocks/funds on the US exchanges. The Yahoo Finance site (the web portal / html version) provides quotes for a broader range of exchanges, but they do not support those through the quote API.

    ReplyDelete
    Replies
    1. Robert - Any other option for extracting quote values for other Non-US Exchanges.

      Thanks

      Delete
    2. Dutch quotes come to me from finance.yahoo.com

      Delete
  47. Has anybody figured out the conf. data ofxpython scrippt for JP Morgan Securities?
    Here is what's in "Moneydance":

    “fi_name” = “J.P. Morgan Securities” “fi_org” = “PCS” “fi_id” = “7315″ “bootstrap_url” = “https://ofxpcs.toolkit.clearco.com” “uses_fi_tag” = “y” “app_id” = “QWIN” “app_ver” = “1900″ “access_type” = “OFX” “broker_id” = “https://ofxpcs.toolkit” } { “id” = “md:1400

    When I test run this I get an error code. Are hyphenated acc. no's allowed?

    ReplyDelete
  48. Hello Robert,

    True, Microsoft let us download stock-quotes untill 1 july 2013. I was happy encountering your elaborate workaround, and it seems to work for me almost completely. The issue I struggle with is the date of the quotes: in the browser 7/19/2013, the US-way of saying 19th of july, 2013 as we do in Europe. Money can't cope with that an imports with 11/30/2013 (US notation). I guess that is also the reason the quotes don't really get into Money itsself.

    ReplyDelete
    Replies
    1. Thanks for the post Hugo. I had never thought about this. I'm assuming that your Windows installation globally shows dates in the same format that Money is using (e.g., dd/mm/yyyy rather than mm/dd/yyyy)?

      Delete
    2. Yes, it does. I can change that but then it will change all over. What file is Money actually importing? I might be able to change that file in Notepad and import anew. Thanks.

      Delete
    3. I'm going to update the quote script to (hopefully) support user locale. Stay tuned...

      Delete
    4. After thinking on this, it's not so straight forward. Money uses the OFX parameter DTASOF to set dates for all the quotes in import file. The default format for DTASOF is yyyymmddhhmmss (e.g., 20130727235959). This is not the standard locale date/time format, so I need verification that changing this date/time field to some other format will import correctly. If you manually edit the quotes*.ofx file, and change the DTASOF field to something different (e.g., yyyyddmmhhmmss), does it import correctly? If so, I can easily add a user parameter to sites.dat for formatting the field, or I can "auto detect" European formats and adjust accordingly.

      Delete
    5. I changed the value of DTASOF - yyyyddmm or ddmmyyyy - but it doesn't make any difference. The file is still imported as if downloaded 30-11-1999. So where Money gets this date from?

      Delete
    6. Not sure what the difference is. What version are you using? I previously used the US version of Money 2008 w/ the scripts, and I'm currently using Money Sunset.

      Delete
    7. I am using Money 2004, 14.0.120.1105. But the original version with Amazon UK. Right now I changed all the dates to European format. Doesn't make any difference. Imported into Money the statement has the correct stocks and quotes (amount is zero, is that a problem?), if I touch finish the statement is gone and nothing has changed in the stockprices.

      Delete
    8. Not sure Hugo. I'm assuming that the quotes aren't creating *new* stock symbols in Money either (i.e., different than the original symbols)? The totals should be zero, but it sounds like the quotes aren't being recorded. If not, then I haven't a clue.

      Delete
  49. Good morning and thank you to Robert for all his hard work with these scripts. I think this is a general question rather than anything script specific. Since Friday my attempts to download from our Chase credit card account have been failing. From the error message it looks like the problem is at the Chase end, so I was wondering if anyone knew if Chase had changed settings on their OFX ?
    The error I get is :-

    *** An Error occurred sending POST request to ofx.chase.com
    Exception Type : class 'ssl.SSLERROR'
    Exception Val : _ssl.c.484: The handshake operation timed out

    ReplyDelete
    Replies
    1. I just downloaded some transactions from my Chase Amazon credit card a few minutes ago. Worked fine. Perhaps simply trying again will do the trick for you. Good luck.

      Delete
    2. Thank you. I just retries and now everything works fine. An extended maintenance outage, perhaps?

      Delete
  50. Am using PocketSense scripts with MS-Money sunset edition. All has been well for a couple of years until recently. I've been struggling of late to make a successful connection to Wells Fargo. I received a message indicating "software version is not supported." It may not be obvious to everyone, but download support for Quicken versions are phased out after 2 years. Therefore, it would seem we have to keep updating the APPVER field about once every 2 years, since we are "tricking" Wells Fargo into thinking we are downloading data for Quicken. As of tonight, I guessed at the following settings in sites.dat and now I am able to connect/download my accounts. (Next year or the year after I will change 2200 to something like 2400.)
    appid : QWIN
    appver : 2200

    I'm not certain whether it is necessary or not, but I went ahead and ran through the PocketSense setup.py script and re-entered each account at Wells Fargo before testing. Hope this helps anyone else out there with similar troubles. BUT, Robert, does this make sense? It's hard to argue with success, but I can't help but think I've got something wrong. (Thanks so much for all the hard work!)

    ReplyDelete
    Replies
    1. Thanks for posting. Yes, the version update makes sense, but most providers don't cutoff support that quickly. That said, you do *not* need to re-enter your account data. Just change the appVer field in sites.dat for the site. I'll update the default value in the next release to a more modern version (2100 or 2200). It's currently at 1900.

      Delete
  51. I am using Mocrosoft money 2006 deluxe with Pocketsense. I am thinking of downloading the Sunset sdition. Should I uninstall Money 2006 first or run both programs side by side?

    ReplyDelete
  52. "Sunset" can have different interpretations. If you have not already done so, have a look at this post in the Microsoft Money Forum:
    http://social.microsoft.com/Forums/en-US/479281b2-90f9-42ca-85f7-644fc6e1e5c3/download-microsoft-money-installation-files-solve-activation-and-some-other-errors
    to be sure that you are downloading the correct version of Money for your region. If you are in the US, "Sunset" will be Microsoft Money Plus, you can install it along side of Money 2006, and it will open your current MyMoney.mny file.

    However, when you open your MyMoney.mny file, Sunset will convert it to a format that can no longer be read by Money 2006. It will also save a copy of your current file in the Money 2006 format, so if you decide you don't like Sunset you can uninstall it and revert to Money 2006. Of course, any changes or additions that you make with Sunset will be lost when you revert to the saved file.

    ReplyDelete
    Replies
    1. Thanks, and how will Sunset work with Pocketsense? "GetData.py" now imports to Microsoft Money, how can I direct it to "Sunset"?

      Delete
    2. Gun, Easiest method is to open Sunset first, then run Pocketsense

      Delete
    3. Getdata simply tells Windows to load the ofx file(s) to the program currently "associated" with .ofx files. It's identical to "double clicking" on the ofx file. Sunset should set itself as the default program for ofx files.

      Delete
  53. The last few days I am having trouble with Vanguard.The brokerage accounts download OK, but the mutual fund accounts do not.
    Here the error code:
    VANGUARD : XXXXXXXXX : Getting records since: 20130629
    OFX statement is missing required section.
    ** Review .\xfr\VANGUARD20130730232201343170.ofx for possible clues...
    An online error occurred while testing the new account.

    I checked the ofx file but can't find anything out of line.

    ReplyDelete
    Replies
    1. Vanguard mutual funds working fine here.
      - Did you happen to change anything in your sites.dat or user settings?
      - Are there any transactions during the download period?
      - Are you running the latest PocketSense version?

      Delete
    2. Tried my old laptop used for backup and still had the old Pocketsense ver 13-Oct-2010
      Vanguard loaded down just fine. Must have screwed up bigtime when I downloaded the newest version. But quotes still only download after I acknowledge each and every stock and mutual fund in "ticker", only then the correct quoted price shows up in portfolio.
      The funny part,it's been doing that evidendly from day one but I never noticed that till July 1 when Microsoft took their quote server offline.
      Now I am leaning to install Pocketsense from scratch and delete all the old files.
      ActivePython 2.6 still ok to use for Win7?

      Delete
    3. I'm using ActivePython 2.7 x64 on Windows 7 x64.

      Delete
  54. 'timeOffset' set to 0
    The market closes at 16:00 EST
    I live in the EST timezone do I have to make an adjustment to 'timeOffset' to get the current closing prices at 16:05?

    ReplyDelete
    Replies
    1. I'm not sure if I understand the question, but the timeOffset is intended for situations where the quotes are recording for the wrong date. Money only accepts one quote per day via ofx import, so small differences in time won't have an effect.

      Delete
    2. Thanks, for some reason I thought maybe I had to make an adjustment in 'sites.dat'

      Delete
  55. hello - I am a complete novice at computers. I would like to use Pocketsense only for stock quotes for Money2002
    Is that possible ?

    Or must I setup at least one Acct from a bank/brokerage with statement?
    Thank you

    ReplyDelete
    Replies
    1. I'm not sure if Money 2002 supports OFX imports, but if it does... then it should work. You'll need to follow the instructions for accepting quotes into Money, which does include adding a "dummy" investment account to catch the quotes.

      Delete
    2. Thank you for your advice, will go ahead and enter the stock data and give it a try. thanks again

      Delete
  56. I have been successfully running Sunset with Pocketsense for two weeks and think it is wonderful. Like the old days! Thanks Robert. Since Saturday I have been having a strange issue whereby my downloads are arriving in Sunset as usual with "items to review" seen as always in the Account List. The Bank Balances are correct so I can see the data is arriving. BUT, the transactions will not forward to the Account Register for some reason. They simply stay as "items to review". Anyone have a view on what I did to cause this? It happens on all my accounts and transaction types. Ed

    ReplyDelete
    Replies
    1. No clue here, but to clarify... you're saying that the transactions don't show in the account register(s), but do show on the "online statement summary", (i.e., it shows xx number of transactions to be accepted in the summary for each account)?

      Delete
    2. Yes, that's what is so strange. I can see that the downloads are taking place properly. So, I re-downloaded Sunset, no help. After I try to "read transactions" from the account list, the screen flips to the register, but the transactions are not there, and, the "transactions to read" are there to be read again on the Account list. I have used notepad to review the OFX files from XFR and nothing seems amiss, which makes sense since the files are moving to money, but, not then finishing their travels. Go figure!?

      Delete
    3. So there are actual transactions in the OFX file that aren't showing in the register after import? Try the "repair file" option in Money. Since it was working fine until recently, there is no reason to suspect that ofx/account matching is wrong.

      Delete
    4. I have a simular situation here. Nothing is imported to the portfolio manager. just reinstalled Money Sunset. Tested my TD Amritrade account with setup.py, tells me download successful, "do you want to import to Money"? yes, all quotes are current,(last nights closing prices) but are not current in portfolio. No other transactions are reported, there should have been a few div. transactions.

      Delete
    5. I also noticed that the 'minInterval' is for 30 days. I didn't put a number there, is that the default?

      Delete
    6. Gun: I'm not sure about the portfolio manager issue. I have only one fund that I update via the quote interface, and the totals in the portfolio manager are correct for the last quote value, and the price history is also correct. As for the download interval, the default is 30 days, but can be changed in sites.dat by setting the defaultInterval option. You can also enable the promptInterval option, which will prompt every time.

      Delete
  57. Found the issue, at least the one I was dealing with. The OFX files and transactions were arriving into Money and showing correctly as "Transactions to Read". But, when I would access them by reading, they would not flow to their register, simply staying as unread. I uninstalled and reinstalled Sunset which at first did not help. I tried again, this time doing a cold restart of my system before reinstallation. I received a message on restart that several files needed to be repaired which took place automatically and then when I reinstalled Sunset, everything is working perfectly. Sorry to be a bother, Robert, and thanks again from all us Money junkies.

    ReplyDelete
  58. Hello,
    I am leaving in France and using Money 2005.
    Importing OFX files from Banks still works, but, since July 1st, stock Quotes are not available anymore.
    I have installed the PocketSense. It works for the US stocks only. For European and French stocks, is it possible to import stock tickers from fr.finance.yahoo.com?
    What part of the code should be changed?
    Thanks
    JM

    ReplyDelete
    Replies
    1. You can try. Change the YahooURL parameter in sites.dat (be sure to un-comment it too by removing the # symbol at the start). Let us know how it goes.

      Delete
    2. You can try. Change the YahooURL parameter in sites.dat (be sure to un-comment it too by removing the # symbol at the start). Let us know how it goes.

      Delete
  59. Thanks for the quick feed-back.
    I had already tried to change the URL site, but it did not work.
    I got error message when testing. It looks like the YahooURL which I have edited is just ignored.
    Hereunder is the code I have tried in the Site.dat file:

    YahooURL: http://fr.finance.yahoo.com # Alternate site for quotes. Default = finance.yahoo.com
    QuoteCurrency: EUR # Currency for quotes. Default = USD
    EnableYahooScrape: Yes # Try a screen scrape if the primary Yahoo csv interface fails
    YahooTimeZone: -5:EST # Timezone rule for the Yahoo server (default = -5:EST)
    ShowQuoteHTM: No # Always show quotes.htm from Getdata
    AskQuoteHTM: Yes # Ask to show quotes.htm from Getdata (overrides ShowQuoteHTM)


    #--- indexes ---
    INDU #Dow Jones Industrial Avg.
    ^GSPC #S&P 500 and
    ^IXIC #NASDAQ Composite

    #--- stocks ---
    ALU # Alcatel Lucent
    FP # Total
    Local # Solocal Group
    VK # Vallourec
    EDF # Electricité de France
    GSZ # Gaz de France
    RIA # Stéria Groupe
    IPS # Ipsos
    DG # Vinci

    #--- Currencies ---
    EURUSD=X #Euro to US Dollar
    USDJPY=X #USD to Japanese Yen



    MBFIX #Wells fargo total return bond I
    AGTHX #Growth fund of america

    What can I try to get correct connexion to Yahoo french server?

    ReplyDelete
  60. Hello,
    it looks like on the French Yahoo server, the tickers are identified with a ".PA" extension.
    Ex: When I use VK.PA, I get the quote for Vallourec, which I was looking for.
    So, finally, changing the alternate server to "fr.finance.Yahoo.com", I can retrieve the quotes, but, when using Test Menu option 6 of setup, I still have at the end of the process an error message which I do not understand.
    Any proposal?
    JM

    ReplyDelete
  61. Hello,
    the error was coming from the Dow ticker. Removing this ticker, I got the OFX file and the option to import it to Money. The quotes are correctly imported into the Dummy account which I had created and stock values are correct in the Dummy account.
    Although I have associated each existing investment to its new ticker, it looks like their values are not updated in the real investments account where they are registered???
    Any proposal?
    Thanks for help
    JM

    ReplyDelete
    Replies
    1. When you say 'associated each existing investment to its new ticker', do you mean that you did this in the sites.dat entry for each ticker using the s:value option? For example, an entry for Vallourec above would look like:

      VK.PA s:VK

      This means 'qet quote for VK.PA from Yahoo, but pass it to Money as VK'.

      Delete
  62. Hello Robert,
    the tickers which were previously used to download quotes from MSN were looking like "FR0000123456" which are the official code for the stock.
    Ex: Vallourec: FR0000120354
    On MSN site the abbreviate quote for Vallourec was VK, but it was not used.
    When I have imported the OFX file, Money has recognized the name of the stock and it has asked wether I wanted to change the ticker to VK.PA or create a new stock with a different name for VK.PA.
    I have chosen the first option and Money has recorded VK.PA.
    It looks like I am very close to get something working properly.
    I believe the transfer of the value does not properly work because the date format is not the european format dd/mm/yy and it is not recognized.
    Is there a way to change this date format?
    When I look the content of the OFX file, I can see the following fields:
    title Symbol Quantity Quote Amount

    There is no date recorded for each stock. There is only one date for a title field called "Last remote update" for which the value is recorded at 30/11/1999. !!!!

    Shall the date not appear on each stock line of the OFX file?

    Thanks for your support.
    JM

    ReplyDelete
    Replies
    1. JM: It looks like you're hitting the same obstacle as Hugo in an earlier thread above. I don't understand what's happening w/ the European date issue, but will fix it if we figure it out. The scripts currently use the OFX parameter DTASOF to specify the date for *all* quotes in an import file (this works for the US version, at least). The default format for DTASOF is yyyymmddhhmmss (e.g., 20130727235959). This isn't a standard OS/locale date format, though, so I'm not sure what's happening during import for European versions of Money. It may be that we need a field that doesn't currently exist in the quotes file, and that Money is simply reverting to an Epoch date (ground zero date/time for the Money development platform).

      I'm going to think on this a bit more.

      Delete
    2. OK. I hope you'll be able to understand what's happening wrong when importing OFX file from PocketSense and you can find a work-around.
      Thanks again for your help.
      JM

      Delete
    3. I made one minor change. Beta uploaded for testing:
      https://sites.google.com/site/pocketsense/ofxpy_pocketsense_beta.zip

      Delete
  63. I have downloaded the package and experimented some problems.
    When running GetData, I got the selection menu N/Y/I, which is OK
    Then, selecting Y or I, a screen pops-up and disappears almost immediately. It looks something goes wrong. I was not successful trying to display the message contained in the pop up screen by freezing the screen using the "Hold" key.
    I have then tried to run the setup.
    I first disabled the Quote option, then re enabling the quote option, I got the same result. A screen popping up and disappearing.

    Is there a way to run the getdata and/or setup step by step?

    ReplyDelete
  64. Robert,
    FORGET ABOUT MY PREVIOUS MESSAGE.
    When editing correctly the new sites.dat with Yahoo french URL and my list of quotes, Setup and Getdata properly works.
    The only difference with previous package is that the OFX info now flies directly into money.
    The date is still at ground 0 and imported quotes does'nt show up into Money.
    PS: I have checked the HTM file, it still shows date the American way for each quote .
    JM

    ReplyDelete
    Replies
    1. If you look in the quote*.ofx file, you'll find that the dtasof time formats don't really follow a standard locale format. I have tested other ofx date fields, to see if they make a difference, but they don't (on Sunset). I'm starting to think that there may be a bug of some type in the European version (I'm assuming that you're *not* running Money Sunset). It would be great if you can edit the quotes*.ofx file manually, and change the *first* DTASOF value to another format, save the file, and double-click it. It should "try" to load to Money. I have no clue whether the format may be the issue, but it's worth a shot. The existing format should be yyyymmddhhmmss. If it isn't, then that's a problem.

      Is it possible for you to upgrade to the Sunset edition of Money without breaking something else? The issue may be related to the version, but that's a guess. I do know that it all works fine on my machine w/ Money Sunset.

      Delete
    2. I should clarify the above a bit. I haven't actually validated *your* quote symbols importing to Money from the French Yahoo server... just my own from the US and CA servers.

      Delete
    3. I am currently running the MS package released by MS to replace Money. This package was retrieved and installed already few years ago.
      To minimize breaking risks, I will try to find the Sunset french version from MS (if it is available) and I will install it on an other computer. I'll let you know the result.
      Thanks for help
      JM

      Delete
    4. Robert,
      I have downloaded and installed Money Plus Sunset. For Downloads, there is no French option, just English and Japanese.
      When I try to open Sunset using my previous Money file, I get an error message. "Your file was created with a different version of Money and it cannot be converted".
      This file contains more then 10 years accounting info which I want to maintain.
      Looking at MS site, it seems that MS has managed to get different, incompatible file formats between US and other regional area. There are advising to generate QIF files from older version and to import these files into Sunset. I have already tried this to feed Quicken, and never succeed to get something working.
      So using Sunset seems impossible.
      Is there a way I can send you the source I am using to install the Money version I am currently running so that you can try to find which format is currently used for OFX file?

      Delete
    5. I have no way to 'decode' the ofx format expected by Money. I use the Microsoft OFX specification when working on the scripts, and then test the code against Money Sunset. There really isn't a way to determine the 'right' Money ofx format outside of using the OFX specification documentation. The only thing that I could do is the same as anyone else... and that is to generate a quotes*.ofx file with the scripts (or manually), edit that file to change date or other field formatting, and then try to import it. Change something else, repeat, etc.

      Delete
    6. OK, I can edit the OFX file myself and try to import. Shall I only edit the date for each stock or other dates also?

      When importing the OFX file in Money, I get a screen listing all accounts registered in Money. In the Dummy account, I see that there is 10 entries to import. When I open this account, I can see for each stock what is being imported. As I already wrote, there is no info on date.

      Can you tell me for your case what fields are displayed (Ticker, quantity, Price etc...)

      An other question, where can I find the OFX spec for Money?

      Thanks a lot for your help.
      JM

      Delete
    7. JM: Shoot me an email at pocketsense1 /at/ gmail /dot/ com (just copy your last post into the message). It's easier to communicate details via email than these comment forms.

      Delete
    8. Robert,
      Sorry, but I did not succeed with outlook to send a message at the address given above: pocketsense1 /at/ gmail /dot/ com
      I have an old mail address which I don't use anymore but which is still valid: Sylpale2@gmail.com
      Can you send me there an address e-mail which I can use to communicate with you.
      I will then send you my current e-mail.
      Thanks

      Delete
  65. Hi Robert, on the "European" date and quotes not updating even when import went OK, I am assuming the users in questions are using 2005 and earlier.
    In my work in hleofxquotes to support 2005UK, I've found a couple of things that might be related to what your users are seeing:

    . in 2005UK, if you import a zero share entry, money will ignore that price quote
    . for 2005UK, you need a tag INVTRANLIST or 'statement will show up in MM05 as having a date of 1970.'

    See my notes on https://code.google.com/p/hle-ofx-quotes/wiki/UKUsers

    hleofxquotes --

    ReplyDelete
    Replies
    1. Excellent. I skimmed over your notes, and understand the INVTRANLIST tag. If I'm understanding correctly, you also force an increment to 'quantity held' for each stock/fund 'holding', looping @ ~0.999. Is that required to force MM05UK to record the value? If so, does it work if you decrement instead (i.e., add 0.001 and then subtract 0.001).

      On a separate note, I didn't realize that you were working on a java package to handle quotes, but it's great to see. Thanks for posting your work!

      Delete
    2. Re: increment - what you said is correct.
      Re: inc then dec - I vaguely remember thinking about do the N:inc, N+1:dec but must have ran into issue. Don't remember the specific right now.
      Caveat: doing the incremental share has couple of side effect:
      1. User will have to accept the fake "buy"
      2. The fake "buy" will show up in the price chart

      Some user are OK with that. Others have decide not to use because of that.

      Delete
  66. Robert,
    I have downloaded and installed Money Plus Sunset
    I use ca.finance.yahoo.com to import Stocks and funds in msmoney. the currency is CAD. it works well for my stocks (both canadian and us) but for my funds, in canadian $, using the code available in Yahoo (DSFFPGCANQUI.TO) for exemple, i have a error message. How can i resolve the problem ?

    ReplyDelete
    Replies
    1. The Yahoo quote API doesn't support many stocks/funds from exchanges outside the US. There is an option in sites.dat to attempt to perform a "screen scrape" from Yahoo Finance html output when the Yahoo quote service doesn't provide a delimited quote result. This feature is broken in the current version.

      I'm currently finishing up a beta (test) version in an attempt to support quotes for European versions of Money. While I'm there, I'm going to attempt a rework of the EnableYahooScrape code. If successful, quotes like the one you mentioned should work. Well... it will work until Yahoo changes their html output again.

      Delete
    2. Thank you for the information.I will follow with great interest the discussions to be able to test when available. I tried to switch to Quicken since July and I grabbed my duplicate transactions in the hope that there would be a way to import the data into money. Since I used your application I stopped using Quicken. Again thank you.
      Will there be a way to update currencies for exchange rate, like it was possible in money 2006?

      Delete
    3. I do not know of any way to automatically update currencies. You can manually do this from the Settings->Program Settings menu.

      Delete
  67. Comments for this thread closed. See latest post for more discussion.

    ReplyDelete