• Registered: 2023-03-05
  • Posts: 1

Topic: Creating OFX files

I have some investment accounts which I am tracking with Quicken for macOS. However, I am using the Quicken feature to auto-download the status of the account. However, the company does not support downloading the individual transactions, which I would like to also track inside of Quicken. But, I do not want enter these transitions manually. The do allow me to download the transactions as a CSV file. I had the idea of taking that CSV file and converting it to OFX which Quicken should be able to import. However, the OFX file I am creating is not valid and I am not sure how to fix it so Quicken will import it.

Should I be able to create an OFX file myself and expect it to be importable? Or, does the spec require there be a connection back to some financial institution?

When I try to import the OFX file, the error I get from Quicken is:

This FI is inactive, we cannot connect.

If I remove the FI block, I get the error:

Unable to read the selected Web Connect file.

The CSV file is:

Run Date,Action,Symbol,Security Description,Security Type,Quantity,Price ($),Commission ($),Fees ($),Accrued Interest ($),Amount ($),Settlement Date
01/02/2023,YOU BOUGHT,A,AGILENT TECHNOLOGIES INC,Cash,42,84,,,,-3528.00,01/03/2023
01/03/2023, YOU BOUGHT,AA,ALCOA CORPORATION,Cash,43,86,,,,-3698.00,01/04/2023
01/04/2023, YOU BOUGHT,AAC,ARES ACQUISITION CORP,Cash,44,88,,,,-3872.00,01/05/2023

The OFX file I am creating is:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?OFX OFXHEADER="200" VERSION="220" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?>
<OFX>
  <SIGNONMSGSRSV1>
    <SONRS>
      <STATUS>
        <CODE>0</CODE>
        <SEVERITY>INFO</SEVERITY>
      </STATUS>
      <DTSERVER>20230304170917.174[+0:UTC]</DTSERVER>
      <LANGUAGE>ENG</LANGUAGE>
      <FI>
        <ORG>Investments</ORG>
        <FID>1234</FID>
      </FI>
    </SONRS>
  </SIGNONMSGSRSV1>
  <INVSTMTMSGSRSV1>
    <INVSTMTTRNRS>
      <TRNUID>0</TRNUID>
      <STATUS>
        <CODE>0</CODE>
        <SEVERITY>INFO</SEVERITY>
      </STATUS>
      <INVSTMTRS>
        <DTASOF>20230304170917.178[+0:UTC]</DTASOF>
        <CURDEF>USD</CURDEF>
        <INVACCTFROM>
          <BROKERID>investments.com</BROKERID>
          <ACCTID>Y12345678</ACCTID>
        </INVACCTFROM>
        <INVTRANLIST>
          <DTSTART>20230102000000.000[+0:UTC]</DTSTART>
          <DTEND>20230104000000.000[+0:UTC]</DTEND>
          <BUYOTHER>
            <INVBUY>
              <INVTRAN>
                <FITID>725bb8d9-ef22-4b9b-9214-8080a4a59ddb</FITID>
                <DTTRADE>20230102000000.000[+0:UTC]</DTTRADE>
                <DTSETTLE>20230103000000.000[+0:UTC]</DTSETTLE>
              </INVTRAN>
              <SECID>
                <UNIQUEID>100000000</UNIQUEID>
                <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
              </SECID>
              <UNITS>42</UNITS>
              <UNITPRICE>84</UNITPRICE>
              <TOTAL>3528</TOTAL>
              <SUBACCTSEC>CASH</SUBACCTSEC>
              <SUBACCTFUND>CASH</SUBACCTFUND>
            </INVBUY>
          </BUYOTHER>
          <BUYOTHER>
            <INVBUY>
              <INVTRAN>
                <FITID>a04dad7f-7374-4920-bf1c-ed90bdef5991</FITID>
                <DTTRADE>20230103000000.000[+0:UTC]</DTTRADE>
                <DTSETTLE>20230104000000.000[+0:UTC]</DTSETTLE>
              </INVTRAN>
              <SECID>
                <UNIQUEID>100000001</UNIQUEID>
                <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
              </SECID>
              <UNITS>43</UNITS>
              <UNITPRICE>86</UNITPRICE>
              <TOTAL>3698</TOTAL>
              <SUBACCTSEC>CASH</SUBACCTSEC>
              <SUBACCTFUND>CASH</SUBACCTFUND>
            </INVBUY>
          </BUYOTHER>
          <BUYOTHER>
            <INVBUY>
              <INVTRAN>
                <FITID>f2a9db1d-22e8-43ea-aab9-ad9c27e40cee</FITID>
                <DTTRADE>20230104000000.000[+0:UTC]</DTTRADE>
                <DTSETTLE>20230105000000.000[+0:UTC]</DTSETTLE>
              </INVTRAN>
              <SECID>
                <UNIQUEID>100000002</UNIQUEID>
                <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
              </SECID>
              <UNITS>44</UNITS>
              <UNITPRICE>88</UNITPRICE>
              <TOTAL>3872</TOTAL>
              <SUBACCTSEC>CASH</SUBACCTSEC>
              <SUBACCTFUND>CASH</SUBACCTFUND>
            </INVBUY>
          </BUYOTHER>
        </INVTRANLIST>
      </INVSTMTRS>
    </INVSTMTTRNRS>
  </INVSTMTMSGSRSV1>
  <SECLISTMSGSRSV1>
    <SECLIST>
      <MFINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>100000000</UNIQUEID>
            <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
          </SECID>
          <SECNAME>AGILENT TECHNOLOGIES INC</SECNAME>
          <TICKER>A</TICKER>
        </SECINFO>
      </MFINFO>
      <MFINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>100000001</UNIQUEID>
            <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
          </SECID>
          <SECNAME>ALCOA CORPORATION</SECNAME>
          <TICKER>AA</TICKER>
        </SECINFO>
      </MFINFO>
      <MFINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>100000002</UNIQUEID>
            <UNIQUEIDTYPE>OTHER</UNIQUEIDTYPE>
          </SECID>
          <SECNAME>ARES ACQUISITION CORP</SECNAME>
          <TICKER>AAC</TICKER>
        </SECINFO>
      </MFINFO>
    </SECLIST>
  </SECLISTMSGSRSV1>
</OFX>