import OFX to initialize account doesn't load price info

orders's Avatar

orders

22 Apr, 2021 03:49 PM

I'm loading an OFX file to initialize an account, but the price info in both the <POSSTOCK> <UNITPRICE> field and the <TRANSFER> <UNITPRICE> <AVGCOSTBASIS> fields seems to be ignored: it is displayed as "100" in the register.

This means I can't use History -> Import... -> Import From Transactions to get a proper price for each security. Attached is a portion of my OFX file for 1 security.

BTW: is there a better way of getting prices associated with securities? I have years of monthly data for several hundred securities, and manual processes per security just won't work for me...

  1. 1 Posted by derekkent23 on 22 Apr, 2021 04:38 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi orders

    Try the extension Quote Loader under EXTENSIONS – MANAGE EXTENSION

    For information on the features of this extension and how to use see post 150 at
    https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    Download the PDF attached to posts 150 and have a read.

    To get an overview take a look at the YouTube videos by using the links on page 1 and 2 of the PDF.

    Let us know how you get on or if you need help just post.

    Hope this helps.

  2. 2 Posted by orders on 23 Apr, 2021 02:15 PM

    orders's Avatar

    I have been able to work around the OFX <TRANSFER> issue by replacing them with <BUYSTOCK> or <BUYMF> entries. It gives me the proper balances now - we'll see later if this causes problems when my next statement is available...

    The Quote Loader seems to work well enough going forward, but the real value for me is Mike Bray's other utilities, especially the Security History Load which looks to be able to input CSV files with ticker, date and price fields that I can easily generate from my data. [PS: for you Python programmers out there, there is an ofxtools library that works well for parsing OFX/QFX files.]

    As far as I'm concerned, this discussion can be closed. (I'm off to do the same battle with QIF files...)

  3. Jenny closed this discussion on 29 Apr, 2021 06:36 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac