Ellen's Fidelity troubleshooting-- replacement thread.

211 views
Skip to first unread message

Cal Learner

unread,
Jul 11, 2023, 9:15:59 AM7/11/23
to Microsoft Money
Ellen, and all: I messed up. I meant to delete my latest posting, but I accidentally deleted the whole thread. I got concerned that my scrubbing was incomplete.  The thread had several posts  including a segment from ofx_config.cfg, and Ellen said hers matched. Ameridan  and Ellyn contributed very useful information, and I killed that too. I have moderation power to delete.   I promise to be much more careful in the future.

 I still had the post I had intended to delete, so here that is with the sanitizing checked and completed: 

 Ellen: I did not understand that you did not see a batch file but you deleted it.

I also got to wondering if you have two versions of Python, and the wrong one was somehow running. I had that at one point, and I forget what the symptoms were.

Anyway, here is another comparison  that I am sure will not match yours. I am thinking yours will say <SEVERITY>ERROR. Maybe the message will have a clue.   From my XFR folder, this is the start of a Fidelity OFX file, with FITID and account number sanitized:

===========================
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>SUCCESS
</STATUS>
<DTSERVER>20230711060835.140[-4:EDT]
<LANGUAGE>ENG
<FI>
<ORG>fidelity.com

<FID>7776
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<INVSTMTMSGSRSV1>
<INVSTMTTRNRS>
<TRNUID>123xxxyyyzzzaaabbbccddd
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>SUCCESS
</STATUS>
<INVSTMTRS>
<DTASOF>20230710120000
<CURDEF>USD
<INVACCTFROM>
<BROKERID>fidelity.com
<ACCTID>123456789
</INVACCTFROM>
<INVTRANLIST>
<DTSTART>20230611120000
<DTEND>20230711060835.401[-4:EDT]
</INVTRANLIST>

Ellen S

unread,
Jul 12, 2023, 12:05:51 PM7/12/23
to Microsoft Money
no worries, Cal.  Here's what I recall of how the thread ended:  I noticed the order of company listing from SETUP didn't match the order in SITES, but Ameridan said they were meant to display in alpha.  I also noted my Schwab SITES entry didn't come up, but maybe the entry wasn't quite right.   You didn't find anything wrong with my ofx_config.cfg.  Ameridan said to look at the getdatasomething.bak file, which was the short cut for GETDATA, but I had already suspected the shortcut and deleted it, and then ran GETDATA from the Pocketsense directory, with no change in outcome for fidelity.   But my ticker downloads are now working again after installing the yahoo v10 repair.  and here we are.

I did at one point try python 3.x but had errors and went back to Python 2.7; the latest .exe files are from 2020; most of the folders are dated 7/23/2022; folders lib and scripts are dated 1/14/2023.  I recall having some Money Sunset problems last summer and then again last winter when the program kept crashing; I think it was a faulty DLL file that you helped me fix, and I must have returned to 2.7 during this period as well.

I don't have time now to look at the rest of your post, will check back in probably tomorrow.
 
thx

Martin Cole

unread,
Jul 12, 2023, 6:09:48 PM7/12/23
to Microsoft Money
Guys
For my investments I use the Performance View.
Has anyone any idea why similar investments are showing as 'n/a' in the Ann.Ret. column?
Like this screen shot below, two cash investments only income is interest they use to both show a % (however sad it is!)  but one now only declaring 'n/a'.
I can find no Zero value entries and the two investment's setting are the same.
The 'TR All' column works fine!

Inline image

Many thanks in advance

Martin

joe dempsey

unread,
Jul 12, 2023, 6:38:34 PM7/12/23
to Microsoft Money
Me too

I think it's because I have a share I've held for many, many years and Money runs out of memory trying to calculate the return - try updating the current price to different values and you will find that it will calculate the Annual Return for some values but not for others 



Cal Learner

unread,
Jul 12, 2023, 10:58:11 PM7/12/23
to Microsoft Money
Martin: There is a bug in the Portfolio software. It usually comes from an investment that has appreciated a lot.
Somewhere I have about 4 or 5 transactions that can be entered into a test file and reproduce that, at least for a stock. 

Now is yours the same way as bug I am thinking of? Not sure. If you are not talking about the Portfolio, then not the same.

Ellen S

unread,
Jul 13, 2023, 7:57:31 PM7/13/23
to Microsoft Money
Cal, 
from my Fidelity OFX file, the only difference I see besides the error message (and lack of carriage returns) is that <CODE> is different.   Yours says '0' mine says '15500'.  Also, it looks like you're downloading 2 accounts, while mine stops sooner.

FWIW, it looks like you sanitized <TRNUID> but my entry there looks like an unrecognizable alphanumeric sequence.  I blanked mine anyway in case it reveals something it shouldn't.

Finally, I found myself wondering where you are located.  Is it possible we are logging into different Fidelity servers?

First group from OFXHEADER to NEWFILEUID:NONE completely matches yours

then:

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>15500<SEVERITY>ERROR<MESSAGE>Error occurred logging in</STATUS><DTSERVER>20230710221940.994[-4:EDT]<LANGUAGE>ENG<FI><ORG>Fidelity.com

then

<FID>7776</FI></SONRS></SIGNONMSGSRSV1><INVSTMTMSGSRSV1><INVSTMTTRNRS><TRNUID>**************************<STATUS><CODE>15500<SEVERITY>ERROR<MESSAGE>Error occurred logging in</STATUS></INVSTMTTRNRS></INVSTMTMSGSRSV1></OFX>





On Tuesday, July 11, 2023 at 9:15:59 AM UTC-4 Cal Learner wrote:

Cal Learner

unread,
Jul 13, 2023, 8:42:04 PM7/13/23
to Microsoft Money
https://www.quicken.com/support/error-15500-or-2000-updating-accounts-quicken-mac

The financial institution's server returned a response containing an OFX error 15500 "The user entered an invalid user ID or password. Ensure that the customer ID and the password entered are correct."

Make sure that the user name and password are the same as what you log into the website with, including making the password the same case.

Cal Learner

unread,
Jul 14, 2023, 12:04:12 PM7/14/23
to Microsoft Money
I see https://www.fidelity.com/psw/WS_PSW_Body_Frame/0,,PROBLEMS,00.html says "Your User ID is case-sensitive."

Cal Learner

unread,
Jul 14, 2023, 1:06:58 PM7/14/23
to Microsoft Money
I did a test with my login to the Fidelity website. I changed the case of one of my user ID letters, and the login still works. So I infer that the Fidelity Investments User ID is *not* case sensitive.

What I propose as a test, for you, is to log in to Fidelity on the web. But to enter your user ID and password, copy  from the 
ofx_config.cfg file, and paste into the browser. I am particularly interested in if the user ID matches.

And speaking of ofx_config.cfg, I keep copies named ofx_config.cfg.bk1, ofx_config.cfg.bk2, etc.

Also, while I am at it, I will point out that when I want to change my Fidelity credentials, I change my User ID. Sometimes just the User ID and sometimes both. If I were to enter the wrong password for the right user ID several times, it would lock me out of the website. If I give the wrong user ID, I don't get locked out. Some other person could have been locked out inadvertantly, but I now make sure that my User ID is one that is unlikely to be used by anybody. This last paragraph is not aimed at your PocketSense problem, Ellen, because if you were not getting into the website, you would have noticed. So, who is this paragraph aimed at? Somebody who automates the PocketSense access. I did that once -- changed the password on one computer, but forgot to change the PocketSense password on the other computer I was trying to get automated access working on. Got myself locked out of the website, and had to call  to get that reset. Now I change the username (User ID) if I make a change in Fidelity credentials.

Ellen S

unread,
Jul 14, 2023, 2:03:47 PM7/14/23
to Microsoft Money
Cal, I have these recurring fears that I have been entering my credentials wrong all this time and then be exposed as an idiot and waster of other peoples' time.   But I just now tried again:  directly logging onto fidelity's web site (success), logging onto the website using a copy of the password from ofc_config.cfg (success), checking the logon stored in Edge (match).   Then:  resetting Setup logon (option 3) - nogo, modifying Setup logon (option 1) - nogo.  I tried proceeding past the option 1 setup logon Error to configure the individual account--nogo, and then also tried adding a 2d Fidelity account - nogo.    Just not seeing where the glitch could possibly be.

I have not been keeping backup copies of ofx_config.cfg, have not noticed any changes during the download attempts, but don't the new GETDATA and SETUP log txt files record the same info?  When I checked recently, it looked like they insert the new run info ahead of the previous run log.  Not sure how many runs they store.

I'm prepared to let this go and add transactions manually, if you can't think of anything else to try.   It's quite the conundrum.



Ellen S

unread,
Jul 14, 2023, 2:10:59 PM7/14/23
to Microsoft Money
correction, I logged onto Fidelity using a userID copied from ofc_config.cfg, as suggested.   I'm sure you're correct that the userID is insensitive to case. 

Cal Learner

unread,
Jul 14, 2023, 3:38:44 PM7/14/23
to Microsoft Money
I like a puzzle. But I am running short of ideas. But don't feel you have to hurry. Wait until you feel like it.

I presume you also tried copy and paste of the password to try for web access.

I have not yet put in the newest version with the new logging. I should. You could delete, or rename, the log file(s). Then use setup.py to run the Fidelity account. That should give only info relevant to the Fidelity try. If you scrub that and post, I could maybe try the new version and compare logs.

I presume you run "setup.py" and getdata.py. I don't know if you run from a command (CMD) window.

Here is a 3-line python program to make sure that the file associations are getting you to the right compiler.
============begin test1.py===================
import sys
import platform
print(sys.version)
================end test1.py================

Then run test1.py. The printout on mine for one computer starts 2.7.12 and on another computer it is 2.7.17. Yours is probably in that range.

Also, if the path is set up for the compiler, if you type this, you may get the same version info:
python --version

Cal Learner

unread,
Jul 14, 2023, 9:46:42 PM7/14/23
to Microsoft Money
OK, I did it... sorry for the delay. Consider Notepad++ for viewing your log.
My procedure:

Kept copy of my existing PocketSense folder contents.

Downloaded contents of newer version 6-22-2023 over my existing folder

Temporarily caused my personalized scrubber to not run by renaming it.

Did Setup.py test for just small account, copied debug.log to hugetst0.txt

Make Debug = True in control2.py

In Setup.py, I did "7. Test Account", It asks if I should send to Money. I say yes. Log did not get written until exiting.
 
The scrubbed and redacted debug.log follows in the next post:

Cal Learner

unread,
Jul 14, 2023, 9:48:24 PM7/14/23
to Microsoft Money
2023-07-14 20:14:17,095 - WARNING - **DEBUG Enabled: See Control2.py to disable.
2023-07-14 20:14:17,098 - DEBUG - xfrdir = .\xfr\
2023-07-14 20:14:17,098 - INFO - PocketSense OFX Download Python Scripts, Ver: 2023-Jun-24
2023-07-14 20:14:29,184 - DEBUG - urlHost    :ofx.fidelity.com:443
2023-07-14 20:14:29,184 - DEBUG - urlSelector:/ftgw/OFX/clients/download
2023-07-14 20:14:29,184 - INFO - FIDELITY: AcctNum: Getting records since: 20230613
2023-07-14 20:14:31,075 - DEBUG - *** SENT ***
2023-07-14 20:14:31,075 - DEBUG - HEADER: {'Content-Length': '723', 'Connection': 'Keep-Alive', 'Accept': 'application/x-ofx', 'User-Agent': 'InetClntApp/3.0', 'Host': 'ofx.fidelity.com:443', 'Content-Type': 'application/x-ofx'}
2023-07-14 20:14:31,075 - DEBUG -
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20230714201429
<USERID>MyUserID
<USERPASS>My_Password

<LANGUAGE>ENG
<FI>
<ORG>fidelity.com
<FID>7776
</FI>
<APPID>QWIN
<APPVER>2700

</SONRQ>
</SIGNONMSGSRQV1>
<INVSTMTMSGSRQV1>
<INVSTMTTRNRQ>
<TRNUID>7ae6b84f-a1c9-4547-a6a3-34d200505f2d
<INVSTMTRQ>
<INVACCTFROM>
<BROKERID>fidelity.com
<ACCTID>AcctNum
</INVACCTFROM>
<INCTRAN>
<DTSTART>20230613
<INCLUDE>Y
</INCTRAN>
<INCOO>Y
<INCPOS>
<DTASOF>20230714201429
<INCLUDE>Y
</INCPOS>
<INCBAL>Y
</INVSTMTRQ>
</INVSTMTTRNRQ>
</INVSTMTMSGSRQV1>
</OFX>
2023-07-14 20:14:31,075 - DEBUG - *** RECEIVED ***
2023-07-14 20:14:31,075 - DEBUG - HEADER:{'Content-Length': '6499', 'X-Content-Type-Options': 'nosniff', 'Set-Cookie': 'JSESSIONID=F407457AF27E2D893D8A7F44A6191ECA; path=/ftgw/OFX; secure; httponly, _abck=.......bunch of mystery characters scrubbed out of here..... ==~-1~-1~-1; Domain=.fidelity.com; Path=/; Expires=Sun, 14 Jul 2024 01:15:21 GMT; Max-Age=31536000; Secure, bm_sz=25CC9FF74F2656CBC6CE37B621ECD61F~YAAQTMvVF5VwvyiJAQAAhtkdVxQ71u7IgO+s3stJpKJDNhwxe6+FHFMq1i9XOiSOfnr34P/iK8SJXgBe2V/nOt06UJsHmKkqcC5MZbRA/5rCwSD71ZBLGPfkGSIiDRcPe8uCMPfkqiRrIanYsOY/M4vAuhnh6S94TrAgWe6bhCT8TRVY8etYeHfR6OVbaqbBVi1GSBJhHNd+9cqdIwvTW70R9UGqzAl875eHaJfmGFvn9SeO9T+b/MflKuE99yVbIqfFOctPMFYxZ32spWN9BhPrrpKMe4DHYYucPwS8aOQCcbtzkw==~3355956~3158834; Domain=.fidelity.com; Path=/; Expires=Sat, 15 Jul 2023 05:15:20 GMT; Max-Age=14399', 'fscalleeid': 'https-ofx.fidelity.com-10000', 'Strict-Transport-Security': 'max-age=31536000', 'Server': 'Apache', 'Connection': 'keep-alive', 'fsreqid': 'REQ64b1f328352f3e388c814861b352aa33', 'fselapsedtime': '506839', 'Date': 'Sat, 15 Jul 2023 01:15:21 GMT', 'X-Frame-Options': 'SAMEORIGIN', 'Content-Type': 'application/x-ofx; charset=iso-8859-1', 'P3P': 'CP="UNI DEM GOV FIN STA COM NAV PRE INT ONL CUR ADM DEV PSA PSD CUSi IVDi IVAi TELi CONi TAI OUR OTRi"'}
2023-07-14 20:14:31,075 - DEBUG -
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20230714211520.973[-4:EDT]<LANGUAGE>ENG<FI><ORG>fidelity.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><INVSTMTMSGSRSV1><INVSTMTTRNRS><TRNUID>7ae6b84f-a1c9-4547-a6a3-34d200505f2d<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><INVSTMTRS><DTASOF>20230714033014.000[-4:EDT]<CURDEF>USD<INVACCTFROM><BROKERID>fidelity.com<ACCTID>AcctNum</INVACCTFROM><INVTRANLIST><DTSTART>20230613000000.000[-4:EDT]<DTEND>20230714211521.260[-4:EDT]<BUYMF><INVBUY><INVTRAN><FITID>AcctNum18201320230630<DTTRADE>20230630000000.000[-4:EDT]<MEMO>REINVESTMENT</INVTRAN><SECID><UNIQUEID> ....A lot OFX stuff deleted here.......</SECLIST></SECLISTMSGSRSV1></OFX>
2023-07-14 20:14:31,082 - INFO - + Scrubber: Null time values updated.
2023-07-14 20:14:31,092 - INFO - Download completed successfully
2023-07-14 20:14:46,056 - INFO - -----------------------------------------------------------------------------------

martcole61

unread,
Jul 15, 2023, 3:50:01 AM7/15/23
to joe dempsey, Microsoft Money
Interesting, I will give that a look.  I could understand total return having that issue but not annual return that is just looking back a year.  I'll experiment later.
Cheers for sharing the thoughts and comparison.



Sent from my Galaxy
--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/4460369c-1527-4b91-826e-5c7da2a33dd2n%40googlegroups.com.

Dan Adkins

unread,
Jul 15, 2023, 8:52:23 AM7/15/23
to martcole61, joe dempsey, Microsoft Money
I'm pretty sure the Ann Ret column is not annual return "looking back one year", but rather (per https://microsoftmoneyoffline.wordpress.com/portfolio-columns-in-microsoft-money/ ) Total Annualized Return, which "Returns for the short-term investments are projected to one year; returns for the long-term investments are averaged to one year".

First Name Last Name

unread,
Jul 15, 2023, 9:58:38 AM7/15/23
to Ellen S, Microsoft Money
> I'm prepared to let this go and add transactions manually, if you can't think of anything else to try.   It's quite the conundrum.
If you'd like to try an alternate path (if anything to check if the account credential is OK or not), I can give you a quick pointer on how to use hleofxquotes to download Fidelity OFX. Let me know.

First Name Last Name

unread,
Jul 15, 2023, 1:06:13 PM7/15/23
to Microsoft Money
hleofxquotes tool can also download OFX from various FI such as Fidelity. This capability has been there for a while but I did not advertise it since other tools such as PocketSense seems to have worked well for most people for tthat purpose.

Someone has asked about the "Statement" tab recently so I thought I would put down some notes here.

To use OFX download, switch the bottom tab to "Statement".

image.png

Next, you need to create an FI (Financial Institution). For example, Fidelity.
Menu: File -> Financial Institution -> New FI

Choose from a list of template for the drop down list, Choose "Fidelity"
image.png
Click "OK"
Then Select "Fidelity" from the top list
image.png
Next, update values in the bottom "Properties" panel.
If you have more than one account, my suggestion is to try to get 1 account working first.
After you've update your id/password and account id, save using popup menu Properties -> Save

image.png

Then click on "Download" to download the currently selected FI (Fidelity). 

image.png

"Response" tab will show the OFX response.
"Error" tab will show error (if any)

You can then click "Import" to import the just download OFX from the select FI to Microsoft Money (essentially just open the OFX file)

Ellen S

unread,
Jul 16, 2023, 6:09:24 PM7/16/23
to Microsoft Money
Cal, I've read your 3 recent posts, but frankly, am a bit lost.   Looks like you've just downloaded the newest Pocketsense to try out the new log files (vs opening the Fidelity ofx file in XFR), then you stopped your scrubbers and ran the new SETUP for a small Fidelity account and tested that account.   Is that right?   but then you lost me at debug; I don't have any files or folders called debug.   am I supposed to have one? do I need to turn something on? and then compare its contents to your debug.log in the 3d post?

Ellen S

unread,
Jul 16, 2023, 6:24:14 PM7/16/23
to Microsoft Money
Hi hleofxquotes, yes thanks, I'm interested in trying this tool.   Where's the best place to download it?   FYI, I saw a Reddit post from Dec 2022 that says it no longer works.  But I assume it still works for you or you wouldn't have mentioned it.   
Also wondering:  I saw the Gaiersoftware.com message about its msmoneyquotes tool hitting a brick wall on 6/23/2023.  Is this (hleofxquotes) the other tool mentioned in that message?    Gaier Software - MSMoneyQuotes - Details and Help  

Are these the only tools out there--Pocketsense, hleofxquotes and msmoneyquotes-- for retrieving (or recently retrieving) account data? 

Cal Learner

unread,
Jul 16, 2023, 10:02:25 PM7/16/23
to Microsoft Money
Ellen, this  enabling of logging requires changing control2.py. Originally, Line 21 is not commented out,  and line 22 is. If you comment out line 21 and un-comment line 22, so that becomes "Debug = True", then you will get that logging.

Feel free to delete, or rename, debug.log between runs. Else the file keeps growing, which is not a problem in itself, but could make it harder to look at.

Cal Learner

unread,
Jul 17, 2023, 8:52:02 AM7/17/23
to Microsoft Money

On  https://pocketsense.blogspot.com/ main page, it used to say this on the screen without clicking further:
6-22-2023:  Logging functionality added.  A log file is now created for the GETDATA and SETUP scripts (i.e., getdata.log and setup.log).  An important note is that enabling Debug (via control2.py) will write complete ofx messages to the associated log, including full request and response packets.  This means that sensitive data typically found in ofx messages may be written to a log when Debug is enabled (e.g., username and/or password).  A warning message will be shown when starting either script if an ofx username or password field is found in the log, as a reminder. It is recommended that log files be deleted after using Debug mode to start fresh with empty logs, since standard (non-debug) logging does not contain sensitive info.  Needless to say, do NOT share log files without sanitizing.

With the Yahoo quotes alert added, you have to click    Read more » to see that text.

First Name Last Name

unread,
Jul 17, 2023, 12:07:13 PM7/17/23
to Microsoft Money
> Where's the best place to download it? 
The best place to download is from here: https://bitbucket.org/hleofxquotesteam/hleofxquotes/downloads/. There are two versions
  1. Microsoft Installer - this is easiest to install but you will see a warning from Microsoft (on "unknown publisher", due to the fact that I did not pay Microsoft): https://bitbucket.org/hleofxquotesteam/hleofxquotes/downloads/hleOfxQuotes-1.0.326.msi
  2. Zip file: https://bitbucket.org/hleofxquotesteam/hleofxquotes/downloads/hleOfxQuotes-gui-Build_20230715_326.zip. You will need to install (one-time) Java which you can get from here: https://adoptium.net/en-GB/temurin/releases/ (choose version JDK 17)
> FYI, I saw a Reddit post from Dec 2022 that says it no longer works.
It is working.


Ellen S

unread,
Jul 17, 2023, 2:04:32 PM7/17/23
to Microsoft Money
Thx, hle, will try it next weekend.

Ellen S

unread,
Jul 17, 2023, 2:31:48 PM7/17/23
to Microsoft Money
Cal --  SUCCESS!!!   I used debug, compared line by line with yours, made a discovery and tested.

I discovered that your '<ORG>fidelity.com' is lowercase while mine was uppercase (i.e., Fidelity.com).  Not sure how we missed that since we both examined and compared the SITES code.

Then, I decided to delete Fidelity and add it back during SETUP.   When adding back, I deliberately entered an incorrect password.  Then I tried again with the correct password, and voila.  Perhaps I should have run it before changing the password b/c now I'm not sure which change fixed it, but it now works, and I am a very happy camper.  Thanks for sticking with me.   

BUT now I have a new problem:  one Fidelity account is loading to the wrong account in Money.   For this retirement account, Money never asked where to load it, and when I saw the transactions loading wrong, it asked if I wanted to move them to another account, so I redirected them to the correct account, but they remained in the first loaded account too and still won't go to the right account on new runs.  I tried resetting and then deleting and adding that account in SETUP, but the damage is done, it won't load properly.   Is there a way to fix this?  

Cal Learner

unread,
Jul 17, 2023, 5:53:00 PM7/17/23
to Microsoft Money
I would not have guessed that the ORG would be case sensitive.. I am very pleased at the progress.

Regarding the info coming into the wrong account, here are some notes below. They are aimed at web download, but maybe the same techniques would apply. Keep an extra copy of your file and also keep a copy of the backup file that preceded this. Or maybe you will need to restore that backup, make the changes suggested below (blank the FI in the wrong account, or change the currency), and import again

If I want to re-download the same OFX file, I will often run that file from the XFR folder. Microsoft Money is associated with *.ofx files during installation.

==========notes:===========
If OFX Web statements are placed in the wrong account, blank the
Financial Institution (FI) for the *wrong* account in account
settings.  Do that in the Account Settings/Details, which you can
reach by right-clicking the account name on the Account List.  Don't
just change the FI.  Blank it using the Delete or Backspace keys.

On the Account List, if there are transactions to read for the
wrong account, right-click TransactionsToRead, and then click
Delete Statement.

Import the OFX file.  Money should ask which account to use.  Tell
Money the statement should go onto the right account.

Put the FI for the *wrong* account back.


If that does not fix it, there is a methode where you temporarily
change the currency of the wrong account. You can experiment with that.
See https://social.microsoft.com/Forums/en-US/5c28b013-2638-49b5-9880-64ea8a7a5e5a/one-bank-ac-not-accepting-ofx-downloads?forum=money
which also has a picture illustrating.

Ellen S

unread,
Jul 22, 2023, 6:06:16 PM7/22/23
to Microsoft Money
Cal,
I tried both methods (deleting FI name and changing currency), to no avail.   FYI, changing the currency only led Money to tell me to change the currency back to USD to match the incoming data, but it still wanted to download to the wrong account.   

Then I tried closing that (wrong) account, and money finally let me redirect the incoming transactions.   This was on the test file, so I decided to try it on the main file.  I couldn't tell if it worked because I had previously inputted the last transactions manually, there were no new transactions and money didn't ask where to put the data.   I actually thought it might still be going to the wrong (now closed) account, but they weren't there.  The GETDATA log report lists the correct account but not the wrong "closed" account, so maybe I'm good.   Maybe next week I'll try reopening that wrong account, see what happens.  any case, I am much better off today than a week ago, so no complaints, many thanks.
Ellen

Martin Cole

unread,
Aug 1, 2023, 3:04:19 PM8/1/23
to Dan Adkins, joe dempsey, Microsoft Money
Sorry guys, I have been away
The idea of changing the first date for this investment (which was 1970, when I was 9!!) worked a treat!!  It was only minimal part of the investment (gift from a Grandmother but started me on a track....) and I am one for detail
As always I appreciate your input and advice

Martin



Cal Learner

unread,
Aug 1, 2023, 3:35:33 PM8/1/23
to Microsoft Money
"The idea of changing the first date for this investment (which was 1970, when I was 9!!) worked a treat!!  It was only minimal part of the investment (gift from a Grandmother but started me on a track....) and I am one for detail
As always I appreciate your input and advice)

Which way from 1970, and how much? I am going to guess that you changed to a later date.
Reply all
Reply to author
Forward
0 new messages