Enhance the download process to include Stock or Bond Prices from Broker interfaces

richard.mourino's Avatar

richard.mourino

Feb 09, 2019 @ 02:00 AM

I only have Bonds no stocks In the OFX file from my broker contains information on the investments. Since I only have Bonds I cannot claim that stock info is also there. In the OFX files from my broker contains the bond cusip number and the current price for all my bonds in my account no matter if there are no transactions. It shold be easy to update all the information that is in the ofx downloaded file.
I am assumming that your direct connect contains the same info from the OFX download I have pasted a section of the file that shows the information. If you need a full file let me know. If this is too difficult then make an extension . Lets make your product better than other systems

</POSDEBT><POSDEBT>
<INVPOS><SECID><UNIQUEID>06050WBP9</UNIQUEID><UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE></SECID><HELDINACCT>CASH</HELDINACCT><POSTYPE>LONG</POSTYPE><UNITS>5000.00000</UNITS><UNITPRICE>101.221000000</UNITPRICE><MKTVAL>5061.05</MKTVAL><DTPRICEASOF>20190205120000</DTPRICEASOF><MEMO>BANK OF AMERICA CORP</MEMO></INVPOS>

</POSDEBT><POSDEBT>
<INVPOS><SECID><UNIQUEID>156700AM8</UNIQUEID><UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE></SECID><HELDINACCT>CASH</HELDINACCT><POSTYPE>LONG</POSTYPE><UNITS>14000.00000</UNITS><UNITPRICE>81.750000000</UNITPRICE><MKTVAL>11445.00</MKTVAL><DTPRICEASOF>20190205120000</DTPRICEASOF><MEMO>CENTURY LINK</MEMO></INVPOS>

</POSDEBT><POSDEBT>
<INVPOS><SECID><UNIQUEID>42824CAY5</UNIQUEID><UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE></SECID><HELDINACCT>CASH</HELDINACCT><POSTYPE>LONG</POSTYPE><UNITS>25000.00000</UNITS><UNITPRICE>102.753000000</UNITPRICE><MKTVAL>25688.25</MKTVAL><DTPRICEASOF>20190205120000</DTPRICEASOF><MEMO>HP ENTERPRISE CO</MEMO></INVPOS>

</POSDEBT><POSDEBT>
<INVPOS><SECID><UNIQUEID>00206RCP5</UNIQUEID><UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE></SECID><HELDINACCT>CASH</HELDINACCT><POSTYPE>LONG</POSTYPE><UNITS>25000.00000</UNITS><UNITPRICE>94.542000000</UNITPRICE><MKTVAL>23635.50</MKTVAL><DTPRICEASOF>20190205120000</DTPRICEASOF><MEMO>AT&amp;T INC</MEMO></INVPOS>

</POSDEBT><POSDEBT>
<INVPOS><SECID><UNIQUEID>88732JAU2</UNIQUEID><UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE></SECID><HELDINACCT>CASH</HELDINACCT><POSTYPE>LONG</POSTYPE><UNITS>10000.00000</UNITS><UNITPRICE>107.690000000</UNITPRICE><MKTVAL>10769.00</MKTVAL><DTPRICEASOF>20190205120000</DTPRICEASOF><MEMO>TIME WARNER CABLE INC</MEMO></INVPOS>

  1. System closed this discussion on May 11, 2019 @ 02:10 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