matthiasstraka / php-invest

Self-hosted stock portfolio tracking software using PHP/Symfony. It tracks portfolios across multiple brokers and automatically updates daily stock data. It allows tracking trades of raw stock and EUSIPA derivatives/instruments.
GNU General Public License v3.0
18 stars 7 forks source link

Accuracy problem when using exchange rates #24

Open matthiasstraka opened 1 year ago

matthiasstraka commented 1 year ago
  1. add transaction with volume=1000, cost = 500 and exchange rate = 0.01
  2. This leads to An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'portfolio' at row 1