Insider trading readers subtract a day from explicit FileDate timestamps

Open Beginner friendly
#17 1 comment 0 reactions 0 assignees View on GitHub

@quantconnect-kronos is already working on this.

Since Nov 17, 2026.

  • #19 by @quantconnect-kronos — open

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
90/100
Issue type
Bug
Clarity
Clearly specified
Activity status
Active
Tech stack
csharp
Domain
data

Research direction

Start with the parsing expressions in QuiverInsiderTrading.cs and QuiverInsiderTradingUniverse.cs, then check the downloader serialization noted in the issue. Add regression coverage for both readers using the supplied rows; update the existing compact-format assertion. Done means explicitly supplied FileDate timestamps are preserved in both readers and the tests pass.

Written by the indexing model from the issue text.

Description

kronos:skip priority:P2

Problem

QuiverInsiderTrading.Reader and QuiverInsiderTradingUniverse.Reader subtract one day from FileDate even when the CSV explicitly supplies the filing timestamp. This makes the reported filing time one day earlier than the stored value, affecting filters and intervals based on FileDate.

This is present on master at b9f250fc550bf963b71a0b0050000f17d23f0c0b; it is independent of legacy column-count handling.

Synthetic reproduction

With a read date of 2026-05-08, parse these current-layout rows using the corresponding readers:

20260508,20260507093000,20260507,P,150.25,100,500,A,D,Example Person,CEO,T,T,F,
AAPL R735QTJ8XC9X,AAPL,20260507093000,20260507,P,150.25,100,500,A,D,Example Person,CEO,T,T,F,

For the per-ticker reader, use an AAPL SubscriptionDataConfig; the universe reader accepts a null config.

Both readers return:

Expected FileDate: 2026-05-07 09:30:00
Actual FileDate:   2026-05-06 09:30:00

Verified with two local NUnit cases against the base readers: both fail with exactly that expected/actual difference.

Cause and required outcome

  • QuiverInsiderTrading.cs:167 and QuiverInsiderTradingUniverse.cs:150 on the cited commit apply .AddDays(-1) to the result of the entire parse-or-fallback expression.
  • DataProcessing/QuiverInsiderTradingDataDownloader.cs:119–124 serializes a non-omitted filing timestamp directly, without a compensating day offset.
  • FileDate is documented as the time the transaction was filed and became publicly available. The separate Time/EndTime convention does not require altering this supplied timestamp.

Preserve explicitly supplied filing timestamps in both readers and add regression coverage. Existing compact-format coverage currently asserts the shifted per-ticker value and will need to reflect the corrected behavior. Suggestion: apply any intended fallback adjustment only to the missing-value branch, not to an explicit timestamp.

Priority is P2 because the verified impact is limited to this metadata field; evidence of broader user impact would raise it.

Dominant language
C#
Stars
0
Forks
3
Avg merge
39m
Merged PRs (30d)
4

Getting set up

This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from QuantConnect/Lean.DataSource.QuiverQuant

All issues in QuantConnect/Lean.DataSource.QuiverQuant

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.