My experiences using PocketSense scripts with Money Plus Deluxe Sunset

All replies

• 

  

  0

  Sign in to vote

  Thank you Cal for the nice review of both my OFFLINE Blog and Bobby's PocketSense site and scripts.   I am going to reference your review in my Blog as it may help others setting up FIDELITY 401k, Citi Card, and Vanguard accounts.  Regarding your Janus account, my experience is that wothout 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.  Then it proceeded to add the FID and ACCOUNT NUMBERS for each account.

  Regarding Ameridan's 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.

  Wednesday, October 6, 2010 11:56 PM
• 

  

  0

  Sign in to vote

  Note that the Fidelity entry might be better listed as Fidelity Investments. Mine is the same as yours. There is a related Fidelity Netbenefits site that I don't know the data for. That is the one for 401k. Feel free to add info from my posting to your site. I looked into posting this there, but I did not see how to start a new thread.

  I have thought that it would be nice to be able to specify which things you want to update at a given time. I understand you can approximate this with the interactive mode in the Getdata.py, but it still fetches everything. It just limits which it passes on to Money. However extra options could complicate things needlessly. Also, I like to prefer to only pick up quotes when the market has been closed over 20 minutes, so that the prices fetched are  closing prices. Not a big deal. In Setup.py, there is menu item "Add or Modify Account". It seems to only allow adding. To modify an entry, you need to add the new one and delete the old one.

  Fancier would be to combine multiple accounts from a single FI into a single OFX. That would save the extra click in Money as the OFX file gets fed in.

   

   

  Thursday, October 7, 2010 12:23 AM

  Moderator
• 

  

  0

  Sign in to vote

  Cal,

  If you only want a single account download, the Setup script (Test) is an ideal alternative.   That is why I include that in the webpage addon.

  Thanks for clarifying the Fidelity data - I changed the Blog accordingly.

  Thursday, October 7, 2010 4:29 PM
• 

  

  0

  Sign in to vote

  Use the following URL for AMEX and it should work (it does for me)...

  url     : https://online.americanexpress.com/myca/ofxdl/desktop/desktopDownload.do?request_type=nl_ofxdownload

  Sunday, October 10, 2010 1:02 PM
• 

  

  0

  Sign in to vote

  The following entry for Fidelity NetBenefits has been working for me:

  <site>
      SiteName: FIDELITY_NB
      AcctType: INVSTMT
      fiorg   : nbofx.fidelity.com
      BrokerID: nbofx.fidelity.com
      fid     : 8288
      url     : https://nbofx.fidelity.com/netbenefits/ofx/download
   minInterval: 30        
  </site>

  Sunday, October 10, 2010 1:06 PM
• 

  

  0

  Sign in to vote

  Cal,

  Do you know the URL for Yahoo finance UK to substitute in the sites.dat file in order to enable stock and Fund quotes from the UK. I appreciate that you can get London stock quotes from the US site, although they are in dollars, but you cannot get UK fund prices. Ace money has the option to use the UK site of Yahoo to get csv files, so it can be done. I have experimented with various options but with no succes yet.

  Thanks, Don

  Wednesday, October 13, 2010 2:38 PM
• 

  

  0

  Sign in to vote

  Do you know the URL for Yahoo finance UK to substitute in the sites.dat file in order to enable stock and Fund quotes from the UK. I appreciate that you can get London stock quotes from the US site, although they are in dollars, but you cannot get UK fund prices.

  See if https://microsoftmoneyoffline.wordpress.com/category/microsoft-money/page/2/ helps. Maybe somebody will write a script to do the currency conversion if the numbers are not directly available in GBP. A conversion rate could be read, and the math could be done to convert the share value from USD to GBP in the script.

  Wednesday, October 13, 2010 3:47 PM

  Moderator
• 

  

  0

  Sign in to vote

  I too have tried but failed to get this to work with non-US stocks.

  It is a great shame as users of Money outside of USA do not even have the Quicken option.

  I guess Microsoft considers us less important than their US customers.

  Friday, October 15, 2010 7:26 AM
• 

  

  0

  Sign in to vote

  I don't get any errors using the netbenefits settings above, but it doesn't download the transactions or the prices.

  Saturday, November 6, 2010 6:45 PM
• 

  

  0

  Sign in to vote

  Wells Fargo stopped allowing Microsft OFX updates as of Nov 1, 2010.  You now can only generate QFX and CSV files.  I asked Wells Fargo to continue to support OFX but they ignored the request.

  Saturday, November 6, 2010 6:48 PM
• 

  

  0

  Sign in to vote

  Wells Fargo stopped allowing Microsft OFX updates as of Nov 1, 2010.  You now can only generate QFX and CSV files.  I asked Wells Fargo to continue to support OFX but they ignored the request.

  
  I think you are referring to using the Wells Fargo website rather than the PocketSense scripts in this case. Try saving the QFX file to disk, and then File->Import that file as a statement into Money.

  If that works, it is also possible to make a file association to feed QFX files to Money to save some steps.

  Saturday, November 6, 2010 7:22 PM

  Moderator
• 

  

  0

  Sign in to vote

  I have run across an anomaly on my Money Plus Deluxe Sunset use with PocketSense. I am asking others to check to see if they see the same symptom. I am pretty sure it is not caused by the PocketSense scripts, but rather an anomaly in Money that I have not been aware of. My symptom is that the price history in Money associates the day after the price quote with the quote. I would request that others who get price data via OFX and/or PocketSense compare the price history for a security in Money with the price history of the particular security.

  In Money, to see the prices recorded for a security, you can right-click the security in the Portfolio and choose SeePriceHistory.  Then UpdatePrices->UpdatePricesManually.  That will give a history.  Compare those prices with prices from
  <http://finance.yahoo.com/q/hp?a=&b=&c=&d=0&e=8&f=2011&g=d&s=msft> (enter a symbol into the "Get Historical Prices for:" box to choose a different symbol.  How does the data compare for you?

  OFX files can contain quoted data. PocketSense requests OFX 1.x files from the financial institutions, and passes it on unchanged to Money. (That is the default -- there is a hook to put in a scrubber function if needed). For quotes from a Yahoo quote server, PocketSense creates an OFX 1.x file that it sends to Money. In the file, there are DTPRICEASOF tags to identify when the quote is for. Money does not seem to be applying that DTPRICEASOF date correctly, if at all. PocketSense uses OFX 1.x version files. I don't know if the behavior would be the same with OFX 2.x files.

  Saturday, January 8, 2011 6:24 PM

  Moderator
• 

  

  0

  Sign in to vote

  On Sat, 8 Jan 2011 18:24:08 +0000, Cal Learner wrote:

   

  >

  >

  >I have run across an anomaly on my Money Plus Deluxe Sunset use with PocketSense. I am asking others to check to see if they see the same symptom. I am pretty sure it is not caused by the PocketSense scripts, but rather an anomaly in Money that I have not been aware of. My symptom is that the price history in Money associates the day after the price quote with the quote. I would request that others who get price data via OFX and/or PocketSense compare the price history for a security in Money with the price history of the particular security.

  >

  >In Money, to see the prices recorded for a security, you can right-click the security in the Portfolio and choose SeePriceHistory.  Then UpdatePrices->UpdatePricesManually.  That will give a history.  Compare those prices with prices from

  ><http://finance.yahoo.com/q/hp?a=&b=&c=&d=0&e=8&f=2011&g=d&s=msft> (enter a symbol into the "Get Historical Prices for:" box to choose a different symbol.  How does the data compare for you?

  >

  >OFX files can contain quoted data. PocketSense requests OFX 1.x files from the financial institutions, and passes it on unchanged to Money. (That is the default -- there is a hook to put in a scrubber function if needed). For quotes from a Yahoo quote server, PocketSense creates an OFX 1.x file that it sends to Money. In the file, there are DTPRICEASOF tags to identify when the quote is for. Money does not seem to be applying that DTPRICEASOF date correctly, if at all. PocketSense uses OFX 1.x version files. I don't know if the behavior would be the same with OFX 2.x files.

   

  Cal,

   

  Long before Pocket Sense, or even before MS announced the end of MSMoney, I noted that if, as usual, I downloaded my account data and stock quotes in the early morning, before the market opened, the price seen would be associated with the date of download, in addition to being associated with the day before.

   

  However, looking a last years quotes for F (Ford), there is a very definite tendency for the Yahoo close for a given date to be the same as the Money quote for the next day.  I'm sure I'm missing some of the downloads, but this seems to be a "feature" of Money, and not of the OFX Python scripts.

   

  I can't tell what's happening with a pure OFX download as I'm not running the Sunset edition, and stock price updates are taking place as usual in Money.

   

   

   

   

   

  ---

  Ron

  Saturday, January 8, 2011 8:04 PM
• 

  

  0

  Sign in to vote

  Cal,

  Regarding OFX 2 files, HLE's Java app for Quotes creates that version if you'd like to experiment some.   I noticed that the date variable [DTSERVER]20110109030317 is GMT with no offset, meaning it uses your computer's offset to calculate the date and time.   In the example I just pasted from the hle quotes ofx file, it is 5 hours ahead of my time (EST GMT -5), but even at this late hour, the stock quote was correctly input as 2010 01 08 (today).

  Dan

  Sunday, January 9, 2011 3:29 AM
• 

  

  0

  Sign in to vote

  Cal,

  Regarding OFX 2 files, HLE's Java app for Quotes creates that version if you'd like to experiment some.   I noticed that the date variable [DTSERVER]20110109030317 is GMT with no offset, meaning it uses your computer's offset to calculate the date and time.   In the example I just pasted from the hle quotes ofx file, it is 5 hours ahead of my time (EST GMT -5), but even at this late hour, the stock quote was correctly input as 2010 01 08 (today).

  Dan

  If a quote comes up as 2010-01-08, that is a problem. With the markets closed on Saturday, there should be no quotes for that date.
  

  Sunday, January 9, 2011 5:35 AM

  Moderator
• 

  

  0

  Sign in to vote

  Since i use PocketSense everyday, I get Yahoo quotes for Saturdays and Sundays too, but naturally they are repeats of Friday's closing price.

  Sunday, January 9, 2011 3:06 PM
• 

  

  0

  Sign in to vote

  Since i use PocketSense everyday, I get Yahoo quotes for Saturdays and Sundays too, but naturally they are repeats of Friday's closing price.

  
  Having quotes in Money's history dated for Saturday and Sunday does not seem natural to me.

  Regarding your Friday quotes in the history, do the Friday-dated quotes in your Money history match Friday's actual close for

  • quotes that come in from the Broker OFX?
  • quotes that come in from the Yahoo quote server?

   

  Sunday, January 9, 2011 3:28 PM

  Moderator
• 

  

  0

  Sign in to vote

  I do not get quotes from Yahoo for investments in my Brokerage accounts.  Anyway, here is the data for Ford Stock from yesterday, and as you can see it is Friday's closing price at 4:17 pm.   It may not seem natural, but it is fine with me.  My Friday data usually isn't the closing price as I usually do all this work in the mornings, so in fact this works out better for me on the weekends :)

            [POSSTOCK]
              [INVPOS]
                [SECID]
                  [UNIQUEID]F[/UNIQUEID]
                  [UNIQUEIDTYPE]TICKER[/UNIQUEIDTYPE]
                [/SECID]
                [HELDINACCT]OTHER[/HELDINACCT]
                [POSTYPE]LONG[/POSTYPE]
                [UNITS]0[/UNITS]
                [UNITPRICE]18.27[/UNITPRICE]
                [MKTVAL]0.00[/MKTVAL]
                [DTPRICEASOF]20110109030317[/DTPRICEASOF]
                [MEMO]Price as of date based on closing price[/MEMO]
              [/INVPOS]
              [REINVDIV]Y[/REINVDIV]
            [/POSSTOCK]

   

  Sunday, January 9, 2011 4:43 PM
• 

  

  0

  Sign in to vote

  I had a longer reply, but lost it when pressed the wrong button. I think I have found that Money ignores the <DTPRICEASOF> fields, and instead uses the <DTASOF>  field. The GMT date thing may be working in your favor at times in this case.

  The good thing is that transactions, such as Buy, Sell, and Dividend, have no problem. So the quotes being remembered a day off less important. But still, I think it will get solved.

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

  I have a further thing to report. I did experiments with my Money Deluxe Plus (not Sunset) install. I have determined two things. The same quote-date anomaly exists when Money Deluxe Plus  does the downloading on its own without the MoneySense scripts. It is just mostly hidden by the Microsoft Quote server, which will be going away at the end January. You can see this happening if you look at your Quote History in Money and see quotes for Saturday or Sunday dates. Those will have "Update" in the Source column, whereas those from the  Microsoft Quote server will show "Online" in that column.

  I also determined that the symbol field is not necessary for quotes brought in via the OFX files. I blanked some symbols. The quotes got read in -- obviously because Money used the CUSIP. This would mainly of interest for Listed Options users, I would think.

  • Edited by Cal LearnerModerator Monday, January 10, 2011 8:46 PM added more findings

  Monday, January 10, 2011 5:24 PM

  Moderator
• 

  

  0

  Sign in to vote

  Since i use PocketSense everyday, I get Yahoo quotes for Saturdays and Sundays too, but naturally they are repeats of Friday's closing price.

  
  I have written a scrubber into scrubber.py for Fidelity. I held off downloading Monday, and did download today-- Tuesday. The Monday closing prices were downloaded and correctly recorded as Monday in Money. Success.

   PS: I DID one for Vanguard too. It looks much smaller and cleaner than my one for Fidelity. I may modify my Fidelity one to use that method. If you characterize  how the <DTASOF> fields for Ameritrade should be munged, I could maybe try that too. The code below is a little off in appearance, but it is not too mangled.

  def _scrubVanguard(filename,siteURL):
      #replace good timestamp from first <DTPRICEASOF> for any <DTASOF> dates
      print 'Scrubbing ', filename
      f = open(filename,'r')
      ofx = f.read() #original ofx file as received
      #search pattern string is from <DTPRICEASOF> up to (whitespace or '<')
      x = re.search("<DTPRICEASOF>(\d[^<\s]*)",ofx)
      date2use = x.group(1) #the replacement date
      ofx2 = re.sub("<DTASOF>\d[^<\s]*", "<DTASOF>"+ date2use ,ofx)
      #write the new version to the same file name

      #close the input file
      f.close()

      f = open(filename, 'w')
      f.write(ofx2)
      f.close
      return
      #end of _scrubVanguard

  • Edited by Cal LearnerModerator Thursday, January 13, 2011 6:30 AM added comment on Vanguard scrubber

  Wednesday, January 12, 2011 3:01 AM

  Moderator
• 

  

  0

  Sign in to vote

  This post should be of interest only to more adventuresome users of PocketSense scripts. The problem being addressed is if the stored dates on quotes are a day  off. Not a big deal, but that is what the scrubber is about. I think my Fidelity scrubber is working now, but there could be problems.

  edit... posted scrubber removed... working on improvements. Will put up improved version later or upon request.

  • Edited by Cal LearnerModerator Thursday, January 20, 2011 4:55 AM removed link to scrubber.py

  Saturday, January 15, 2011 7:34 PM

  Moderator
• 

  

  0

  Sign in to vote

  I put up another prototype PocketSense file. This one makes the associated date for quotes fetched from the quotes.py module from the Yahoo server be the time returned for the first quote fetched. This is in contrast with the original module which use the current time of fetching to generate a time stamp.

  I left this one in a not-cleaned up state. So it generates a log that will be meaningless to others. But it works, and I will be trying it for a while.

  However I suggest not downloading quotes between when the market opens until about an hour after market close. The reason for that is that the quotes are in flux during that interval. Fund NAVs are usually fixed within an hour of market close.

  So this quotes.py could be of interest to the more adventurous. Expect some functionally-similar mod to be made to the official files at some point.

  edit.... removed link because code needs work. Fidelity scrubber applying earlier date than it shold have. Investigating.

   

  • Edited by Cal LearnerModerator Wednesday, January 19, 2011 5:51 AM removed link

  Tuesday, January 18, 2011 8:49 PM

  Moderator
• 

  

  0

  Sign in to vote

  Ressom,

   

  I'm having a hard time setting up my Amex card in PocketSense, can you walk me through it?  Following is what I have in sites.dat:

   

  <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:
      timeOffset :
  </site>

  Thursday, August 18, 2011 9:56 PM
• 

  

  0

  Sign in to vote

  Edit: Site data originally posted in this post was wrong, since Amex has stopped accepting the settings. I  deleted the Money and 1700, which left this which did work:

   

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

   

  
  
  

  • Edited by Cal LearnerModerator Friday, August 19, 2011 2:41 PM

  Thursday, August 18, 2011 10:35 PM

  Moderator
• 

  

  0

  Sign in to vote

  Cal,

  Thanks for the quick response.  I cut and pasted the <site> entry with the one you posted and confirmed that I can log into https://home.americanexpress.com/home/axpi/ with my username and password.  A "test" of the account in Setup.py resulted in an "Error in OFX message".  The Amex*.ofx file in my xfr folder included the following:

  <OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>2000<SEVERITY>ERROR<MESSAGE>[ofx.unsupportedClientApplication]
  Client application or version is not supported by this server.
  [ref: 20110819124333.578]</STATUS><DTSERVER>20110819054333.578[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI><START.TIME>20110819054333</SONRS>

  </SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>c934e67f39b74d419b74e6a9f659f114<STATUS><CODE>15500<SEVERITY>ERROR</STATUS>

  <CLTCOOKIE>4</CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>

   

  Please note that the previously logged Amex*.ofx using the <site> entry I had previously posted was as follows:

   

  <OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>Login successful</STATUS><DTSERVER>20110818151854.872[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI><START.TIME>20110818151854<ORIGIN.ID>FMPWeb</SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1>

  <CCSTMTTRNRS><TRNUID>2d1708c7bf284af1af5e34852069c913<STATUS><CODE>2003<SEVERITY>ERROR</STATUS><CLTCOOKIE>4</CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>

   

  With the <site> entry you provided, login was not achieved, with the <site> entry I had originally used login was achieved but a fualt occured, Code 2003, which my research indicates is an "Account not found  (Error)".

   

  What do you think?

  Friday, August 19, 2011 12:58 PM
• 

  

  0

  Sign in to vote

   

  I had thought that Amex was still working with that setting for me
  identifying as Money because the OFX file was appearing in my xfr frile. Since I hold the card, but have not put
  transactions lately, I did not notice that my returned OFX file
  actually includes this:
  ****************************************
  <STATUS>
  <CODE>2000
  <SEVERITY>ERROR
  <MESSAGE>[ofx.unsupportedClientApplication]
  Client application or version is not supported by this server.

  ****************************************************

  I don't know if the info at http://microsoftmoneyoffline.wordpress.com/2010/10/06/cal-learners-review-fidelity-401k-citi-card-and-vanguard-account-info/ is going to fix it. I will try.

  I will removed the bad site data from my above post to avoid causing more problems.

  Sorry for the bad info.

  Edit:

  This one does work for me:

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

  I see that matches the one on Ameridan's site but the URL does not match the one you had been using. So I think this is going to work for you.
  
  

  • Edited by Cal LearnerModerator Friday, August 19, 2011 2:42 PM add site descriptor data

  Friday, August 19, 2011 2:30 PM

  Moderator
• 

  

  0

  Sign in to vote

  I don't think AE supports appid/appver: Money/1700 anymore. You can leave them blank (I believe PocketSense default to QWIN) or use

  appid      : QWIN
  appver     : 1900

   

  Regarding the second error: code 2003. Yes, that indicates that account not found. Usually that means you specify the wrong account number. In my quick test, for a working AE setting, I added an X to my account and I got same error.

  Caveat: I am not a direct PocketSense user but use tool of same protocol to get AE statement. See

    . http://code.google.com/p/hle-ofx-quotes/wiki/Download_Statements_Tips

    . http://code.google.com/p/hle-ofx-quotes/

   

  Friday, August 19, 2011 2:42 PM
• 

  

  0

  Sign in to vote

  The reasoning for the appver is explained on this Blog page http://microsoftmoneyoffline.wordpress.com/appid-appver/ 

  No one should be using 1700 any longer.   I will make sure that my Blog page of working settings that Cal referenced in his most recent comment doesn't contain that setting as well.

  Gregg - let us know what settings you end up with that work, and I'll make sure the reference page reflects those.

  Friday, August 19, 2011 2:56 PM
• 

  

  0

  Sign in to vote

  I cut and pasted Cal's updated <site> entry and was able to successfully run a test transaction download via Setup.py.  Thanks for all your help and input!  I have now been able to successfully set up my Bank of Stockton savings and checking as well as the Amex.  Now we're on to the CapitalOne card...

  Friday, August 19, 2011 3:49 PM
• 

  

  0

  Sign in to vote

  I spent some time researching urls that might provide access to OFX files for the CapitalOne credit card, as I think most of you know, I didn't have any luck.  Any suggestions?

  Saturday, August 20, 2011 2:52 PM
• 

  

  0

  Sign in to vote

  I suggest you look at http://microsoftmoneyoffline.wordpress.com/2010/10/06/cal-learners-review-fidelity-401k-citi-card-and-vanguard-account-info/ and search for each occurance of "Capital One".

  Saturday, August 20, 2011 3:03 PM

  Moderator
• 

  

  0

  Sign in to vote

  Thanks for the suggestion Cal, I tried that yesterday with no luck.  Conventional wisdom on my google searches is that I'll have to download directly from the CapitalOne credit card website.

  Saturday, August 20, 2011 3:39 PM