hello,
I have lines in a csv like these:
07/09/2002,'ORDER POSTING',-5,'TMT',0.463,10.8,0
01/06/2003,'ORDER POSTING',75.76,'C',-2.4524,37.4,15.96
--'Date','Description','Amount','Symbol','Quantity','Price','Commission'
The quantity column is negative for a withdrawal (sell stocks), positive otherwise. I have no other way with this data set to see if withdrawal/deposit. any hope of a signed decimal datatype for this? There is too much precision for "money" datatype. I am using pgsql
muchas gracias,
joe
--
joe speigle
www.sirfsup.com