This is quite interesting. I'm not sure if I'm a future user but I do
love to learn and explore things. I know zip about Python. I did explore
the links a bit. I'm way over my head. One thing I did notice was the
SSL Failed validation msgs in the ofxhome directory for Morgan Stanley
and for another bank (JP Morgan Chase). Looking further into it both
banks have SSL Failed Validation for every day since August 3, 2022.
What is the significance of this, please? May one take it that the OFX
non-fails is a good thing and data was obtained? Thanks,
Stephen
On 1/23/2023 9:37 AM, Ed Greenberg wrote:
This was a great success. I'll embellish a bit for the sake of others.
1. Install ofxtools. For Windows, you may need python. For Mac and
Linux, it's probably there.
Go to https://ofxtools.readthedocs.io/en/latest/index.html to get the
documentation, which includes an "Installing" section.
2. Find your bank. do an 'ofxget list' command. You'll get a text
table of institutions, each with a number.
Steve Brown pointed to a URL below,
https://www.ofxhome.com/index.php/institution/view/500
where 500 is the number in 'ofxget list' output
3. Following the instructions under 'Using ofxget' do something like
ofxget acctinfo ... and then ofxget stmt.
I was able to download an OFX from Morgan Stanley of my entire year's
transaction history.
Thanks for the pointer, Steve.
Ed
On 1/22/2023 8:35:32 AM, Steve Brown wrote:
Morgan Stanley is running an OFX server. I'd see if I could get online
banking to connect with it and download that.
I haven't tried it as I don't have an account there, but I think all
the info you need to set it up is here:
https://www.ofxhome.com/index.php/institution/view/500
I was able to download the profile with ofxget from ofxtools and it
promises to support investments.
Good luck,
Steve
On Sun, 2023-01-22 at 06:29 -0500, Ed Greenberg wrote:
I have a portfolio at Morgan Stanley which generates some dividends,
income, cap gains distribution, etc. All sorts of odd transactions.
MS
does not offer a QFX/OFX, but only an excel download which is
inadequate
for import. Near as I can tell.
Does anybody have suggestions for interacting with Morgan Stanley?
I'm considering writing a transformation program that will read the
csv
and rewrite it in a more importable set of csv columns. Or just
biting
the bullet and keying it all in manually.
On the other hand, what procedures have people developed to track
just
the asset value of the entire portfolio and update it each month?
Thanks,
Ed Greenberg
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
