I am looking for ideas on how to price a portfolio of securities collateral that is currently only priced monthly. This is a small portfolio, and usually not "purpose" credit, so a margin system would be overkill.

At another bank I worked at there was an excel program that had a feed from Dow Jones...of course I have no idea how to do that.

Just looking for ideas! I need to get this fixed.


Kathleen O. Blanchard, CRCM "Kaybee"
HMDA/CRA Training/Consulting/Mapping
The HMDA Academy