search

dohernandez / market-manager

MIT License
1 stars 0 forks source link

Error adding BANR from NASDAQ #8

Open dohernandez opened 6 years ago

dohernandez commented 6 years ago

When I tried to add BANR from NASDAQ I got this error:

{"@timestamp":"2018-09-09T20:42:45Z","level":"error","message":"An error happen while updating all stock dividend symbol [BANR] -\u003e error [INSERT INTO stock_dividend VALUE (1a82dc78-2e20-473d-af4e-052304a924e6, 2018-07-09 00:00:00 +0000 UTC, 2018-07-19 00:00:00 +0000 UTC, 2018-07-10 00:00:00 +0000 UTC, payed, 0.500000, 0.000000, 0.000000, 0.000000): pq: duplicate key value violates unique constraint \"stock_dividend_pkey\"]"}

The historical dividend looks like:


Ex Date | Record Date | Pay Date | Special | Amount | Note | % ChangeFrom Prev | % ChangeFromPrev Year | Prior12 MonthsYield
9-Jul-2018 | 10-Jul-2018 | 19-Jul-2018 |   | 0.3500 |   |   | +40.0% | 1.93%
9-Jul-2018 | 10-Jul-2018 | 19-Jul-2018 | Y | 0.5000 | Board of Directors declared a regular quarterly cash dividend of $0.35 per share and a special cash dividend in the amount of $0.50 per share. The dividends will be payable July 19, 2018 |   |   |  
9-Apr-2018 | 10-Apr-2018 | 19-Apr-2018 |   | 0.3500 | Increased | +40.0% | +40.0% | 2.00%
dohernandez commented 5 years ago

Another error related 

{"@timestamp":"2018-10-01T19:42:23Z","level":"error","message":"An error happen while updating all stock dividend symbol [WRB] -\u003e error [INSERT INTO stock_dividend VALUE (cb8a0906-33e8-412f-9bba-1d6eca191138, 2018-09-18 00:00:00 +0000 UTC, 2018-10-03 00:00:00 +0000 UTC, 2018-09-19 00:00:00 +0000 UTC, announced, 0.150000, 0.000000, 7.100000, 0.730000): pq: duplicate key value violates unique constraint \"stock_dividend_pkey\"]"}