Trying to create a spreadsheet for tracking investments across accounts, and Wealthfront only offers the option to export into QFX format (for import into Quicken). It appears to be an XML file (example below).
Anyone have a clue how to manipulate this into a simple column-based spreadsheet?
I guess I'd also have to convert the CUSIP's into ticker symbols--not sure how to do that.
<BUYSTOCK> <INVBUY> <INVTRAN> <FITID>1234567890.000000</FITID> <DTTRADE>20171002000000.000</DTTRADE> <DTSETTLE>20171002000000.000</DTSETTLE> </INVTRAN> <SECID> <UNIQUEID>74926P688</UNIQUEID> <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE> </SECID> <UNITS>14.410000</UNITS> <UNITPRICE>1.00</UNITPRICE> <TOTAL>-14.41</TOTAL> <SUBACCTSEC>CASH</SUBACCTSEC> <SUBACCTFUND>CASH</SUBACCTFUND> </INVBUY> <BUYTYPE>BUY</BUYTYPE> </BUYSTOCK>
Submitted December 21, 2018 at 07:04AM by nukem2k5 http://bit.ly/2PSGDHe
