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

[Stephen]

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