[GNC] Getting OFX files via the command line: (was: Re: Morgan Stanley Portfolio)

Ed Greenberg edg at greenberg.org
Mon Jan 23 10:37:41 EST 2023


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


More information about the gnucash-user mailing list