As a continuation from the last blog I have PocketSense back up and running in Microsoft Money since getting my computer hacked last week. Thanks everyone for the help!
One thing I'm still having a problem with. I had the same problem in January when I did a clean install and solved it but should have kept notes on what I did.
Under Favorites/Favorite Web Sites I had a link named Update Prices that I would click and it would run Getdata.py - Shortcut. It pointed to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk. For the life of me I cannot get that link saved under Favorite Web Sites. I do have a shortcut D:\Microsoft Money\OFX Scripts but it just opens the folder in Microsoft Money.
Where are these Favorite Web Sites stored? I believe many years ago they were stored in Internet Explorer. Maybe that would help me solve this. Thanks!
I have the Windows Firewall prevent Microsoft Money from accessing outside servers. That is to prevent Money from waiting for servers that are gone. If you did that, that might or might not mess up the process.
I have some notes on some previous discussions we have, but I cannot find those discussions. Joe: I did some experimenting, and I am having trouble posting what I want to describe. Let me say I did put a link into favorites, and it appeared in into folder "%USERPROFILE%\Favorites\Financial Links"
The entry was the file type described in https://fileinfo.com/extension/url
See if http://pocketsense.blogspot.com/2025/03/comments-continued.html#comment-form helps. There are steps about getting an entry into place. I think you are already aware of the info in http://moneymvps.org/faq/article/352.aspx
Also consider having the shortcut point to a *.bat file rather than the GetDat.py file. In that batch file, start with a CD (change directory) to the folder that contains your PocketSense files.
I have a file called lines.txt in my PocketSense folder. This contains at least 4 blank lines. Then I invoke getdata with this line in the batch file: getdata.py < lines.txt That causes getdata.py to run to completion, taking all of the defaults, rather than waiting for a response. It presses the Enter key for me up to 4 times.
One of my batch files starts Money with this line in a batch file: start "" /D "C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles" msmoney.exe
That line starts Money, but does not wait until the process ends before continuing on with the rest of the batch file. That would be appropriate for starting Money but not for invoking GetData I think.
The other thread is locked, but I wanted to say thank you Robert for this idea. I often forget to add a file to the imports folder before running the script as well and came to look in the comments for an answer to the same question. Ideally there would be an option to only process the imports folder, but it's a great workaround.
AnonymousFebruary 17, 2025 at 11:54 AM Hi Folks,
Is there a way to manually run the scrubber on files in the import folder? With the recent Amex change, I occasionally forget to download the OFX from Amex prior to running Getdata, so I'm looking for a way to do that part of the Getdata processing without doing all of the other accounts and downloads again.
Thanks!
Replies
Robert February 17, 2025 at 12:01 PM There's no setting to do it... however, you can create a new folder with a fresh copy of the scripts, and not configure any accounts, etc. Run setup once, and then getdata to process imports as needed.
Ah. We did it! Thanks, everybody, for pointing me in the right direction. In "%USERPROFILE%\Favorites\Financial Links" was my shortcut Update which would take me to my OFX Scripts file but not run Getdate.py - Shortcut. By right clicking on that shortcut, going to properties and changing the URL: to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk it now works.
That is, in Money, I can now go to Favorites>Favorite Web Sites and just click on Update to run Getdata.py.
Now another comment. When my computer was hacked the hacker was actually on my computer. Isn't it a concern that ofx_config.cfg has your user names and passwords and can just be opened with a text editor?
Yes. Change all of those passwords at a minimum, and changing your usernames would be a good move too.
PocketSense offers the option to encrypt that file, and require you to enter a password each time. I don't encrypt myself, and when I change password, I tend to modify ofx_config.cfg with Notepad++.
Good morning. Thanks for helping me with MS money quote update. For some reason, MS Money won't update any of my portfolio after python script run (script run fine, money open up fine and will stated update completed, but not a single ticker got updated). I deleted the "getdata.txt" and try the script again, same result. Any suggestion?
I'm using Pocketsense with Python 2.7.18 for downloads from Fidelity and Regions Bank. On another machine I'm using Pocketsense with Python 3.10.12 for the same financial institutions. The Python 3 version of Pocketsense I downloaded from Github https://github.com/magnuspyke/ofxscripts
Up until several days ago both were working as expected. Recently though, the Python3 version throws an OFX error with Regions Bank. It continues to work as expected with Fidelity.
The Python 2 version works as expected with both Regions Bank & Fidelity.
Does anyone have any ideas as to why the scripts may be erroring out for Regions with the Python 3 version but not the Python 2 version?
Pocketsense using Python 2 with Regions Bank requires the User Agent setting in sites.dat to be set to userAgent: none
Apparently, Pocketsense using Python3 with Regions Bank now requires the User Agent setting in sites.dat to be set to the actual User Agent. e.g. userAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0
An easy way the glean your particular User Agent is from https://whatmyuseragent.com/
I haven't used the python3 scripts, but curious if the default user agent would have worked. If useragent is set to none, then it's not defined at all. If it's omitted (i.e., not defined for the site entry), it defaults to "InetClntApp/3.0".
@Robert, I had first tried commenting out the entire userAgent line from sites.dat. I just now tried simply leaving userAgent entry blank. Both settings error out testing the account in Setup.py. Plunk the userAgent back in and it works as expected.
Since it worked as expected up until a few days ago with userAgent set to none; I can only assume that Regions Bank is tinkering with things.
Anyone having issues with E*Trade Brokerage? Since early May, it only seems to work sometimes. I’ve tried running setup again and it won’t even accept my login credentials now. I’ve opened a ticket with E*Trade, but I’m skeptical of their support for this issue. Any help would be greatly appreciated.
Thanks! Still can't get it to work with your settings. Are you using your regular login and password and 9-digit account number? I enabled third-party data access in etrade security setting, anything else I'm missing?
Yes using regular login and password and 9-digit account number. It was working just fine before 1 May. I don't know if they changed something or if this is happening because i enabled 2FA.
Thanks. I haven't enabled 2FA yet since I wanted to make sure ofx download works first. So now I can't be sure if it's my config or some issue on their end. Would you please post here if it starts working again for you?
Would you mind telling me the number of characters in your password? Also are there any special characters? Around this same time, I changed the length of my password to 24 characters
As a continuation from the last blog I have PocketSense back up and running in Microsoft Money since getting my computer hacked last week. Thanks everyone for the help!
ReplyDeleteOne thing I'm still having a problem with. I had the same problem in January when I did a clean install and solved it but should have kept notes on what I did.
Under Favorites/Favorite Web Sites I had a link named Update Prices that I would click and it would run Getdata.py - Shortcut. It pointed to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk. For the life of me I cannot get that link saved under Favorite Web Sites. I do have a shortcut D:\Microsoft Money\OFX Scripts but it just opens the folder in Microsoft Money.
Where are these Favorite Web Sites stored? I believe many years ago they were stored in Internet Explorer. Maybe that would help me solve this. Thanks!
I have the Windows Firewall prevent Microsoft Money from accessing outside servers. That is to prevent Money from waiting for servers that are gone. If you did that, that might or might not mess up the process.
DeleteI have some notes on some previous discussions we have, but I cannot find those discussions.
Joe: I did some experimenting, and I am having trouble posting what I want to describe. Let me say I did put a link into favorites, and it appeared in into folder
"%USERPROFILE%\Favorites\Financial Links"
The entry was the file type described in https://fileinfo.com/extension/url
That may be enough to get you going.
=========
Cal Learner
See if http://pocketsense.blogspot.com/2025/03/comments-continued.html#comment-form helps. There are steps about getting an entry into place. I think you are already aware of the info in http://moneymvps.org/faq/article/352.aspx
ReplyDeleteAlso consider having the shortcut point to a *.bat file rather than the GetDat.py file. In that batch file, start with a CD (change directory) to the folder that contains your PocketSense files.
I have a file called lines.txt in my PocketSense folder. This contains at least 4 blank lines. Then I invoke getdata with this line in the batch file:
getdata.py < lines.txt
That causes getdata.py to run to completion, taking all of the defaults, rather than waiting for a response. It presses the Enter key for me up to 4 times.
One of my batch files starts Money with this line in a batch file:
start "" /D "C:\Program Files (x86)\Microsoft Money Plus\MNYCoreFiles" msmoney.exe
That line starts Money, but does not wait until the process ends before continuing on with the rest of the batch file. That would be appropriate for starting Money but not for invoking GetData I think.
Cal Learner
Thank you! The batch file was the missing piece that got this working for me.
DeleteThe other thread is locked, but I wanted to say thank you Robert for this idea. I often forget to add a file to the imports folder before running the script as well and came to look in the comments for an answer to the same question. Ideally there would be an option to only process the imports folder, but it's a great workaround.
ReplyDeleteAnonymousFebruary 17, 2025 at 11:54 AM
Hi Folks,
Is there a way to manually run the scrubber on files in the import folder? With the recent Amex change, I occasionally forget to download the OFX from Amex prior to running Getdata, so I'm looking for a way to do that part of the Getdata processing without doing all of the other accounts and downloads again.
Thanks!
Replies
Robert February 17, 2025 at 12:01 PM
There's no setting to do it... however, you can create a new folder with a fresh copy of the scripts, and not configure any accounts, etc. Run setup once, and then getdata to process imports as needed.
Ah. We did it! Thanks, everybody, for pointing me in the right direction. In "%USERPROFILE%\Favorites\Financial Links" was my shortcut Update which would take me to my OFX Scripts file but not run Getdate.py - Shortcut. By right clicking on that shortcut, going to properties and changing the URL: to file:///D:/Microsoft%20Money/OFX%20Scripts/Getdata.py - Shortcut.lnk it now works.
ReplyDeleteThat is, in Money, I can now go to Favorites>Favorite Web Sites and just click on Update to run Getdata.py.
Now another comment. When my computer was hacked the hacker was actually on my computer. Isn't it a concern that ofx_config.cfg has your user names and passwords and can just be opened with a text editor?
Yes. Change all of those passwords at a minimum, and changing your usernames would be a good move too.
DeletePocketSense offers the option to encrypt that file, and require you to enter a password each time. I don't encrypt myself, and when I change password, I tend to modify ofx_config.cfg with Notepad++.
Cal Learner
Good morning. Thanks for helping me with MS money quote update. For some reason, MS Money won't update any of my portfolio after python script run (script run fine, money open up fine and will stated update completed, but not a single ticker got updated). I deleted the "getdata.txt" and try the script again, same result. Any suggestion?
ReplyDeleteHi, user error. I got it solved.
ReplyDeleteThanks so much for all of the support from this community!
ReplyDelete"Thanks so much for all of the support from this community!"
DeleteSarcasm Andrew?
Cal Learner
Hi All,
ReplyDeleteA bit of an anomaly...
I'm using Pocketsense with Python 2.7.18 for downloads from Fidelity and Regions Bank.
On another machine I'm using Pocketsense with Python 3.10.12 for the same financial institutions.
The Python 3 version of Pocketsense I downloaded from Github
https://github.com/magnuspyke/ofxscripts
Up until several days ago both were working as expected. Recently though, the Python3 version throws an OFX error with Regions Bank. It continues to work as expected with Fidelity.
The Python 2 version works as expected with both Regions Bank & Fidelity.
Does anyone have any ideas as to why the scripts may be erroring out for Regions with the Python 3 version but not the Python 2 version?
-Kevin N.
So, for anyone playing along at home...
DeletePocketsense using Python 2 with Regions Bank requires the User Agent setting in sites.dat to be set to userAgent: none
Apparently, Pocketsense using Python3 with Regions Bank now requires the User Agent setting in sites.dat to be set to the actual User Agent.
e.g. userAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0
An easy way the glean your particular User Agent is from https://whatmyuseragent.com/
-Kevin N.
I haven't used the python3 scripts, but curious if the default user agent would have worked. If useragent is set to none, then it's not defined at all. If it's omitted (i.e., not defined for the site entry), it defaults to "InetClntApp/3.0".
Delete@Robert,
DeleteI had first tried commenting out the entire userAgent line from sites.dat.
I just now tried simply leaving userAgent entry blank.
Both settings error out testing the account in Setup.py.
Plunk the userAgent back in and it works as expected.
Since it worked as expected up until a few days ago with userAgent set to none; I can only assume that Regions Bank is tinkering with things.
@Kevin - Started noticing the issue with Regions last week. Made the update to the userAgent field and I'm back working again.
Delete@John, Excellent! I'm glad to hear that it's working for others besides me. :)
Delete@John, Just to clarify... Are you using the scripts with Python 3 or Python 2?
DeleteAnyone having issues with E*Trade Brokerage? Since early May, it only seems to work sometimes. I’ve tried running setup again and it won’t even accept my login credentials now. I’ve opened a ticket with E*Trade, but I’m skeptical of their support for this issue. Any help would be greatly appreciated.
ReplyDeleteI'm trying to set up a new E*Trade brokerage account. Would you mind sharing your site configuration?
DeleteThese are my settings:
DeleteSiteName : ETRADE
AcctType : INVSTMT #investment
fiorg : etrade.com
fid : fldProv_mProvBankId
url : https://ofx.etrade.com/cgi-ofx/etradeofx
bankid :
brokerid :
ofxVer : 102
appid :
appver :
mininterval:
timeOffset :
delay :
skipZeroTrans:
userAgent :
dtAcctUp :
clientUID :
Thanks! Still can't get it to work with your settings.
DeleteAre you using your regular login and password and 9-digit account number?
I enabled third-party data access in etrade security setting, anything else I'm missing?
Yes using regular login and password and 9-digit account number. It was working just fine before 1 May. I don't know if they changed something or if this is happening because i enabled 2FA.
DeleteThanks. I haven't enabled 2FA yet since I wanted to make sure ofx download works first. So now I can't be sure if it's my config or some issue on their end. Would you please post here if it starts working again for you?
DeleteJust tried again this morning and it works! So seems like the issue was on their end. Can you confirm that it works for you with 2FA enabled?
DeleteIt still doesn't work for me. Did you do anything differently?
DeleteJust tested again after enabling 2FA, still works. Using your settings as is.
DeleteWould you mind telling me the number of characters in your password? Also are there any special characters? Around this same time, I changed the length of my password to 24 characters
ReplyDeleteOops that was meant as a response to the above E*trade questions
DeleteIt's 16 characters, with special characters * and $
Delete