Skip to content

MSFT dividend data has gaps #1004

@fashandge

Description

@fashandge

I downloaded dividend data using the rest API and use them in my application. While debugging the data using Claude Code, it finds the following issue on MSFT dividend data. Could you fix them?

MSFT pays quarterly (Feb, May, Aug, Nov), but Massive's data for 2017 has only two records instead of four — the May and November ex-dividend dates are
missing entirely. Their haf values bundle two quarters of adjustment into each event.

The consequence for adjust_daily_bars.py: for any price date between 2017-02-14 and 2017-08-14, the next ex-div in our data is 2017-08-15 (haf=0.908207).
Yahoo has 2017-05-17 as next, with a haf that's lower by one dividend factor (~0.6%). So our adjusted prices are ~0.57–0.60% too high for that entire
window. Same story between Aug and Nov 2017.

This is a source data gap in Massive — nothing in the pipeline is broken. Everything from 2018 onward is fine.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions