Bug: Issue with Dividends?

[tynorton]

Problem
Seeing a very large sum that doesn't make sense in dividend view for AMAT symbol.

Expected
Dividend values should make sense

[tynorton]

Refreshed this morning without any data changes and the shares used by the first dividend jumped up even more.

[hackerESQ]

That's wild. Can you share an export of that portfolio so I can take a look?

[hackerESQ]

Disregard the request for an export. Looks like you are using the hosted version as well. Seeing multiple rows in the dividends table for AMAT. Specifically for Aug 22. Investigating.

[hackerESQ]

Hi @tynorton, I've identified the issue and it should be resolved by the referenced commit above. I am tagging a new release now. Hoping you can confirm this resolves the issue?

Even once you update, you may still have erroneous dividends. To clear the previous / erroneous dividends, you can use the following query which is what I just ran for the hosted version:

WITH RankedDividends AS (
    SELECT 
        id,
        symbol,
        date,
        dividend_amount,
        ROW_NUMBER() OVER (PARTITION BY symbol, date ORDER BY id) AS row_num
    FROM dividends
)
DELETE FROM dividends
WHERE id IN (
    SELECT id
    FROM RankedDividends
    WHERE row_num > 1
);